Missing data on the slave db during replication

johnyu1997
johnyu1997 used Ask the Experts™
on
I try to replicate my email server db to another server for backup.  When there is an update on the master db, sometimes it will miss data inserting into one of the tables on the slave server. It will add the row but the data inside are all "Null". Then, it will try to add that row again and it will generate the duplicate primary key error which causes the replication to stop. On the internet, a lot of people say to skip the error, but I don't think it is the right way to do it because it will create the inconsistency on the slave db.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial