A quick note to announce that Percona toolkit 2.0.3 is now available on Dotdeb for Debian 6.0 “Squeeze” on both amd64 and i386 architectures. You’ll find its Changelog here.
Useful tool for any MySQL DBA, Maatkit is a collection a utilities that ease painful MySQL manipulations (archive tables, keep a slave in sync, analyse slow queries…).
Or should I say “Maatkit was…”. In fact, it’s now known as “Percona Toolkit” and it’s available on Dotdeb for both Debian 6.0 “Squeeze” and 5.0 “Lenny”.
Maatkit is one of the great Open Source tools (among Percona Server, Xtrabackup and so on…) published by Percona. It’s a collection of utilities that help MySQL DBAs in many redundant, complex or boring tasks. For example :
- mk-query-digest that outputs a digest of the queries from a slow-query logfile or from a running MySQL server,
- mk-slave-delay that could help you to keep a copy of your databases while rolling back a new version of your application,
- mk-parallel-dump and mk-parallel-restore to speed up your dump/load processes,
- mk-table-checksum that checks the consistency of your MySQL slave,
If you’re a MySQL DBA that runs Debian servers, you really should install the new Maatkit packages from Dotdeb and read its documentation. There is a tool that will help you on your daily usage of MySQL, for sure!