RedShift/RDS Backup Best practices


Hi, We are using RedShift and RDS for a project. We would like to know what are some of the best practices for backing up these two services. Note: We use terraform for deployment and when a snapshot is used to launch a new cluster, terraform is not aware of the new cluster. This causes some issues in terraform. Any assistance with automating this process is appreciated.

1 réponse

Hello ,

Amazon Redshift provisioned cluster takes snapshots which are are point-in-time backups of a cluster.

There are 2 types of snapshots

Automated snapshots - By default automated snapshots are enabled when you create a cluster, Amazon Redshift periodically takes snapshots of that cluster. By default Amazon Redshift takes a snapshot about every eight hours or following every 5 GB per node of data changes, or whichever comes first. You can change the schedule based on your requirement.

Manual snapshot - You can take a manual snapshot any time. By default, manual snapshots are retained indefinitely, even after you delete your cluster. You can also automate creation of manual snapshot if you need to retain the snapshot even after deleting the cluster.

Please refer to this doc for more details -

Please refer to this doc - to learn about Amazon Redshift serverless backups.

Please feel free to comment if you have any further questions.

répondu il y a 3 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions