Effective MySQL: Backup & Recovery

  • 3h 33m
  • Ronald Bradford
  • Oracle Press
  • 2012

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

About the Author

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.

In this Book

  • The Five Minute DBA
  • Understanding Backup Options
  • Understanding Business Requirements for Disaster Recovery
  • Using MySQL Replication
  • Using Recovery Options
  • MySQL Configuration Options
  • Disaster Scenarios
  • Optimizing Backup and Recovery
  • MySQL in the Cloud