Maatkit tools for database administrators
Order into Chaos
Maatkit [1], which was named after Maat, the Egyptian goddess of order and justice, gives administrators and developers a comprehensive collection of command-line tools written in Perl that help extend the functionality of database management systems and facilitate management tasks. For example, you can check whether replication is working correctly, identify and repair damaged files, quickly export tables into files, parse data from files, or output the privileges assigned to individual database users. Most of the features were written for MySQL [2]; however, Maatkit does support other free database management systems including PostgreSQL [3] and Memcached [4].
Maatkit was developed in 2006 by Baron Schwartz. Since 2008 Daniel Nichter has been the main developer, although Schwartz still contributes suggestions for new tools and features. Both Schwartz and Nichter work for database specialist Percona, which has often impressed users in the past with performance-boosting patches for MySQL [5].
You can install Maatkit with just a couple of keystrokes. Many package repositories include the tool selection, but, if this is not the case with your distribution, you can download the source code and Deb or RPM packages off the project website. To quickly download and start using an individual tool, you can also try:
wget http://www.maatkit.org/get/ toolname
Maatkit currently includes 30 tools; Admin magazine picked a couple of them for closer inspection.
Fast Dump and Restore
Wherever you need to roll out a new system, you need to test it thoroughly up front,
...
Buy ADMIN Magazine
US / Canada
UK / Australia
Related content
-
Stopping SQL Injection
SQL injection can strike at any moment. GreenSQL is an effective remedy that sits between the database and application and filters out suspicious queries.
-
Blocking SQL injections with GreenSQL
SQL injection can strike at any moment. GreenSQL is an effective remedy that sits between the database and application and filters out suspicious queries. -
Sharding and scale-out for databases
Apache ShardingSphere extends databases like MySQL or PostgreSQL, adding a modular abstraction layer to support horizontal sharding and scalability – but not replication or encryption at rest. -
RSQL, a Microsoft SQL clone
The open source relational database RSQL aims to completely replace slimmed-down instances of Microsoft SQL Server. -
MySQL upgrade obstacles
A number of breaking changes have been introduced between MySQL 5.7 and 8.0. We show you how to navigate this mandatory upgrade.