Book 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
- Cover
- About the Authors
- About the Technical Editors
- Copyright
- Dedication
- Contents
- Acknowledgments
- Introduction
- 1. The Five Minute DBA
- 2. Understanding Backup Options
- 3. Understanding Business Requirements for Disaster Recovery
- 4. Using MySQL Replication
- 5. Using Recovery Options
- 6. MySQL Configuration Options
- 7. Disaster Scenarios
- 8. Optimizing Backup and Recovery
- 9. MySQL in the Cloud
- Index
Product information
- Title: Effective MySQL Backup and Recovery
- Author(s):
- Release date: May 2012
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071788588
You might also like
book
MySQL Troubleshooting
Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer …
book
Professional SQL Server High Availability and Disaster Recovery
Leverage powerful features of the SQL Server and watch your infrastructure transform into a high-performing, reliable …
book
Oracle Database 12c Backup and Recovery Survival Guide
A comprehensive guide for every DBA to learn recovery and backup solutions A practical reference to …
book
Introducing InnoDB Cluster: Learning the MySQL High Availability Stack
Set up, manage, and configure the new InnoDB Cluster feature in MySQL from Oracle. If you …