Disaster Recovery Planning for MySQL & MariaDB

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.

Get the whitepaper

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.

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.