search

department-of-veterans-affairs / abd-vro

To get Veterans benefits in minutes, VRO software uses health evidence data to help fast track disability claims.
Other
19 stars 6 forks source link

Automate RDS DbInstance Initialization Steps #2004

Open msnwatson opened 1 year ago

msnwatson commented 1 year ago

Followup to #1845

User Story

As a VRO engineer, I want to be able to automate initialization steps for creating RDS dbinstances configured for interaction with VRO, so that new dbinstances can be created without following manual steps.

New dbinstances may be created if there is a desire (or requirement) to upgrade to newer versions of the Postgres DB engine for security reasons.

Acceptance Criteria

  1. VRO engineers can push a button to create a new dbinstance in any of the LHDI environments (probably through a GH action or workflow)
  2. Newly created dbinstances have users for running flyway migrations and handling DB client connections from apps deployed in VRO along with the proper roles
  3. After dbinstance creation, db-init containers and any client connections work without futher manual intervention beyond updating any environment variables

Not included in this work

A note about things that should not be considered necessary.

Notes about work

meganhicks commented 2 months ago

could be good for Paul or Kyle

meganhicks commented 1 month ago

removed from Sprint A in place for a ticket more related to ArgoCd