TDSQL-C for MySQL supports automatic backup and manual backup. This document describes how to create a manual backup in the console.
Note:
To ensure the stability of the backup system, the current system allows initiating a backup only once per hour.
With manual backup, you can use snapshot backup to manually back up the entire cluster or use logical backup to back up the entire cluster or specified databases/tables.
Logical backups in the manual backup can be manually deleted from the backup list to free up backup space and avoid space waste and occupancy. Snapshot backups do not support manual deletion.
Logical backups in the manual backup (entire cluster) supports enabling cross-region backup feature, allowing manual logical backup (entire cluster) CFS to other regions.
If your cluster storage space usage exceeds 2TB, it is not recommended to use the logical backup due to the risk of backup failure.
Directions
2. Select the region at the top, 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 Manual Backup.
4. In the pop-up window, select the backup type and object, set the backup file alias, and click OK.
|
Backup Type | Snapshot backup and logical backup are supported. Note: We recommend you perform a manual logical backup task during off-peak hours, as it will lock the database and affect database use. |
Object | Snapshot backup applies to the entire instance, while logical backup applies to the entire instance or specified databases/tables. |
Alias | You can set a file alias when creating a manual backup, which can contain up to 60 digits, letters, or symbols (-_./()[]+=:;@). |
Cross-Region Backup | Manual logical backup (entire cluster) allows you to choose whether to enable cross-region backup. Once enabled, the manual logical backup (entire cluster) files can be saved to other regions. If not enabled, the reserved region for the manual logical backup is the current cluster's region by default. |
Backup Region | When enabling cross-region backup, you can choose up to three different regions to store the manual logical backup (entire cluster) files. |
5. After creating a manual backup task, you can view the task progress in the Task List on the left sidebar. You can also view the execution status by clicking Backup Details in the Operation column.
Was this page helpful?