Database outages are almost inevitable and understanding the timeline of an outage can help us better prepare, diagnose and recover from one. To mitigate the impact of downtime, organizations need an appropriate disaster recovery (DR) plan. This white paper provides essential insights into how to build such a plan, discussing the database mechanisms involved as well as how these mechanisms can be fully automated with ClusterControl, a management platform for open source database systems.
Disaster Recovery Planning for MySQL & MariaDB
Introducton
Database outages are almost inevitable and understanding the timeline of an outage can help us better prepare, diagnose and recover from one. To mitigate the impact of downtime, organizations need an appropriate disaster recovery (DR) plan. This white paper provides essential insights into how to build such a plan, discussing the database mechanisms involved as well as how these mechanisms can be fully automated with ClusterControl, a management platform for open source database systems.
Want to read the rest? Just login and download for free
Table of contents
- Introduction
- Business considerations for Disaster Recovery
- Is 100% Uptime Possible?
- Analysing risk
- Assessing business impact
- Defining Disaster Recovery?
- Outage Timeline
- Recovery Time Objective
- Recovery Point Objective
- RPO + RTO = 0 ?
- Disaster Recovery Tiers
- 1. No Offsite Data
- 2. Database Backup with no Hot Site
- 3. Database Backup with Hot Site
- 4. Asynchronous Replication to Hot Site
- 5. Synchronous Replication to Hot Site
- In Conclusion
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.
Follow Us
