Skip to content

Draft: Prepare to fully shard the identities table

Tomasz Skoruparequested to merge
tskorupa/mark-identities-as-sharded into master

What does this MR do and why?

Follow up to !202814 (merged)

Addresses #578135

The table is sharded by identities#user_id. There is missing a foreign key constraint on the sharding key. I am running a background job that will remove all orphaned identities.

SQL

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.

Edited by Tomasz Skorupa

Merge request reports