Answer-first summary for fast verification
Answer: Employ RDS read replicas with application code adjustments for replica usage.
The correct answer is 'C'. For read-heavy workloads, using Amazon RDS read replicas is the most effective way to achieve high read performance. Read replicas distribute the database read operations, which significantly improves read scalability and performance. Multi-AZ deployments are mainly used for high availability and failover but do not improve read performance. Using open-source replication software on an EC2 instance would involve more effort compared to utilizing managed read replicas in RDS.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A company is migrating to Amazon RDS for MySQL with a focus on optimizing for read-heavy workloads. What is the most efficient solution for achieving high read performance with minimal ongoing effort?
A
Implement a multi-AZ RDS setup and scale connection usage.
B
Utilize multi-AZ RDS with code modifications for secondary instance access.
C
Employ RDS read replicas with application code adjustments for replica usage.
D
Adopt open-source replication on EC2, redirecting queries to the EC2 instance.