Restoring a Snapshot to a New Cluster

Scenario

This section describes how to restore a snapshot to a new cluster when you want to check point-in-time snapshot data of the cluster.

When a snapshot is restored to a new cluster, the restoration time is determined by the amount of data backed up by the snapshot. If a snapshot contains a large amount of data, the restoration will be slow. A small snapshot can be quickly restored.

Automatic snapshots are incremental backups. When restoring a snapshot to a new cluster, GaussDB(DWS) uses all snapshots between the latest full backup and the current snapshot. You can set the backup frequency. If snapshots are backed up only once a week, the backup will be slow if the incremental data volume is large. You are advised to increase the backup frequency.

• Currently, you can only use the snapshots stored in OBS to restore data to a new cluster.
• By default, the new cluster created during restoration has the same specifications and node quantity as the original cluster.
• Restoring data to a new cluster does not affect the services running in the original cluster.
• If cold and hot tables are used, snapshots cannot be used to restore cold data to a new cluster.
• Fine-grained restoration does not support tables in absolute or relative tablespace.

Prerequisites

• The resources required for restoring data to a new cluster do not exceed your available resource quota.
• The snapshot is in the Available state.

Procedure

1. Log in to the GaussDB(DWS) management console.
2. In the navigation pane, choose Snapshots. All snapshots are displayed by default.
3. In the Operation column of a snapshot, click Restore.

   

4. On the Restore Snapshot page, configure the parameters of the new cluster, as shown in the following figure.
   1. Restore to a single-AZ cluster.

   You can modify cluster parameters. For details, see Table 1. By default, other parameters are the same as those in the snapshot. For details, see Table 2.

   Table 1 Parameters for the new cluster

   Category	Operation
   Basic settings	Region, AZ, node flavor, cluster name, database port, VPC, subnet, security group, public access, and enterprise project
   Advanced settings	If Custom is selected, configure the following parameters: Tag: If encryption is enabled for the original cluster, you can configure a key name.

5. Click Restore to go to the confirmation page.
6. Click Submit to restore the snapshot to the new cluster.

   When the status of the new cluster changes to Available, the snapshot is restored.

   After the snapshot is restored, the private network address and EIP (if EIP is set to Automatically assign) are automatically assigned.