Change 675185 had a related patch set uploaded (by Urbanecm; author: Urbanecm):
[operations/puppet@production] add growthexperiments_mentor_mentee to $private_tables

https://gerrit.wikimedia.org/r/675185

Is there a typo on the task description?

Table creation
Database should be created for all wikis in growthexperiments.dblist. The table should not be replicated.

I assume it should be table should be created?

Change 675185 merged by Marostegui:

[operations/puppet@production] add growthexperiments_mentor_mentee to $private_tables

https://gerrit.wikimedia.org/r/675185

Mentioned in SAL (#wikimedia-operations) [2021-04-05T05:12:02Z] <marostegui> Restart all sanitarium hosts to pick up new filters T278573

All sanitarium hosts have been restarted to pick up the filter.

In T278573#6971609, @Marostegui wrote:

Is there a typo on the task description?

Table creation
Database should be created for all wikis in growthexperiments.dblist. The table should not be replicated.

I assume it should be table should be created?

Of course, thanks for catching that. I'm apparently so used to creating databases rather than tables :-).

@Marostegui I'd appreciate it if you could have a look on the schema proposed and give a +1 (probably here, as the implementation side of the patch is likely to be changed as code review comes) as mentioned by https://wikitech.wikimedia.org/wiki/Creating_new_tables#Deployment.

CREATE TABLE /*_*/growthexperiments_mentor_mentee (
  gemm_mentee_id INT UNSIGNED NOT NULL,
  gemm_mentor_role VARCHAR(255) NOT NULL,
  gemm_mentor_id INT UNSIGNED NOT NULL,
  INDEX gemm_mentor_mentee (gemm_mentor_id),
  PRIMARY KEY(
    gemm_mentee_id, gemm_mentor_role
  )
);

@Urbanecm let's change VARCHAR with VARBINARY if that's ok.

Change 677921 had a related patch set uploaded (by Urbanecm; author: Urbanecm):

[mediawiki/extensions/GrowthExperiments@master] Create growthexperiments_mentor_mentee to store mentor/mentee relationship

https://gerrit.wikimedia.org/r/677921

In T278573#6974892, @Marostegui wrote:

@Urbanecm_WMF let's change VARCHAR with VARBINARY if that's ok.

Sure, done. New schema:

CREATE TABLE /*_*/growthexperiments_mentor_mentee (
  gemm_mentee_id INT UNSIGNED NOT NULL,
  gemm_mentor_role VARBINARY(255) NOT NULL,
  gemm_mentor_id INT UNSIGNED NOT NULL,
  INDEX gemm_mentor_mentee (gemm_mentor_id),
  PRIMARY KEY(
    gemm_mentee_id, gemm_mentor_role
  )
) /*$wgDBTableOptions*/;

heh, it took me a while to realize that the INDEX was different from the PK first column, so many similar column names :-)
That looks good to me.

Change 677921 merged by jenkins-bot:

[mediawiki/extensions/GrowthExperiments@master] Create growthexperiments_mentor_mentee to store mentor/mentee relationship

https://gerrit.wikimedia.org/r/677921

Mentioned in SAL (#wikimedia-operations) [2021-04-13T22:04:07Z] <Urbanecm> [urbanecm@mwmaint1002 /srv/mediawiki]$ foreachwikiindblist growthexperiments sql.php php-1.37.0-wmf.1/extensions/GrowthExperiments/maintenance/schemas/mysql/growthexperiments_mentor_mentee.sql # T278573

In T278573#6996501, @Stashbot wrote:

Mentioned in SAL (#wikimedia-operations) [2021-04-13T22:04:07Z] <Urbanecm> [urbanecm@mwmaint1002 /srv/mediawiki]$ foreachwikiindblist growthexperiments sql.php php-1.37.0-wmf.1/extensions/GrowthExperiments/maintenance/schemas/mysql/growthexperiments_mentor_mentee.sql # T278573

(and at the right database cluster, realized seconds before submitting in prod)

Confirmed - table isn't on wiki replicas:

root@clouddb1021:/srv# find . | grep -i growthexperiments_mentor_mentee
root@clouddb1021:/srv#