Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse. It can scale from a few hundred gigabytes to a petabyte or more. Backups help protect data from operational issues and accidental deletion, and support business continuity and compliance.
Use Commvault software to protect Amazon Redshift provisioned clusters and serverless namespaces across multiple AWS accounts and Regions. Commvault uses native AWS snapshots and export-based backups. Restore destinations depend on the deployment type and backup method.
Note
-
Snapshot-based backups use native AWS snapshots. You cannot create a backup copy of a snapshot-based backup.
-
You can back up Amazon Redshift clusters that contain vector data.
Backups
Backup granularity
-
Snapshot-based backups: Cluster level.
-
Export-based backups: Namespace level.
Backups you can perform
Full backups are available.
-
Snapshot-based backups: Commvault initiates AWS manual snapshots through backup agent access nodes. AWS snapshots are incremental. Commvault classifies each snapshot as a full backup because it is self-contained and can be restored even if earlier snapshots are deleted.
-
Export-based backups: For provisioned clusters, exports include cluster configuration. For serverless namespaces, exports include workgroup configuration and namespace details. Exports also include the following entities:
-
Databases
-
Schemas
-
Tables
-
Views
-
Materialized views
-
User-defined functions (UDFs)
-
Stored procedures
-
When you can perform backups
-
Scheduled: The backup plan that you assign manages scheduled backups.
-
On demand: You can run a backup at any time.
Restores
Restore granularity
-
Snapshot-based backups: Cluster level.
-
Export-based backups: Namespace level.
Backups you can use for restores
-
Most recent backup: Restore the latest backup to its original location.
-
Backup from a specific date: Restore a backup from before the data became unusable.
-
Backups from a date range: Restore data that was accidentally deleted.
Restore destinations
-
In-place restore: Restore data to the same AWS account and Region where it was backed up.
-
Out-of-place restore: Availability depends on the deployment type and backup method.
| Deployment type | Backup method | Same account, same Region | Same account, different Region | Different account, same Region | Different account, different Region |
|---|---|---|---|---|---|
| Provisioned | Snapshot | Yes | Yes | No | No |
| Provisioned | Export | Yes | No | Yes | No |
| Serverless | Snapshot | Yes | Yes | No | No |
| Serverless | Export | Yes | Yes | Yes | Yes |
Note
Cross-region restores of export-based backups are not supported for provisioned clusters because the restore cannot copy data from an Amazon S3 bucket in a different AWS Region.