GCP Cloud SQL
Deploy managed databases on Google Cloud.
Create Instance
gcloud sql instances create mydb
--database-version=POSTGRES_15
--tier=db-f1-micro
--region=us-central1
--root-password=secretpassword
--storage-auto-increase
--backup-start-time=02:00
Create database
gcloud sql databases create myapp --instance=mydb
Create user
gcloud sql users create appuser
--instance=mydb
--password=userpassword
High Availability
gcloud sql instances create mydb
--database-version=POSTGRES_15
--tier=db-custom-2-8192
--region=us-central1
--availability-type=REGIONAL
Best Practices
-
Enable automated backups
-
Use Cloud SQL Proxy for connections
-
Implement private IP
-
Use read replicas for scaling