MySQL Forums
Forum List  »  Replication

Making the original master a slave after a crash
Posted by: Ravi Malghan
Date: August 07, 2018 11:41AM

I have two mysql dbs (5.7) setup as master and slave. In the event master crashes, I promote the slave to be master (new master). When I bring back the mysql process on original master, I make him a slave by running

CHANGE MASTER TO MASTER_HOST='<ip of new master>',MASTER_USER='slave', 
MASTER_PASSWORD='password',MASTER_LOG_FILE='mysql-bin.000001', 
MASTER_LOG_POS=  77;
start SLAVE;

If my original master is down for 2 hours, how do I ensure any updates that were sent to the new master during that 2 hours are copied from new master to new slave?

Thanks
Ravi

Options: ReplyQuote


Subject
Views
Written By
Posted
Making the original master a slave after a crash
606
August 07, 2018 11:41AM


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.