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年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ