A company’s reporting job that previously ran in 15 minutes is now taking 1 hour.

RDS read replicas offload read traffic from the primary database, improving performance and availability. By directing reporting queries to the reader endpoint, the primary instance is freed from heavy read workloads.

ElastiCache is unsuitable for complex SQL reporting. CloudFront cannot front a database. Increasing instance size does not address inefficient read scaling.

Thus, read replicas are the correct solution.