Compact database migrations
Compact the database migrations from Icehouse through to Ussuri. This should speed up deployments in the gate, make the DB schema more understandable to mere mortals, and allow us to finally (finally!) move to alembic.
Blueprint information
- Status:
- Complete
- Approver:
- Balazs Gibizer
- Priority:
- Undefined
- Drafter:
- Stephen Finucane
- Direction:
- Approved
- Assignee:
- Stephen Finucane
- Definition:
- Approved
- Series goal:
- Accepted for wallaby
- Implementation:
-
Implemented
- Milestone target:
-
wallaby-3
- Started by
- Balazs Gibizer
- Completed by
- Balazs Gibizer
Related branches
Related bugs
Sprints
Whiteboard
Gerrit topic: https:/
Addressed by: https:/
Compact pre-Juno database migrations
Addressed by: https:/
TODO: Compact pre-Kilo database migration
Addressed by: https:/
Compact pre-Liberty database migrations
Addressed by: https:/
TODO: Compact pre-Mitaka database migrations
Addressed by: https:/
WIP: Compact pre-Newton database migrations
[20201015 gibi]: Approved as specless bp on the weekly nova meeting with two comments:
* this only covers the compaction of the migrations and the move to alembic needs a separate bp and discussion on the PTG.
* special care is needed for testing and reviewing the compaction. We need to ensure that the current schema and the schema after the compaction is the same.
Addressed by: https:/
db: Clean up base migration
Addressed by: https:/
db: Merge in unique constraints
Addressed by: https:/
db: Drop add/remove of index
Addressed by: https:/
db: Compact Newton database migrations
Addressed by: https:/
db: Compact Ocata database migrations
Addressed by: https:/
db: Compact Pike database migrations
Addressed by: https:/
db: Compact Queens database migrations
Addressed by: https:/
db: Compact Rocky database migrations
Addressed by: https:/
db: Compact Stein database migrations
Addressed by: https:/
db: Compact Train database migrations
Addressed by: https:/
db: Compact Kilo database migrations
Addressed by: https:/
apidb: Compact Liberty database migrations
Addressed by: https:/
apidb: Compact Mitaka database migrations
Addressed by: https:/
apidb: Compact Newton database migrations
Addressed by: https:/
apidb: Compact Ocata database migrations
Addressed by: https:/
apidb: Compact Pike database migrations
Addressed by: https:/
apidb: Compact Queens database migrations
Addressed by: https:/
apidb: Compact Rocky database migrations
Addressed by: https:/
apidb: Compact Stein database migrations
[20210312 gibi]: The remaining patches has been approved and pushed through the gate. So I mark this as implemented in Wallaby.
