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

Table of Contents

Chapter 1 The Five Minute DBA
Chapter 2 Understanding Backup Options
Chapter 3 Understanding Business Requirements for Disaster Recovery
Chapter 4 Using MySQL Replication
Chapter 5 Using Recovery Options
Chapter 6 MySQL Configuration Options
Chapter 7 Disaster Scenarios
Chapter 8 Optimizing Backup and Recovery
Chapter 9 MySQL in the Cloud