Page MenuHomePhabricator

Extend sites.site_global_key on WMF production
Closed, ResolvedPublic

Description

ALTER TABLE: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/620044/3/maintenance/archives/patch-sites-site_global_key.sql

ALTER TABLE sites MODIFY `site_global_key` varbinary(64) NOT NULL;

WHERE: All wikis with the site table (it should be every wiki database)
WHEN: At DBAs leisure; change isn't necessary for WMF production, but helps keep tables in sync with core schema changes
BACK COMPAT: Yes
TESTED: Not yet on beta, will be merged soon

Table on the wikis should be relatively small, ~1000 rows

Schema change progress:

  • s1
  • s2
  • s3
  • s4
  • s5
  • s6
  • s7
  • s8
  • wikitech
  • labtestwiki

Event Timeline

Marostegui moved this task from Backlog to Pending comment on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2020-08-25T12:39:39Z] <marostegui> alter table sites on s6, directly on the primary master T260476

Marostegui updated the task description. (Show Details)
Marostegui moved this task from Pending comment to In progress on the DBA board.
Marostegui moved this task from Backlog to In progress on the Schema-change-in-production board.

s3 is the only one pending - will do it once the DC switchover is done next week.

Mentioned in SAL (#wikimedia-operations) [2020-09-10T05:29:50Z] <marostegui> Deploy schema change on s3 master - T260476