javascript using string of function name to call function« an older post
a newer one »View mail in queue

Skip duplicate entries for replication queries

Snippet kitt decided around 09:43 on 7 December 2009 to publish 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;
#mysql
#replication

Add new comment

Plain text

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