阅读背景:

MySQL中主从复制重复键问题修复方法

来源:互联网 

!--NEWSZW_HZH_BEGIN--

-------------------quote begin------------------------ 3. If you decide that you can skip the next statement from the master, issue the following statements: mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = n; mysql> START SLAVE; The value of n should be 1 if the next statement from the master does not use AUTO_INCREMENT or LAST_INSERT_ID(). Otherwise, the value should be 2. The reason for using a value of 2 for statements that use AUTO_INCREMENT or LAST_INSERT_ID() is that they take two events in the binary log of the master.-------------------quote beg




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: