QuestionQ157

VerifiedPlanning and implementing a cloud solution

You need to migrate multiple PostgreSQL databases from your on-premises data center to Google Cloud. You want to significantly improve the performance of your databases while minimizing changes to your data schema and application code. You expect your largest database to exceed 150 TB of data per geographical region. You want to follow Google-recommended practices and minimize your operational costs. What should you do?

Explanation

Spanner's PostgreSQL interface lets you keep PostgreSQL schemas, SQL syntax, drivers and tools with limited rework. Spanner scales storage and throughput horizontally: it allots 10 TiB of storage per node, and its storage limit grows with the instance's compute capacity rather than stopping at a fixed database size, so a single database can exceed 150 TB per region. AlloyDB is PostgreSQL-compatible and fast, but a cluster supports at most 128 TiB of storage (about 140.7 TB), which is below the stated volume. Firestore is a document database and Bigtable is not a relational database, so both would need schema and application rewrites.

Learn more

Community Discussion

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