I have a RedShift cluster of 4 nodes.
Thanks a lot!
If it's a single node failure - amazon will start a new node and stream data from other nodes (each block is written to two different nodes if any). In such case, we can expect:
In case more than one nodes fails, redshift will restore itself from the latest S3 backup. S3 backups are done on the following occasions: