Tag - pt-table-checksum

Data Consistency for RDS for MySQL: The 8.0 Version

data consistency rds mysql 8

In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency.
Starting with 8.0.1, MySQL introduced something called “Dynamic Privileges” which is a solution to grant […]

Read more

Caveats With pt-table-checksum Using Row-Based Replication, and Replication Filters

pt-table-checksum row based replication caveat

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 […]

Read more

How to Handle pt-table-checksum Errors

pt-table-checksum Errors

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. […]

Read more

MySQL replication primer with pt-table-checksum / pt-table-sync, part 2

pt-online-schema-change

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 […]

Read more

MySQL replication primer with pt-table-checksum and pt-table-sync

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 […]

Read more