- Newest
- Most votes
- Most comments
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/
Relevant content
- asked 4 months ago
- asked 2 years ago
- asked 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago