QuestionQ63

VerifiedMigrate data solutions

You have a transactional PostgreSQL system that is being overwhelmed by analytic queries during the work day. You want to shift this workload to AlloyDB for PostgreSQL and need the most cost-effective solution that supports both the transactional and analytic workloads with minimal downtime.

What should you do?

Explanation

An AlloyDB primary instance provides read/write access for the transactional workload, while a read pool provides read-only capacity for analytic queries. A read pool can be horizontally scaled by changing its node count without instance-level downtime; increasing the node count leaves client connections unaffected. Scheduling scale-out before the predictable work-day analytics peak and scaling back at night provides the needed capacity only when it is needed, reducing compute cost.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!