Making MySQL Administration a Breeze - A Look Into a MySQL DBA's Toolchest

The MySQL Server distribution includes several command-line tools for administrative purposes.

However, the included tools leave a lot to be desired – many common DBA tasks are more complicated to perform than necessary, others can’t be accomplished at all.

Fortunately, these gaps have nicely been filled by other Open Source projects in the meanwhile, providing a wide range of functionality to ease a MySQL DBA’s life.

In this session, Lenz will give an introduction and overview to the most popular and commonly used tools and tool collections that make performing MySQL administration tasks on Linux and other Unix systems a breeze.

The attendees will learn which tools are suitable to better tackle duties like user administration, setting up and administering replication setups, performing backups and security audits.

Among others, the session will cover the following tools and their most useful components:

• maatkit
• openark-kit
• kontrollkit
• securich
• xtrabackup
• mylvmbackup