MySQL 5.7如何在线设置忽略表复制办法
发布时间：2022-01-11 17:30:33 所属栏目：MySql教程 来源：互联网
导读：这篇文章主要介绍MySQL 5.7如何在线设置忽略表复制方法，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！ MySQL5.7版本后增加了在线设置忽略表复制方法，举例如下: 先停止SQL线程: mysql STOP SLAVE SQL_THREAD; Query OK, 0 rows af
|
这篇文章主要介绍MySQL 5.7如何在线设置忽略表复制方法，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！ MySQL5.7版本后增加了在线设置忽略表复制方法，举例如下: 先停止SQL线程: mysql> STOP SLAVE SQL_THREAD; Query OK, 0 rows affected (0.01 sec) mysql> CHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE =('credit.%'); Query OK, 0 rows affected (0.00 sec) mysql> start SLAVE SQL_THREAD; Query OK, 0 rows affected (0.01 sec) mysql> show slave status G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.16.16.70 Master_User: slave Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000022 Read_Master_Log_Pos: 460682 Relay_Log_File: nginx-relay-bin.000004 Relay_Log_Pos: 4201 Relay_Master_Log_File: mysql-bin.000022 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: credit Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: credit.% --此处表示上面的命令在线设置成功 Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 460682 Relay_Log_Space: 4408 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 70 Master_UUID: f1366940-266c-11e7-92c2-525400f39f79 Master_Info_File: /usr/local/mysql/data/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: 32197cd9-2957-11e7-a5c4-525400e493a4:1-3, f1366940-266c-11e7-92c2-525400f39f79:1-6956 Auto_Position: 0 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec) 备注:全部同步所有库的命令就是: CHANGE REPLICATION FILTER REPLICATE_DO_DB = (); 只同步部分库: CHANGE REPLICATION FILTER REPLICATE_DO_DB = (db1, db2); 以上是“MySQL 5.7如何在线设置忽略表复制方法”这篇文章的所有内容，感谢各位的阅读！ （编辑：威海站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
