GCP Cloud SQL

Overview

Cloud SQL is Google Cloud's managed relational database service for MySQL, PostgreSQL, and SQL Server. It handles patches, upgrades, replication, automated backups, point-in-time recovery, and HA failover so applications focus on schema and queries instead of database administration.

Instructions

Core Concepts

• Instance — a managed VM running MySQL/Postgres/SQL Server with attached storage
• High Availability (HA) — synchronous replica in another zone with automatic failover
• Read replica — async read-only copy for scaling reads or cross-region DR
• Cloud SQL Auth Proxy — local sidecar that handles IAM auth, TLS, and connection routing
• Private IP — instance reachable only via VPC peering, never the public internet
• Point-in-time recovery (PITR) — restore to any second within the retention window using binary logs

Prerequisites