Which solution meets these requirements?

A company wants to build a solution for its business-critical Amazon RDS for MySQL database. The database requires high availability across different geographic locations. A SysOps administrator must build a solution to handle a disaster recovery (DR) scenario with the lowest recovery time objective (RTO) and recovery point objective (RPO).

Which solution meets these requirements?
A . Create automated snapshots of the database on a schedule. Copy the snapshots to the DR Region.
B . Create a cross-Region read replica for the database.
C . Create a Multi-AZ read replica for the database.
D . Schedule AWS Lambda functions to create snapshots of the source database and to copy the snapshots to a DR Region.

View Answer

Answer: B

Explanation:

To ensure high availability and disaster recovery for the RDS for MySQL database, follow these steps:

Create a Cross-Region Read Replica:

In the RDS console, create a cross-Region read replica of the primary database instance. This read replica will provide high availability and the lowest RTO and RPO in case of a disaster.

Reference: Creating a Read Replica in a Different AWS Region

This solution ensures that your database is replicated across regions, providing robust disaster recovery capabilities with minimal recovery time and data loss.