Bug 518326 - Replication: default location for relay logs is not persistent across reboots
Summary: Replication: default location for relay logs is not persistent across reboots
Keywords:
Status: CLOSED DUPLICATE of bug 448534
Alias: None
Product: Red Hat Enterprise Linux 5
Classification: Red Hat
Component: mysql
Version: 5.5
Hardware: All
OS: Linux
low
medium
Target Milestone: rc
: ---
Assignee: Tom Lane
QA Contact: BaseOS QE
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-08-19 20:56 UTC by Charles Gillet
Modified: 2013-07-03 03:23 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-08-19 22:23:21 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Charles Gillet 2009-08-19 20:56:21 UTC
Description of problem: 

After turning on slave replication on a system, the slave creates critical relay log files in /var/run/mysqld by default, and that directory is blown away at boot time.

Version-Release number of selected component (if applicable):
mysql-server-5.0.45-7.el5


How reproducible: Easy


Steps to Reproduce:
1. Configure mysql server as a master in master/slave replication setup and add replication permissions for a DB user
2. On second slave server, add server-id setting in /etc/my.cnf (documented well) but do not add relay-log setting (which is only mentioned as optional in /var/log/mysqld.log to survive a hostname change)  
3. follow mysql docs for using "change master to" command and then "start slave"
  
Actual results:
Slave replication will work until the system is rebooted

Expected results:
Slave system should not lose its relay logs and should continue to replicate data

Additional info:
Recommendations: change default location of relay-log setting when you build mysql-server, or document in /etc/my.conf comments section that relay-log location needs to be set to a persistent directory, like /var/lib/mysql, because /var/run/mysqld is the default place mysqld uses and is not persistent.

Comment 1 Tom Lane 2009-08-19 21:15:18 UTC
I think this is a duplicate of bug #448534, which is already fixed for RHEL 5.4.  Please see if you agree ...

Comment 2 Charles Gillet 2009-08-19 21:25:12 UTC
Agreed. I thought I searched for "replication" through all mysql bugs.  Oh well.  Thanks!

Comment 3 Tom Lane 2009-08-19 22:23:21 UTC

*** This bug has been marked as a duplicate of bug 448534 ***


Note You need to log in before you can comment on or make changes to this bug.