MySQL Forums :: Replication :: MySQL Replication

Advanced Search

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 1802 Santosh Reddy 11/11/2012 11:37PM
Re: MySQL Replication 717 Rick James 11/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.