MySQL Replication

[Santosh Reddy]

Hi Everyone,

I've done Master-Master Replication on Centos server.
But, once I restart MySQL, both log_bin and log_pos changes. Resulting replication breakdown.
If I manually override using command "CHANGE MASTER TO MASTER_LOG_FILE='<MASTER_LOG_FILENAME>', MASTER_LOG_POS=<MASTER_POSITION>", then old data will be lost after replication breakup and before recovering of replication.

So my question is
1) How can I make automatic resync of log_file and positon to Slave? OR
2) How can I assign previous used log_file and position to Master?

Thanks in advance :)



Edited 1 time(s). Last edit at 11/11/2012 11:49PM by Santosh Reddy.