As per the documentation, pt-table-checksum is a tool to perform online replication consistency checks by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master.
The master and each slave insert checksums into the percona.checksums table, and these are later compared for differences. It’s fairly obvious that […]
In this blog post, we’ll look at how to approach pt-table-checksum errors.
pt-table-checksum is one of the most popular tools in Percona Toolkit, and it is widely used to identify data differences between masters and slaves. Therefore, as Percona Support Engineers we have customers often asking questions related to the pt-table-checksum errors and warnings produced. […]
This is the second and last tutorial blog post on how to use pt-table-checksum / pt-table-sync tools for MySQL replication.
In the first post, I showed you how to use the
pt-table-checksum /
pt-table-sync tools in a typical MySQL replication setup. In this post, we’ll discuss MySQL replication for more advanced topologies. I will show you how to […]
MySQL replication is a process that allows you to easily maintain multiple copies of MySQL data by having them copied automatically from a master to a slave database.
It’s essential to make sure the slave servers have the same set of data as the master to ensure data is consistent within the replication stream. MySQL […]
MySQL replication isn’t perfect and sometimes our data gets out of sync, either by a failure in replication or human intervention. We are all familiar with Percona Toolkit’s pt-table-checksum and pt-table-sync to help us check and fix data inconsistencies – but imagine the following scenario where we mix regular replication with the Tungsten Replicator:
We […]
Read more
