How To Skip Certain Errors In MySQL Replication
Mar 02, 2013, 07:00 (0 Talkback[s])
(Other stories by Falko Timme)
How to Help Your Business Become an AI Early Adopter
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.