canonical / mysql-operator

Machine charm for MySQL following the operator framework
https://charmhub.io/mysql
Apache License 2.0
7 stars 10 forks source link

DPE-4247 Change binlog retention period #503

Closed paulomach closed 1 month ago

paulomach commented 1 month ago

Issue

Default binlog retention period (30 days) not aligned with other logs retention period (7 days). Change requested by support team due huge binlogs on Kubeflow deployments.

Solution

Set binlog retention period to 7 days.

7annaba3l commented 1 month ago

This is approved on my end. @taurus-forever : Indeed, we should archive bin logs to an ObjectStore after the retention period. Hopefully, this will be part of our backup manager implementation. For now, we can provide a config parameter to provide binlog retention in days (with a minimum of 1).