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.