Being responsible for business continuity isn't easy. You must consider a wide variety of failure scenarios, including the outage of a Google region and, more commonly, human error. Along with replication, Cloud SQL offers tools like backups and point-in-time recovery to help you plan ahead and protect your data.
We are happy to announce that Cloud SQL now supports retention settings for automated backups. This means you can keep up to one year’s worth of automated backups to safeguard against accidental data loss and follow the data protection best practices in your industry. Should you need backups going back even farther, Cloud SQL on-demand backups remain as long as you need them.
We are also announcing retention settings for point-in-time recovery. By default, Cloud SQL lets you restore your database to its state at any point up to 7 days back. If you don’t need the full 7 days for your recovery period, you can reduce retention and save on storage costs.
You can use the Cloud SQL REST API to retain between 1 and 365 days’ worth of automated backups and between 1 and 7 days of transaction logs for point-in-time recovery. By default, Cloud SQL keeps 7 days of automated backups and transaction logs. Take a look at our documentation for more information.
The Cloud SQL Team