Set databases as read-only or switchover to secondary datacenter
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	jcrespo
	Jun 28 2016, 10:54 AM

Description

Blocker for several task related to maintenance:

Decomission old eqiad db masters
Apply long-running schema changes.

It requires either set shards in read only mode (it can be done 1 shard at a time, but it may be extended) or failover to a secondary datacenter and temporarily stop replication.

Related Objects
Search...

View Standalone Graph

This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Status	Assigned	Task
		· · ·
Resolved	None	T134476 Decommission old coredb machines (<=db1050)
Resolved	jcrespo	T69223 Schema change for page content language
Resolved	None	T155099 Database maintenance scheduled while eqiad datacenter is non primary (after the DC switchover)
Resolved	Marostegui	T147166 Apply change_tag and tag_summary primary key schema change to Wikimedia wikis
Resolved	Marostegui	T130067 Add wl_id to watchlist tables on production dbs
Resolved	Marostegui	T73563 *_minor_mime are varbinary(32) on WMF sites, out of sync with varbinary(100) in MW core
Resolved	jcrespo	T138810 Set databases as read-only or switchover to secondary datacenter
		· · ·

Event Timeline

jcrespo created this task.Jun 28 2016, 10:54 AM

Restricted Application added subscribers: Zppix, Aklapper. · View Herald TranscriptJun 28 2016, 10:54 AM

jcrespo added a parent task: T134476: Decommission old coredb machines (<=db1050).Jun 28 2016, 10:54 AM

jcrespo added a parent task: T130067: Add wl_id to watchlist tables on production dbs.

jcrespo added a parent task: T73563: *_minor_mime are varbinary(32) on WMF sites, out of sync with varbinary(100) in MW core.

jcrespo added a parent task: T69223: Schema change for page content language.Jun 28 2016, 10:57 AM

jcrespo renamed this task from Depool all eqiad hosts from mediawiki to Set databases as read-only or switchover to secondary datacenter.Jul 12 2016, 10:17 AM

jcrespo updated the task description. (Show Details)

jcrespo triaged this task as Medium priority.Jul 12 2016, 10:20 AM

jcrespo mentioned this in T69223: Schema change for page content language.Jul 28 2016, 10:40 AM

jcrespo mentioned this in T126641: [RFC] Devise plan for a cross-wiki watchlist back-end.Aug 3 2016, 6:31 AM

jcrespo mentioned this in T125990: Add a wl_id field to the watchlist table.Aug 31 2016, 6:57 PM

kaldari mentioned this in T130067: Add wl_id to watchlist tables on production dbs.Aug 31 2016, 7:14 PM

Addshore subscribed.Sep 11 2016, 4:53 PM

jcrespo added a parent task: T147166: Apply change_tag and tag_summary primary key schema change to Wikimedia wikis.Dec 14 2016, 4:40 PM

jcrespo mentioned this in T147166: Apply change_tag and tag_summary primary key schema change to Wikimedia wikis.Dec 14 2016, 4:44 PM

jcrespo added a parent task: T155099: Database maintenance scheduled while eqiad datacenter is non primary (after the DC switchover).Apr 12 2017, 5:47 PM

jcrespo closed this task as Resolved.Apr 21 2017, 8:38 AM

jcrespo claimed this task.