Switch current partition_id value to 101 for ci_builds_metadata and ci_builds

For the p_ci_builds_metadata table we have two partitions:

  • ci_builds_metadata FOR VALUES IN ('100')
  • gitlab_partitions_dynamic.ci_builds_metadata_101 FOR VALUES IN ('101')

Switching partition_id to 101 will stop the growth of the ci_builds_metadata table because the new records will be persisted in the ci_builds_metadata_101 table.

We should also stop the growth of ci_builds table once we implement our second partition for it #416457 (closed).

Proposal:

  • create a plan to make sure that it doesn't take down production
  • prepare a plan for recovering from the unexpected
  • make the change
Edited by Caroline Simpson