mysql主从故障跳过错误

mysql主从故障跳过错误
1.从库报错 21,22,23,25无法执行
Retrieved_Gtid_Set: 265c6c2a-86ca-11ed-b07a-0242ac120002:1-25
Executed_Gtid_Set: 265c6c2a-86ca-11ed-b07a-0242ac120002:1-19,

2.navicat
工具-数据传输
修复主从的具体表
stop slave;
start slave;
show slave status\G;
不需要执行第三步

 3.非gtid跳过错误

stop slave;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
start slave;

 

4.gtid跳过错误
stop slave sql_thread;
set gtid_next='265c6c2a-86ca-11ed-b07a-0242ac120002:25'; （21,22,23,24,25都要执行）
begin;commit;
set gtid_next=automatic;
start slave sql_thread;
show slave status\G;

 

5.跳过多个错误

stop slave;
reset master;

#需要查看当前slave执行到哪里了
set global gtid_purged='265c6c2a-86ca-11ed-b07a-0242ac120002:1-40';
start slave;
show slave status \G;