Question

A SysOps administrator manages a web application backed by an Amazon RDS for MySQL database. During peak hours, CloudWatch shows that the RDS instance's CPU is consistently above 90% and read latency has increased significantly. Analysis reveals that the same set of product catalog queries (which change infrequently) are being executed thousands of times per minute. The team wants to reduce the load on the database and improve response times with minimal application redesign. Which approach BEST addresses this situation?

Accepted Answer

Deploy an Amazon ElastiCache for Redis cluster and cache the frequently repeated read query results in front of the database

Answer

Convert the RDS instance to a larger instance type with Provisioned IOPS (io2) storage

Answer

Enable RDS Multi-AZ so that read traffic is automatically distributed to the standby instance

Answer

Migrate the database to Amazon DynamoDB to gain single-digit millisecond latency