A company is developing a business-critical application.
Their RTO and RPO requirements call for a relational database in an active-active configuration, with zero downtime for all database operations.
What is the optimal database choice for these requirements?
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: C.
Option A is incorrect because Amazon Aurora Global Database uses a primary instance for write operations.
Although there is automatic fail-over capability, it is not without any downtime.
Option B is incorrect because the requirement specifically calls for a relational database.
Option C is CORRECT because the Amazon Aurora Multi-Master cluster offers write capability to multiple instances.
In applications where zero downtime is required for database write operations, a multi-master cluster can be used to avoid an outage when a writer instance becomes unavailable.
Option D is incorrect because Amazon RDS with Multi-AZ does not meet the requirements.
This capability can be used for automatic failover.However, the Multi-AZ instances are not accessible during normal operation.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-multi-master.htmlThe optimal database choice for the given requirements of an RTO and RPO with zero downtime for all database operations is Amazon Aurora Global Database (option A).
Amazon Aurora is a relational database service that is designed for high availability and fault tolerance. Aurora Global Database is a feature that allows for an active-active configuration in multiple AWS regions. This means that read and write operations can be performed on all replicas of the database in real-time. Therefore, in case of a failure in one region, the application can automatically redirect to another region with minimal interruption to the service.
Option B, Amazon DynamoDB with global tables, is a NoSQL database service that allows for data to be replicated across multiple regions. While it provides high availability, it may not be the best choice for a relational database with complex querying requirements.
Option C, Amazon Aurora Multi-Master Cluster, is another Aurora feature that allows for multiple read-write instances of the database in the same region. While this provides high availability, it may not be sufficient for global disaster recovery or multi-region resiliency.
Option D, Amazon RDS with Multi-AZ, is a feature of Amazon Relational Database Service (RDS) that provides high availability by replicating the database to multiple availability zones within the same region. While this provides redundancy within a region, it does not provide global disaster recovery or multi-region resiliency.
In summary, Amazon Aurora Global Database is the optimal choice for a business-critical application that requires zero downtime with an active-active configuration in multiple regions.