I see that as far as automated backups go for Google CloudSQL, we only have the following options:
- Full backup once per day
- If binary logs are enabled, point in time recovery in-between
- Backups retained for seven days
What are my options if I want to take more backups during the day, let's say take a full backup once every 6 hours, cycle logs, retain backups for 3 months.
Is that possible?
It doesn't look to be based on the native console, i.e. there is no option there to tailor make a backup strategy like there is for example in Mongo Cloud Manager, which allows for really excellent granularity of backup sets.
Cloud SQL Second Generation allows "on demand" backups. You can trigger these whenever you want, by API. They are kept until you delete them.