AWS Certified Solutions Architect – ProfessionalDesign for New SolutionsMedium
A large enterprise is migrating a critical, highly transactional legacy application to AWS. The application requires a relational database that can sustain millions of transactions per second, offer high availability with automatic failover, and provide disaster recovery across multiple AWS regions with a Recovery Point Objective (RPO) of seconds and a Recovery Time Objective (RTO) of minutes. Which AWS database solution is most appropriate?
- AAmazon DynamoDB Global Tables.
- BAmazon Redshift with cross-Region snapshot replication.
- CAmazon RDS for PostgreSQL Multi-AZ with cross-Region read replicas.
- DAmazon Aurora MySQL with Aurora Global Database.
Show answer & explanationAnswer & explanation
Correct answer: D. Amazon Aurora MySQL with Aurora Global Database.
Aurora Global Database is specifically designed for global applications, offering fast RPO (seconds) and RTO (minutes) across regions for disaster recovery, while providing high performance and availability for transactional workloads with Aurora's architecture.
Why the other options are wrong
- A. DynamoDB Global Tables are suitable for NoSQL workloads, but the question specifies a relational database for a 'highly transactional legacy application'.
- B. Redshift is a data warehouse service, not a transactional relational database. Cross-Region snapshot replication provides DR for data warehouses, but not for high-transactional OLTP applications.
- C. RDS Multi-AZ provides high availability within a region and read scaling with cross-Region read replicas, but does not offer the RPO/RTO guarantees of Aurora Global Database for cross-Region disaster recovery.
Aurora Global Database
A feature of Amazon Aurora that spans multiple AWS regions, enabling fast disaster recovery with an RPO of seconds and an RTO of minutes.
- Single primary DB instance in one region, up to 5 read-only secondary regions.
- Asynchronous replication with minimal latency.
- Designed for global applications and fast disaster recovery.
Memory trick: Aurora Global Database Guarantees Rapid Recovery.