View a markdown version of this page

Database DevOps on AWS: Development Workflow - Database DevOps on AWS
Database DevOps on AWS: Development WorkflowFurther readingDiagram history

Database DevOps on AWS: Development Workflow

Publication date: March 31, 2023 (Diagram history)

Use this architecture in the development workflow to automate database changes as part of DevOps practice. Build an orchestration to deploy database changes at the same rate as application code, enforce database-application-joint code reviews, integrate database and application code operations, detect abnormal system behavior, and automate notifications to appointed teams.

Database DevOps on AWS: Development Workflow

Architecture diagram showing database DevOps development workflow with AWS CodeCommit, CodePipeline, CodeBuild, and Amazon RDS.

The following steps describe the architecture:

  1. The developer checks both application and database code into AWS CodeCommit.

  2. At every push request, AWS CodeCommit enforces code reviews through the use of approval rules.

  3. Amazon CodeGuru Reviewer automatically evaluates code changes, detects errors, and offers code recommendations.

  4. AWS CodeCommit initiates CodePipeline to take pipeline actions.

  5. The CodePipeline Source action checks out application and database code.

  6. The CodePipeline Build action invokes a build management tool to start the application and database code build phase.

  7. The build tool calls the database change tool. It downloads the database scripts and runs them against the target database.

  8. The build tool calls database test scripts and validates output.

  9. The CodePipeline Deploy action deploys code to the target environment.

  10. Build artifacts are published to AWS CodeArtifact for others to consume.

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

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

Further reading

For additional information, refer to the following resources:

Diagram history

To be notified about updates to this reference architecture diagram, subscribe to the RSS feed.

ChangeDescriptionDate

Initial publication

Reference architecture diagram first published.

March 31, 2023

Note

To subscribe to RSS updates, you must have an RSS plugin enabled for the browser you are using.