Aurora and RDS Automated Database Refresh from CirrusHQ

CirrusHQs' Database Refresh solution automatically migrates Aurora and RDS database snapshots from a production AWS Account to a non-production AWS Account to securely refresh the non-production environment with production-level data to allow for performance testing at a production scale. Migrating Database Data cross-account can be a long, complex and manual process requiring a high level of effort due to long-running tasks which can be extremely error-prone. CirrusHQ delivers this as a fully engineered pipeline: once deployed, the entire refresh runs automatically end to end, with no manual intervention required.

This solution provisions all infrastructure components by utilising Infrastructure as Code (IaC) and a CI/CD CodePipeline to deploy an AWS Step Function State Machine to orchestrate database snapshot copy, re-encryption, restore and cleanup of the non-production database with zero impact to the production database. Due to the end-to-end fully automated approach of this solution, errors due to human errors are mitigated. With Slack Integration as standard, your team is informed about the Database Refresh process every step of the way.

Typical use cases: pre-release performance testing against production-scale data, and UAT environments that need production-realistic data under data-protection rules, using the built-in PII anonymisation option.

CirrusHQ Database Refresh is optionally executed on a schedule to periodically refresh non-production databases, customisable to the business requirements. Additional customisations and requirements can be discussed and designed to meet business needs;

• Database Anonymisation to randomise sensitive PII Data. Anonymisation scripts are custom to the Database Schema and your use case.
• Non-Production Database Table backup and restore to persist data specific to the environment, such as configuration tables.