Some times you will be getting replication errors on the slaves , this might be coming because of the following any one of the reason

  • Might have killed a query in between in the master server
  • Duplicate entry
  • Version difference , due to this some of the queries may not work in slaves
  • Any other reasons
You can put  the following line in my.cnf file to get rid of all these errors
slave-skip-errors=all
This will ignore all the errors and your slave will work properly.

Post By Gishore J Kallarackal (2,121 Posts)

Gishore J Kallarackal is the founder of techgurulive. The purpose of this site is to share information about free resources that techies can use for reference. You can follow me on the social web, subscribe to the RSS Feed or sign up for the email newsletter for your daily dose of tech tips & tutorials. You can content me via @twitter or e-mail.

Website: → Techgurulive

Connect