Requirement Summary:
E-commerce app using Amazon RDS for MySQL
Needs caching layer for most-viewed products
Evaluate Options:
A. Add a cache node to RDS
No such feature in RDS for MySQL
Caching must be implemented outside RDS
B. ElastiCache for Redis (OSS)
Purpose-built for caching frequently accessed data
Reduces read pressure on RDS
Fast in-memory access (microseconds)
Seamless integration into app logic
C. DynamoDB DAX
DAX is for accelerating DynamoDB, not RDS
D. RDS standby instance
Read from standby is not allowed
Standby is for failover 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/