Amazon-RDS [SOLVED]: How to create "Write" clone of a production RDS Aurora instance?

Amazon-RDS [SOLVED]: How to create "Write" clone of a production RDS Aurora instance?

Home Forums Amazon Web Services Amazon RDS Amazon-RDS [SOLVED]: How to create "Write" clone of a production RDS Aurora instance?

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #247025

    Cloudy Point
    Keymaster

    QuestionQuestion

    I have a production DB that is on RDS Aurora MySQL. I would like to create a “staging” version of it, so I need a complete duplicate/clone of the production version.

    Most importantly I need the staging version to have write access to the new instance.

    Is this possible?

    #247026

    Cloudy Point
    Keymaster

    Accepted AnswerAnswer

    Review Cloning Databases in an Aurora DB Cluster in the RDS User Guide.

    Clones are not the same thing as replicas. A replica, in Aurora, has read-only access to the same data store allowing you to spread out your read workload across multiple instances… but a clone is a readable/writable moment-in-time fork of your original database. Any changes after the clone is created don’t change the data on the original database instances (or on any other clones, and up to 15 independent clones are currently supported).

    You can also create a new Aurora cluster from a snapshot of your production database, but a clone is probably the preferred solution for two reasons: it’s faster to create a clone… but perhaps more importantly, clones use copy-on-write, so until you change the data on either the clone or the master it was cloned from, they share common storage space in the Aurora Cluster Volume that stores the data — so you’re only paying once for storage of the data that never gets changed. How this works is explained, with diagrams, in the RDS User Guide at the link, above.

    Source: https://stackoverflow.com/questions/47944639/how-to-create-write-clone-of-a-production-rds-aurora-instance
    Author: Michael – sqlbot
    Creative Commons License
    This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.