GaussDB(DWS) Backup and Restoration
GaussDB(DWS) helps you back up and restore multiple types of data at multiple layers.
- Media formats supported
Data can be backed up to disks, OBS, EISOO, and NetBackup.
- Multiple backup modes
Full physical backup, differential incremental backup, and cumulative incremental backup are supported.
- No impact on services
No tables are locked during the backup. SQL and DDL executions are not affected.
- Global consistency
Backup sets use globally consistent snapshots to ensure the consistency of restored data.
- Fine-grained backup and restoration
You can restore an entire cluster or just specific schemas. Data can be restored to a new cluster or the original one.
- High security
Data is encrypted before transmission to prevent leakage.
gs_dump and gs_restore
gs_dump and gs_restore are logical backup tools. gs_dump is used to export database object metadata to a text file, a custom-format file, a .tar file, or a separate directory. gs_restore is used to import the files generated by gs_dump to the database for restoration.
GaussDB(DWS) provides Roach to back up and restore large-scale data in real time. Roach regularly synchronizes data from the production cluster to the backup for disaster recovery purposes, as shown in the following figure.
Figure 4-1 Dual-cluster DR using Roach
In a large cluster, data backup is likely to be interrupted by cluster restart or primary/standby node switchover. Roach supports resumable backups. If a backup gets interrupted, you can resume your backup from where it left off. There is no need to start from scratch.
Roach can resume progress for:
- Full backup
- Full restoration
- Data transfer via SCP between clusters
- Backup of an old cluster and restoration to a new cluster executed in parallel