如何乾淨的清除Slave同步資訊【小技巧】

 

  
mysql> show slave status\G; 
  
*************************** 1. row *************************** 
  
               Slave_IO_State: Waiting for master to send event 
  
                  Master_Host: 192.168.8.22 
  
                  Master_User: repl 
  
                  Master_Port: 3306 
  
                Connect_Retry: 10 
  
              Master_Log_File: mysql-bin.000015 
  
          Read_Master_Log_Pos: 107 
  
               Relay_Log_File: vm02-relay-bin.000025 
  
                Relay_Log_Pos: 253 
  
        Relay_Master_Log_File: mysql-bin.000015 
  
             Slave_IO_Running: Yes 
  
            Slave_SQL_Running: Yes 
  
              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: 107 
  
              Relay_Log_Space: 554 
  
              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: 22 
  
1 row in set (0.03 sec) 
  
 
  
ERROR:  
  
No query specified 
 

現在由於業務的需要，不需要這台Slave同步複製Master，那麼採用reset slave時，你會發現同步資訊還存在，如：

 

  
mysql> stop slave; 
  
Query OK, 0 rows affected (0.19 sec) 
  
 
  
mysql> reset slave; 
  
Query OK, 0 rows affected (0.17 sec) 
  
 
  
mysql> show slave status\G; 
  
*************************** 1. row *************************** 
  
               Slave_IO_State:  
  
                  Master_Host: 192.168.8.22 
  
                  Master_User: repl 
  
                  Master_Port: 3306 
  
                Connect_Retry: 10 
  
              Master_Log_File:  
  
          Read_Master_Log_Pos: 4 
  
               Relay_Log_File: vm02-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: 126 
  
              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: 22 
  
1 row in set (0.02 sec) 
  
 
  
ERROR:  
  
No query specified 
 

執行reset slave，其實是把master.info和relay-log.info檔案給刪除，但裡面的同步資訊還在，那麼可以用這個方法，讓其清除的徹徹底底。

 

  
mysql> reset slave all; 
  
Query OK, 0 rows affected (0.04 sec) 
  
 
  
mysql> show slave status\G; 
  
Empty set (0.02 sec) 
  
 
  
ERROR:  
  
No query specified 
 

650) this.width=650;" border="0" alt="" src="http://www.bkjia.com/uploads/allimg/131228/2256451525-0.jpg" />

註：此語句支援在MySQL5.5或更高版本。

本文出自 “賀春暘的技術專欄” 部落格，請務必保留此出處http://hcymysql.blog.51cto.com/5223301/1183656