-
Hi, I am joining the club of the people struggling with this question.
A Database Engineer plans to migrate an Oracle database instance running in the Northern California (us-west-1) region to an Amazon RDS for MySQL DB instance located in the Northern Virginia (us-east-1) region using AWS DMS. The source database is configured to dynamically transform and manipulate data using transformation rule expressions.
How should the engineer set up the AWS DMS replication instance to achieve the MOST optimal performance?
In Stephane’s course, he explicitly recommended placing the RI into the destination AZ. This article describes different configurations, all with RI in the Target VPC https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.VPC.html
