CODEWITHSUNDEEP
mysqlreplication
Sergio Rodriguez
Sergio Rodriguez

Reputation: 8688

mysql replication duplicated entry

Is it recommended to add the slave-skip-errors = 1062 option into the my.cnf file? I want to keep my data consistent.

Thanks for your opinions.

Upvotes: 0

Views: 250

Answers (1)

Jeff Ferland
Jeff Ferland

Reputation: 18312

I personally recommend against it. If you run into this error, something got out of sync. Skipping that error without ensuring that things are correct could result in your slave database having different results in the other columns for the primary key in question.

Find the root cause of your error, fix that.

Upvotes: 2

Related Questions