A company is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs). The site performs a high number of repetitive reads and writes each second on an Amazon RDS for MySQL Multi-AZ DB instance with General Purpose SSD (gp2) storage. After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance. Which approach should the database specialist to take to resolve this issue without changing the application?
A) Implementing sharding to distribute the load to multiple RDS for MySQL databases.
B) Use the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.
C) Add an RDS for MySQL read replica.
D) Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS).

Question

Quizplus · Accepted Answer

Adding an RDS for MySQL read replica can help offload read traffic from the primary DB instance, reducing read latency and CPU utilization without changing the application.

A Company Is Running a Website on Amazon EC2 Instances