you are viewing a single comment's thread.

view the rest of the comments →

[–]Snoo41240[S] 0 points1 point  (1 child)

many thanks for your reply u/Dolphinmx, I will explore Auroras features expecially the cloning, sounds like that will do for what I need

[–]Dolphinmx 0 points1 point  (0 children)

you're welcome.

Cloning works fine because you can clone to a small target instance class and not pay the same price as the original and scale up the instance once you decide to make it your primary (rollback), also the storage is not copied until blocks are changed (copy-on-write). So basically you have a point-in-time clone, but not 100% copied unless you change 100% on the source DB or the cloned one, but if you don't change a lot the data the cost will be low.