You are browsing a read-only backup copy of Wikitech. The live site can be found at wikitech.wikimedia.org

Switch Datacenter/planned db maintenance

From Wikitech-static
< Switch Datacenter
Revision as of 15:57, 31 March 2017 by imported>Marostegui
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
  • Switchover date: Wednesday April 19th, 14:00 UTC
  • Switchback date: Wednesday May 3rd, 14:00 UTC

Tasks

ALTER TABLE watchlist ADD COLUMN wl_id int unsigned NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (wl_id);
ALTER TABLE tag_summary ADD COLUMN ts_id INT UNSIGNED NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (ts_id);
ALTER TABLE change_tag ADD COLUMN ct_id INT UNSIGNED NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (ct_id);
ALTER TABLE filearchive MODIFY COLUMN fa_minor_mime varbinary(100) default "unknown";
ALTER TABLE image MODIFY COLUMN img_minor_mime varbinary(100) NOT NULL default "unknown";
ALTER TABLE oldimage MODIFY COLUMN oi_minor_mime varbinary(100) NOT NULL default "unknown";


osc_host.sh --host=db1041 --port=3306 --db=metawiki --table=pagelinks --method=ddl --no-replicate "remove partitioning"
(several)