A company runs an internal analytics application in a single AWS Region. A solutions architect is reviewing the Amazon RDS for MySQL deployment and finds a Multi-AZ DB instance with a standby in another Availability Zone, used only for failover. The application performs many read-heavy queries against the primary instance, driving up instance size and cost. The team wants to offload read traffic and reduce the primary instance size. Which change should the architect recommend?
RDS read replicas serve read-only traffic on separate instances, letting the team offload read-heavy queries and shrink the primary instance. This directly addresses the cost driver, which is an oversized primary handling both reads and writes, and it works within a single Region while the Multi-AZ standby continues to provide high availability for failover.
Why this answer
Adding RDS read replicas moves read-heavy queries onto separate instances, relieving the primary and enabling a smaller, cheaper primary instance. The Multi-AZ standby exists only for failover and cannot serve reads, so the architect should introduce read replicas rather than re-architecting the deployment or switching database engines.
Exam trap
The trap here is assuming the Multi-AZ standby can serve read traffic, when a Multi-AZ DB instance standby is strictly for failover and never handles application reads.