How to clear slave synchronization information
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!
