Verifying MySQL Replication Integrity with pt-table-checksum

4 April 11:00AM - 11:50AM @ Ballroom B

Experience level: 
50 minutes conference
Do you have MySQL slaves? Are all slaves' data in sync with the master? How can you check? -- "Yes", "I think so", and "I don't know" are very common responses to these questions. MySQL has no intrinsic way to verify that slaves have the same data as the master. This is a problem because it is very common for slaves to become out of sync with the master. pt-table-checksum is a free, open-source tool which solves this problem by safely and efficiently verifying that data on MySQL slaves is identical to the master. In this talk we will: * Discuss the dangers of inconsistent slave data * Demonstrate the importance of using the right tool * Learn how to use pt-table-checksum (it's easy!) 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.


System Architect, Percona
Daniel started making MySQL tools in 2004. At the time almost no MySQL tools existed publicly. In 2005 he created where he published tools and whitepapers about MySQL performance, query optimization, and internals. These were lessons learned from his previous job as a Unix sysadmin at a large datacenter. Daniel joined Percona in July 2008 to work on Maatkit, a suite of command-line tools for MySQL which is now Percona Toolkit. At the 2010 MySQL Conference & Expo, Daniel was named the Community Contributor of the Year for his work on Maatkit. Daniel currently leads web development at Percona, focusing on Percona Cloud Tools, a web app and service for MySQL performance management.