Add and backfill a sharding_key to an existing small table
This issue will allow us to work out what the series of steps looks like to backfill a sharding key on a table that is missing it.
We should choose a table small enough so that we're not needing to deal with the complexities of backfilling at massive scale.
Possible tables
packages_tags
snippet_repositories
user_achievements
vulnerability_issue_links
Steps
-
MR1 (%16.6): Add the column and start the migration !135451 (merged) -
MR2 (%16.7) !136792 (merged): - Finalize the migration
- Validate the not-null constraint
Edited by Tiger Watson