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

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?

asked 16 days ago22 views
1 Answers
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/

answered 15 days 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