All Products
Search
Document Center

AnalyticDB for MySQL:Manage backups

Last Updated:Feb 22, 2024

AnalyticDB for MySQL can restore data to avoid data loss caused by accidental changes. When you create a cluster, the data backup feature of AnalyticDB for MySQL is automatically enabled to back up cluster data. You can view backup sets or modify backup settings for your AnalyticDB for MySQL cluster.

Usage notes

  • DDL statements cannot be executed on a cluster within about 10 minutes after a full backup of the cluster starts.

  • If you release a cluster, the backup data of the cluster is also deleted. If you want to retain specific data of the cluster, you can export the data to Object Storage Service (OSS) before you release the cluster. For more information, see Export data to OSS.

View a backup set

  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. On the Data Warehouse Edition (V3.0) tab, find the cluster that you want to manage and click the cluster ID.

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

  3. On the Backup and Restoration page, click the Data Backup tab to view backup set details of the cluster, such as the backup start time, backup end time, and backup set size.

    备份与恢复

    Note

    The Backup Size values displayed in the AnalyticDB for MySQL console vary based on the mode of the cluster.

    • Elastic mode of Data Warehouse Edition (V3.0) : The Backup Size values displayed in the console are the actual sizes of the backup sets in the cluster.

    • Reserved mode of Data Warehouse Edition (V3.0): The Backup Size values displayed in the console are larger than the actual sizes of the backup sets in the cluster.

    For example, the preceding figure is a screenshot of backup sets in a cluster in elastic mode. 1654.76 M indicates the actual size of a backup set generated by the cluster between 13:00 to 13:14 on July 26, 2021.

Modify backup settings

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

  2. Click Modify Backup Settings. In the Backup Settings panel, configure the parameters that are described in the following table.

    Parameter

    Description

    Data Backup Cycle

    The days of the week on which automatic data backups are performed.

    Backup Start Time

    The start time of automatic data backup.

    Important

    The amount of time it takes to back up data is determined by the amount of data to back up. We recommend that you set the backup start time to a period of time during off-peak hours.

    Full Backup Retention

    The number of days for which full backup files are retained.

    If you perform full backup, snapshots of full data in a cluster are compressed and stored in other offline storage media. For metadata consistency on a distributed cluster, DDL statements cannot be executed on the cluster within about 10 minutes after a full backup of the cluster starts. Full restoration from backup sets is performed by cloning clusters. Backup sets are downloaded to restore data to a new cluster. For more information, see How backup works.

    Note
    • By default, full backup is enabled, and backup files are retained for seven days.

    • Backups can be retained for 7 to 730 days.

    Log Backup Retention

    The number of days for which log backup files are retained.

    If you perform log backup, redo logs are uploaded in parallel by using multiple nodes in a cluster to OSS to store real-time logs. A full backup and subsequent redo logs generated within a period of time can be used to restore data at a point in time to a new cluster. For more information, see How backup works.

    Note

    By default, log backup is enabled, and backup files are retained for seven days. You cannot modify the retention period.

What to do next

You can clone the backup data of an AnalyticDB for MySQL cluster to a new cluster by using existing backup sets. For more information, see Clone a cluster.