migrate data to new Aurora cluster

0

Hi team,

I modified my CDK code to add the encryption option in my Existing Aurora DB cluster => which created a brand new cluster.

now I have 2 clusters :

  • the old cluster (non-encrypted)
  • the new cluster created after CDK changes (the encrypted one)

how can I take existing data from my old cluster (the non-encrypted one) and inject them into the newly created cluster( the encrypted one created following CDK changes)?

Thank you :)

2 Answers
0

Restore a snapshot from the unencrypted database into the encrypted database by specifying the KMS key used for encryption: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Overview.Encryption.html

AWS
SeanM
answered 2 years ago
  • Thank you for your answer :) but this doesn't answer my question

    I have a new Aurora cluster created because I changed the encryption option (un-encrypted => to encrypted) via CDK code now I would like to copy my data from the original cluster (the non-encrypted one) ==> to the newly created one (the encrypted one)

    Thank you

  • if you are not using snapshot to from unencrypted cluster to create an encrypted cluster. you can use dms to migrate the data.

0

When you restore a snapshot, it creates a new DB Cluster, see: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Backups.html#Aurora.Managing.Backups.Restore

You specify the KMS key as a parameter on your restore, see: https://awscli.amazonaws.com/v2/documentation/api/latest/reference/rds/restore-db-cluster-from-snapshot.html

Look for --kms-key-id

Since the CDK creates CloudFormation templates, you'll likely have to import the new cluster into your stack. See: https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/resource-import.html

profile pictureAWS
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