MySQL 过滤复制
第一种方法:
进行物理备份,备份后指定GTID
show variables like "%gtid%";
set global gtid_purged = '40571d7e-4cee-11ea-8199-00163e084b44:1-2104754,474b6197-4cee-11ea-bf97-00163e02e59a:1-9,4e6230ad-4cee-11ea-98e6-00163e085606:1-2871425';
set gtid_purged = '40571d7e-4cee-11ea-8199-00163e084b44:1-2104754,474b6197-4cee-11ea-bf97-00163e02e59a:1-9,4e6230ad-4cee-11ea-98e6-00163e085606:1-2871425';
set @@global.gtid_purged = '40571d7e-4cee-11ea-8199-00163e084b44:1-2104754,474b6197-4cee-11ea-bf97-00163e02e59a:1-9,4e6230ad-4cee-11ea-98e6-00163e085606:1-2871425';
STOP SLAVE SQL_THREAD;
CHANGE REPLICATION FILTER Replicate_Do_Table = (db2.tags,db2.drawing,db2.pay_records,db2.member_tags,); start slave SQL_THREAD;
change replication filter replicate_rewrite_db=((db1,db2)); #重写,上流db1重写到 db2
第二种方法:
拷贝表不带数据
change master_host='172.18.15.230',master_user='repl',master_port=3306,master_password='123',master_auto_position=1;
STOP SLAVE SQL_THREAD;
CHANGE REPLICATION FILTER Replicate_Do_Table = (db2.tags,db2.drawing,db2.pay_records,db2.member_tags,); start slave SQL_THREAD;
change replication filter replicate_rewrite_db=((db1,db2)); #重写,上流db1重写到 db2