Objective.
Back up a MySQL database on demand and restore it to a point in time, into a new database.
Scenario.
An on-demand backup was taken and the database was restored to a target time after it.
Expected behaviour.
- Complete the backup.
- Restore into a new database to the target time.
- The restored database answers.
Measured recovery.
- Recovery time RTO
- 5 min 21 s
- How long recovery took.
- Application health
- Pass
Customer impact.
- Application availability
- The original database served throughout
What happened.
- Restore to the target time ordered.
- Restored database running and answering.
What we learned.
- The on-demand backup completed in 78 seconds.
What we changed.
- No change needed.
Scope of this drill.
This drill measured restore readiness; exact-row recovery is measured in the PostgreSQL drill.