Skip duplicate entries for replication queries

Snippet Instead of being asleep at 09:43 on 7 December 2009, kitt created this:

If a conflicting query occurs on a slaved database, and it's okay to skip that query, use the SQL_SLAVE_SKIP_COUNTER setting.

STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = N;
START SLAVE;

Add new comment