How can this objective be met?
Add database retries to effectively use RDS with vertical scaling.
Use RDS with multi-AZ deployment.
Add a connection string to use an RDS read replica for read queries.
Add a connection string to use a read replica on an EC2 instance.
Explanations:
Vertical scaling involves increasing the instance size, which does not address the specific requirement of improving read-heavy performance. It could be beneficial for performance, but it doesn’t optimize read queries through multiple instances or replicas.
Multi-AZ deployments are primarily used for high availability and disaster recovery, not for improving read performance. It provides failover capabilities but does not provide extra read capacity.
Adding a connection string to use an RDS read replica directs read queries to a replica, allowing the primary instance to focus on write operations. This optimizes performance for read-heavy workloads.
Using a read replica on an EC2 instance is not an optimal solution for improving read performance. RDS read replicas are managed services and are designed for this purpose, while using EC2 introduces unnecessary complexity and overhead.
It appears that the answer is:
Add a connection string to use an RDS read replica for read queries.