mysql replication master change on every X Day

October 10, 2016 39 views

I have two server
one is live server and second one is standby server.
so every X day i am swapping this server.

so i make one server as live server as master and second standby have slave.

now after X day my Second one is live(master) ans First one is standby(slave)

so now i want to also make 3rd one slave server (now configured as per master server log number) but when i swap master server to slave then what change i need to do in 3rd slave server according new master server.


Be the first one to answer this question.