AWS Certified SysOps Administrator – AssociateCost and Performance OptimizationEasy
A development team uses an Amazon RDS for PostgreSQL database for their analytics application. They are experiencing performance bottlenecks during peak reporting times, specifically due to complex read-heavy queries. The primary database instance is already provisioned with sufficient compute and memory. Which AWS service or feature would be most effective in offloading the read workload and improving the application's reporting performance?
- ACreate an Amazon RDS Read Replica from the primary instance.
- BIncrease the storage size and IOPS of the primary RDS instance.
- CMigrate the read-heavy queries to an Amazon DynamoDB table.
- DEnable Multi-AZ deployment for the RDS instance.
Show answer & explanationAnswer & explanation
Correct answer: A. Create an Amazon RDS Read Replica from the primary instance.
Amazon RDS Read Replicas are specifically designed to offload read-heavy workloads from the primary database instance, improving performance for read-intensive applications like reporting tools. This allows the primary instance to focus on write operations.
Why the other options are wrong
- B. While increasing storage and IOPS might help with I/O-bound issues, it doesn't distribute the read workload, and the problem is described as complex read-heavy queries, suggesting CPU/memory contention on the primary instance.
- C. DynamoDB is a NoSQL database and migrating complex SQL queries to it would require significant application re-architecture and data model changes, which is not the most effective solution for offloading existing SQL read workloads.
- D. Multi-AZ provides high availability and disaster recovery but does not offload read workloads or improve read performance.
Amazon RDS Read Replicas
Copies of an Amazon RDS database instance that allow you to offload read-heavy database workloads from your primary database instance, improving performance for read-intensive applications.
- Asynchronous replication from primary instance.
- Can be promoted to standalone database instances.
- Supports cross-Region and cross-AZ replication.
Memory trick: RDS reads, replicas lead, performance indeed.