Creating a development instance of a large production RDS instance

Question

We have a large RDS instance in AWS (100GB). We're creating a script which will clear out old data in the database at regular intervals. In order to test this fully we'd like to setup a copy of the existing production RDS instance which we can use to test the script on (so we don't lose data from the production instance).

Is there a way to create a standalone duplicate RDS instance based on another instance? I had thought I could do this by using a snapshot, but it appears you can only restore an instance from a snapshot.

Archdoog · Accepted Answer · 2018-03-07 17:45:02Z

1

With a snapshot you can restore to a different/new instance name. E.g. create a snapshot of database-one then restore the snapshot to a different instance name database-one-copy.

I use this method programmatically to create a development database on a nightly schedule or as needed using the python AWS SDK Boto3 and this method https://github.com/airsciences/aws-rds-persist.

answered Mar 7, 2018 at 17:45

Archdoog

92010 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating a development instance of a large production RDS instance

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related