A PostgreSQL-based SaaS platform needs horizontal read scaling with low lag, wants to remain 100 percent PostgreSQL compatible, and may later add a secondary deployment in another region. Which architecture fits best?

Question

Accepted Answer

B. AlloyDB cluster with a read pool and optional secondary cluster. An AlloyDB cluster matches this design because it remains fully PostgreSQL compatible, uses a read pool for horizontal read scaling, and can replicate to secondary clusters in separate regions. Firestore is a document database and does not satisfy the PostgreSQL compatibility requirement.

A PostgreSQL-based SaaS platform needs horizontal read scaling with low lag, wants to remain 100 percent PostgreSQL compatible, and may later add a secondary deployment in another region. Which architecture fits best?

Related Questions

Discussion