Survey of Percona Toolkit: Command-line Tools for MySQL

Tools
24 April 2:00pm - 2:50pm @ Ballroom F

Percona Toolkit is a collection of more then 30 command-line tools for MySQL that automate a variety of MySQL and system tasks. With so many choices, it can be difficult knowing where to start: is pt-archiver safe? what is the relationship between pt-table-checksum and pt-table-sync? how does pt-online-schema-change work? etc.

This session will survey 9 of the most popular tools in Percona Toolkit: pt-archiver, pt-duplicate-key-checker, pt-mysql-summary, pt-online-schema-change, pt-query-digest, pt-stalk, pt-summary, pt-table-checksum, and pt-table-sync. The main purpose of each of these tools will be explained and briefly demonstrated.

If you have never heard of Percona Toolkit, or if you have but are still new to it, this session will provide you with a starting point from which you can learn more about the particular tools that spark your interest.

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