GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

read slave out of synch with master due to inserts

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

  • read slave out of synch with master due to inserts

    Our read slave got out of synch because some insert statements were run against it.

    What's the best way to resynch it with the master?

    Thanks

  • #2
    Either one of these two:

    1) recreate the slave from the master
    2) the --replicate mode of mk-table-checksum and mk-table-sync

    If you have a complicated problem, such as needing to recover some of the changes made to the slave and apply them to the master, then you're basically faced with manual work.

    Comment

    Working...
    X