Skip to content

Move `members` to gitlab_main_cell schema

Manoj M J requested to merge members-415204-cells-iteration-2-configure-namespaces-adjacent-tables-to-be-gitlab_main_cell-to-support into master

What does this MR do and why?

Related to #415204 (closed)

As part of building out Cells, this MR tags the members table as a cell-local table, by assigning the schema gitlab_main_cell to it.

After assigning this schema, some specs failed because of cross-joins involving members table and other tables in the cluster-wide schema, and this has been marked and allowed for now using allow_cross_joins_across_databases(url: 'https://gitlab.com/gitlab-org/gitlab/-/issues/422405') wherever this happens.

members.user_id needs to be converted to a loose foreign key as well, and that has been marked in the MR as well.

NOTE:

More information on this kind of work we are doing for cells: !129303 (comment 1515839531)

Similar MRs can be found in the Related merge requests section of #415204 (closed)

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before After

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #415204 (closed)

Edited by Manoj M J

Merge request reports