ITPub博客

首页 > 数据库 > MySQL > sql_slave_skip_counter

sql_slave_skip_counter

翻译 MySQL 作者:kakaxi9521 时间:2021-07-13 14:51:35 0 删除 编辑

-- sql_slave_skip_counter 

The number of events from the source that a replica should skip. Setting the option has no immediate effect. The variable applies to the next  START SLAVE statement; the next  START SLAVE statement also changes the value back to 0. When this variable is set to a nonzero value and there are multiple replication channels configured, the  START SLAVE statement can only be used with the FOR CHANNEL channel clause.

此参数可以指定副本跳过多少event。 设置此参数不会立即生效。  在设置完此参数,使用start slave 参数会生效。 start slave 命令同时也会使sql_slave_skip_counter 的设置归零。 当复制有多个channel 时,start slave 需要指定特定的channel。


This option is incompatible with GTID-based replication, and must not be set to a nonzero value when  gtid_mode=ON. If you need to skip transactions when employing GTIDs, use  gtid_executed from the source instead. See  Section 16.1.7.3, “Skipping Transactions”.

此参数和基于GTID的复制是不兼容的。在基于GTID复制时,即gtid_mode=on 时不要将此参数设置为非0。 在基于GTID 的复制中需要跳过事务,可以在源端使用gtid_executed 代替。


Important

If skipping the number of events specified by setting this variable would cause the replica to begin in the middle of an event group, the replica continues to skip until it finds the beginning of the next event group and begins from that point. For more information, see  Section 16.1.7.3, “Skipping Transactions”.


参考文档:

https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21374452/viewspace-2781061/,如需转载,请注明出处,否则将追究法律责任。

上一篇: slave-skip-errors
请登录后发表评论 登录
全部评论

注册时间:2009-04-13

  • 博文量
    119
  • 访问量
    120757