froscon2010 - PREVIEW

FrOSCon
Free and Open Source Software Conference

Speakers
Lenz Grimmer
Schedule
Day Day 2 - 2010-08-22
Room HS6
Start time 17:45
Duration 01:00
Info
ID 591
Event type Lecture
Track OpenSQLCamp
Language used for presentation English
Feedback

A Look into a MySQL DBA's Toolchest

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 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