A company is developing a business-critical application.
Their RTO and RPO requirements call for a database with data storage in three AWS regions.
The company wants to minimize the latency of all database operations.
What is the optimal solution for these requirements?
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: B.
Option A is incorrect because write operations are issued directly to the primary DB instance in the primary AWS Region.
This does not reduce the latency of write operations.
Option B is CORRECT because DynamoDB global tables automatically replicate data across two or more AWS Regions, with full support for multi-master writes.
Option C is incorrect because the Aurora Multi-Master cluster supports a maximum of two DB instances in a multi-master cluster.
Additionally, all DB instances in a multi-master cluster must be in the same AWS Region.
These limitations do not meet the three-region requirement.
Option D is incorrect because Amazon RDS with Multi-AZ does not meet the multi-region requirement.Also, these instances are used for automatic failover.
However, they are not accessible during normal operation.
Reference:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/V2globaltables_HowItWorks.html https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Streams.CrossRegionRepl.html https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.htmlThe company requires a database with data storage in three AWS regions to ensure that the business-critical application can continue to function in the event of an outage in any one region. The Recovery Time Objective (RTO) and Recovery Point Objective (RPO) requirements dictate that the database must be highly available and durable, respectively. The company also wants to minimize the latency of all database operations to ensure that the application performs well.
Option A: Amazon Aurora Global Database Amazon Aurora Global Database is a globally distributed relational database service that provides low-latency access to a single database across multiple AWS regions. It replicates the data to all regions automatically and provides fast read and write performance. Aurora Global Database meets the requirements of RTO and RPO, but it may not provide the lowest latency for all database operations across all regions.
Option B: Amazon DynamoDB with Global Tables Amazon DynamoDB is a fully managed NoSQL database service that offers low latency, high scalability, and availability. Global Tables feature of DynamoDB enables the replication of data to multiple AWS regions and provides fast, local access to data in any region. This option meets the requirements of RTO and RPO, and also offers the lowest latency for all database operations across all regions.
Option C: Amazon Aurora Multi-Master Cluster Amazon Aurora Multi-Master Cluster is a distributed database that allows multiple read/write nodes across multiple AWS regions. It replicates data across all regions automatically and provides fast read and write performance. Aurora Multi-Master Cluster meets the requirements of RTO and RPO, but may not provide the lowest latency for all database operations across all regions.
Option D: Amazon RDS with Multi-AZ Amazon RDS is a managed relational database service that provides high availability and durability. Multi-AZ feature of RDS creates a standby database instance in another AWS region that automatically takes over in case of an outage in the primary region. This option meets the requirements of RTO and RPO, but may not provide the lowest latency for all database operations across all regions.
Based on the requirements of RTO, RPO, and lowest latency for all database operations across all regions, the optimal solution is Option B: Amazon DynamoDB with Global Tables.