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
ESPERTO
john_l
posta 3 anni fa1153 visualizzazioni
1 Risposta
0
Risposta accettata

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
con risposta 3 anni fa
profile picture
ESPERTO
verificato 10 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande