MySQL Forums :: Replication :: Row based replication and --binlog-do-db

Advanced Search

Row based replication and --binlog-do-db
Posted by: Richard ()
Date: October 17, 2007 09:44AM

Hello All,
I am reading the documentation at
about --binlog-do-db. It states:

An example of what does not work as you might expect: If the server is started with binlog-do-db=sales, and you run USE prices; UPDATE sales.january SET amount=amount+1000;, this statement is not written into the binary log.

Now if I have:


That statement above is NOT true when using row level replication, correct?
I did do a similar test to the above and then ran this query:


It seems to have logged the update. Just making sure I do not get hit with a gottcha other than my binlog potentially getting huge.


Options: ReplyQuote

Subject Views Written By Posted
Row based replication and --binlog-do-db 3744 Richard 10/17/2007 09:44AM

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.