Question

A CloudOps engineer manages a read-heavy e-commerce product catalog running on an Amazon RDS for MySQL Multi-AZ instance. CloudWatch shows the primary instance's CPUUtilization consistently at 85-90% and ReadIOPS very high during business hours, while WriteIOPS remains low. The same product records are queried repeatedly. Application read latency is climbing and customers are complaining. Which combination of changes will MOST effectively reduce load on the primary and improve read performance?

Accepted Answer

Add one or more RDS read replicas to serve read traffic and deploy Amazon ElastiCache in front of the database to cache frequently requested product records

Answer

Convert the Multi-AZ deployment to Single-AZ to free the standby instance's capacity for read queries

Answer

Enable RDS Performance Insights and increase the CloudWatch metric collection frequency to 1-second resolution

Answer

Increase the Provisioned IOPS on the primary instance's EBS volume and enable Multi-AZ automatic failover