am3n portfolio

This is happen long time ago when Mysql Replication stop due to duplicate error, Kumay has the log. But I don’t want to do a manual labor. So to skip a duplicate error on A MySQL Replication Server (SLAVE) automatically. Added this line on /etc/my.cnf

Note: Make sure you know what cause a duplicate error and does it really not important so that you can skip inserting that query.

[mysqld]
...
slave-skip-errors=1062

You can use other error code, if that error happen. Again: Make sure you know what cause the error, and why you want to skip it.
References:

• http://dev.mysql.com/doc/refman/5.0/en/replication-options-slave.html
• http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html

Related posts:

1. Magento error with pdo_mysql Magento is a great Free / Open source eCommerce script,...

Related posts brought to you by Yet Another Related Posts Plugin.

This entry was posted on Monday, February 9th, 2009 at 3:23 pm and is filed under Web and System Administrator. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.