How To Skip Certain Errors In MySQL Replication

Posted by falko on Mar 1, 2013 1:57 PM
By HowtoForge
Mail this story
Web version

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.

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 [url=http://www.howtoforge.com/how-to-skip-certain-errors-in-mysql-replication]make the MySQL slave ignore certain errors using the slave-skip-errors directive[/url]. [url=http://www.howtoforge.com/how-to-skip-certain-errors-in-mysql-replication]http://www.howtoforge.com/how-to-skip-certain-errors-in-mysql-replication[/url]

Full Story

Printed at http://lxer.com/module/newswire/view/181611/index.html