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
What's the best way to resynch it with the master?
Thanks
-
Contributor- Aug 2009
- 41
-
MySQL Sage
- Apr 2008
- 326
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