Add sharding key for design_management
We have a total of 6 tables related to DesignManagement:
design_management_designs
design_management_repositories
design_management_versions
design_management_designs_versions
design_management_repository_states
design_user_mentions
There are 5 steps to add namespace_id
as sharding key to these tables and backfill them.
- Add
desired_sharding_key
config to relevantdocs/db/#{table_name}.yml
files - Generate Backfill MRs for tables which don't have dependency of parent tables backfilling(first 3 from the list)
- Validate Backfill is successful
- Generate Backfill MRs for dependent table(last 3 from the list)
- Validate Backfil is successful
Note: Both Backfill and Validate MRs will be raised via gitlab-housekeeper either my Tenet team or by the assignee of this issue based on priority.
Older context of the Issue
For all of our tables, we need to define a sharding key. For `design_management` we want to use `namespace_id`. We have not backfilled `namespace_id` on all design management related tables (see #458869 (closed) which blocks this issue).Edited by Abhilash Kotte