-- 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 代替。
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
编辑推荐:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
