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

1

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.

2개 답변
1

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/

전문가
답변함 2년 전
1

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

답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠