Cloud SQL Backups and Restore
Can you backup every 10 minutes (your maximum tolerable data loss)?
- Yes, up to 10 minutes of data loss, as the db backups (e.g. .bak file in SQL Server) writes out to cloud storage every 10 minutes.
Backups of your Cloud SQL Instance
Upto 7 backups are stored by default (you only pay for the storage approx 0.17/GB/month)
No egress charges as long as backups are in the same region
Default backup window is 4 hours, but can be manually triggered
gcloud sql backups create --async --instance MY_SQL_INSTANCE_NAME
Restores of your Cloud SQL Instance
gcloud sql backups list --instance MY_INSTANCE_NAME gcloud sql backups restore ID_of_INSTANCE --restore-instance=RESTORE_INSTANCE_NAME
Need an experienced Cloud Networking or a Cloud Data Protection Expert? Anuj has successfully delivered over a dozen deployments on each of the public clouds (AWS/GCP/Azure) including several DevSecOps engagements. Set up a time with Anuj Varma.
Leave a Reply