AlloyDB Kanji Yomoda (@k-yomo) May 2022

Confidential & Proprietary 2021 AlloyDB

Confidential & Proprietary 2021 Key features ● Fully compatible with PostgreSQL ● 4x faster for transactional workloads, up to 100x faster for analytical queries than standard PostgreSQL ● 2x faster than RDS ● SLA of 99.99% (inclusive of maintenance) ● non-disruptive instance resizing and database maintenance (several seconds) ● Built-in integration with Vertex AI

Confidential & Proprietary 2021

Confidential & Proprietary 2021 Architecture transition ● Disaggregation of compute and storage ● => No private storage for replicas ● => Much less replication delay

Confidential & Proprietary 2021 Why higher availability and scalability? => persistence is horizontally partitioned into groups of blocks

Confidential & Proprietary 2021 Why analytical queries get faster up to 100x? => Make use of columnar format

Confidential & Proprietary 2021 Columnar format works well for OLAP OLAP example

Confidential & Proprietary 2021

Confidential & Proprietary 2021 Pricing https://cloud.google.com/alloydb/pricing

Confidential & Proprietary 2021 Pricing [Min Price] 4vCPU * 48.24 + 32 * 8.18 = 454$ (in preview)

Confidential & Proprietary 2021 Summary ● High performance ● High availability & scalability Pros Cons (for now) ● Cost ● Low flexibility for instance size ● Can’t be used as Bigquery external datasource

Confidential & Proprietary 2021 References ● AlloyDB for PostgreSQL under the hood: Intelligent, database-aware storage ● Introducing AlloyDB, a PostgreSQL-compatible cloud database service ● Introducing AlloyDB for PostgreSQL: Free yourself from expensive, legacy databases

Confidential & Proprietary 2021 Thanks!