Take the 2-minute tour ×
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. It's 100% free, no registration required.

Database is created on all multi masters.

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

some explanations?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

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

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 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 at 14:34

Your Answer

 
discard

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.