cloudnative wiki

GCP Databases & Storage Engine Hub

2 min read

GCP Databases & Storage Engine Hub 🗄️

Google Cloud provides an advanced, purpose-built database portfolio designed to handle every operational and analytical data access pattern—from single-instance relational databases to horizontally scalable, globally consistent multi-region databases powered by atomic TrueTime hardware clocks.

Service Catalog & Architecture Map

ServiceData ModelArchitecture & Consistency ProfileReference Guide
Cloud SQLRelational (PostgreSQL, MySQL, SQL Server)Managed OLTP engine, Regional synchronous HA failover (RPO = 0), and Cloud SQL Auth Proxy.Cloud SQL Deep Dive
Cloud SpannerGlobally Distributed RelationalTrueTime atomic clock synchronization, external consistency (serializability), and 99.999% SLA.Cloud Spanner Deep Dive
AlloyDB for PostgreSQLDisaggregated Relational EngineDisaggregated storage engine, log processing service, and integrated vectorized columnar engine.AlloyDB Deep Dive
Cloud BigtableNoSQL Wide-Column StorePetabyte-scale sub-10ms key-value storage, SSTables on Colossus, tablet auto-splitting.Cloud Bigtable Deep Dive
Cloud FirestoreServerless Document DatabaseMobile and web sync, multi-document ACID transactions, offline persistence, Native vs Datastore mode.Cloud Firestore Deep Dive
Cloud MemorystoreIn-Memory CacheFully managed Redis and Memcached, high-availability failover, and cluster sharding (up to 250 nodes).Cloud Memorystore Deep Dive
BigQueryServerless Data WarehouseCapacitor columnar format, Dremel query engine, and BigLake storage abstraction.BigQuery Deep Dive

Database Selection Decision Framework

flowchart TD
    Req["Database Workload Selection"] --> Model{"Data Model & Relational Requirement?"}

    Model -->|"Relational (SQL, ACID, Joins, Foreign Keys)"| Relational{"Scale & Consistency Requirements?"}
    Model -->|"Document (JSON, Mobile SDK, Real-Time Listeners)"| Firestore["Use Cloud Firestore"]
    Model -->|"Wide-Column NoSQL (Time-Series, IoT, Sub-10ms Millions QPS)"| Bigtable["Use Cloud Bigtable"]
    Model -->|"In-Memory Cache (Sub-Millisecond Key-Value / Redis)"| Memorystore["Use Cloud Memorystore (Redis/Memcached)"]
    Model -->|"Analytical OLAP (Petabyte SQL Queries / BI)"| BQ["Use Google BigQuery"]

    Relational -->|"Global Horizontal Multi-Master / 99.999% SLA"| Spanner["Use Cloud Spanner (TrueTime)"]
    Relational -->|"High-Performance PostgreSQL Enterprise / Columnar Acceleration"| AlloyDB["Use AlloyDB for PostgreSQL"]
    Relational -->|"Standard Regional Workloads (MySQL / Postgres / SQL Server)"| CloudSQL["Use Cloud SQL"]

Graph View

Backlinks