CREATE TABLE not issued on other masters

Question

Database is created on all multi masters.

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

some explanations?

Answer 1

If you have MultiMaster Replication, every DB server needs this

[mysqld]
log-slave-updates

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

• Oct 09, 2013 : Multi-master and multi slave
• Dec 05, 2012 : MySQL Slave Relay Logging but not logging Binary Log
• May 29, 2012 : mysqld-multi with first DB as Slave and second DB as Master
• May 07, 2012 : Setting Circular Replication in mysql

Give it a Try !!!