Amazon Redshift | Backup and Restore Flashcards
Does Amazon Redshift support Multi-AZ Deployments?
Backup and Restore
Amazon Redshift | Database
Currently, Amazon Redshift only supports Single-AZ deployments. You can run data warehouse clusters in multiple AZ’s by loading data into two Amazon Redshift data warehouse clusters in separate AZs from the same set of Amazon S3 input files. With Redshift Spectrum, you can spin up multiple clusters across AZs and access data in Amazon S3 without having to load it into your cluster. In addition, you can also restore a data warehouse cluster to a different AZ from your data warehouse cluster snapshots.
Back to top »
How does Amazon Redshift back up my data?
Backup and Restore
Amazon Redshift | Database
Amazon Redshift replicates all your data within your data warehouse cluster when it is loaded and also continuously backs up your data to S3. Amazon Redshift always attempts to maintain at least three copies of your data (the original and replica on the compute nodes and a backup in Amazon S3). Redshift can also asynchronously replicate your snapshots to S3 in another region for disaster recovery.
How long does Amazon Redshift retain backups? Is it configurable?
Backup and Restore
Amazon Redshift | Database
By default, Amazon Redshift retains backups for 1 day. You can configure this to be as long as 35 days.
How do I restore my Amazon Redshift data warehouse cluster from a backup?
Backup and Restore
Amazon Redshift | Database
You have access to all the automated backups within your backup retention window. Once you choose a backup from which to restore, we will provision a new data warehouse cluster and restore your data to it.
Do I need to enable backups for my data warehouse cluster or is it done automatically?
Backup and Restore
Amazon Redshift | Database
By default, Amazon Redshift enables automated backups of your data warehouse cluster with a 1-day retention period. Free backup storage is limited to the total size of storage on the nodes in the data warehouse cluster and only applies to active data warehouse clusters. For example, if you have total data warehouse storage of 8TB, we will provide at most 8TB of backup storage at no additional charge. If you would like to extend your backup retention period beyond one day, you can do so using the AWS Management Console or the Amazon Redshift APIS. For more information on automated snapshots, please refer to the Amazon Redshift Management Guide. Amazon Redshift only backs up data that has changed so most snapshots only use up a small amount of your free backup storage.
How do I manage the retention of my automated backups and snapshots?
Backup and Restore
Amazon Redshift | Database
You can use the AWS Management Console or ModifyCluster API to manage the period of time your automated backups are retained by modifying the RetentionPeriod parameter. If you desire to turn off automated backups altogether, you can do so by setting the retention period to 0 (not recommended).
