Fast way to clone a production instance of RDS

Question

I have an RDS instance that is currently running, and all applications use the same RDS instance. Now that I want to create separate RDS instances for each application, I tried using the RDS function called restore to indicate the time, but it took almost one hour to create a new RDS instance.

Can someone suggest me a good way to execute it so that I can create an exact copy of the rds executable instance.

Answer 1

You really should consider using Aurora Mysql rather than RDS Mysql when using a clone. You can unwind a clone in a matter of minutes, and it does not even duplicate your database pages if you have not changed them (copying using the write protocol).

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

Restoring snapshots will definitely not be as fast as cloning, as they will entail copying the data. If you need to continue to use RDS, then yes, it is best to have a hot standby replica, although I'm not quite sure if this is what you are looking for.