I have replication setup between two mysql servers, one is a master and the other is the slave.
This works well unless the master is restarted for any reason. When it comes back up the slave doesn't connect. On the slave I do a start slave; then it fails with
090922 17:49:59 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000009' (relay_log_pos 67391580) 090922 17:49:59 [ERROR] Could not find target log during relay log initialization
And I am forced to grab all the data from the master and load it back into the slave and start that again.
How can I avoid this from happening so if the master does get restarted it's not a mission to re-do all the databases.
Here is the config file Red Hat 5, mysql 5.0.45
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql old_passwords=1 server-id = 9180 slave_compressed_protocol=1 max_allowed_packet=16M [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid