Question

A financial services company runs a critical transaction processing application on an Amazon Aurora PostgreSQL cluster in us-east-1. Compliance requires an RPO of under 1 second and an RTO of under 5 minutes in the event of a full regional outage, and the disaster recovery region (us-west-2) must be able to accept application traffic quickly. The DevOps team must automate failover so that operators are not required to reconfigure the database endpoint manually during a regional event. Which approach BEST meets these requirements?

Accepted Answer

Configure an Aurora Global Database with a secondary cluster in us-west-2, and use a Route 53 health check with an Amazon EventBridge rule that triggers a Lambda function to perform a managed planned/unplanned failover promoting the secondary.

Answer

Enable automated cross-region snapshot copy of the Aurora cluster to us-west-2 every hour, and restore the most recent snapshot with a Lambda function when CloudWatch detects the primary is unhealthy.

Answer

Deploy a Multi-AZ Aurora cluster in us-east-1 with read replicas across three Availability Zones, relying on Aurora's automatic AZ failover to satisfy the regional recovery requirement.

Answer

Use AWS Database Migration Service with ongoing change data capture replication from us-east-1 to a standalone Aurora cluster in us-west-2, and switch the application connection string manually during an outage.