A digital publishing company operates a high-traffic news website with a global audience. The website's user session state and personalized content recommendations are managed by an Amazon RDS for MySQL database. During major breaking news events, the website experiences massive traffic spikes, leading to high CPU utilization and database connection exhaustion on the RDS database due to a massive volume of session read and write operations. The company wants to optimize the database performance and reduce latency by offloading the session management to an in-memory caching tier. The session data must meet the following requirements:
- Retrieve and update session data with sub-millisecond latency.
- Scale horizontally to handle sudden traffic spikes.
- Support data persistence and backup/restore capabilities to recover user session state in the event of an outage.
- Support replication across multiple Availability Zones with automatic failover to maintain high availability.
Which solution should a solutions architect recommend to meet these requirements with the least operational overhead?
- Migrate the session state management to an Amazon ElastiCache for Redis cluster with Multi-AZ enabled and automatic failover, and configure automatic backups to Amazon S3.Cevap
- BMigrate the session state management to an Amazon ElastiCache for Memcached cluster, configuring the nodes across multiple Availability Zones to ensure replication, and schedule regular snapshot exports to Amazon S3.
- CDeploy Amazon RDS Proxy in front of the RDS for MySQL database to pool database connections, and configure an Amazon RDS Multi-AZ standby instance to offload and scale the session read traffic.
- DConfigure a secondary Amazon RDS for MySQL database in another AWS Region, and use an AWS Lambda-based active-passive pilot light replication strategy to replicate session data, routing traffic using Route 53.