How To Skip Certain Errors In MySQL Replication

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.

Complete Story

Related Stories:

• MySQL Forks(May 14, 2009)
• The State of MySQL(Jun 02, 2009)
• Using Dtrace on MySQL(Oct 05, 2007)
• MySQL System Architecture(May 22, 2007)
• The ongoing MySQL campaign(Jan 04, 2010)
• MySQL Basics In Pictures(Jun 07, 2007)
• MySQL 101: Working with the MySQL DB on Linux(Aug 31, 2010)
• Percona announces MySQL conference(Aug 12, 2011)