tencent cloud

All product documents
TDSQL-C for MySQL
DocumentationTDSQL-C for MySQLOperation GuideBackup and RestorationManaging BackupSetting Backup Retention Period
Setting Backup Retention Period
Download PDF
Last updated: 2025-03-18 11:05:28
Setting Backup Retention Period
Last updated: 2025-03-18 11:05:28
Download PDF
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

1. Log in to the TDSQL-C for MySQL console.
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 Backup

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.

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon