majiayu000 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