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:
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.