RDS Upgrade - Postgres 12.7 - Aurora - best way with zero or little downtime

Question

Good evening ... as the subject states, we are currently running an RDS version of postgres 12.7 and wish to migrate over to Aurora. I would assume the easiest would be to create an aurora read replica, test all functions (including postGIS), and once confirmed things work, promote that and should be good however the create aurora read replica is not showing on the console. I saw a few threads about that being a big but that was months ago.

This database gets thousands of updates every minute, so really trying to keep the downtime to nothing or as little as possible, so any guidance or help is appreciated.

Answer

This could be a good use case for DMS with continuous replication:

1. use DMS for ongoing replication
2. move read endpoints to Aurora
3. move write endpoints to Aurora

https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatabases.mysql2rds.replication.html

Answer

I've seen the same issue too - I found this discussion which suggests it's a console bug only and the workaround is to use CLI.
https://www.reddit.com/r/aws/comments/qcbgfr/option_to_create_aurora_read_replica_of_rds/

RDS Upgrade - Postgres 12.7 -> Aurora - best way with zero or little downtime

Relevanter Inhalt