1、stop slave ‘xxxx’; 2、set @@default_master_connection=‘xxxx’; 3、select @@default_master_connection; 4、SET GLOBAL sql_slave_skip_counter =1; (跳过一个事务) 5、start slave ‘xxxx’; 6、show slave ‘xxxx’ status\G; 注:xxxx代表channal名称 处理1236等错误跳过报错信息 stop slave ‘shcc’; change master ‘shcc’ to master_log_file=‘mysql-bin.004380’,master_log_pos=106; start slave ‘shcc’;