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
EXPERTO
john_l
preguntada hace 3 años1154 visualizaciones
1 Respuesta
0
Respuesta aceptada

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
respondido hace 3 años
profile picture
EXPERTO
revisado hace 10 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas