Compact database migrations

Registered by Stephen Finucane on 2020-10-15

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:
Not started
Approver:
Balazs Gibizer
Priority:
Undefined
Drafter:
Stephen Finucane
Direction:
Approved
Assignee:
Stephen Finucane
Definition:
Approved
Series goal:
Accepted for wallaby
Implementation:
Unknown
Milestone target:
milestone icon wallaby-1

Related branches

Sprints

Whiteboard

Gerrit topic: https://review.opendev.org/#/q/topic:bp/compact-db-migrations-wallaby

Addressed by: https://review.opendev.org/758394
    Compact pre-Juno database migrations

Addressed by: https://review.opendev.org/758395
    TODO: Compact pre-Kilo database migration

Addressed by: https://review.opendev.org/758396
    Compact pre-Liberty database migrations

Addressed by: https://review.opendev.org/758397
    TODO: Compact pre-Mitaka database migrations

Addressed by: https://review.opendev.org/758398
    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://review.opendev.org/758155
    db: Clean up base migration

Addressed by: https://review.opendev.org/758156
    db: Merge in unique constraints

Addressed by: https://review.opendev.org/758157
    db: Drop add/remove of index

Addressed by: https://review.opendev.org/759085
    db: Compact Newton database migrations

Addressed by: https://review.opendev.org/759086
    db: Compact Ocata database migrations

Addressed by: https://review.opendev.org/759087
    db: Compact Pike database migrations

Addressed by: https://review.opendev.org/759088
    db: Compact Queens database migrations

Addressed by: https://review.opendev.org/759089
    db: Compact Rocky database migrations

Addressed by: https://review.opendev.org/759090
    db: Compact Stein database migrations

Addressed by: https://review.opendev.org/759091
    db: Compact Train database migrations

Addressed by: https://review.opendev.org/759256
    db: Compact Kilo database migrations

Addressed by: https://review.opendev.org/759399
    apidb: Compact Liberty database migrations

Addressed by: https://review.opendev.org/759400
    apidb: Compact Mitaka database migrations

Addressed by: https://review.opendev.org/759401
    apidb: Compact Newton database migrations

Addressed by: https://review.opendev.org/759402
    apidb: Compact Ocata database migrations

Addressed by: https://review.opendev.org/759403
    apidb: Compact Pike database migrations

Addressed by: https://review.opendev.org/759404
    apidb: Compact Queens database migrations

Addressed by: https://review.opendev.org/759405
    apidb: Compact Rocky database migrations

Addressed by: https://review.opendev.org/759406
    apidb: Compact Stein database migrations

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.