What happens to PT table checksum when replication stops?
If any replica has an error, or replication stops, pt-table-checksum pauses and waits. In addition, pt-table-checksum looks for common causes of problems, such as replication filters, and refuses to operate unless you force it to.
What does PT table checksum mean in MySQL?
By Muhammad IrfanMySQLMuhammad Irfan, MySQL Replication, Percona Toolkit, pt-table-checksum, pt-table-sync14 Comments 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.
Is there a backwards compatible version of PT-table checksum?
The table referenced in that query is the checksum table, where the checksums are stored. Each row in the table contains the checksum of one chunk of data from some table in the server. Version 2.0 of pt-table-checksum is not backwards compatible with pt-table-sync version 1.0. In some cases this is not a serious problem.
Why is PT-table-checksum-Percona dangerous?
In addition, pt-table-checksum looks for common causes of problems, such as replication filters, and refuses to operate unless you force it to. Replication filters are dangerous, because the queries that pt-table-checksum executes could potentially conflict with them and cause replication to fail.
How does MySQL replication utility check data consistency?
It checks data consistency between a master and slaves or between two slaves. The utility reports missing objects as well as missing data. The utility can operate on an active replication topology, applying a synchronization process to check the data.
Which is faster PT table checksum or MD5?
Take into consideration that by default, pt-table-checksum use CRC32 checksums. CRC32 is not a cryptographic algorithm and for that reason it is prone to have collisions. On the other hand, CRC32 algorithm is faster and less CPU-intensive than MD5 and SHA1.