Verifying MySQL Replication Integrity with pt-table-checksum

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

Experience level: 
Beginner
Duration: 
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.


Speakers

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.