Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to set up the method of ignoring table replication on MySQL 5.7. it is very detailed and has certain reference value. Interested friends must read it!

The method of online setting to ignore table replication has been added after the MySQL5.7 version, for example:

Stop the SQL thread first:

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.%-- this indicates that the above command was successfully set online

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)

Note: the command to synchronize all libraries is as follows:

CHANGE REPLICATION FILTER REPLICATE_DO_DB = ()

Synchronize only part of the library:

CHANGE REPLICATION FILTER REPLICATE_DO_DB = (db1, db2)

These are all the contents of the article "how to set up ignore table replication methods online in MySQL 5.7". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.