MySQL Forums
Forum List  »  Replication

CREATE DATABASE not replicated (v.5.0)
Posted by: Dmitri Minaev
Date: October 09, 2014 02:02AM

Hello,

I have two servers with master-master active-passive replication. Server 1 (current passive, read_only=ON) is Mysql 5.0.91 and server 2 (current active) is 5.0.89. Evertything is replicated, there are no do-db or ignore-db.
When CREATE DATABASE statement is executed on server 2, it gets logged in the binary log and transferred to server, but is not executed. The same thing happens with CREATE TABLE, DROP TABLE and, probably, other DDL statements.
But when the same statement is run on server 1, the database is created on both servers. What might be the reason for the difference? Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
CREATE DATABASE not replicated (v.5.0)
2004
October 09, 2014 02:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.