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

 

arrow
arrow
    文章標籤
    MySQL Slave
    全站熱搜

    DanBrother 發表在 痞客邦 留言(0) 人氣()