Migrating RDS PostgreSQL to Aurora PostgreSQL in a different account

0

Hello, I have a customer who needs to move their RDS PostgreSQL database to a different account, and would like to migrate to Aurora while doing so. Just wanted to do a quick sanity check + see if there are simpler options available before I shoot over the following options to the customers.

With downtime

  1. Take snapshot of PostgreSQL database
  2. Share snapshot with new account following these steps (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Import.Console)
  3. Create Aurora cluster from RDS PostgreSQL snapshot

No downtime

  1. Create Aurora cluster in new account
  2. Use DMS to migrate data from RDS PostgreSQL to Aurora cluster in new account (https://aws.amazon.com/blogs/database/set-up-aws-dms-for-cross-account-migration/)

The customer is running RDS PostgreSQL 10.13 at the moment.

AWS
专家
john_l
已提问 3 年前1154 查看次数
1 回答
0
已接受的回答

Look into Amazon Aurora Fast Cloning as well. It supports Cross-account cloning via Resource Access Manager:

Possible route to take, this will have downtime but will still be minimal, and doesn't require DMS or manually dealing with logical replication:

Having said that, to err on the safe side, I personally would recommend customer to separate this into 2 tasks and not try to group into one operation. One to upgrade to Aurora, and the second to create the fast DB clone cross-account. It will require 2 DNS cutover for the applications or require 2 updates in route 53 if you're using CNAMEs, but will likely make things clearer.

AWS
已回答 3 年前
profile picture
专家
已审核 10 个月前

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

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

回答问题的准则