mysql主从跳过错误的示例剖析

小编给大家分享一下mysql主从跳过错误的示例分析，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！

非gtid：

stop slave;

set global sql_slave_skip_counter=1;

start slave;

有gtid的情况：

mysql> show slave status\G;

*************************** 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主从跳过错误的示例分析”这篇文章的所有内容，感谢各位的阅读！

（编辑：银川站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!