bcgov / bcgov/entity

Evaluate Need for Cloud SQL Read Replicas Across Projects

Open
#32,364 3 comments 0 reactions 1 assignee Claimed by @panish16 View on GitHub
SRE
Dominant language
JavaScript
Stars
23
Forks
62
Avg merge
24m
Merged PRs (30d)
1

Description

Some projects currently have Cloud SQL read replicas configured, but it’s unclear whether they are actually needed or being used.

Observations so far:

Many instances are Enterprise (non-Enterprise Plus), so features like cross-region DR replicas or read pools don’t apply.
Read replicas do not automatically route reads. Jobs and applications require separate connection strings to use them.
Most jobs perform writes, so they cannot safely use a replica.

No documented services or workloads are currently configured to read from these replicas.
The apparent use case may be for manual/ad-hoc queries, but this isn’t confirmed. Read replicas effectively double storage costs.

Which read replicas are actually being used, and by whom?
Are they intended only for manual queries?
Do any workloads require read scaling or DR for these replicas?

Evaluate each read replica across projects for actual usage and value.

Decide whether to:

Keep (and document usage/connection strategy)

Remove (to reduce cost and complexity)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.