Prepare cluster_providers_aws for sharding

Tomasz Skoruparequested to merge
tskorupa/prepare-cluster_providers_aws-for-sharding into master

What does this MR do and why?

Prepare cluster_providers_aws for sharding:

  • add organization_id, namespace_id && project_id columns
  • create a trigger that assigns the sharding key
  • index each sharding key column
  • add a foreign key constraint (not valid) on each sharding key column
  • add a not null (not valid) constraint on the sharding key
  • backfill the sharding key

Addresses #584431

Changelog: other

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Merge request reports