Hologres local backup and recovery - snapshots, scheduled backups, restore - Hologres

Limitations

The backup and recovery feature requires Hologres V1.3 or later. If your instance is older than V1.3, see Troubleshoot common upgrade preparation failures for upgrade instructions or join the Hologres DingTalk group for support. For more information, see How can I get more online support?.
Backup snapshots are deleted when the associated instance is released.
Only instance-level backups are supported. Backup data includes table data and metadata and may differ in size from storage metrics. To restore, create a new instance from a point-in-time snapshot.
Backups are stored in the same region as the Hologres instance and can be restored across different availability zones within that region. Cross-region backup and recovery is available only in select regions. For more information, see Cross-region backup and recovery.
Backups are supported only for general-purpose and virtual warehouse instances, not for read-only secondary or shared cluster instances.
Perform backups during off-peak hours. The process is non-disruptive, but storage usage on the source instance may temporarily increase to ensure data consistency. The extra storage is released within four hours.
If SQL audit is not enabled for your Hologres instance, you cannot use SQL logs to trace accidental data deletion. In this case, the only way to recover deleted data or objects is through backup snapshots. Make sure that you have configured scheduled backups or created manual snapshots before data loss occurs. If no backups are available, the deleted data cannot be recovered.

Billing

Local backup is billed by backup storage size. For billing details, see Billing overview.

Feature overview

Local backup

A local backup is a snapshot of your instance data stored in the same region. If data is accidentally deleted or a zone fails, you can create a new instance from a snapshot to resume services.

Use cases: Accidental data deletion or availability zone failure.
Backup type: Full backups.
Backup methods: Manual snapshots and scheduled backups.
Backup speed: Depends on instance data volume.
Instance types: General-purpose and virtual warehouse instances only.
Cost: Charged for backup storage.

Recovery

Recovery creates a new instance from a backup snapshot.

Recovery destinations: Same or different availability zone within the same region, or a different region (cross-region limited to specific region pairs).
Recovery point: Select a snapshot by its backup start time.
Recovery speed: Depends on snapshot data size.
Cost: Recovery is free. The new instance incurs standard compute and storage charges.

The following diagram shows scheduled snapshots in one availability zone and restoration to another zone within the same region.

Access the local backup page

Log in to the Hologres console and click Instances in the navigation pane on the left.
On the Instances page, click the name of an instance to go to its Instance Details page.

You can also click Manage in the Actions column of the target instance to go to the Instance Details page.
In the navigation pane on the left of the Local Backup page, click Backup and Disaster Recovery to go to the Local Backup page.

Create a local backup

Scheduled backups

On the local backup page, perform the following steps.

Click Edit next to Periodic Backup Settings.

In the Periodic Backup Settings dialog box, turn on scheduled backup and configure the following parameters.

Parameter	Description
Backup Cycle	Automatic backup frequency.
Backup Time	Start time for automatic backups.
Snapshots to Retain	Number of successful scheduled snapshots to keep. Excludes failed backups and manual snapshots. For example, if set to 7, only the seven most recent successful scheduled snapshots are kept. Older snapshots are automatically deleted.

Click OK to save the configuration.

Manual snapshots

On the local backup page, perform the following steps.

Click Create Snapshot.
In the Create Snapshot dialog box, click Create Snapshot.

After you click Create Snapshot, the backup starts within 5 minutes. Large volumes may take longer.

Important
Manual snapshots are not automatically deleted. To delete one, go to the Snapshots, find the snapshot, and click Delete in the Actions column.

Manage backups

Viewing snapshots

On the local backup page, you can view backup snapshots of the current instance.

The Snapshot List section displays the following information:

Column	Description
Snapshot ID	Unique snapshot identifier.
Backup start and end time	Start and end times of the backup.
Snapshot granularity	Scope of data in the snapshot. Only instance-level full snapshots are supported.
Snapshot region	Region of the source instance.
Snapshot size	Storage size of the snapshot.
Generation method	Scheduled: The snapshot was generated by an automated task. Manual: The snapshot was created manually.
Backup type	Backup type. Only instance-level full backups are supported.
Snapshot type	Source instance type, such as general-purpose or virtual warehouse. Snapshots can only be restored to the same instance type.
Remarks	Notes for the snapshot.

Alternatively, you can log in to the Hologres console and click Snapshots in the navigation pane on the left to view all snapshots available in the current region. This list includes local snapshots and those replicated from other regions.

Disabling scheduled backups

To disable scheduled backups, follow Set up scheduled backups. In the Periodic Backup Settings dialog box, turn off the Periodic Backup switch.

Restore data

On the local backup page, restore a snapshot to a new instance as follows.

Important

If data is accidentally deleted and SQL audit is not enabled for your Hologres instance, backup snapshots are the only way to recover the data. Check whether scheduled backups or manual snapshots were created before the deletion occurred. If a valid backup snapshot is available, you can restore the data by creating a new instance from the snapshot by following the steps below. If no backup snapshots exist, the deleted data or objects cannot be recovered. To prevent unrecoverable data loss, we recommend that you enable scheduled backups in advance.

Click Restore Instance.
On the Clone Instance page, first select the Instance ID (the ID of the original instance is selected by default), Instance Type, and Snapshot Captured At. Next, configure the Computing Resources, storage resources (Standard Storage and Infrequent Access Storage), and Resource Group. Finally, enter an Instance Name, accept the Terms of Service, and click Buy Now.

After payment, the new instance is created with data from the selected snapshot.