Learn the simplest solution to protect a single Amazon RDS MySQL DB instance against the risk of a single point of failure, while minimizing implementation effort.
Table of Contents
Question
A company hosts an ecommerce application that stores all data in a single Amazon RDS for MySQL DB instance that is fully managed by AWS. The company needs to mitigate the risk of a single point of failure.
Which solution will meet these requirements with the LEAST implementation effort?
A. Modify the RDS DB instance to use a Multi-AZ deployment. Apply the changes during the next maintenance window.
B. Migrate the current database to a new Amazon DynamoDB Multi-AZ deployment. Use AWS Database Migration Service (AWS DMS) with a heterogeneous migration strategy to migrate the current RDS DB instance to DynamoDB tables.
C. Create a new RDS DB instance in a Multi-AZ deployment. Manually restore the data from the existing RDS DB instance from the most recent snapshot.
D. Configure the DB instance in an Amazon EC2 Auto Scaling group with a minimum group size of three. Use Amazon Route 53 simple routing to distribute requests to all DB instances.
Answer
A. Modify the RDS DB instance to use a Multi-AZ deployment. Apply the changes during the next maintenance window.
Explanation
Amazon RDS Multi-AZ deployments provide enhanced availability and durability for database instances. When you create or modify your DB instance to run as a Multi-AZ deployment, Amazon RDS automatically creates a primary DB instance and synchronously replicates the data to a standby instance in a different Availability Zone (AZ). In case of an infrastructure failure, Amazon RDS performs an automatic failover to the standby, minimizing downtime.
Enabling Multi-AZ for an existing RDS DB instance is a simple process that can be done through the AWS Management Console, AWS CLI, or API. AWS manages the replication and failover processes, making it the easiest option to implement compared to the other choices.
The other options have drawbacks:
B. Migrating from RDS to DynamoDB would require significant effort to redesign the application and database structure. It’s not the least effort solution.
C. Creating a new Multi-AZ RDS instance and manually restoring data from a snapshot involves more steps and downtime than simply modifying the existing instance.
D. Configuring the DB instance in an EC2 Auto Scaling group would require substantial effort to set up EC2 instances, configure replication, and modify the application to handle distributed database requests. It’s far more complex than using RDS Multi-AZ.
Therefore, enabling Multi-AZ for the existing RDS DB instance is the best choice to mitigate single point of failure risk with minimal effort.
Amazon AWS Certified Solutions Architect – Associate SAA-C03 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Amazon AWS Certified Solutions Architect – Associate SAA-C03 exam and earn Amazon AWS Certified Solutions Architect – Associate SAA-C03 certification.