By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Redshift Disaster Recovery, attempting to restore tables to cluster in another account.

0

Setting up Redshift disaster recovery. I'd like to be able to restore data (tables, schema) to another cluster in a DR account. It seems sharing snapshots wont as restoring tables needs to take place in the cluster they were created. Restoring snapshot to a provisioned cluster isn't ideal as the cluster in the DR account would be provisioned and managed by IAC. Wondering what options I have? Possibly using COPY, UPLOAD sql commands and store data in s3?

Topics
Analytics
Tags
Amazon Redshift
Language
English
rePost-User-5531754
asked 2 years ago483 views
1 Answer
0

1 -- if you want to just have only few tables and schema available to DR site on you can unload on S3 and load it to DR site Cluster when needed.

2 -- You can also run dual ETL to load data in primary and DR cluster for specific tables. For both option 1 & 2 You can use Redshift Serverless as a DR cluster, which will be auto paused when not being used and will be available in minutes when you need it.

3 -- AZ Failure - You may want to look into CROSS AZ Relocation feature of Redshift. This will have fail over cluster available with no data loss and will be available in minutes. https://docs.aws.amazon.com/redshift/latest/mgmt/managing-cluster-recovery.html

4 -- Region Failure - You can enable cross region snapshot to copy data in other region in a automated fashion and restore it to the DR cluster when required. https://aws.amazon.com/blogs/aws/automated-cross-region-snapshot-copy-for-amazon-redshift/

AWS
EXPERT
Nita_S
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content