TDSQL-C for MySQL supports both automatic and manual backups. Snapshot backups are enabled by default for automatic backups, while logical backups needs to be enabled manually. You can also set backup policies for automatic backups to achieve long-term backup retention and ensure data security.
At the inception of cluster creation, TDSQL-C for MySQL generates data backups based on factors such as log generation rate and volume of data written (snapshot backups in automatic backups). By default, backups are performed every two days. However, if the volume of data written exceeds 4GB and more than 24 hours have passed since the last backup, a backup is initiated immediately. Subsequently, you may also enable logical backups in automatic backups according to business needs on the backup management page. Additionally, it supports setting the retention period for logical backups in automatic backups.
This document describes how to configure automatic backup in the console.
Note:
To ensure the stability of the backup system, the current system allows initiating a backup only once per hour.
If your cluster storage space usage exceeds 2TB, it is not recommended to use logical backup due to the risk of backup failure.
Note
Snapshot backups created by automatic backups cannot be deleted. You can use the Data Backup Retention option in the automatic backup settings to manage the retention period of automatic snapshot backup files, thereby controlling the lifecycle of backup files to achieve deletion.
You can view the Backup Time field in the data backup list to determine the exact time point of the data image in a backup file.
2. Select a region at the top and proceed according to the actually used view mode.
Tab view
List view
Click the 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 pop-up window, configure the following items and click OK.
Parameter
Description
Data Backup Retention
Data backup files can be retained for 7–1,830 days.
Start Time
Backup files are generated every 6-48 hours on a 24/7 uninterrupted basis, which has no impacts on the instance performance. You can set the Backup Time field below the backup list to determine the exact time point of the file backup.
Logical Backup
If you only need to set up snapshot backup in automatic backup, there is no need to enable and set logical backup.
2. Select a region at the top and proceed according to the actually used view mode.
Tab view
List view
Click the 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. Under logical backup, click Enable and Set.
5. In the pop-up window, configure the following items 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
Default is daily.
Note:
The current version only supports an automatic backup cycle of daily. 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 Backups Retention
Backups can be retained from 7 to 1,830 days.
6. Once enabled and set up successfully, click OK in the lower right corner to complete the logical backup settings.
7. You can also modify the backup settings or disable the backup settings.
Modify Backup Settings: You can change the start time and adjust cross-region backup settings (modify the region for cross-region backup, and enable or disable cross-region backup capability)
Disable Backup Settings: Supports disabling the cross-region backup feature of logical backup and automatic logical backup. Once disabled, backup files will be retained until the end of the backup cycle.
8. The file name of an automatic logical backup is automatically generated. You can click the edit icon after the alias in the backup list to set and modify it.
