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

Database is created on all multi masters.

Why CREATE TABLE doesn't being replicated to other masters.

some explanations?

share|improve this question
up vote 0 down vote accepted

If you have MultiMaster Replication, every DB server needs this


This will tell a Slave to log completed SQL commands from the Relay Logs into the Slave's binary logs. Just add that option to every Slave and restart mysql.

If this does not work, you may need to explain more things to us.

Here are my other posts where I suggested using log-slave-updates

Give it a Try !!!

share|improve this answer
when I start mysql, the server id change to other thing even if added in my.cnf . – Julio Fong Jun 2 '14 at 14:30
Please look at my post from May 07, 2012. I made sure the server_id is defined underneath the [mysqld] section. Please go back and check all my.cnf files. – RolandoMySQLDBA Jun 2 '14 at 14:34

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.