Skip navigation links

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 http://dev.mysql.com/doc/refman/5.1/en/binary-log.html
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:

binlog-format=row

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:

SHOW BINLOG EVENTS;

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.

Thanks,
Richard

Options: ReplyQuote


Subject Views Written By Posted
Row based replication and --binlog-do-db 2597 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.