A developer is working on an ecommerce application that stores data in an Amazon RDS...

Requirement Summary:

E-commerce app usingAmazon RDS for MySQL

Needscaching layerformost-viewed products

Evaluate Options:

A. Add a cache node to RDS

❌No such feature inRDS for MySQL

Caching must be implementedoutsideRDS

✅B. ElastiCache for Redis (OSS)

✅Purpose-built forcachingfrequently accessed data

✅Reduces read pressure on RDS

✅Fast in-memory access (microseconds)

✅Seamless integration into app logic

C. DynamoDB DAX

❌DAX is for acceleratingDynamoDB, not RDS

D. RDS standby instance

❌Read from standby is not allowed

Standby is forfailover only, not for load balancing

ElastiCache for Redis:https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/WhatIs.html

Caching with Redis for RDS:https://aws.amazon.com/blogs/database/caching-strategies-using-amazon-elasticache-for-read-heavy-workloads-on-amazon-rds/