Hi!
There are 2 kinds of backups, Manual and Automatic. They both save a binlog.
If you have Automatic backups, they are kept for 7 days and the binlog is deleted automatically with the backup after 7 days.
If you have manual backups, the binlogs and backups will not be deleted.
It is suggested to use automated backups as Cloud SQL will manage your backups and deletes. This has been confirmed with the engineering team[1].
[1]: https://issuetracker.google.com/35904375#comment9
On Monday, November 9, 2020 at 12:44:24 PM UTC-5 ji...@siteground.com wrote:
I am running CloudSQL with HA enabled and one read replica. Recently I notices that the used space of the primary instance is larger than the read replica (more than 10%). It turned out that there is a lot of binary logs (68 files). I have also noticed that the expire_logs_days is set to 0 which means that there is no automatic removal. How am I supposed to manage the retention of the binary logs ?
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/4e06213a-a88a-4012-b873-380392fc1088n%40googlegroups.com.
No comments:
Post a Comment