A failed leader node will be replaced and the meta-data will be replicated from the other nodes/S3 to restore functionality of the cluster. Since the meta-data is typically very small the recovery time is also low once the hardware has been replaced.
No restore from snapshot should be required.
Is able Redshift to restore leader node upon fail as it would do with compute nodes?Accepted Answerasked 7 years ago
Restoring Redshift Schema (only schema no data)form Prod cluster to non-prod clusterasked 7 months ago
Will Redshift reserved nodes polong automatically?Accepted Answerasked 4 months ago
How is data returned from Spectrum to Redshift cluster?Accepted Answerasked 3 years ago
Connecting AppSync with Redshift via Data APIasked 2 years ago
about redshift HA, what happens when the header node fails.Accepted Answerasked 5 years ago
CDK: How to restore a Redshift from a Snapshot ?asked 4 months ago
LISTAGG on svv_redshift_columns - Gives error because it can only be run on compute nodes - Looking for a workaroundasked 8 months ago
Restoring Redshift Cluster from Snapshot fails. You do not have access to node type.asked 2 months ago
parallelCluster compute node public IP addresses?asked 4 years ago