The backup for TDSQL-C for MySQL includes data backup and binlog backup, with the backup methods divided into automatic and manual backups. Backup regions support local and cross-regional backups. The scenarios for setting backup retention periods include: setting the retention period for snapshot backups in automatic backups, setting the retention period for logical backups in automatic backups either locally or cross-regionally, and setting the retention period for binlog backups.
This document describes how to set the backup retention period in the console.
Directions
Setting the Retention Period for Snapshot Backups in Automatic Backups
2. Select a region at the top and proceed according to the actually used view mode.
Tab view
List view
Click Target Cluster in the cluster list on the left to enter the cluster management page.
Find the target cluster in the cluster list and click the Cluster ID or Manage in the Operation column to enter the cluster management page.
3. On the cluster management page, select the Backup Management tab and click Auto-Backup Settings.
4. In the Backup Settings window, you have the option to set the retention period for snapshot backups of the database. Click OK.
Setting the Retention Period for Logical Backups in Automatic Backups
1. Follow Steps 1-3 to enter the Automatic Backup Settings Page.
2. In the automatic backup settings window and under Logical Backup, click Enable and Set.
3. In the appearing dialog box, complete the following configuration and click OK.
Parameter
Description
Start Time
Establish the automatic logical backup's daily commencement time, set by default from 02:00 to 06:00.
Auto-Backup Cycle
It is daily by default.
Note:
The current version only supports automatic backup on a daily basis. Due to logical backup speed limitations, the backup cycle for some larger data volume clusters is expected to extend to more than a day (if the logical backup for that day is not completed, the next automatic logical backup will not occur until the day after this logical backup is completed).
Cross-Region Backup
Indicate if the cross-region backup should be enabled.
Once enabled, automatic logical backup files can be saved to other regions. For detailed instructions, see Cross-Region Backup.
If not enabled, the default region for automatic logical backup retention is the current cluster's region.
Backup Region
When enabling cross-region backup, you can select up to three regions for backup storage.
Automatic Backup Retention
Backups can be retained for 7 to 1,830 days. The retention period for logical backup files in automatic backups (local domain) is consistent with that for logical backup files in automatic backups (cross-region).
4. Once enabled and set up successfully, click OK in the lower right corner to complete the logical backup settings.
Setting the Retention Period for Binlog Backu
Note:
Binlog backup retention days: 7–1,830 days, which cannot be shorter than the data backup retention period.
If cross-region backup is enabled for binlog, the retention period for local binlog backup files will be consistent with that for cross-region binlog backup files.
1. Enter the cluster management page according to Step 1-2.
2. On the cluster management page, select the Backup Management tab, click Log Backup Settings.
3. Set the binlog backup retention days, and click OK.
Yes
No
Was this page helpful?