What should the solutions architect recommend to solve these issues?
Migrate the database to Amazon Aurora with Aurora Replicas.
Migrate the database to Amazon DynamoDB with global tables.
Add an Amazon ElastiCache for Redis layer in front of the database.
Add an Amazon ElastiCache for Memcached layer in front of the database.
Explanations:
Aurora offers snapshots and replication, but it is not designed specifically for sub-millisecond response times needed for high-speed reads. Aurora is also still relational, and migration may not resolve performance issues for read-heavy workloads.
DynamoDB provides low-latency access and global tables for replication but does not support SQL-based queries directly, making migration challenging. Additionally, there is no native compatibility with RDS snapshots.
ElastiCache for Redis provides sub-millisecond response times, snapshot capabilities, and replication, ideal for caching frequently accessed data and reducing load on the RDS instance.
While ElastiCache for Memcached provides sub-millisecond response times, it lacks snapshot and native replication capabilities, making it less suitable for durability and availability needs.