Effective MySQL Backup and Recovery

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.



July 10, 2012


Mixed media product, 256 pages

Other Formats


0071788573 / 9780071788571


Your Price



Main description

The Essential Guide to Protecting Your Business Information

Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Backup and Recovery covers all the options with detailed descriptions and syntax examples to ensure an appropriate backup and recovery plan can be developed. Featuring a side-by-side evaluation of the various backup strategies and complementary recovery implementations, this Oracle Press book helps you to protect your MySQL data from a wide range of disaster situations.

  • Learn how different backup strategies affect locking and system availability
  • Identify the importance of static backup options and point-in-time requirements
  • Recognize the important business factors to determine your optimal data protection requirements
  • Understand the benefits of using MySQL replication for leveraging different backup strategies
  • Understand the benefits and risks of implementing solutions with MySQL in the cloud
  • Identify key configuration variables that affect data durability and performance
  • Find out about the types of possible disasters and develop a robust plan to address them
  • Optimize your backup approach with compression, streaming, incremental, and parallel options

Table of contents

1. The Five Minute DBA
2. Understanding Backup Options
3. Understanding Business Requirements
4. Using Replication
5. Understanding Recovery Options
6. MySQL Configuration Options
7. Disaster Scenarios
8. Optimizing Backup & Recovery
9. References

Author comments

Ronald Bradford is an Oracle ACE Director and MySQL Community Member of the Year. He is also the visionary force behind the Effective MySQL series Ronald is a respected industry expert with more than 20 years of experience in the relational database field, with 12 years of experience working with MySQL. He combines his extensive consulting expertise with numerous public speaking events at conferences worldwide. Ronald is the all-time top individual MySQL blogger.

Copyright 2014 McGraw-Hill Global Education Holdings, LLC


Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.

Yes, I want to receive other special offer.