AlloyDB overview

Transcript

1. AlloyDB Kanji Yomoda (@k-yomo) May 2022
2. Confidential & Proprietary 2021 AlloyDB
3. 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
4. Confidential & Proprietary 2021
5. Confidential & Proprietary 2021 Architecture transition • Disaggregation of compute and storage • => No private storage for replicas • => Much less replication delay
6. Confidential & Proprietary 2021 Why higher availability and scalability? => persistence is horizontally partitioned into groups of blocks
7. Confidential & Proprietary 2021 Why analytical queries get faster up to 100x? => Make use of columnar format
8. Confidential & Proprietary 2021 Columnar format works well for OLAP OLAP example
9. Confidential & Proprietary 2021
10. Confidential & Proprietary 2021 Pricing https://cloud.google.com/alloydb/pricing
11. Confidential & Proprietary 2021 Pricing [Min Price] 4vCPU * 48.24 + 32 * 8.18 = 454$ (in preview)
12. 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
13. 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
14. Confidential & Proprietary 2021 Thanks!