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

This article is about how to clear slave synchronization information. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

For example, in some scenarios, we need to offline a slave, we use reset slave to clear the synchronization information in show slave status\ G, and when we finish executing show slave status\ G, we need to see the information in it.

To execute reset slave is to delete the master.info and relay-log.info files, but the synchronization information is still there.

Click (here) to collapse or open

Mysql > stop slave

Query OK, 0 rows affected (0.01 sec)

Mysql > reset slave

Query OK, 0 rows affected (0.06 sec)

Mysql > show slave status\ G

* * 1. Row *

Slave_IO_State:

Master_Host: 10.10.10.200

Master_User: repl

Master_Port: 3306

Connect_Retry: 60

Master_Log_File:

Read_Master_Log_Pos: 4

Relay_Log_File: mysql-relay-bin.000001

Relay_Log_Pos: 4

Relay_Master_Log_File:

Slave_IO_Running: No

Slave_SQL_Running: No

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 0

Relay_Log_Space: 143

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: NULL

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: 1

Master_UUID: 4adfcd1d-4059-11e7-9532-080027d597f9

Master_Info_File: mysql.slave_master_info

SQL_Delay: 0

SQL_Remaining_Delay: NULL

Slave_SQL_Running_State:

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:

Auto_Position: 0

1 row in set (0.00 sec)

If someone starts start slave by mistake, synchronization will still begin, and we need to clean it up more thoroughly by using the following method.

Click (here) to collapse or open

Mysql > reset slave all

Query OK, 0 rows affected (0.00 sec)

Mysql > show slave status\ G

Empty set (0.00 sec)

Thank you for reading! This is the end of this article on "how to clear slave synchronization information". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.