Switch Datacenter/planned db maintenance

From Wikitech
Jump to navigation Jump to search

2018 Switch Datacenter

Important dates

  • Switchover date: Wednesday, September 12th 2018: 14:00 UTC
  • Switchback date: Wednesday, October 10th 2018: 14:00 UTC

Failover schedule

  • 5th Sept - LAST DB maintenance day in all DCs
  • 6th Sept - Enable replication codfw -> eqiad
  • 6th Sept - Review db-codfw.php. In particular make sure section distribution and loads are ok
  • 11th Sept - Definitive Warmup (pc, es, maybe some big tables on big wikis)
  • 12th Sept - 14:00 UTC Switchover to codfw support and monitoring
  • 4th Oct - LAST DB maintenance day on eqiad
  • 5th Oct - Review db-eqiad.php
  • 8th Oct - Enable eqiad -> codfw replication
  • 10th Oct - 14:00 UTC Switchover support and monitoring

Tasks

2017 Switch Datacenter

Important dates

  • Switchover date: Wednesday April 19th, 14:00 UTC
  • Switchback date: Wednesday May 3rd, 14:00 UTC

Failover schedule

  • 7th Apr - Warm up test for es
  • 12th Apr - LAST DB maintenance day in all DCs
  • 12th Apr - Review db-codfw.php
  • 18th Apr - Definitive Warmup
  • 19th -14:00 UTC Switchover to codfw support and monitoring
  • 28th Apr - Review db-eqiad.php
  • 28th Apr - LAST DB maintenance day on eqiad
  • 3rd May -14:00 UTC Switchover support and monitoring

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);
./osc_host.sh --host=db1052.eqiad.wmnet --port=3306 --db=enwiki --table=revision --method=ddl --no-replicate "drop key rev_id, drop primary key, add primary key (rev_id), add key rev_page_id (rev_page,rev_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)