I have been having some issues creating a redundant multi master setup. Here's the proposed layout:


The problem I'm having is when something is written to master1 it replicates to slave1 and master2 but not slave2. And when something is written to master2 it replicates to slave2 and master1 but not to slave 1.

Is there any way I can get this to work where both slaves are updated no matter which master is written to?

1 Answer 1



When a Master is also a Slave, you need to have log-slave-updates.

From what you described, each Master does not have log-slave-updates configured.


STEP 01) STOP SLAVE; on Slave1

STEP 02) STOP SLAVE; on Slave2

STEP 03) STOP SLAVE; on Master1

STEP 04) STOP SLAVE; on Master2

STEP 05) On Master1, add this to /etc/my.cnf


STEP 06) On Master2, add this to /etc/my.cnf


STEP 07) On Master1, Run service mysql restart --skip-slave-start

STEP 08) On Master2, Run service mysql restart --skip-slave-start

STEP 09) START SLAVE; on Slave1

STEP 10) START SLAVE; on Slave2

STEP 11) START SLAVE; on Master1

STEP 12) START SLAVE; on Master2

That's it. Everything should replicate properly from here.

Give it a Try !!!

I have discussed this before

  • Thank you Rolando again. One day I'll answer a question you have. :)
    – Logan Best
    Oct 9, 2013 at 20:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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