What is the MOST operationally efficient solution that meets these requirements?

A company has a web application with a database tier that consists of an Amazon EC2 instance that runs MySQL. A SysOps administrator needs to minimize potential data loss and the time that is required to recover in the event of a database failure.

What is the MOST operationally efficient solution that meets these requirements?
A . Create an Amazon CloudWatch alarm for the StatusCheckFailed_System metric to invoke an AWS Lambda function that stops and starts the EC2 instance.
B . Create an Amazon RDS for MySQL Multi-AZ DB instance. Use a MySQL native backup that is stored in Amazon S3 to restore the data to the new database. Update the connection string in the web application.
C . Create an Amazon RDS for MySQL Single-AZ DB instance with a read replica. Use a MySQL native backup that is stored in Amazon S3 to restore the data to the new database. Update the connection string in the web application.
D . Use Amazon Data Lifecycle Manager (Amazon DLM) to take a snapshot of the Amazon Elastic Block Store (Amazon EBS) volume every hour. In the event of an EC2 instance failure, restore the EBS volume from a snapshot.

View Answer

Answer: B

Explanation:

Step-by-Step

Understand the Problem:

Minimize potential data loss and recovery time for a MySQL database running on an Amazon EC2 instance.

Analyze the Requirements:

Reduce the risk of data loss.

Ensure quick recovery in the event of a database failure.

Aim for operational efficiency.

Evaluate the Options:

Option A: Create a CloudWatch alarm to invoke a Lambda function that stops and starts the EC2 instance.

This addresses system failures but does not help with minimizing data loss or ensuring database redundancy.

Option B: Create an Amazon RDS for MySQL Multi-AZ DB instance and use a MySQL native backup stored in Amazon S3.

RDS Multi-AZ deployments provide high availability and durability by automatically replicating data to a standby instance in a different Availability Zone.

Using a MySQL native backup stored in Amazon S3 ensures data can be restored efficiently.

Option C: Create an RDS for MySQL Single-AZ DB instance with a read replica.

This provides read scalability but does not ensure high availability or failover capabilities.

Option D: Use Amazon DLM to take hourly snapshots of the EBS volume.

This helps with backups but does not provide immediate failover capabilities or minimize downtime effectively.

Select the Best Solution:

Option B: Using Amazon RDS for MySQL Multi-AZ ensures high availability and automated backups, significantly minimizing data loss and recovery time.

Reference: Amazon RDS Multi-AZ Deployments

Backing Up and Restoring an Amazon RDS DB Instance

Using Amazon RDS for MySQL Multi-AZ provides a highly available and durable solution with automated backups, ensuring minimal data loss and quick recovery.