MySQL Replication - Skip an error to continue replication

Revision as of 17:46, 14 April 2020 by Ardaut (talk | changes) (Created page with "You can skip certain errors that you find not important to continue the replication process. This ensures that replication is still working, after occurrence of the defined er...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

You can skip certain errors that you find not important to continue the replication process. This ensures that replication is still working, after occurrence of the defined error.

In Ubuntu (this path may differ):

vim /etc/mysql/mysql.conf.d/mysqld.cnf

Add this to the main mysql config file:

slave-skip-errors       = 1032

Here as an example skip replication inconsistency error (not recommended): 1032