Amazon Redshift | Availability and Durability Flashcards
Can I access my Amazon Redshift compute nodes directly?
Availability and Durability
Amazon Redshift | Database
No. Your Amazon Redshift compute nodes are in a private network space and can only be accessed from your data warehouse cluster’s leader node. This provides an additional layer of security for your data.
Back to top »
What happens to my data warehouse cluster availability and data durability if a drive on one of my nodes fails?
Availability and Durability
Amazon Redshift | Database
Your Amazon Redshift data warehouse cluster will remain available in the event of a drive failure however you may see a slight decline in performance for certain queries. In the event of a drive failure, Amazon Redshift will transparently use a replica of the data on that drive which is stored on other drives within that node. In addition, Amazon Redshift will attempt to move your data to a healthy drive or will replace your node if it is unable to do so. Single node clusters do not support data replication. In the event of a drive failure you will need to restore the cluster from snapshot on S3. We recommend using at least two nodes for production.
What happens to my data warehouse cluster availability and data durability in the event of individual node failure?
Availability and Durability
Amazon Redshift | Database
Amazon Redshift will automatically detect and replace a failed node in your data warehouse cluster. The data warehouse cluster will be unavailable for queries and updates until a replacement node is provisioned and added to the DB. Amazon Redshift makes your replacement node available immediately and loads your most frequently accessed data from S3 first to allow you to resume querying your data as quickly as possible. Single node clusters do not support data replication. In the event of a drive failure you will need to restore the cluster from snapshot on S3. We recommend using at least two nodes for production.
What happens to my data warehouse cluster availability and data durability in the event if my data warehouse cluster’s Availability Zone (AZ) has an outage?
Availability and Durability
Amazon Redshift | Database
If your Amazon Redshift data warehouse cluster’s Availability Zone becomes unavailable, you will not be able to use your cluster until power and network access to the AZ are restored. Your data warehouse cluster’s data is preserved so you can start using your Amazon Redshift data warehouse as soon as the AZ becomes available again. In addition, you can also choose to restore any existing snapshots to a new AZ in the same Region. Amazon Redshift will restore your most frequently accessed data first so you can resume queries as quickly as possible.
