Back up data in a Hologres instance - Hologres - Alibaba Cloud Documentation Center

Hologres provides the periodic backup and manual backup features that allow you to back up data in Hologres instances. This way, you can restore historical data in scenarios such as accidental deletion of data. You can also restore data in instances from snapshots. This operation takes the same effect as cloning instances and can be used for tests before services are launched. This topic describes how to back up data in a Hologres instance.

Usage notes

The backup and restoration feature becomes available for commercial use on June 20, 2023 (UTC+8). If you use this feature, you are charged for the resources that are used to store backup data. For more information, see Billing overview.
Only Hologres V1.3 and later support the backup and restoration feature. If the version of your instance is earlier than V1.3, manually upgrade your Hologres instance in the Hologres console or join the DingTalk group for technical support. For more information about how to manually upgrade your Hologres instance in the Hologres console, see Manual upgrade (beta). For more information about how to obtain technical support, see Obtain online support for Hologres.
If an instance is released, the backup snapshots are also released.
Only instance-level full backup is supported. Hologres backs up data and generates backup sets. You can restore data to a specific point in time when a backup set is generated.
The backups are stored in the same region in which the Hologres instance resides. Cross-region backup or restoration is not supported.
Only data in general-purpose instances and virtual warehouse instances can be backed up. Data in read-only secondary instances and Hologres Shared Cluster instances cannot be backed up.
We recommend that you back up data in your Hologres instance during off-peak hours. Your Hologres instance continues to provide services during data backup. To ensure data consistency, extra storage resources of your Hologres instance may be consumed. The extra storage resources are released within four hours after the backup starts.

Enable the periodic backup feature

This section describes how to enable the periodic backup feature for a Hologres instance.

Log on to the Hologres console. In the left-side navigation pane, click Instances.
On the Instances page, click the name of your Hologres instance to go to the Instance Details page.
You can also find your Hologres instance and click Manage in the Actions column to go to the Instance Details page.
In the left-side navigation pane, click Backup and Restoration.
On the Periodic Backup Settings tab, turn on the Enable Periodic Backup switch.
In the Periodic Backup Settings dialog box, configure the Backup Cycle, Backup Time, and Number of Snapshots parameters.
The Number of Snapshots parameter specifies only the number of snapshots that are automatically and successfully created. The number of snapshots that fail to be created and the number of snapshots that are manually created are not counted in the value of the Number of Snapshots parameter. For example, if you set this parameter to 7, the latest seven snapshots that are automatically and successfully created are retained. Other automatically created snapshots are automatically deleted. Manually created snapshots are not automatically deleted. You need to manually delete the snapshots.
Click Enable.

Disable the periodic backup feature

This section describes how to disable the periodic backup feature.

Log on to the Hologres console. In the left-side navigation pane, click Instances.
On the Instances page, click the name of your Hologres instance to go to the Instance Details page.
You can also find your Hologres instance and click Manage in the Actions column to go to the Instance Details page.
In the left-side navigation pane, click Backup and Restoration.
On the Periodic Backup Settings tab, turn off the Enable Periodic Backup switch.
After you disable this feature, the system does not automatically create or delete snapshots.

Manually create a snapshot

This section describes how to manually create a snapshot.

Log on to the Hologres console. In the left-side navigation pane, click Instances.
On the Instances page, click the name of your Hologres instance to go to the Instance Details page.
You can also find your Hologres instance and click Manage in the Actions column to go to the Instance Details page.
In the left-side navigation pane, click Backup and Restoration.
On the Snapshots tab, click Create Snapshot.
In the Create Snapshot message, click Create Snapshot.
After you click Create Snapshot, the backup starts five minutes later. If your Hologres instance has a large amount of data, a backup may require a long period of time.
Important
Manually created snapshots are not automatically deleted. You need to manually delete these snapshots.

View the information about snapshots

This section describes how to view the information about snapshots.

Log on to the Hologres console. In the left-side navigation pane, click Instances.
On the Instances page, click the name of your Hologres instance to go to the Instance Details page.
You can also find your Hologres instance and click Manage in the Actions column to go to the Instance Details page.
In the left-side navigation pane, click Backup and Restoration.

On the Snapshots tab, view the snapshot information.

Column	Description
Backup Start Time	The start time and end time of the backup task.
Snapshot Granularity	The granularity of the snapshot. Hologres supports only instance-level full backups.
Snapshot Size	The storage size of the snapshot.
Snapshot Captured At	The point in time when the snapshot was created.
Generation Method	Periodic: The snapshot was created by a periodic backup task. Manual: The snapshot was manually created.
Backup Type	The type of the backup. Hologres supports only instance-level full backups.
Snapshot Type	The type of the instance for which the snapshot is created. Snapshots can be created for general-purpose instances and virtual warehouse instances. When you restore data, you can only use the snapshots of the specific types of instances.
Status	The status of the backup task.
Description	The description of the snapshot.

Optional. Modify the snapshot description.
To better manage snapshots, you can modify the description of snapshots.
1. On the Snapshots tab, click Description in the Actions column.
2. In the Modify Description dialog box, enter the description and click OK.

Delete a snapshot

This section describes how to delete a snapshot that is no longer needed.

Note

The snapshots that are deleted cannot be restored.

Log on to the Hologres console. In the left-side navigation pane, click Instances.
On the Instances page, click the name of your Hologres instance to go to the Instance Details page.
You can also find your Hologres instance and click Manage in the Actions column to go to the Instance Details page.
In the left-side navigation pane, click Backup and Restoration.
On the Snapshots tab, find the snapshot that you want to delete and click Delete in the Actions column.
In the Delete Snapshot message, click Delete Snapshot.