You own a MySQL RDS instance in AWS Region us-east-1. The instance has a Multi-AZ instance in another availability zone for high availability. As business grows, more and more clients come from Europe (eu-west-2), and most of the database workload is read-only. What is the proper way to reduce the load on the source RDS instance?

Answer options:

A.Create a snapshot of the instance and launch a new instance in eu-west-2.
B.Promote the Multi-AZ instance to be a Read Replica and move the instance to eu-west-2 region.
C.Configure a read-only Multi-AZ instance in eu-west-2 as Read Replicas cannot span across regions.
D.Create a Read Replica in the AWS Region eu-west-2.

Correct Answer – D
Read Replica should be used to share the read workload of the source DB instance. Read Replica can also be configured in a different AWS region. Refer to this link-https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html.
Option A is incorrect: Because Read Replica should be configured to share the read traffic. You should not launch a totally new instance.
Option B is incorrect: Because a Multi-AZ instance cannot be promoted to be a Read Replica.
Option C is incorrect: Because a Read Replica can be launched in another region for RDS MySQL.
Option D is CORRECT: Users can quickly configure a Read Replica in another region.