I have 4 database servers. 1 Master and 3 Slave servers.
I am wanting to temporarily migrate to a new Master server while I upgrade the current Master, and then migrate back again.
If you look at the attached image you can see the setup that we currently have on the left, and the setup that I'm wanting to migrate to on the right.
My question :
Is there a way to temporarily stop the Master from logging to the replication binarly log file so that I can stop all of the slaves from replicating and they will have all stopped at the same point in the Masters binary log file. Then, start the Master logging to the replication binary log file again without having lost any data that was inserted or modified during the period that the Master was not logging.
I am wondering about running the MASTER STOP command on the Master but not having a test environment I can not test to see if this will work or not.
Alternatively, is there a way to get the Slaves to all stop at a particular point in the Masters binary log file?