Making the original master a slave after a crash
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
Subject
Views
Written By
Posted
Making the original master a slave after a crash
794
August 07, 2018 11:41AM
459
August 20, 2018 04:14PM
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.