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