Hackfix mysql replication

Updated . Posted . Visible to the public. Repeats.

If replication is broken by a simple invalid query, i.e. grants change, etc. you can force-skip that query:

stop slave;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
start slave;
show slave status\G
Andreas Wagner
Tags
Posted by Andreas Wagner to Toolbox Cash on Go's deck (2015-06-19 17:37)