Verifying MySQL Replication Safely With pt-table-checksum 2.0

Average: 7.3 (7 votes)

pt-table-checksum is a free tool which safely and efficiently verifies that data on MySQL replicas is identical to the master. The tool simplifies the complex task of accurately comparing live data without adversely affecting the servers. This session will demonstrate basic usage, discuss important dos and don'ts, and highlight certain technical issues. Those new to pt-table-checksum will learn how to get started confidently and correctly. Those familiar with pt-table-checksum 1.0 will learn the new features and enhancements of 2.0 while it is demonstrated.

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.

Experience level: 

Schedule info

Time slot: 
12 April 15:00 - 15:50
Ballroom A

Schedule Info

12 April 15:00 - 15:50 @
Ballroom A


Lead User Tools Developer, Percona

Daniel Nichter is the lead developer and database tools specialist at Percona. He has been developing database tools for MySQL since 2005. At the 2010 MySQL Conference & Expose, Daniel was named the Community Contributor of the Year for his work on Maatkit.


Sponsored By