CODEWITHSUNDEEP
amazon-web-servicesamazon-rds
pradeepchhetri
pradeepchhetri

Reputation: 2969

Quick way to clone a production RDS instance

I have an RDS Instance which is currently in production and all the apps are using the same RDS instance. Now when I want to make separate RDS instances for each app, I tried using RDS feature called restore to point in time but it took nearly one hour to create a new RDS instance.

Can someone suggest me some good way to perform it so that i can create an exact replica of running rds instance.

Upvotes: 8

Views: 5748

Answers (1)

The-Big-K
The-Big-K

Reputation: 2830

You should really consider using Aurora Mysql as opposed to RDS Mysql fr the clone use case. You can spin up a clone in a matter of minutes, and it does not even duplicate your database pages unless you mutate them (copy on write protocol).

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Aurora.Managing.Clone.html

Restoring snapshots are definitely not going to be as fast as cloning as they incur data copying over head. If you need to continue using RDS, then yes, having a hot replica stand-by is the best bet, although I'm not entirely convinced that that's what you're looking for.

Upvotes: 2

Related Questions