MySQL 8 Cookbook

Ignore specific tables

You can ignore certain tables using the REPLICATE_IGNORE_TABLE and REPLICATE_WILD_IGNORE_TABLE options. The REPLICATE_WILD_IGNORE_TABLE option allows wildcard characters, where as REPLICATE_IGNORE_TABLE only accepts full table names:

mysql> CHANGE REPLICATION FILTER REPLICATE_IGNORE_TABLE = ('db1.table1'); mysql> CHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE = ('db1.new%', 'db2.new%'); 

You can also set filters for a channel by specifying the channel name:

mysql> CHANGE REPLICATION FILTER REPLICATE_DO_DB = (d1) FOR CHANNEL 'master-1';