What is the best way to change the replication scheme of 2 currently replicated slaves?
Posted
by mmattax
on Server Fault
See other posts from Server Fault
or by mmattax
Published on 2010-06-04T15:31:42Z
Indexed on
2010/06/07
11:02 UTC
Read the original article
Hit count: 277
mysql
|mysql-replication
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) ?
© Server Fault or respective owner