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 Antworten
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
beantwortet vor 2 Jahren
  • 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
beantwortet vor 2 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen