close
MySQL Slave - Skip Replication for A Particular Table
mysql> stop slave sql_thread;
mysql> change replication filter Replicate_Wild_Ignore_Table=('mydb.my_unused_table1');
mysql> start slave sql_thread;
mysql> show slave status\G
PS.
To remove the ignored table, run the following command:
mysql> stop slave sql_thread;
mysql> change replication filter Replicate_Wild_Ignore_Table=();
mysql> start slave sql_thread;
[Reference]
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
文章標籤
全站熱搜
留言列表