Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am setting up master-master replication with MySQL.

Writes are done only to Master1. Master2 is slave of Master1 and is replicating perfectly. When I set Master1 as slave of Master2, I get lots of the following errors:

Lock wait timeout exceeded

When I stop replicating on Master1 (with STOP SLAVE), the errors stop too.

What could cause this? I figured it could be some sort of circular replication loop. But why?

share|improve this question

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.