Skip duplicate entries for replication queries

Snippet

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

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.