Working with MySQL has never been so easy
As someone in Operations I find a vast proportion of my time is dedicated to getting more information, whether it’s trying to accurately capture a customer’s requirements from their request or trying to debugging a crashing application.
Augmenting the toolkit that I rely on day-to-day is a necessity that never seems to get the time it deserves. When I do find a tool(s) that really makes a difference it can save hours if not days of real-world time. Today I would like to talk about one of the world-changing tool(s)!
However, first, some context. Which means I would like to take a minute to talk about the MySQL world. In recent times there has been a lot of movement with Oracle now owning the primary distribution of MySQL, this had led to fragmentation in the market and the creation of companies trying to fill the voids that have been left.
Instead of trying to explain the complicated history here I’ll refer you to https://en.wikipedia.org/wiki/MySQL starting from the “Community” section, with an addendum to say that the Percona guys are really the new unsung heroes of the MySQL world right now.
Percona maintain a widely used distribution of MySQL that roughly tracks the Oracle version however along with this they also provide some of the best tools for MySQL administration available today.
If you’ve ever needed to do any of these tasks …
- Table resynchronisation and check-summing following replication issues
- Data archival from a contended OLTP instance
- Runtime query analysis
- Online schema changes
… then you need to visit http://www.percona.com/software/percona-toolkit now, it will rock your world!
Actually, I’ll be blunt, if your job in any way involves MySQL (as a developer, operator, consultant, etc.) then it’s worth taking 5 minutes out your day to see what the toolkit has that can you help you. Particular favouries of mine include pt-query digest, pt-table-checksum and pt-index-usage however I have made use of most of the tools over the years. I have refrained from diving into any of the tools specifically to try to get you to have a look through all of the tools provided however if there’s enough interest following this article then I’ll happily go into more depth to show usage, pitfalls, etc. so email email@example.com and let me know what you’d like to see