This site is archived.

MySQL Backup and Security - Best practices

LenZ's picture
Submitted by LenZ on Wed, 07/16/2008 - 02:07.
Placement
Session time: 
08/28/2008 - 15:00 - 08/28/2008 - 15:45
Conference booklet summary and bio
Article for conference booklet: 
The MySQL Server is a very widely used open source database system which is often used as the storage backend for Drupal sites. Therefore performing MySQL backups and maintaining a secure installation are two very common tasks for any Drupal administrator. In this talk, Lenz will provide useful hints and suggestions on how to improve the security of a MySQL installation and how to properly perform backups of the databases and tables. The session will cover both tools that are included in the MySQL Server distribution as well as common utilities and facilities provided by the operating system (Linux in particular). The part about improving MySQL Server security will talk about the available mechanisms on the server side and how they can be reinforced and accompanied with security features on the Operating System level. Various backup methods for MySQL exist (both logical and physical. The second part of the session will cover several available options and highlight some practical solutions as well as related tools. Users attending this session will hopefully pick up some useful hints and learn about best practices on how to secure their MySQL installations and how to perform proper and consistent backups.
Bios for conference booklet: 
Lenz Grimmer works for the Database Group at Sun Microsystems as a MySQL Community Relations Manager. He joined MySQL in 2002 as a release engineer, being in charge of building and publishing the official releases of the MySQL Server for the various supported platforms. Prior to joining MySQL, he was a developer in the SuSE Linux Distribution development team at SuSE Linux AG in Nuremberg, Germany. Lenz started using and advocating for Linux and Open Source Software in 1995, when he first got in touch with it during his computer science studies at the Berufsakademie in Mannheim, Germany.

Overview
The MySQL Server is a very widely used open source database system and often used as the storage backend for Drupal sites.
Creating backups and maintaining a secure installations are two very common tasks for any Drupal administrator.

In this talk, Lenz will provide useful hints and suggestions on how to improve the security of a MySQL installation and how to properly perform backups of the databases and tables. The session will cover both tools that are included in the MySQL server/distribution as well as common tools/facilities provided by the operating system (Linux in particular).

Agenda

  • Improving MySQL Server security
    • On the server side
    • On the OS level
  • MySQL Backup methods
    • Logical
    • Physical

Goals
Users attending this session should take home some useful hints on how to secure their MySQL installations and how to perform proper backup.