Posted by: Santosh Reddy
Date: November 11, 2012 11:37PM
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.
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.