Can a MySQL database which is doing master-slave replication to a number of slaves be configured to do master-master replication to a new server at the same time?
I have an application that has a main database (master1) and a number of front-end servers, each with a local slave database (slave1...n). These are doing filtered replication, filtering on slave with
I'm trying to find a way to upgrade the master database without downtime. I need you to review and possibly confirm that the following would work.
- Configure new server (master2) and import data from master1.
- Turn on master-master replication so master2 replicates everything from master1
- On each front-end server, change master to master2
- Switch DNS record for main database from master1 to master2
- Take down master1
Is this possible? Is there anything I should be paying attention to?