Setting a Local Retention Period for MySQL Binlogs
RDS for MySQL deletes local binlogs after they are backed up to OBS. You can set the local retention period for binlogs as required to fully utilize the instance space.
Binlogs can be retained from 0 to 168 (7x24) hours locally.
The rules for deleting local binlogs are as follows:
- All local binlogs will be deleted after they are successfully backed up.
- The binlogs used for replication between primary DB instances and standby DB instances or read replicas are not deleted, even when the retention period is set to 0.
- If the local space usage exceeds 80%, the system ignores the local retention period configured for binlogs and deletes all the binlogs that have been successfully backed up when the local space usage exceeds 90%.
- Log in to the management console.
- Click in the upper left corner and select a region and a project.
- Click Service List. Under Database, click RDS. The RDS console is displayed.
- On the Instance Management page, click the target DB instance.
- In the navigation pane on the left, choose Backups & Restorations. On the Binlog Backups page, click Set Binlog Retention Period.
- In the displayed dialog box, set the local retention period and click OK.
Figure 1 Setting the binlog retention period