What are best practices for setting a test environment for RDS Aurora PostgreSQL
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?
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
Migrating RDS PostgreSQL to Aurora PostgreSQL in a different accountAccepted AnswerEXPERTasked a year ago
Aurora for PostgreSQL plugin listAccepted Answerasked 5 years ago
Choosing RDS PostgreSQL over Aurora PostgreSQLasked a month ago
Migrate snapshot option disabledasked a year ago
RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.Accepted Answerasked 4 months ago
Tracking changes in data in Aurora PostgreSQLAccepted Answerasked 2 years ago
Changes to connection handling with Aurora Postgres?Accepted Answerasked 3 years ago
What are best practices for setting a test environment for RDS Aurora PostgreSQLAccepted Answerasked 2 years ago
Migration from Aurora PostgreSQL back to regular RDSAccepted Answerasked 3 years ago
Move RDS postgresql database to Aurora ServerlessAccepted Answerasked 3 years ago