Google Cloud · Software · YoctoIT tech page

Cloud SQL & AlloyDB

The managed databases: MySQL and PostgreSQL without administration, and AlloyDB — the Postgres boosted by Google for serious workloads.

FOCUS · POSTGRES WITHOUT WORRIESHA, backups and patches included; AlloyDB when Postgres must run fast
Request the Free Assessment Learn more
YoctoIT material for clients and partners · Google Cloud, BigQuery, Gemini and the other products mentioned are trademarks of Google LLC.
01 · What it is

Cloud SQL & AlloyDB, made clear.

Cloud SQL manages MySQL, PostgreSQL and SQL Server: HA with automatic failover, point-in-time backups, hands-free patches and replicas. AlloyDB is the Postgres re-engineered by Google: distributed storage, a columnar engine for in-place analytics and 4x performance — while staying 100% compatible.

99,99%
the Cloud SQL Enterprise Plus SLA, failover included
4x
AlloyDB vs standard Postgres on transactional workloads (Google figure)
PITR
point-in-time recovery: the 11:47 mistake undone at 12:00
Cloud SQL & AlloyDB
OFFICIAL GOOGLE CLOUD BRANDING · CLOUD SQL & ALLOYDB
CONSOLE REALE · CLOUD SQL INSIGHTS · FONTE: GOOGLE CLOUD DOCS
REAL CONSOLE · CLOUD SQL INSIGHTS · SOURCE: GOOGLE CLOUD DOCS
02 · How to use it well

The things that make the difference.

The family

ApplicazioniERPs, web, SaaS
Cloud SQL MySQL/PG/SQLSrv
AlloyDB
Read replicas
managed · boosted · scaled in reads
Automatic HA, backups, patchesil lavoro che sparisce
Private Service Connectthe database never on the internet
A Postgres for every season

La scelta giusta

Cloud SQL for general purpose, AlloyDB where performance and live analytics are needed: we build the matrix with numbers.

Migration with DMS

From on-prem Postgres/MySQL (or from Oracle, with conversion) to managed: continuous replicas, a short cutover.

Tuning that stays ours

PaaS doesn't save you from bad queries: Query Insights and indexes remain a craft.

Network security

Private endpoints, IAM auth and CMEK: the database in the perimeter, your keys.

03 · In depth

Cloud SQL vs AlloyDB: when one, when the other

Cloud SQL manages MySQL/PostgreSQL/SQL Server with regional HA (synchronous standby), read replicas, PITR and Enterprise Plus (data cache, sub-second maintenance). AlloyDB is Google's boosted PostgreSQL: distributed storage that scales on its own, a columnar engine for hybrid HTAP (analytics up to 100x), read pools up to 20 nodes, and AlloyDB Omni to run on-prem too. The route: Cloud SQL for broad compatibility, AlloyDB when PostgreSQL must run fast.

  • HA regionale — a synchronous standby in another zone: automatic failover in ~60s
  • Enterprise Plus — cache and maintenance <1s: il Cloud SQL per la produzione seria
  • AlloyDB storage — the distributed layer growing on its own: no disk resizing
  • Columnar engine — analytics on the transactional data: up to 100x without ETL
  • Read pool — up to 20 replicas at very low lag: reads that scale
  • Omni — AlloyDB on-prem/other clouds too: the same technology everywhere
04 · Numbers and lifecycle

The numbers that matter.

99,99%
the Enterprise Plus and AlloyDB SLA
100x
the columnar engine's analytic speed-up
<1 s
Enterprise Plus maintenance: the downtime that disappears
35 gg
configurable PITR
Managed doesn't remove the project: schema, indexes and rehearsed failovers remain a craft — ours.
05 · Use cases

Where it really pays off.

Line-of-business apps

The ERP's database, without database administration.

Modernization from Oracle

AlloyDB as the Postgres landing of the removals.

Multi-tenant SaaS

Replicas and pools to serve many customers.

The open source database with enterprise SLAs: chosen, migrated and governed by us.