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?


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.