How To Skip Certain Errors In MySQL Replication

Posted by falko on Mar 1, 2013 3:57 PM EDT
HowtoForge; By Falko Timme
Mail this story
Print this story

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 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

Full Story

  Nav
» Read more about: Story Type: Tutorial; Groups: MySQL

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.