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 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则