Bug #31756 binlog-ignore-db is ignored in certain cases
Submitted: 22 Oct 2007 15:36 Modified: 22 Oct 2007 16:08
Reporter: Dominik Jungowski Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:4.1.11 OS:Any
Assigned to: CPU Architecture:Any
Tags: binlog-ignore-db ignored

[22 Oct 2007 15:36] Dominik Jungowski
When you execute a query like "INSERT INTO db1.table" but are not currently using db1, the query will be replicated, even though db1 is set to be ignored

How to repeat:
Set up a replication and set
binlog-ignore-db = mysql

now go to the mysql console on the master and type the following:
mysql> use test;
mysql> INSERT INTO mysql.user (User) VALUES ('foobar');

now the statement is replicated, even though the database is set to be ignored for the replication
[22 Oct 2007 16:08] Hartmut Holzgraefe
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php