feat(new construct): aws-rds-bluegreen

[crenzoaws]

The construct I'm purposing will deploy an RDS or Aurora database configured to use AWS secrets manager for database credentials and take in a local directory containing schema migration application. An example open source schema migration application is Redgate Flyway but the user can use any application of their choice.

The construct will first upload the local schema migration directory to S3 then use Step Functions to orchestrate the pre-migration checks, performing the schema migration and the redirection of traffic to the new database. Within the Step Function, CodeBuild is used to allow customization and support of user supplied schema migration applications, optional Lambda hooks allow for the user to write custom checks to verify the migration is working as intended and the RDS blue/green deployment allows the migration to roll back in the event of errors.

Use Case

The best practice for making modifications to a relational database is to use a schema migration tool checked into source control. This construct helps accelerate this pattern and provides a mechanism to support future database updates.

Proposed Solution

• 👋 I may be able to implement this feature request
• ⚠️ This feature might incur a breaking change

---

This is a 🚀 Feature Request