MySQL复制之防崩溃从节点

点击(此处)折叠或打开

1. mysql> select * from mysql.slave_master_info;
   
2. Empty set (0.00 sec)
   
3. 
   
4. mysql> select * from mysql.slave_relay_log_info;
   
5. Empty set (0.00 sec)

点击(此处)折叠或打开

1. mysql> select * from mysql.slave_master_info \G
   
2. *************************** 1. row ***************************
   
3. Number_of_lines: 25
   
4. Master_log_name: mysql-bin.000020
   
5. Master_log_pos: 344
   
6. Host: 192.168.8.57
   
7. User_name: repl
   
8. User_password: mysql
   
9. Port: 3306
   
10. Connect_retry: 10
    
11. Enabled_ssl: 0
    
12. Ssl_ca: /usr/local/mysql/certs/ca-cert.pem
    
13. Ssl_capath:
    
14. Ssl_cert: /usr/local/mysql/certs/client-cert.pem
    
15. Ssl_cipher:
    
16. Ssl_key: /usr/local/mysql/certs/client-key.pem
    
17. Ssl_verify_server_cert: 0
    
18. Heartbeat: 30
    
19. Bind:
    
20. Ignored_server_ids: 0
    
21. Uuid: 9ad24233-aeef-11e7-aa1b-080027768e58
    
22. Retry_count: 86400
    
23. Ssl_crl:
    
24. Ssl_crlpath:
    
25. Enabled_auto_position: 0
    
26. Channel_name:
    
27. Tls_version:
    
28. 1 row in set (0.00 sec)
    
29. 
    
30. mysql> select * from mysql.slave_relay_log_info \G
    
31. *************************** 1. row ***************************
    
32. Number_of_lines: 7
    
33. Relay_log_name: ./relay-log.000003
    
34. Relay_log_pos: 510
    
35. Master_log_name: mysql-bin.000020
    
36. Master_log_pos: 344
    
37. Sql_delay: 0
    
38. Number_of_workers: 0
    
39. Id: 1
    
40. Channel_name:
    
41. 1 row in set (0.00 sec)

点击(此处)折叠或打开

1. mysql> stop slave;
   
2. Query OK, 0 rows affected (0.03 sec)
   
3. 
   
4. mysql> alter table mysql.slave_master_info engine=innodb;
   
5. Query OK, 0 rows affected (0.31 sec)
   
6. Records: 0 Duplicates: 0 Warnings: 0
   
7. 
   
8. mysql> alter table mysql.slave_relay_log_info engine=innodb;
   
9. Query OK, 0 rows affected (0.09 sec)
   
10. Records: 0 Duplicates: 0 Warnings: 0
    
11. 
    
12. mysql> start slave;
    
13. Query OK, 0 rows affected (0.01 sec)