MySQL Forums
Forum List  »  Replication

MySQL Replication
Posted by: Santosh Reddy
Date: November 11, 2012 11:37PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Replication
1843
November 11, 2012 11:37PM
734
November 15, 2012 08:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.