There are several possibilities to end up with inconsistent MySQL replication, This could be accidental or intentional. In this blog I would like to discuss on how to identify the inconsistent slaves with master and fix them. I used here pt-table-checksum (to find the difference between master and slave) and pt-table-sync (to sync. between MySQL master and slave) from Percona Toolkit, The detailed documentation of Percona toolkit is available here for your reference. I expect / recommend you to be careful (as I mentioned above, sometimes records are inserted / deleted on MySQL slave intentionally) before using pt-table-checksum to sync. slave with master because rollbacking this task is even more expensive. The objective of this blog is to show you how to find differences between master and …
[Read more]
Showing entries 1 to 1
Sep
21
2018
Showing entries 1 to 1
Search
Top 20 Authors
Frederic Descamps (15)Valeriy Kravchuk (13)
Mark Callaghan (9)
Dave Stokes (8)
Federico Razzoli (8)
Jesper Krogh (8)
Chris Calender (6)
Alena Subotina (5)
Baron Schwartz (xaprb) (5)
Andrew Grimo (4)
Bhuvanesh R (4)
Krunal Lathiya (4)
Ankit Kumar (3)
René Cannaò (3)
Evert Pot (2)
Jean-François Gagné (2)
Adam Johnson (1)
Ansgar Becker (1)
Balazs Pocze (1)
Dathan Pattishall (1)
Oracle MySQL Blogs
InsideMySQL.com (17)MySQL Server Team (17)
MySQL High Availability (12)
MySQL Support Team (8)
Oracle's MySQL Blog (7)
MySQL Release Engineering (2)
MySQL Workbench (2)