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] |
Printed at http://lxer.com/module/newswire/view/181611/index.html