Question

A financial services company runs a transactional web application on an Amazon RDS for PostgreSQL Multi-AZ instance. During business hours, the analytics team runs long, complex read-only reporting queries directly against the primary database. These reports are causing high CPU utilization and slowing down customer-facing write transactions. The company wants to eliminate the performance impact on the primary while keeping operational overhead low. What should the solutions architect recommend?

Accepted Answer

Create one or more RDS read replicas and direct the analytics reporting queries to the replica endpoint.

Answer

Promote the Multi-AZ standby instance to serve the reporting queries during business hours.

Answer

Add an Amazon ElastiCache for Redis cluster in front of RDS to cache the reporting query results.

Answer

Increase the RDS instance size to a larger instance class to handle both workloads simultaneously.