Effective MySQL Backup and Recovery

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