Changing masters

I have a three server replication setup with a single master and two slaves - M1, S1 and S2

I am about to change Slave 1, S1 to be the new master.

Binary logging is enabled on all three servers and replication grants appear to be OK.

The way I have done this in the past is:

On M1 - flush logs

Point our applications at S1 to do read/writes

On S2 - stop slave ; change master to new_master ; reset slave ; start slave

On M2 - change master to new_master ; reset slave ; start slave

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

My concern is that if I for whatever reason am unable to get the old master, M1 and the secondary slave to replicate with my new master, S1. Normally I would just fix whatever issue I had then refresh the slave using a mysqldump with --master-data to get me back up and running but in this setup, not having a replication slave for any length of time would be a very bad thing.

Have I any way of mitigating any risk other than making S2 a slave of S1 before making S1 a master?

Any other thoughts on making this go smoothly?

Dave Received on Thu Sep 27 04:58:02 2007