AnalyticDB:Manage backups

Features

• Basic backup: After you create a cluster, the data backup and log backup features are automatically enabled to perform cluster-level data backups. The backup sets are stored in the region where the cluster resides.

• Cross-region backup: After a cluster is created, you must submit a ticket to have this feature manually enabled by technical support. After this feature is enabled, full backups of the cluster are automatically copied to the destination backup region, and log backups are synchronized in real time. The cross-region backup feature provides region-level disaster recovery for AnalyticDB for MySQL.

Limitations

• Only data in internal tables can be backed up and restored. Data in external tables and lake storage is not supported.

• The cross-region backup feature is not supported for Data Warehouse Edition clusters or clusters in the US (Silicon Valley) and US (Virginia) regions.

Precautions

• For about 10 minutes after a full backup starts, you cannot run Data Definition Language (DDL) statements on the cluster.

• Log backup is enabled by default. Log backup sets are retained for 7 days at no charge.

• Releasing a cluster also deletes its backup data. If you have critical data to retain, export it to OSS for backup before you release the cluster. For more information, see Export to OSS.

• For cross-region backup, the default destination region is China (Hangzhou) for all regions in the Chinese mainland, and China (Beijing) for the China (Hangzhou) region. For the China (Hong Kong) region and other regions outside the Chinese mainland, the default destination region is Singapore. The default destination region for Singapore is China (Hong Kong). To specify a destination region, submit a ticket.

• After you enable cross-region backup, only newly generated full backup sets are copied to the destination region. Existing full backup sets are not copied.

• For cross-region backup, the lifecycle of a full backup set copied to the destination region is the same as that of the associated source backup set. If you delete the source backup set, the cross-region copy is also deleted.

Billing

• The latest backup set for an AnalyticDB for MySQL cluster is retained free of charge. Storage for all other backup sets is charged on a pay-as-you-go basis.

• Cross-region backup sets incur pay-as-you-go storage fees based on the pricing in the cluster's region.

For more information about billing, see Product Pricing.

Enable cross-region backup

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. Find the cluster that you want to manage and click the cluster ID.

2. In the left-side navigation pane, click Backup and Restoration, and then click the Backup Settings tab.

3. In the Cross-region Backup Settings section, click Edit.

4. In the Cross-region Backup Settings dialog box that appears, select Enable, select the checkbox to agree to the terms, and then click OK.

View backup sets

1. In the left-side navigation pane, click Backup and Restoration.

2. View the backup sets.

   • Click the Basic Backup Sets tab to view details about the basic backup sets for the cluster, such as the backup start and end times, free quota, and backup type.

     The backup list also includes the Backup Set ID, Backup Expiration Time, Backup Size, and Backup Method columns. You can also Delete or Batch Delete backup sets.

   • Click the Cross-region Backup Sets tab to view details about the cross-region backup sets for the cluster, such as the backup start and end times, backup size, and backup region.

     You can also view information such as Backup Set ID, Backup Expiration Time, Backup Method, Backup Type, and Associated Backup Set ID. In the Actions column, you can Delete a backup set or use the Batch Delete feature.

   Note

   The Backup Size displayed in the console varies based on the product series of your cluster:

   • For Enterprise Edition, Basic Edition, Data Lakehouse Edition, and Data Warehouse Edition (Elastic Mode) clusters: The Backup Size displayed in the console is the actual data volume of the target backup set.

   • For Data Warehouse Edition (Reserved Mode) clusters: The backup storage space is equal to the disk space that you selected when you purchased the cluster. Therefore, the Backup Size displayed in the console is larger than the actual data volume of the target backup set.

Modify backup settings

1. On the Backup and Restoration page, click the Backup Settings tab.

2. In the Basic Backup section, click Edit. In the Backup Settings dialog box, configure the following parameters:

   Parameter	Description
   Data Backup Cycle	Specifies the frequency of automatic data backups. Important We recommend that you set the data backup cycle to once a week and the data backup retention period to 7 days. This ensures that only one data backup set is stored in the cluster and prevents extra backup fees.
   Backup Start Time	Specifies the start time for automatic data backups. Important The backup duration depends on the amount of data to be backed up. We recommend that you set the backup start time to off-peak hours.
   Data Backup Retention Period	Specifies the retention period for data backups. Unit: days. The default retention period is 7 days. If you need to restore a cluster to a specific point in time, make sure that a complete data backup set from before that point in time is available. We recommend that you specify a reasonable data backup retention period based on your business requirements.

   Important

   The Data Backup Cycle, Backup Start Time, and Data Backup Retention Period for cross-region backups are the same as the settings for basic backups.

Delete a backup set

Disable a backup feature

Next steps

You can use an existing backup set to clone an AnalyticDB for MySQL cluster. For more information, see Clone a cluster.