What is the best way to change the replication scheme of 2 currently replicated slaves?
- by mmattax
I have MySQL replication set up in production as follows:
DB1 - DB2
DB1 - BAK
Where DB2 and BAK are slaves to DB1. All 3 servers are in sync (0 seconds behind the master) and have 30+ GB of data.
I'd like to put the servers in a new master-slave configuration as follows:
DB1 - DB2 - BAK
What is the best way to change the master host on BAK?
Is there a way to avoid having to stop the slave thread on DB2 and getting a mysqldump for BAK (a 5-6 hour processes) ?