MySQL Server Backup, Restoration, and Disaster Recovery Planning

Lenz Grimmer (Sun Microsystems), Colin Charles (SkySQL Ab/MariaDB Foundation)
Average rating: ****.
(4.00, 4 ratings)

Performing backups, recovery and disaster planning are some of the most important functions of a database administrator. However, these functions are often neglected. Just ask the DBA for the Denver post: http://neighbors.denverpost.com/viewtopic.php?f=56&t=123003000

This session will cover what software can be used for backups highlighting the venerable mysqldump and the online backup of MySQL server 6.0. I will touch on all other commonly used backup options as well.

Backup strategies are next. What to backup, where to store the data, and how long to store the data are points of fundamental importance to your backup strategy. Each of these will be covered.

In addition, I will cover the recovery process, and the preparation of a disaster recovery plan. All the backups in the world do no good if you can’t restore what you backed up. More than once I have seen situations where people thought they were performing proper backups but they didn’t restore and test these backups. When these backups were needed they just didn’t work.

Many database administrators don’t even know what a disaster plan is. I will cover the basics of a disaster plan and why they are important to an organizations data.

Emphasis on practicality and common sense (which is not very common)

.. such as ..

“Do you check your backups to make certain that they are really backing up correctly?” “Do you have a plan for when the hurricane wipes out your data center?” “Maybe it is a good idea to back up the users also….” “Did you really check to make sure you backup was done correctly?”

and my favorite

“If you don’t perform backups and check them routinely…polish up your resume. Just don’t ask me for a job!”

Backups, recovery and disaster planning will never be hip and cool. But they are too important to neglect. This session will teach you how and why you should perform backups. Just as important you will learn why you should plan beyond the actual backup.

Photo of Lenz Grimmer

Lenz Grimmer

Sun Microsystems

Lenz Grimmer is a member of the MySQL Community Relations team of the Database Group 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.

Photo of Colin Charles

Colin Charles

SkySQL Ab/MariaDB Foundation

Colin Charles works on MariaDB at SkySQL. He has been the Chief Evangelist for MariaDB since 2009, with work ranging from speaking engagements to consultancy and engineering works around MariaDB. He lives in Kuala Lumpur, Malaysia and had worked at MySQL since 2005, and been a MySQL user since 2000. Before joining MySQL, he worked actively on the Fedora and OpenOffice.org projects. He’s well known within open source communities in Asia and Australia, and has spoken at many conferences to boot.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL 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@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.