Following up T275242: iwlinks.iwl_prefix should be the same length as interwiki.iw_prefix
Where: All wikis
When: At DBA's leisure
Is backwards compatible: Yes
Has been tested already: Yes
Progress
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Restricted Task | |||||
| Resolved | Legoktm | T281515 June 2021 Datacenter switchover | |||
| Resolved | Marostegui | T285139 DB maintenance work to do while eqiad is passive (June 2021) | |||
| Resolved | Reedy | T275242 iwlinks.iwl_prefix should be the same length as interwiki.iw_prefix | |||
| Resolved | Marostegui | T277123 Extend iwlinks.iwl_prefix to VARBINARY(32) |
Going to deploy this on s6 on a couple of hosts in eqiad. If all goes well, I will try to deploy it entirely on codfw, so I can do eqiad once the dc switchover has happened.
root@cumin1001:/home/marostegui# mysql.py -hdb1096:3316 frwiki -e "show create table iwlinks\G"
*************************** 1. row ***************************
Table: iwlinks
Create Table: CREATE TABLE `iwlinks` (
`iwl_from` int(10) unsigned NOT NULL DEFAULT 0,
`iwl_prefix` varbinary(32) NOT NULL DEFAULT '',
`iwl_title` varbinary(255) NOT NULL DEFAULT '',
PRIMARY KEY (`iwl_from`,`iwl_prefix`,`iwl_title`),
KEY `iwl_prefix_title_from` (`iwl_prefix`,`iwl_title`,`iwl_from`),
KEY `iwl_prefix_from_title` (`iwl_prefix`,`iwl_from`,`iwl_title`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8s6 eqiad progress
Mentioned in SAL (#wikimedia-operations) [2021-07-01T05:55:52Z] <marostegui> Deploy schema change on s6 eqiad master (db1173) T277123
Mentioned in SAL (#wikimedia-operations) [2021-07-01T05:57:34Z] <marostegui> Deploy schema change on s5 eqiad master (db1130) T277123
Mentioned in SAL (#wikimedia-operations) [2021-07-01T06:31:51Z] <marostegui> Deploy schema change on s2,s8 eqiad masters T277123
Mentioned in SAL (#wikimedia-operations) [2021-07-01T06:34:42Z] <marostegui> Deploy schema change on s7 eqiad (db1136) masters T277123
Mentioned in SAL (#wikimedia-operations) [2021-07-01T07:06:03Z] <marostegui> Deploy schema change on s4 eqiad (db1138) master T277123
Mentioned in SAL (#wikimedia-operations) [2021-07-01T08:52:42Z] <marostegui> Deploy schema change on s1 eqiad (db1163) master T277123
Mentioned in SAL (#wikimedia-operations) [2021-07-01T09:05:08Z] <marostegui> Deploy schema change on s1 eqiad (db1157) master T277123