Not the answer you need?
Register and ask your own question!

How to sync tables with triggers?

dchicksdchicks ContributorCurrent User Role Beginner
I've got two slaves that have somehow become out of sync with the master. Each is giving me HA_ERR_KEY_NOT_FOUND errors when trying to execute updates in replication. I tried to sync them to the master, but the tables contain triggers. So, pt-table-sync doesn't want to execute anything.

Does anyone know of a reliable procedure for bringing such tables back into sync?

Right now, I do not have the luxury of getting rid of the triggers.

Thanks,
Dave
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.