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.
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.
Colin Charles works at Monty Program Ab, on MariaDB, and Open Ocean Investments on Web of Trust, and MoSync. He lives in Kuala Lumpur, Malaysia and had worked at MySQL since 2005. Before joining MySQL, he worked actively on the Fedora and OpenOffice.org projects. He’s spoken at many conferences – linux.conf.au, The MySQL Conference & Expo, foss.in, to name a few.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at email@example.com
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.