Question

A company runs a production application on a single Amazon RDS for PostgreSQL Multi-AZ DB instance. During business hours, an internal analytics team runs heavy read-only reporting queries that increase CPU and read IOPS on the primary instance, causing the customer-facing application to experience slow response times. The SysOps administrator must offload the reporting workload without impacting the transactional application and with minimal ongoing operational effort. What should the administrator do?

Accepted Answer

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

Answer

Increase the instance class of the primary DB instance to a larger size to handle both workloads simultaneously.

Answer

Enable Multi-AZ and configure the analytics team to query the standby instance in the second Availability Zone.

Answer

Take an automated snapshot of the primary instance each morning and have the analytics team restore it into a separate reporting instance.