Hologres:Local backup and restoration

Local backup

Local backup refers to backing up instance data to local storage through snapshots. When data is accidentally deleted or the current zone fails, you can quickly restore a new instance using backup snapshots to resume business operations.

• Scenarios: Local backup ensures data integrity when data is accidentally deleted or lost, or when the current zone fails.

• Backup type: Each backup is a full data backup.

• Backup methods: Manual backup and periodic backup based on rules are supported.

• Backup speed: The backup speed depends on the amount of instance data.

• Instance types: Virtual warehouse instances and general-purpose instances are supported. Read-only secondary instances and Shared Cluster (Lakehouse Acceleration Edition) instances are not supported.

• Fees: Only storage fees for backup data are charged. The storage fees are charged based on storage size.

Restoration

The restoration feature supports creating a new instance from a backup snapshot to restore business operations.

• Regions and zones for restoration: You can restore an instance within the same zone, across zones in the same region, or across regions. However, cross-region restoration is only supported between certain regions.

• Restoration scope: You can specify the start time for snapshot backup.

• Restoration speed: The restoration speed depends on the amount of snapshot data.

• Fees: No additional fees are charged for the restoration process. However, fees are charged for the computing and storage resources required for the new instance.

Create a periodic backup

After accessing the Local Backup tab through the entry point, follow these steps to create a periodic backup:

1. Click Edit next to Periodic Backup Settings.

2. In the Periodic Backup Settings dialog box, turn on Periodic Backup and configure the related parameters.

   Parameter	Description
   Backup Cycle	The automatic data backup cycle.
   Backup Time	The start time range of automatic data backups.
   Number of Snapshots	The number of automatic periodic snapshots to retain. Only successfully created snapshots through automatic periodic backup are counted. Failed snapshots and manually created snapshots are not counted toward the automatic snapshot retention limit. 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.

3. Click OK to complete the periodic backup creation.

Create a manual snapshot

After accessing the Local Backup tab through the entry point, follow these steps to create a manual snapshot:

1. Click Create Snapshot.

2. In the Create Snapshot dialog box. Click Create Snapshot to complete the manual snapshot creation.

   After you click Create Snapshot, the backup will start in 5 minutes. If your 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. To do this, go to the Snapshots page, and click Delete in the Actions column of the target snapshot.

View the backup list

After accessing the Local Backup tab through the entry point, view the backup snapshots of the current instance.

1. In the Snapshots section, view the information about a backup snapshot.

   Column	Description
   Snapshot ID	The ID generated after the snapshot is created.
   Backup Start and End 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 Region	The region to which the instance corresponding to the snapshot belongs.
   Snapshot Size	The storage size of the snapshot.
   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 instance type corresponding to the snapshot, including General-purpose and Compute Group Type (virtual warehouse instance). When restoration, only snapshots of the corresponding instance type are supported.
   Description	The description of the snapshot.

You can also log on to the Hologres console, and click Snapshots in the left-side navigation pane to view all snapshots (including cross-region snapshots) in the current region.

Disable backup

If you do not need periodic backup, follow the first step in Create a periodic backup to go to the Periodic Backup Settings dialog box, and then turn off the Periodic Backup switch.