You have a read-intensive application hosted in AWS. The application is currently using the MySQL RDS feature in AWS. The CloudWatch metrics show high-read throughput on the database and are causing performance issues on the database. Which of the following can be used to increase the read throughput on the MySQL database?

Answer options:

A.Enable the Multi-AZ on the MySQL RDS.
B.Use Cold Storage Volumes for the MySQL RDS.
C.Enable Read Replica.
D.Use SQS to queue up the reads.

Answer – C
The AWS documentation mentions the following on Read Replica.
Amazon RDS Read Replicas provide enhanced performance and durability for database (DB) instances. This replication feature makes it easy to elastically scale out beyond a single DB Instance`s capacity constraints for read-heavy database workloads. You can create one or more replicas of a given source DB Instance and serve high-volume application read traffic from multiple copies of your data, thereby increasing aggregate read throughput. Read replicas can also be promoted when needed to become standalone DB instances.
Option A is invalid since this is used for fault tolerance for the database.
Option B is invalid since this is not the ideal storage mechanism for databases that require high read throughput.
Option D is invalid since SQS is used as a decoupling component and would not be ideal for reducing the reads on the database.
For more information on Read Replica, please visit the below URL-
https://aws.amazon.com/rds/details/read-replicas/