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

People planning to attend this session also want to see:

Lenz Grimmer

Sun Microsystems

Lenz Grimmer is a member of the MySQL Community Relations team at Sun Microsystems. He lives in Hamburg, Germany and has worked for MySQL since April, 2002. Before joining the community team in December 2005, he was a member of the release engineering team that is in charge of creating the official release builds of the MySQL server and related products. Prior to working for MySQL AB, he was a developer at the distribution engineering team at SuSE Linux AG, Nuernberg, Germany.