A crash on the master side can result in the master's binary log
having a final position less than the most recent position read
by the slave, due to the master's binary log file not being
flushed. This can cause the slave not to be able to replicate
when the master comes back up. Setting
sync_binlog=1
in the master
my.cnf
file helps to minimize this problem
because it causes the master to flush its binary log more
frequently.
User Comments
Add your own comment.