84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
mysql5.7中,主从同步复制时,貌似只能设置成忽略一张表.配置成多张表时,不起作用.
单表设置可以:
replicate-ignore-table = db.table1
多表设置不起作用:
replicate-ignore-table = db.table1 db.table2
或者是以分号隔开都不起作用
replicate-ignore-table = db.table1,db.table2
人生最曼妙的风景,竟是内心的淡定与从容!
CHANGE REPLICATION FILTER filter[, filter][, ...] filter: REPLICATE_DO_DB = (db_list) | REPLICATE_IGNORE_DB = (db_list) | REPLICATE_DO_TABLE = (tbl_list) | REPLICATE_IGNORE_TABLE = (tbl_list) | REPLICATE_WILD_DO_TABLE = (wild_tbl_list) | REPLICATE_WILD_IGNORE_TABLE = (wild_tbl_list) | REPLICATE_REWRITE_DB = (db_pair_list) db_list: db_name[, db_name][, ...] tbl_list: db_name.table_name[, db_table_name][, ...] wild_tbl_list: 'db_pattern.table_pattern'[, 'db_pattern.table_pattern'][, ...] db_pair_list: (db_pair)[, (db_pair)][, ...] db_pair: from_db, to_db
Example:
CHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE = ('db1.new%', 'db2.new%');
Pay attention to the brackets.
Look through the document link description
Use the following method in the configuration file to set multiple tables to ignore
replicate-ignore-table = db.table1 replicate-ignore-table = db.table2 replicate-ignore-table = db.table3
Example:
Pay attention to the brackets.
Look through the document link description
Use the following method in the configuration file to set multiple tables to ignore