Last modified: 2011-12-20 12:47:58 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T33170, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 31170 - centralauth needs a read-only db flag that allows queries to go to lagged slaves
centralauth needs a read-only db flag that allows queries to go to lagged slaves
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
CentralAuth (Other open bugs)
unspecified
All All
: High major with 3 votes (vote)
: ---
Assigned To: Sam Reed (reedy)
: platformeng
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-09-26 19:11 UTC by Asher Feldman
Modified: 2011-12-20 12:47 UTC (History)
6 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Asher Feldman 2011-09-26 19:11:55 UTC
There doesn't currently seem to be a way to set centralauth to read-only which results in a site outage when its master needs to be rotated.

When the cluster with centralauth is set to read-only (currently S7), it only applies to wikis also on that cluster.  Other wikis will still both want to write to centralauth, and also only send their queries to a caught up slave, which there won't be any of for a time during a master switch.  

Normally, when a cluster has $wgReadOnly = true, queries are sent to any slave and replication lag checking is disabled.  Setting centralauth to read-only needs this behavior as well.
Comment 1 Rob Lanphier 2011-09-26 19:44:14 UTC
Created new "platformeng" keyword, and adding that to this bug.  I'll have to coordinate with Tim as to who exactly fixes this bug, but it looks like one we need to address soon.
Comment 2 Sam Reed (reedy) 2011-12-20 12:25:50 UTC
r106784 adds $wgCentralAuthReadOnly

Just need to look at the lag checking code now
Comment 3 Sam Reed (reedy) 2011-12-20 12:47:58 UTC
Not sure there is a need for anything else

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links