Menu
I have enabled binary log option on Google Cloud SQL. But seems expire_log_days option can not be configured on google developpers console.
Can I configure this option? If can't, when binary log will be deleted?
852
To delete all binary log files, use RESET MASTER. To move to a new log file (for example if you want to remove the current log file), use FLUSH LOGS before you execute PURGE LOGS .
Can I Remove MySQL Binary Log Yes, as long as the data is replicated to Slave server, it's safe to remove the file. It's recommend only remove MySQL Binary Log older than 1 month. Besides, if Recovery of data is the main concern, it's recommend to archive MySQL Binary Log.
Cloud SQL is a managed solution that helps handles backups, replication, high availability and failover, data encryption, monitoring, and logging. Cloud SQL is ideal for lift and shift migration from existing on-premises relational databases.
There is no way to configure expire_log_days
According to official doc: https://cloud.google.com/sql/docs/replication#binary-log-implication
The storage of binary logs is charged at the same rate as regular data. Cloud SQL retains binary logs from the time when the oldest backup was taken (Cloud SQL currently retains 7 backups).
If you need to delete binary log manually, please contact [email protected]
56
answered Oct 13 '22 21:10
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
