Get to know Google Cloud SQL
summary
Managed Cloud SQL adds Postgres (9.6 beta) with automated minor upgrades, daily block-level snapshots kept seven days, and offloads integrity checks to separate VMs by copying snapshots into Google’s private cloud. Persistent Disk (Colossus) supplies CRC checks and multi-node replication; PG page verification scans cold 8KB pages using Postgres checksums (enabled fleet-wide with negligible CPU impact). Auto-storage grows disks (example: 10GB → ~400GB during an OpenStreetMap import) and the page-validation tool is planned to be open source.
AI-written summary · about
chapters (32)
- 0:00Introduction
- 0:55Agenda
- 1:33Questions
- 2:49Database portfolio
- 4:26Selfmanaging a database
- 6:28High availability
- 8:07Monitoring
- 10:17Storage
- 11:39Active Database Administration
- 12:29Auto Storage Increase
- 14:28Backups
- 15:30Architecture
- 16:15Cloud Storage
- 16:48Persistent Disk
- 17:52Persistent Disk Architecture
- 18:48Data Integrity
- 22:12Data Verification Validation
- 24:25Performance
- 26:06PG page verification
- 27:02Open source
- 28:41Public Cloud
- 29:24Data Verification
- 33:23Data Pages
- 33:52Page Layout
- 34:41Page Header
- 34:56Free Space Map
- 35:17Visibility Map
- 36:24Free Space
- 36:43Scanning for Corruption
- 38:06Future Work
- 38:31Connecting to Cloud SQL
- 41:03Cloud SQL OS
related talks
01h 02mDiamond Sponsor Hall
24mWhy Google Cloud is the Best Place for Your PostgreSQL Workload
05mMaximizing Cloud SQL database availability
49mPractical Guide to Migrating +100 Large PostgreSQL to the Cloud
09mExplains the Cloud Bigtable Platform
51mPostgreSQL in the Cloud: DBaaS vs Kubernetes
41mPostgres Plus Cloud Database
05mNext Big Step