干净的清除slave同步信息

  比如，在有些场景，我们需要下线一台slave，我们使用reset slave来清除show slave status \G里边的同步信息，当我们执行完show slave status \G之后，需要可以看到里边的信息。
  执行reset slave，其实是把master.info和relay-log.info文件给删除，但是里边的同步信息还在.

点击(此处)折叠或打开

1. mysql> stop slave;
   
2. Query OK, 0 rows affected (0.01 sec)
   
3. 
   
4. mysql> reset slave;
   
5. Query OK, 0 rows affected (0.06 sec)
   
6. 
   
7. mysql> show slave status \G
   
8. *************************** 1. row ***************************
   
9.                Slave_IO_State:
   
10.                   Master_Host: 10.10.10.200
    
11.                   Master_User: repl
    
12.                   Master_Port: 3306
    
13.                 Connect_Retry: 60
    
14.               Master_Log_File:
    
15.           Read_Master_Log_Pos: 4
    
16.                Relay_Log_File: mysql-relay-bin.000001
    
17.                 Relay_Log_Pos: 4
    
18.         Relay_Master_Log_File:
    
19.              Slave_IO_Running: No
    
20.             Slave_SQL_Running: No
    
21.               Replicate_Do_DB:
    
22.           Replicate_Ignore_DB:
    
23.            Replicate_Do_Table:
    
24.        Replicate_Ignore_Table:
    
25.       Replicate_Wild_Do_Table:
    
26.   Replicate_Wild_Ignore_Table:
    
27.                    Last_Errno: 0
    
28.                    Last_Error:
    
29.                  Skip_Counter: 0
    
30.           Exec_Master_Log_Pos: 0
    
31.               Relay_Log_Space: 143
    
32.               Until_Condition: None
    
33.                Until_Log_File:
    
34.                 Until_Log_Pos: 0
    
35.            Master_SSL_Allowed: No
    
36.            Master_SSL_CA_File:
    
37.            Master_SSL_CA_Path:
    
38.               Master_SSL_Cert:
    
39.             Master_SSL_Cipher:
    
40.                Master_SSL_Key:
    
41.         Seconds_Behind_Master: NULL
    
42. Master_SSL_Verify_Server_Cert: No
    
43.                 Last_IO_Errno: 0
    
44.                 Last_IO_Error:
    
45.                Last_SQL_Errno: 0
    
46.                Last_SQL_Error:
    
47.   Replicate_Ignore_Server_Ids:
    
48.              Master_Server_Id: 1
    
49.                   Master_UUID: 4adfcd1d-4059-11e7-9532-080027d597f9
    
50.              Master_Info_File: mysql.slave_master_info
    
51.                     SQL_Delay: 0
    
52.           SQL_Remaining_Delay: NULL
    
53.       Slave_SQL_Running_State:
    
54.            Master_Retry_Count: 86400
    
55.                   Master_Bind:
    
56.       Last_IO_Error_Timestamp:
    
57.      Last_SQL_Error_Timestamp:
    
58.                Master_SSL_Crl:
    
59.            Master_SSL_Crlpath:
    
60.            Retrieved_Gtid_Set:
    
61.             Executed_Gtid_Set:
    
62.                 Auto_Position: 0
    
63. 1 row in set (0.00 sec)

 如果有人误开始了start slave，同步依然会开始进行，我们需要用以下这个方法清除的更彻底。

点击(此处)折叠或打开

1. mysql> reset slave all;
   
2. Query OK, 0 rows affected (0.00 sec)
   
3. 
   
4. mysql> show slave status \G
   
5. Empty set (0.00 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30135314/viewspace-2144871/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30135314/viewspace-2144871/