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 個月前

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

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

回答問題指南