A large enterprise is migrating a critical, highly transactional legacy application to AWS. The application requires a relational database that can scale reads globally across multiple regions with very low latency, support fast disaster recovery (RTO in minutes, RPO in seconds), and maintain strong consistency within the primary region. The database must also be compatible with PostgreSQL. Which database solution should a solutions architect recommend?
- AAmazon RDS for PostgreSQL with cross-region read replicas
- BAmazon DynamoDB Global Tables
- CAmazon Aurora Global Database (PostgreSQL compatible)
- DAmazon Redshift
Show answer & explanationAnswer & explanation
Correct answer: C. Amazon Aurora Global Database (PostgreSQL compatible)
Aurora Global Database provides a single Aurora cluster spanning multiple regions, allowing very low-latency global reads from secondary regions, fast disaster recovery (RTO/RPO in minutes/seconds), and maintains strong consistency in the primary region, all while being PostgreSQL compatible.
Why the other options are wrong
- A. RDS for PostgreSQL with cross-region read replicas offers global reads but typically has higher RPO/RTO than Aurora Global Database and doesn't provide the same low-latency global read performance for critical applications.
- B. DynamoDB Global Tables is a NoSQL database, and the requirement specifies a 'relational database' compatible with PostgreSQL.
- D. Amazon Redshift is a data warehouse solution and is not suitable for highly transactional operational workloads requiring a relational database with global read scaling and fast disaster recovery.
Aurora Global Database for DR
Amazon Aurora Global Database is a single database spanning multiple AWS regions, enabling fast local reads in secondary regions, rapid disaster recovery (RTO/RPO in minutes/seconds), and maintaining strong consistency in the primary region for critical relational workloads.
- Single database spans multiple regions.
- Low-latency global reads from secondary regions.
- RPO in seconds, RTO in minutes for disaster recovery.
- PostgreSQL and MySQL compatible.
Memory trick: Aurora Global Database is the ultimate relational fortress, globally accessible and rapidly recoverable.