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

Security and Database Administration
Location: Ballroom E Level: Novice
Average rating: ****.
(4.70, 10 ratings)

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
Photo of Lenz Grimmer

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.

Comments on this page are now closed.


Picture of Lenz Grimmer
Lenz Grimmer
04/14/2010 10:49am PDT

Slides are available on SlideShare now:

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.