Verifying MySQL Replication Integrity with pt-table-checksum

Tools
25 April 3:00pm - 3:50pm @ Ballroom G

pt-table-checksum is a free tool which safely and efficiently verifies that data on MySQL replicas is identical to the master. Having inconsistent data on MySQL replicas is a well-known and rather common problem, yet many people who depend on MySQL replication never check for it. Moreover, inconsistent data can be an expensive problem, but the solution is free: pt-table-checksum.

If you use MySQL replication but do not verify that data on replicas is the same as the master, then this session is for you. In it, you will learn:

  • Why inconsistent data can be an expensive problem (and why you should check for it)
  • Why pt-table-checksum is the right tool for detecting inconsistent data
  • How to use pt-table-checksum (in brief)
  • Four things to avoid that make pt-table-checksum sad
  • What pt-table-checksum does under the hood

With this knowledge, you will be able to use pt-table-checksum immediately and confidently to verify that data on your replicas is consistent with the master.

About pt-table-checksum

pt-table-checksum was created in 2007 by Baron Schwartz as part of Maatkit. The tool is extensively tested, and it has been used widely in real-world environments. In 2011, pt-table-checksum 2.0 was created as part of Percona Toolkit, the successor to Maatkit. pt-table-chekcsum 2.0 is a major advancement: faster, simpler, more reliable, able to do more work with less system resources. The tool is free, open source, and developed by Percona.

About the Speaker

Daniel Nichter has developed pt-table-checksum and other tools since he began working at Percona in 2008. pt-table-chekcsum 2.0 was designed by Baron Schwartz and coded by Daniel.

Speakers

Daniel Nichter
Platform Engineer, Square
Biography: 
Daniel has been writing MySQL tools and automation since 2004. In the early years, he created HackMySQL.com where he published some of the first open-source MySQL tools. He also blogged and wrote technical white papers for several years. From 2008 to 2016 he worked at Percona on the most widely-used open-source MySQL toolkit: Percona Toolkit. He also developed other products like the first versions of Percona Monitoring and Management (PMM). At the 2010 MySQL Conference & Expo, he was named the Community Contributor of the Year. Today, he works at Square as a DBA and Platform Engineer developing tooling and automation to manage thousands of MySQL instances.

Slides