Sooner or later your MySQL replication will probably go boom. Here’s how to fix it:
- “Stop Slave;“
- “SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;“
- “Start Slave;“
- “Show slave Status;“
If this is a constant issue, you can use the slave-skip-errors in the my.cnf file, skipping either specific errors or all errors.