View a markdown version of this page

Database DevOps on AWS: Production Workflow - Database DevOps on AWS
Database DevOps on AWS: Production Workflow

Database DevOps on AWS: Production Workflow

Publication date: March 31, 2023 (Diagram history)

Use this architecture in the production workflow to automate database changes as part of DevOps practice. Build an orchestration to deploy database changes at the same rate as application code, detect abnormal system behavior, and automate notifications to appointed teams to take corrective actions.

Database DevOps on AWS: Production Workflow

Architecture diagram showing database DevOps production workflow with CodePipeline, CodeBuild, and Amazon RDS.

The following steps describe the architecture:

  1. The release manager issues a production deployment request.

  2. CodePipeline invokes the build management tool which calls the database change management tool.

  3. The database change tool downloads the database change scripts and runs them against the target Amazon RDS production database.

  4. CodePipeline initiates the Deploy action to deploy code to the target environment.

  5. (Optional) Use Performance Insights on Amazon RDS and Amazon DevOps Guru to automatically apply ML techniques to detect performance bottlenecks and operational issues.

  6. EventBridge captures events and sends them to an Amazon SNS topic for user notifications.