I have a RedShift cluster of 4 nodes.
- When one of the nodes goes down, will the entire cluster become unavailable?
- If yes - for how long?
- When the cluster gets back - is it returned to exactly the same point it was before the failure, or the data may be rolled back a to S3 snapshot from a few hours ago?
- How can I simulate this situation to check this scenario by myself?
Thanks a lot!