froscon2010 - PREVIEW

FrOSCon
Free and Open Source Software Conference

Referenten
Lenz Grimmer
Programm
Tag Day 2 - 2010-08-22
Raum HS6
Beginn 17:45
Dauer 01:00
Info
ID 591
Veranstaltungstyp Vortrag
Track OpenSQLCamp
Sprache der Veranstaltung englisch
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