I have a VPC which has 2 Private subnets i.e. subnet 1 and subnet 2. My redshift cluster sits in subnet 2 and has data. I want to move the redshift from subnet 2 to subnet 1 within the same VPC (Which can be done easily). But I have few doubts related to data migration:
Any leads would be appreciated.
From Amazon Redshift Snapshots - Amazon Redshift:
Restoring a Cluster from a Snapshot
A snapshot contains data from any databases that are running on your cluster, and also information about your cluster, including the number of nodes, node type, and master user name. If you need to restore your cluster from a snapshot, Amazon Redshift uses the cluster information to create a new cluster and then restores all the databases from the snapshot data. The new cluster that Amazon Redshift creates from the snapshot will have same configuration, including the number and type of nodes, as the original cluster from which the snapshot was taken. The cluster is restored in the same region and a random, system-chosen Availability Zone, unless you specify another Availability Zone in your request.
So, you should take a Snapshot of the existing Redshift cluster, then create a new cluster in the other AZ by Restoring a Cluster from the Snapshot. Once everything seems to be okay, you can delete the old cluster.
