AnalyticDB for MySQL supports full restoration and restoration to a point in time.

Cluster cloning is used to restore data. A new cluster is created each time you restore data. Data to be restored is downloaded and imported to the new cluster.

If you want to restore full data, you can use valid backup sets. Each valid backup set is a snapshot of the full data generated during backup. After you select a backup set to be restored, the new cluster remotely downloads the backup set from Object Storage Service (OSS), and data in the backup set is imported to the cluster. The time taken to restore data varies with the size of backup sets. A backup set is downloaded in parallel by multiple nodes in a cluster to accelerate restoration.

If you want to restore data to a point in time, you can use valid backup sets and subsequent redo logs generated within a period of time after the point in time. After you select a point in time, the new cluster downloads the last valid backup set generated before the point in time and the redo logs generated between the backup time and the restoration point in time. Then, the downloaded logs are replayed until data is restored. The time taken to restore data varies with the size of backup sets and logs. Logs are downloaded in parallel by multiple nodes in a cluster to accelerate restoration.

The following figure shows how to back up and restore data.Backup and restoration