Question

Your team runs a transactional web application backed by a Cloud SQL for PostgreSQL instance. The analytics team runs heavy read-only reporting queries that are slowing down the primary database and affecting customer-facing transactions. You need to offload these reporting queries without changing the application's write path or migrating to a different database engine. What should you do?

Accepted Answer

Create a Cloud SQL read replica and direct the analytics team's reporting queries to the replica's connection endpoint.

Answer

Increase the machine type of the primary Cloud SQL instance to handle both the transactional and reporting workloads.

Answer

Enable high availability (HA) on the Cloud SQL instance and point the reporting queries to the standby instance.

Answer

Export the database to BigQuery on a nightly schedule and have the analytics team query BigQuery instead.