XS Add sharding key YAML config to ci_builds_runner_session (1 table)
What we need to do
The ci_builds_runner_session
has build_id
, so we can add project_id
and use ci_builds.project_id
to backfill ci_builds_runner_session
How to do it
-
Read https://docs.gitlab.com/ee/development/cells/#define-a-desired_sharding_key-to-automatically-backfill-a-sharding_key - It seems like the automation will not be able to handle composite keys (
build_id
+partition_id
in this case), so we'll need to implement the migrations manually
- It seems like the automation will not be able to handle composite keys (
-
Modify https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/p_ci_runner_machine_builds.yml
This is a small table atm in .com:
gitlabhq_dblab> SELECT COUNT(*) FROM ci_builds_runner_session
+-------+
| count |
|-------|
| 6844 |
+-------+
Edited by Pedro Pombeiro