Question

A financial reporting application runs on Amazon Aurora MySQL. During business hours, analysts generate large numbers of read-only dashboard queries that overwhelm the primary database instance, causing write transactions from the core application to slow down. The team wants to offload the reporting queries and improve availability without changing the application's write path. Which solution best meets these requirements?

Accepted Answer

Add Aurora Replicas and configure the reporting application to use the Aurora reader endpoint for its queries.

Answer

Enable Multi-AZ on the Aurora primary instance and route all queries to the cluster endpoint.

Answer

Vertically scale the primary Aurora instance to a larger instance class to handle both reads and writes.

Answer

Create a manual snapshot of the cluster each morning and restore it into a separate cluster for reporting.