How To Skip Certain Errors In MySQL Replication
Mar 02, 2013, 07:00 (0 Talkback[s])
(Other stories by Falko Timme)
Re-Imagining Linux Platforms to Meet the Needs of Cloud Service Providers
MySQL replication is nice, however it can happen that it stops because of an error, and restoring a working replication can be hard - you need to set locks on the master to get a consistent MySQL dump, and during that time websites are not accessible. However there's a way to make the MySQL slave ignore certain errors using the slave-skip-errors directive.