read slave out of synch with master due to inserts

MySQL & MariaDB Other MySQL® Questions
1

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.