AnalyticDB for MySQL automatically backs up your cluster data and logs, letting you restore data from any point within the last 7 days. This topic describes how to view backup sets, configure backup settings, enable cross-region backup, delete backup sets, and disable backup.
Backup types
AnalyticDB for MySQL supports two backup types:
| Backup type | Description |
|---|---|
| Basic backup | Enabled automatically when you create a cluster. Performs cluster-level full data and log backups. All backup sets are stored in the same region as your cluster. |
| Cross-region backup | Copies full backups to a destination region and synchronizes log backups in real time, providing region-level disaster recovery. Requires a support ticket to enable. |
Limits
Only data in internal tables can be backed up and restored. External tables and lake storage are not supported.
Cross-region backup is not supported for Data Warehouse Edition clusters or clusters in the US (Silicon Valley) and US (Virginia) regions.
Usage notes
For about 10 minutes after a full backup starts, Data Definition Language (DDL) statements cannot be executed on the cluster.
Log backup is enabled by default. Log backup sets are retained for 7 days at no charge.
To urgently restore data, Submit a ticket to contact technical support.
After a cluster is released, its backup data is also deleted. Export critical data to OSS before releasing a cluster. For more information, see Export data to OSS.
Cross-region backup behavior
When cross-region backup is enabled, the following rules apply:
Default destination regions: To use a different destination region, submit a ticket.
Source cluster location Default destination region Chinese mainland China (Hangzhou) China (Hangzhou) China (Beijing) China (Hong Kong) and regions outside China Singapore Singapore China (Hong Kong) Only new full backup sets created after cross-region backup is enabled are copied to the destination region. Existing backup sets are not copied.
The lifecycle of a cross-region backup set follows its source backup set. Deleting the source backup set also deletes the corresponding cross-region copy.
Billing
The most recent backup set for a cluster is free. If multiple backup sets exist, you are charged for backup storage space on a pay-as-you-go basis for all sets except the latest one.
Cross-region backup sets are billed separately for storage on a pay-as-you-go basis, using the pricing of the region where your cluster resides.
Tip: To avoid extra backup fees, set the backup cycle to once a week and the retention period to 7 days. This keeps only one backup set at a time.
For pricing details, see Pricing.
Enable cross-region backup
Log on to the AnalyticDB for MySQL console. In the upper-left corner, select a region. In the left-side navigation pane, click Clusters. Find the target cluster and click the cluster ID.
In the left-side navigation pane, click Backup and Restoration, then click the Backup Settings tab.
In the Cross-region Backup Settings section, click Edit.
In the Cross-region Backup Settings dialog box, select Enable, select the checkbox to agree to the terms of service, and click OK.
View backup sets
In the left-side navigation pane, click Backup and Restoration.
Click the appropriate tab to view backup sets:
Basic Backup Sets: Shows backup start and end times, free quota, and backup type for each set.
Cross-region Backup Sets: Shows backup start and end times, backup set size, and backup region for each set.
The Backup Size shown in the console depends on the cluster edition:
For Enterprise Edition, Basic Edition, Data Lakehouse Edition, and Data Warehouse Edition (Elastic Mode) clusters, Backup Size reflects the actual data size.
For Data Warehouse Edition (Reserved Mode) clusters, Backup Size equals the disk space purchased when the cluster was created, which is larger than the actual data size.
Modify backup settings
On the Backup and Restoration page, click the Backup Settings tab.
In the Basic Backup section, click Edit.
In the Backup Settings dialog box, configure the following parameters:
Parameter Description Data Backup Cycle The schedule for automatic data backups. Backup Start Time The start time for automatic data backups. Set this to off-peak hours, as backup duration depends on data size. Data Backup Retention Period How long data backups are kept, in days. The default is 7 days. Set a longer period if you need to restore to an earlier point in time—a complete backup set must exist before the target point.
Cross-region backups share the same Data Backup Cycle, Backup Start Time, and Data Backup Retention Period settings as basic backups.
Delete backup sets
Delete basic backup sets
On the Backup and Restoration page, click the Basic Backup Sets tab.
In the Actions column for the target backup set, click Delete.
Click OK.
Delete cross-region backup sets
On the Backup and Restoration page, click the Cross-region Backup Sets tab.
In the Actions column for the target backup set, click Delete.
Click OK.
Disable backup
Disable basic backup
On the Backup and Restoration page, click the Backup Settings tab.
Click Modify Backup Settings. In the Backup Settings panel, clear the Data Backup Cycle checkbox.
Click OK.
Disable cross-region backup
On the Backup and Restoration page, click the Backup Settings tab.
In the Cross-region Backup Settings section, click Edit.
In the Cross-region Backup Settings dialog box, select Disable, select the checkbox to agree to the terms of service, and click OK.
What's next
Use an existing backup set to clone your cluster data to a new cluster. For more information, see Clone a cluster.