Ignoring databases to write to a binary log

You can choose which databases should be written to the binary log by specifying the --binlog-do-db=db_name option in my.cnf. To specify multiple databases you must use multiple instances of this option. Because database names can contain commas, the list will be treated as the name of a single database if you supply a comma-separated list. You need to restart the MySQL server to effect changes.

How to do it...

Open my.cnf and add the following lines:

shell> sudo vi /etc/my.cnf
[mysqld]
binlog_do_db=db1
binlog_do_db=db2

The behavior on binlog-do-db changes from statement-based logging to row-based logging just like the --database option in the mysqlbinlog utility.

In statement-based logging, only those statements are written to the binary log where the default database (that is, the one selected by USE) is written to the binary log. You should be very careful while using the binlog-do-db option because it does not work as you might expect when using...