A media streaming company hosts its user profile database in the us-east-1 Region. The application requires local, sub-second read performance for users in the eu-west-1 Region. Additionally, the architecture must support a cross-region disaster recovery strategy with a Recovery Point Objective (RPO) of less than seconds and a Recovery Time Objective (RTO) of less than minutes. Which database configuration meets these requirements with the least operational overhead?
- ADeploy Amazon RDS for MySQL Multi-AZ DB instances in both us-east-1 and eu-west-1, and configure an Amazon Route 53 latency-based routing policy to route write traffic.
- Configure an Amazon Aurora Global Database with the primary cluster in us-east-1 and a secondary cluster in eu-west-1.Answer
- CDeploy an Amazon RDS for MySQL DB instance in us-east-1 and create a cross-region read replica in eu-west-1, configuring the application to automatically promote the read replica to primary during a failure.
- DImplement a Pilot Light disaster recovery plan by deploying a scaled-down Amazon RDS DB instance in eu-west-1 and backing up the database using daily cross-region snapshots.
Answer
Configure an Amazon Aurora Global Database with the primary cluster in us-east-1 and a secondary cluster in eu-west-1.
The correct database configuration is an Amazon Aurora Global Database with the primary cluster in us-east-1 and a secondary cluster in eu-west-1. Aurora Global Database uses dedicated storage-based replication that delivers sub-second replication latency (typically under second), meeting the -second RPO. In the event of a regional outage, the secondary cluster can be promoted to primary in less than minute, satisfying the -minute RTO. This provides local reads in the secondary region with the lowest operational overhead.
Step-by-Step Solution
Key Concept
High availability and disaster recovery configurations in Amazon Aurora
Estimated Time:1m 30s