How To Skip Certain Errors In MySQL Replication

falko's picture

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.

http://www.howtoforge.com/how-to-skip-certain-errors-in-mysql-replication