sql_slave_skip_counter =1 是跳过一个事务啊, 不然事务的完整性都破坏了.
官网原文: https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
16.1.7.3.2.1 Skipping Transactions With SET GLOBAL sql_slave_skip_counter
If you want to skip the complete transaction, you can count the events to the end of the transaction, or you can just skip the relevant event group. Remember that with SET GLOBAL sql_slave_skip_counter, the replica continues to skip to the end of an event group. Make sure you do not skip too far forward and go into the next event group or transaction, as this then causes it to be skipped as well.