Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I recently needed to setup MySQL replication across 4 servers, so that each one is a slave of another.

After several hours of tweaking I finally got this working - it was actually quite simple. I am using MySQL 5.5.

What happens if one of the machines fails and the replication stops happening?

For instance, if there was a change on server 1, and server 3 failed during the change, the 4th machine will not know about the change.

What are possible scenarios to think about? How can I mitigate this issue?

share|improve this question… – user1240 Jun 2 '12 at 3:01
Basically, if one of the chain breaks, then you are mostly hosed and have to reconfigure the entire thing from scratch. Friends don't let friends do circular replication. Just because you can, doesn't mean that you should. – Aaron Brown Jun 2 '12 at 3:24
I give +1 for Aaron. – Rick James Jun 20 '12 at 23:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.