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
add comment

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.