AWS Aurora Global Database Recovery

By using an Aurora global database, you can plan for recovery from disaster fairly quickly.

Recovery from disaster is typically measured using values for RTO and RPO.

• Recovery time objective (RTO) — The time it takes a system to return to a working state after a disaster. In other words, RTO measures downtime. For an Aurora global database, RTO can be in the order of minutes.
• Recovery point objective (RPO) — The amount of data that can be lost (measured in time). For an Aurora global database, RPO is typically measured in seconds.

With an Aurora global database, there are two different approaches to failover depending on the scenario.

1. Manual unplanned failover (“detach and promote”)

• To recover from an unplanned outage or to do disaster recovery (DR) testing, perform a cross-Region failover to one of the secondaries in your Aurora global database.
• The RTO for this manual process depends on how quickly you can perform the all the manual tasks listed.
• The RPO is typically measured in seconds, but this depends on the Aurora storage replication lag across the network at the time of the failure.

2. Managed planned failover

• This can only be perform for a managed…