Dynamic Replication Filter Settings

The variables replicate_do_db, replicate_ignore_db, replicate_do_table, replicate_ignore_table, replicate_wild_do_table, replicate_wild_ignore have been made dynamic. This makes it possible to change them without having to restart the server.

These variables are used on a replication slave to restrict replicated changes to specific databases and/or tables (see the MySQL manual for details on the semantics on how this works with statement-based and row-based replication).

The slave threads must still be stopped to change any of the above variables:

STOP SLAVE;
SET GLOBAL replicate_do_db = "mydb1,mydb2";
SET GLOBAL replicate_wild_ignore_table = "mydb1.local_%";
START SLAVE;

To specify multiple database names, table names, or wildcard patterns, separate them with commas. Note that this means that it is not possible to specify names or patterns that contain commas. If this is needed, it is necessary to use the command-line options in my.cnf and restart the server.