Need to move or clone RDS Instance MS SQL with DB data to another region

0

Hi, I have created an Initial RDS Instance with MS SQL and DB Data but it's too slow for me in the California region, I am planning to migrate RDS Instance with DB using a cloud formation template to the Mumbai region, can I anyone help me with the steps?

1 個回答
2

One solution [1] involves a source RDS DB instance running in the primary Region in its own VPC and subnet. The target RDS DB instance is running in a separate DR Region in its own VPC and subnet. Both the VPCs are accessible via VPC peering. The target database is created from a backup of the source database. The ongoing changes are then replicated from the source using MS-CDC. AWS DMS runs the database migration jobs that continuously replicate data from source to target. AWS DMS runs in a separate Amazon Elastic Compute Cloud (Amazon EC2) instance in the same VPC in the secondary Region.

You can also use cross-Region snapshot and restore [2]

Note : Depending on the AWS Regions involved and the amount of data to be copied, a cross-Region snapshot copy can take hours to complete.

  1. https://aws.amazon.com/blogs/database/set-up-a-cross-region-disaster-recovery-site-for-amazon-rds-for-sql-server/
  2. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CopySnapshot.html
profile pictureAWS
專家
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南