What are best practices for setting a test environment for RDS Aurora PostgreSQL

0

Customer who periodically simulates an outage in RDS Aurora PostgreSQL by stopping and starting the entire Aurora cluster and observing the effect on different upstream systems. This is not an ideal situation as it takes some time for the stopping/starting and the environment is offline and unavailable for other testing use during the duration. They were thinking of setting up a reader node for testing and isolate testing to this node. However, they indicated that these reader nodes can only be rebooted and not just stopped, this may not be ideal for them.

Is there a way for the customer to have a similar parallel environment for testing purposes for these offline scenarios while maintaining functionality of the database for other testing?

質問済み 4年前728ビュー
1回答
0
承認された回答

Currently Aurora PG does not support multi-primary. Since this testing is done periodically, one option would be to restore a snapshot every time for simulation. Second option would be the promote read replica and delete the read-replica after the testing. With this, you need to create new read-replica every time. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.Replication.ReadReplicas.html#USER_PostgreSQL.Replication.ReadReplicas.Limitations

Another option would be to keep two active read-write databases. To configure this, you can first restore a snapshot and then keep a DMS instance to replicate changes from source to target instance. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.PostgreSQL.html

回答済み 4年前
profile picture
エキスパート
レビュー済み 6ヶ月前

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

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

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

関連するコンテンツ