Create automated backups that are not stored on the instance
Cloud SQL automated backups are now stored on the instance itself. So, if the instance is gone or deleted, the backups are as well.
I know we can export the database to a bucket, but we cannot do this automatically. Only manually.
What good is a backup if it gets deleted when I delete the instance, the idea of a backup is to restore something especially for when someone accidentally deletes the instance.
This is even more important because deleting an instances is appearantly really easy to do. There is no 2FA or password asked.
So, in short, I would love to be able to create a backup and store it to a storage bucket. Preferably even a storage bucket on another account so if someone got into my account they won't be able to delete both the database and storage buckets.
Ralph Bolton commented
I'd additionally like to have multiple schedules applied. That is, maybe a daily schedule that sends to one bucket and monthly that sends to another. Thus I can lifecycle the dailies more rapidly than the monthlies (or whatever schedules and lifecycles I want).
Marek Suscak commented
There's a somewhat easy way to do this right now but it requires you to set up a Cloud Function: