GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

How to sync tables with triggers?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to sync tables with triggers?

    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
Working...
X