CODEWITHSUNDEEP
amazon-web-servicesaws-lambdaamazon-redshiftaws-cliamazon-redshift-spectrum
Rakesh Karn
Rakesh Karn

Reputation: 113

How to automate Redshift snapshot creation and resume cluster from snapshot at a particular time?

I want some solution where a CloudWatch rule triggers the lambda function that takes a snapshot and shutdown the cluster at the given time, and resume the cluster from the created snapshot at another time.

This way a lot money can be saved.

As of now, AWS does not provides such solutions. Cluster Pause and Resume can be done by scheduling but still we need to pay for the storage resource of the cluster.

Upvotes: 0

Views: 944

Answers (2)

Joe Harris
Joe Harris

Reputation: 14035

Snapshots and paused cluster storage are charged at the same rate. Recommend using a pause and resume schedule.

Upvotes: 1

Bill Weiner
Bill Weiner

Reputation: 11032

This is quite doable and did it at my last company. Just call the API functions to delete cluster w/ snapshot and start cluster from snapshot. I also connected it to cloudwatch events to start / stop on schedules and to slack for on-demand starts and stops.

So what are you looking for? Boto3 calls can do all that you are looking for.

Upvotes: 1

Related Questions