Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze all your data using your existing business intelligence tools. A Redshift cluster is automatically backed up to Amazon S3 by default, and 3 automatic snapshots of the cluster are retained for 24 hours. You can also convert these automatic snapshots to 'manual', which means they are kept forever. You can restore manual snapshots into new clusters at any time, or you can use them to do table restores, without having to use any third-party backup/recovery software. Snapshots are incremental, which means they only store the changes made since the last snapshot was taken, and are very space efficient.
This module gives you the ability to coordinate the Automatic Snapshot mechanism in your Amazon Redshift Clusters so that you can meet fine grained backup requirements. You don't have to write any code or manage any servers; all execution is done within AWS Lambda, and scheduled with Amazon CloudWatch Events.
There are two dimensions to disaster recovery which must be carefully considered when running a system at scale:
- RTO: Recovery Time Objective - how long does it take to recover from an outage scenario?
- RPO: Recovery Point Objective - when you have recovered, at what point in time will the system be consistent to?
A comprehensive overview of how to build systems which implement best practices for disaster recovery can be found the AWS Disaster Re4covery Whitepaper.
When using Amazon Redshift, the recovery time is determined by the node type you are using, how many of those nodes you have, and the size of the data being restored. It is vital that you practice restoration from snapshots created on the cluster to correctly determine the actual recovery time you'll see, so as to ensure your customer's expectations are met. This must be retested any time you resize the cluster, or if your data volume changes significantly.
Amazon Redshift's automatic recovery snapshots are created every 8 hours, or every 5GB of data changed on disk, whichever comes first. For some customers, an 8 hour RPO is too long, and they require the ability to take snapshots more frequently. For other customers who have a very large amount of data change, these snapshots may be taken far too frequently and not allow long enough retention.
That's where this module comes in - by supplying a simple configuration, you can ensure that snapshots are taken on a fixed time basis that meets your needs for data recovery.
The included build script requires that you be able to use a terminal/command line, and have the aws-cli, python (2.7x) and boto3 installed. Alternatively you can deploy the zip file in the 'dist' folder and configure through the AWS Console.
You can deploy this AWS Lambda function by hand using the AWS Console or Command Line tools, or alternatively you can run:
build.sh deploy <role-arn>
where <role-arn>
is the Amazon Resource Name for the IAM you want the function to run as (which determines what it can do). This Role will require at least the following permissions:
{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "Stmt1466597619000",
"Effect": "Allow",
"Action": [
"redshift:CopyClusterSnapshot",
"redshift:CreateClusterSnapshot",
"redshift:CreateTags",
"redshift:DeleteClusterSnapshot",
"redshift:DescribeClusterSnapshots"
],
"Resource": [
"*"
]
}
]
}
You only need to deploy the function once to support a virtually unlimited number of clusters. The function will be configured with:
- Max Runtime: 60 Seconds (each function only runs for 1 cluster, so this is plenty long enough - you can even reduce it)
- Memory Size: 128 MB (the minimum)
- Runtime: Node.js 4.3
This Lambda function can be run by any scheduler, but AWS CloudWatch Scheduled Events are a great way to ensure your function runs on a fixed schedule, without the need for any servers. You can configure CloudWatch Events to be used as the event source for your function, and this can include the configuration for which cluster to work on! To do this, you can add the schedule
directive to the previous deploy command:
build.sh deploy <role-arn> schedule <config.json>
The supplied configuration file must include:
namespace
A unique namespace for the backup schedule that will be used to identify the snapshots createdtargetResource
The name of your Redshift Cluster, excluding<region>.amazonaws.com
region
The region where your Redshift Cluster residessnapshotIntervalHours
The Recovery Point Objective that is used to ensure you take snapshots on the specified intervalsnapshotRetentionDays
How long snapshots should be retained before being deleted. Manual snapshots (which can be restored into new clusters) will be kept forever by default. This is an optional parameter, and when omitted all snapshots will be retained.
{
"namespace": "my-every-2-hour-schedule",
"targetResource": "my-redshift-cluster",
"region": "us-east-1",
"snapshotIntervalHours": 2,
"snapshotRetentionDays": 7
}
Once deployed, you can edit the above configuration from the definition of the CloudWatch Events Rule.
Please note that the current account limit for Redshift manual snapshots is 20 per region. This module will create 24/snapshotIntervalHours * snapshotRetentionDays
snapshots, and so if this number is greater than 20 please open an AWS support case to have the limit increased. For example, an RPO of 2 hours with 7 days retention (as shown above) will create 24/2 * 7 = 84
snapshots.
Running the schedule command will create a CloudWatch Events Schedule that runs your function every 15 Minutes. This means that your snapshots will be taken within 15 minutes of the specified snapshots interval.
After completion, you'll notice a Lambda Function called RedshiftUtilsSnapshotManager
, plus there will be a CloudWatch Events Rule called RedshiftUtilsSnapshotManager.<namespace>-15-mins
which runs every 15 minutes.
You can run ./build.sh schedule <config.json>
as many times as you need to create additional schedules.
Once running, you will see that existing automatic snapshots, or new manual snapshots are created within the snapshotIntervalHours
. These snapshots are called rs-snapman-<cluster-name>-<yyyy>-<mm>-<dd>t<hh><mi><ss>
, and are tagged with:
createdBy=AWS Redshift Utils Snapshot Manager
creationTimestamp=YYYY-MM-DD-HHmmss
scheduleNamespace=<config.namespace>
Only snapshots which are tagged using this scheme will be deleted by this utility - other snapshots are not affected. You can review the Lambda function's CloudWatch Log Streams for execution details, which include output about what the function is doing.
IF you'd like to make changes, then great - we love open source. You can code your changes, and then you'll need to pull in the Node.js dependencies in order to test or deploy. From the src/SnapshotManager
folder, run npm install
, which will perform this download. You can then create a new Lambda zip archive by running ./build.sh assemble
, which will create RedshiftSnapshotManager-<version>.zip
in the the dist
folder. You can then run ./build.sh deploy...schedule...
as before.
Amazon Redshift Utils Snapshot Manager
Copyright 2014-2015 Amazon.com, Inc. or its affiliates. All Rights Reserved.
Licensed under the Amazon Software License (the "License"). You may not use this file except in compliance with the License. A copy of the License is located at
http://aws.amazon.com/asl/
or in the "license" file accompanying this file. This file is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, express or implied. See the License for the specific language governing permissions and limitations under the License.