MySQL Forums
Forum List  »  Synchronization

Apparent replication error, unsure how to fix it.
Posted by: David Hicks
Date: June 03, 2011 01:35PM

I'm fairly new to replication with MySQL, but I'm managing a system that contains a master with several slaves. They are all running on MySQL 5.0.86 Community Edition. Some slaves have a limited amount of replication filtering on them. I've got some errors kicked out complaining of a duplicate key error on two of the slaves. So, I whipped out the MaatKit documentation and started checking up on it. When I run mk-table-checksum on the specific table that is in error, I can clearly see that the checksums between the master and slave do not match. However, if I then run mk-table-sync with --dry-run, it reports no changes. This doesn't make sense to me, but, like I said, I'm new to this.

Can anyone shed any light on this for me?

Options: ReplyQuote

Written By
Apparent replication error, unsure how to fix it.
June 03, 2011 01:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.