Take the 2-minute tour ×
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.

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
    
dba.stackexchange.com/questions/18711/… –  user1240 Jun 2 '12 at 3:01
1  
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
add comment

1 Answer

Basically, you have to monitor your replication topology consistently.Also you may have to get email/snmp notification in-case of replication failure,

If this is the case then you should use MONyog as it shows Replication topology in one place and sends an email/snmp trap incase of replication breaks for any reason and advises on steps to follow to make it work again.

share|improve this answer
add comment

Your Answer

 
discard

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

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