M Add sharding key YAML config to p_ci_job_annotations (1 table)

What we need to do

The p_ci_job_annotations table has a job_id column so we could look into the project_id from a Ci::Build to identify the correct sharding key here and backfill the data accordingly.

How to do it

  1. Read https://docs.gitlab.com/ee/development/cells/#define-a-desired_sharding_key-to-automatically-backfill-a-sharding_key
  2. Modify https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/ci_job_variables.yml
  3. Create all necessary migrations as we did in daed28a6
Edited by Max Orefice