Learn the simplest solution to mitigate the risk of a single point of failure for an Amazon RDS MySQL database instance that requires the least 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
The correct answer is A. Modifying the existing Amazon RDS for MySQL DB instance to use a Multi-AZ deployment is the solution that meets the requirements with the least implementation effort.
With a Multi-AZ deployment, Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone. In the event of a planned or unplanned outage of the primary DB instance, Amazon RDS automatically fails over to the standby replica, minimizing downtime.
This solution requires simply modifying the configuration of the existing RDS DB instance, which can be done with minimal effort during the next maintenance window. It does not require migrating to a different database like DynamoDB (option B), manually restoring data to a new instance (option C), or managing database EC2 instances directly in an Auto Scaling group (option D).
Therefore, enabling Multi-AZ on the existing managed RDS MySQL instance is the easiest way to eliminate the database as a single point of failure. The other options involve much more implementation complexity and effort.
In summary, converting the single Amazon RDS MySQL database to a Multi-AZ deployment is the simplest solution to mitigate the risk of it being a single point of failure, requiring the least implementation effort compared to the other options presented.
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.