I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current slave, and the current slave a master to the current master. So basically, both servers would be replicating to and from each other.

I saw some questions and posts on other sites about 'replication loops', which is how I would describe my question; but these posts seemed to be explaining something completely different.


What you are describing is a master master MySQL setup. It is well documented and supported. We've been using it for many years and we were not early adopters.

The set ups that I've worked on have used the master/master active/passive setup, meaning that only one side takes writes at any given time. We setup a floating IP between the two to manage the write master.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.