Possible to make mysql server both master and slave?
- by Amy Anuszewski
I am getting ready to move a database from one server to another. In order to reduce downtime for the client, I am wondering if it would be possible for me to turn on replication and give it time to replicate fully, then just point the customer to the new server.
The issue I have is that the server I'm moving to has existing, active databases for other customers. And, the server I'm moving from has other active customers who will not be moving at this time.
Is this even possible? If so, how do I configure the server I am moving from and the one I am moving to?