Assembling the perfect MySQL toolbox by Ike Walker of Flite
There are many great tools in the MySQL ecosystem. As a DBA, how do you pick the right tools and get started using them?
In this session, Ike Walker describes how Flite assembled its MySQL toolbox. You will get tips for assembling your own MySQL toolbox based on your environment.
The focus of the session will be on understanding, testing, and using some of the best community tools for MySQL DBAs. MySQL Sandbox is used in demos to test the tools, and there are several simple but powerful examples of how you can start using toolkits such as Percona Toolkit and common_schema today. Also discussed is how to choose the right tool for the job. For example:
Should you use pt-archiver or common_schema for bulk deletes?
For blocking DDL on live tables, should you use pt-online-schema-change or oak-online-alter-table?
With the new replication features in MySQL 5.6 do you still need pt-heartbeat and pt-slave-delay?"
Enjoy!