mysql主从跳过错误的示例解析
发布时间：2021-12-23 12:36:23 所属栏目：MySql教程 来源：互联网
导读：小编给大家分享一下mysql主从跳过错误的示例分析，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！ 非gtid： stop slave; set global sql_slave_skip_counter=1; start slave;
|
小编给大家分享一下mysql主从跳过错误的示例分析，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！ 非gtid： stop slave; set global sql_slave_skip_counter=1; start slave; 有gtid的情况： mysql> show slave statusG; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.2.71 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: bin.000106 Read_Master_Log_Pos: 507171444 Relay_Log_File: relay.000029 Relay_Log_Pos: 927311065 Relay_Master_Log_File: bin.000105 Slave_IO_Running: Yes 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: 1032 Last_Error: Could not execute Update_rows event on table cus_0042.stat_staff_performance; Can't find record in 'stat_staff_performance', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log bin.000105, end_log_pos 927311644 Skip_Counter: 0 Exec_Master_Log_Pos: 927310864 Relay_Log_Space: 1580915694 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: 1032 Last_SQL_Error: Could not execute Update_rows event on table cus_0042.stat_staff_performance; Can't find record in 'stat_staff_performance', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log bin.000105, end_log_pos 927311644 Replicate_Ignore_Server_Ids: Master_Server_Id: 71 Master_UUID: c9c73c70-c089-11e7-8544-00163e0ad76e 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: 171206 13:31:50 Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: c9c73c70-c089-11e7-8544-00163e0ad76e:49794684-62500914 Executed_Gtid_Set: c9c73c70-c089-11e7-8544-00163e0ad76e:1-61492947 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec) mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> set gtid_next='c9c73c70-c089-11e7-8544-00163e0ad76e:61492948'; Query OK, 0 rows affected (0.00 sec) mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> commit; Query OK, 0 rows affected (0.00 sec) mysql> set gtid_next='AUTOMATIC'; Query OK, 0 rows affected (0.00 sec) mysql> start slave; Query OK, 0 rows affected (0.00 sec) 以上是“mysql主从跳过错误的示例分析”这篇文章的所有内容，感谢各位的阅读！ （编辑：拼字网 - 核心网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐