Business Function

Landing zone for data from sources such as GODW, EDC, IxRS, etc.

There are four environments:

• dev
• qa
• uat
• prod

Scope

The scope of this document is all uat and prod running in the ACE Prod AWS Account.

The regional scope of this RC is the us-west-2 region of AWS.

NOTE: gcoreprod Redshift cluster saves its snapshot in us-west-1 and us-west-2 simultaneously.

Out of Scope

• Multi-region availability is out of scope per business requirements.

Backup retention

• Backup retention for dev and qa: 30 days
• Backup retention for uat and prod: 14 days

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. If your data is larger than 5 GB * the number of nodes, the shortest amount of time in between automated snapshot creation is 15 minutes. src: https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-snapshots.html

Key Information

• Enabled VPN
• Logged in to AWS CLI
• Logged in to Terraform
• Name of Redshift cluster you want to restore
• Deployment files are available in terraform-ace-prod repo. Steps below are relevant to this repo.

Recovery Checklist & Dependencies

The following tables provide the step-by-step recovery checklist that the ACE Infra team can use to guide them through the recovery steps for the gCORE Redshift clusters.