Which solution will meet these requirements?
Create VPC peering between the VPCs in both accounts. Take a snapshot of the RDS DB instance. Export the snapshot to Amazon S3. Create an S3 gateway endpoint. Use the S3 sync command for ongoing synchronization of data. Restore the snapshot from Amazon S3 in the Aurora account. Migrate the snapshot to the Aurora DB cluster.
Create VPC peering between the VPCs in both accounts. Import the AWS managed KMS key to the Aurora account. Take a snapshot of the RDS DB instance. Share the snapshot with the Aurora account. Copy the shared snapshot to eu-north-1 in the Aurora account. Migrate the shared snapshot to the Aurora DB cluster. Use AWS Database Migration Service (AWS DMS) with ongoing replication to complete the migration.
Create VPC peering between the VPCs in both accounts. Copy the AWS managed KMS key to the Aurora account. Create an Aurora cross-Region read replica of the RDS DB instance in the Aurora account. Promote the read replica from standby DB instance to primary DB instance.
Create VPC peering between the VPCs in both accounts. Create a multi-Region customer managed KMS key in the RDS account, and share the key with the Aurora account. Modify the cluster to use the customer managed KMS key. Take a snapshot of the RDS DB instance. Share the snapshot with the Aurora account. Copy the shared snapshot to eu-north-1 in the Aurora account. Migrate the shared snapshot to the Aurora DB cluster. Use AWS Database Migration Service (AWS DMS) with ongoing replication to complete the migration.
Explanations:
This option involves exporting the snapshot to Amazon S3 and using S3 sync for ongoing data synchronization, which would cause a significant delay and potential inconsistency in data migration, violating the requirement for no interruption to applications.
Although this option uses AWS DMS for ongoing replication, it requires importing the AWS managed KMS key to the Aurora account. However, Aurora can’t directly use the AWS-managed KMS key from the RDS account, so this approach will not work.
Aurora does not support cross-Region read replicas from RDS for PostgreSQL. This makes the solution invalid for the migration requirements as Aurora cannot directly replicate from an RDS PostgreSQL instance across Regions.
This option correctly outlines the process for migration with a customer-managed multi-Region KMS key that can be shared between the accounts. It also uses AWS DMS for ongoing replication, meeting the no-interruption requirement for the application.