RedShift/RDS Backup Best practices

Question

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.

Answer

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 - https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-snapshots.html

Please refer to this doc - https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-snapshots-recovery-points.html  to learn about Amazon Redshift serverless backups.

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

RedShift/RDS Backup Best practices

Relevant content