Cloud SQL has two types of Backups locations Default locations and Custom locations.
For the Default locations Cloud SQL instance stores backup data in two regions for redundancy. If a certain continent has two regions the backup data will remain in the same continent. In case a continent has only one region, for example Australia has only Sydney region for that backup data is also stored in Asia region and for Sao Paulo region data is stored at US centric regions.
For the Custom locations user has the option to select a location to store the backup data. You can get the list of valid regions here. On the other hand multi-regional locations are large geographic areas which has at least two regions which are used for backups.
You can save data of Cloud SQL through On-demand backups which you can take any time and through Automated backups it is possible to set a four hour backup window when the backup will be done automatically. This is also possible to disable automated backups.
You can find the list of stored backups through Console, gcloud or cURL. Unless you are deleting the backups any of the backups you can use for restoring your database.
As for redundancy Google Cloud Platform backing up data of Cloud SQL instance at least in two Regions, so even if something happens to a region another region will still be available for backup data.
Please note that it is cautioned that if you delete the Cloud SQL instance all data within the instance along with backups will be permanently lost. So in case you decide to delete the Cloud SQL instance but would like to preserve the data you can use Cloud Storage to store these data after exporting it. You can get best practices for importing and exporting data here.
On Saturday, January 25, 2020 at 10:17:52 PM UTC-5, Mario Alberto Diaz Castellanos wrote:
Hello,We are using Cloud SQL for storing our customers information. We use the backups provided by GCP. In terms of managing the risk of losing the data, does it make sense that we also would backup this data in AWS, in case of a failure of gcloud providing the backups, or there is a way to make this risk manageable using only GCP provided services?
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/2d8033a2-4c69-4197-bbb0-808b1343e846%40googlegroups.com.
No comments:
Post a Comment