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. Join them; it only takes a minute:

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 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?

share|improve this question
up vote 0 down vote accepted


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

share|improve this answer
Thank you Rolando again. One day I'll answer a question you have. :) – Logan Best Oct 9 '13 at 20:05

Your Answer


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.