Tasks By Author

Author: aaron (Aaron Schulz)

Switch to Active Tasks 102 Phabricator task(s).

Phabricator Link	Wiki Link	Status	Priority	Author	Assignee	Projects	Subtasks	Parent Tasks
T103429	T103429: Investigation: Parser save hook handler does master writes in GETs	resolved	High (red)	aaron (Aaron Schulz)	hoo (Marius Hoch)	Wikidata-Sprint-2015-06-30 (Done) Sustainability (Tag) Wikidata (ready to go) Performance Issue		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T105728	T105728: MySQL field aliases in select() should use quoting	resolved	Medium (orange)	aaron (Aaron Schulz)	Agabi10	Platform Engineering (Icebox) Wikimedia-Rdbms (Rdbms: MySQL support)
T108253	T108253: Make sure CentralAuth login tokens work with two datacenters	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Epic Patch-For-Review MediaWiki-extensions-CentralAuth (Done) Sustainability (Tag) WMF-deploy-2015-09-08_(1.26wmf22) (Backlog) WMF-deploy-2015-09-01_(1.26wmf21) (Backlog)	T111575: Make $wgSessionCacheType and $wgMainStash caches multi-DC ready	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T110399	T110399: WikiPageEntityMetaDataLookup querying DB master on HTTP GET	duplicate	Medium (orange)	aaron (Aaron Schulz)		Wikidata (monitoring) Sustainability (Tag)	T138376: Avoid falling back to master when loading page data in GET requests	T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T111266	T111266: Make LoadBalancer slave lag check and read-only mode more robust (for example, using pt-heartbeat)	resolved	High (red)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Blocked) MW-1.27-release-notes DBA (Done) Performance-Team (Blocked (old)) MW-1.27-release (WMF-deploy-2016-04-05_(1.27.0-wmf.20)) Patch-For-Review Performance Issue	T119648: Fix getLagFromPtHeartbeat() to use the pt entry for the root master, not the immediate one	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T111575	T111575: Make $wgSessionCacheType and $wgMainStash caches multi-DC ready	declined	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Performance-Team (Doing (old)) Sustainability (MediaWiki-MultiDC) (Later) Epic	T134811: Consider REST with SSL (HyperSwitch/Cassandra) for session storage	T108253: Make sure CentralAuth login tokens work with two datacenters T88445: MediaWiki active/active datacenter investigation and work (tracking)
T112708	T112708: Support for master/slave FileBackend distinction in FileBackendMultiwrite	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MW-1.27-release-notes MW-1.27-release (WMF-deploy-2015-10-06_(1.27.0-wmf.2)) (Tag) MW-1.26-release (Backlog) Patch-For-Review Sustainability (Blocked) WMF-deploy-2015-09-22_(1.26wmf24) (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T113192	T113192: Consider using delayed rebound purges for CDN	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Doing) MW-1.27-release-notes Patch-For-Review MW-1.27-release (WMF-deploy-2015-12-15_(1.27.0-wmf.9)) (Backlog)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T113204	T113204: Smart caching logic for handling cross-DC network outages	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MW-1.27-release (WMF-deploy-2015-10-06_(1.27.0-wmf.2)) (Tag) MW-1.27-release (WMF-deploy-2015-10-13_(1.27.0-wmf.3)) (Backlog) Patch-For-Review Performance-Team (Doing (old)) Sustainability (Doing) MW-1.27-release-notes		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T114271	T114271: Audit *all* datastores to see how DR failover is handled	open	Medium (orange)	aaron (Aaron Schulz)		Sustainability (MediaWiki-MultiDC) (Later) Performance-Team (Radar) (Watching) User-mobrovac (Backlog) Epic	T122387: Log multi-DB transaction in MediaWiki	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T114273	T114273: Cleanup active-DC based MW config code and make it more robust and easy to change	resolved	High (red)	aaron (Aaron Schulz)	Joe (Giuseppe Lavagetto)	SRE (Backlog) codfw-rollout-Jan-Mar-2016 (In Progress) Patch-For-Review Performance-Team (Backlog: Maintenance) codfw-rollout (Backlog) Epic Sustainability (Tag)	T124795: codfw is in read only according to mediawiki	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T114398	T114398: Make and document DC switch-over scripts	duplicate	Medium (orange)	aaron (Aaron Schulz)		Sustainability (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T116557	T116557: AFComputedVariable::compute query timeouts	resolved	High (red)	aaron (Aaron Schulz)	Krinkle (Timo Tijhof)	Performance-Team (Doing (old)) DBA (Backlog) Patch-For-Review AbuseFilter (Backlog) MW-1.29-release (WMF-deploy-2017-04-25_(1.29.0-wmf.21))		T163495: Mediawiki revision-related queries are failing with high rate for enwiki on codfw
T119641	T119641: Split-brain strategy for services that use config managed by etcd	open	Low (yellow)	aaron (Aaron Schulz)		Epic Sustainability (Tag) Performance-Team (Radar) (Watching)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T119648	T119648: Fix getLagFromPtHeartbeat() to use the pt entry for the root master, not the immediate one	resolved	Low (yellow)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Performance-Team (Doing (old)) Patch-For-Review Sustainability (Tag) MW-1.27-release (WMF-deploy-2016-01-12_(1.27.0-wmf.10)) (Backlog) Performance Issue DBA (Triage) MW-1.27-release-notes		T111266: Make LoadBalancer slave lag check and read-only mode more robust (for example, using pt-heartbeat)
T119651	T119651: Set $wmfSwiftCodfwConfig in PrivateSettings	resolved	Medium (orange)	aaron (Aaron Schulz)	fgiunchedi (Filippo Giunchedi)	SRE (Backlog) Sustainability (Tag)		T91869: Implement a replication strategy for Swift
T119689	T119689: Enable $wgCentralAuthUseSlaves to avoid master queries	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Performance Issue Sustainability (Tag) Patch-For-Review User-notice (Already announced/Archive)		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T120543	T120543: Investigate write mode flag cleanup for Flow API modules	resolved	Needs Triage (violet)	aaron (Aaron Schulz)	Catrope (Roan Kattouw)	Patch-For-Review MW-1.29-release (WMF-deploy-2017-01-03_(1.29.0-wmf.7)) StructuredDiscussions (Backlog) Collaboration-Team-Triage (Untriaged)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T121440	T121440: Dedicated post-edit cache busting cookie to prevent stale reads (session consistency)	resolved	Low (yellow)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Performance-Team (Doing (old))		T91820: Create HTTP verb and sticky cookie DC routing in VCL
T122387	T122387: Log multi-DB transaction in MediaWiki	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Performance-Team (Doing (old)) Sustainability (Tag) Patch-For-Review Epic MW-1.27-release-notes MW-1.27-release (WMF-deploy-2016-01-19_(1.27.0-wmf.11)) (Backlog)		T114271: Audit *all* datastores to see how DR failover is handled
T122708	T122708: ShortUrl must not write to master db on page views (DBPerformance warning)	open	Medium (orange)	aaron (Aaron Schulz)		Sustainability (MediaWiki-MultiDC) (Discuss next) Performance-Team (Radar) (Perf recommendation) MediaWiki-extensions-ShortUrl (Backlog)	T256993: Deploy read-only mode for ShortUrl	T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T125138	T125138: Create Kafka event relayer subclass able to handle WAN cache and CDN purges	resolved	Medium (orange)	aaron (Aaron Schulz)	Smalyshev (Stas Malyshev)	Patch-For-Review Sustainability (Tag) MW-1.27-release-notes MW-1.27-release (WMF-deploy-2016-04-26_(1.27.0-wmf.22)) Performance-Team (Backlog: Maintenance)		T250781: Move all purge traffic to kafka T97562: WANObjectCache relay daemon or mcrouter support
T130946	T130946: Make ?action=markpatrolled require POST	resolved	Low (yellow)	aaron (Aaron Schulz)	Krinkle (Timo Tijhof)	MediaWiki-Patrolling (Backlog) MW-1.29-release (WMF-deploy-2016-11-08_(1.29.0-wmf.2)) MW-1.29-release-notes Patch-For-Review Sustainability (MediaWiki-MultiDC) (Later) Performance-Team (Doing (old))		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T133422	T133422: DB master queries for entities on parse	duplicate	Medium (orange)	aaron (Aaron Schulz)		Wikidata (ready to go) Sustainability (Tag)		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T134608	T134608: CentralAuth uses master on POST requests for API/specialpages that return false for doesWrites()	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MW-1.27-release-notes MW-1.28-release (WMF-deploy-2016-05-17_(1.28.0-wmf.2)) Patch-For-Review Sustainability (Tag) MW-1.28-release-notes		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T134809	T134809: Apache <=> mariadb SSL/TLS for cross-datacenter writes	stalled	Medium (orange)	aaron (Aaron Schulz)		Performance-Team (Radar) (Watching) DBA (Meta/Epic) Sustainability (MediaWiki-MultiDC) (Discuss next) SRE (Acknowledged)	T196378: Investigate solutions for MySQL connection pooling T171071: Perform testing for TLS effect on connection rate T136218: Audit mysql database class and hhvm binding support of SSL T111654: Set up TLS for MariaDB replication	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T134811	T134811: Consider REST with SSL (HyperSwitch/Cassandra) for session storage	resolved	Low (yellow)	aaron (Aaron Schulz)	mobrovac (Marko Obrovac)	SRE (Acknowledged) Services (designing) Performance-Team (Radar) (Watching) Platform Team Workboards (Done with CPT) Sustainability (MediaWiki-MultiDC) (Discuss next)	T137272: Create BagOStuff subclass for HTTP	T111575: Make $wgSessionCacheType and $wgMainStash caches multi-DC ready T88445: MediaWiki active/active datacenter investigation and work (tracking)
T134841	T134841: MessageGroupStats::queueUpdates trigger on page views	resolved	Medium (orange)	aaron (Aaron Schulz)	Nikerabbit (Niklas Laxström)	MediaWiki-extensions-Translate (maintenance and operational issues) Sustainability (Tag) Language-Team (Language-2018-October-December) (Done)		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T134842	T134842: SpecialCentralAutoLogin calls User::saveSettings() on HTTP GET presend	open	Medium (orange)	aaron (Aaron Schulz)		Sustainability (Tag) MediaWiki-extensions-CentralAuth (Incoming) MediaWiki-Authentication-and-authorization (Backlog)		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T135027	T135027: MASTER_POS_WAIT() alternative that works cross-DC	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Epic MW-1.28-release-notes Patch-For-Review Sustainability (Tag) MW-1.28-release (WMF-deploy-2016-07-19_(1.28.0-wmf.11)) DBA (Triage) Performance-Team (Doing (old))	T138778: Upgrade mariadb in deployment-prep from Precise/MariaDB 5.5 to Jessie/MariaDB 5.10 T133385: Implement GTID replication on MariaDB 10 servers	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T135170	T135170: Require POST in ?action=purge	resolved	Needs Triage (violet)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-API (Needs details or plan) Community-Relations-Support (Team radar) MW-1.28-release-notes Performance Issue MW-1.28-release (WMF-deploy-2016-08-16_(1.28.0-wmf.15)) Patch-For-Review	T215131: The "right-purge" message needs to be updated since it always require confirmation T144524: problem with Purge function T143435: Purge asks for "Clear the cache of this page" for logged in users with the "purge" right	T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T136218	T136218: Audit mysql database class and hhvm binding support of SSL	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review Performance-Team (Doing (old)) Sustainability (Tag) SRE (Backlog) MW-1.28-release-notes MW-1.28-release (WMF-deploy-2016-08-30_(1.28.0-wmf.17))		T134809: Apache mariadb SSL/TLS for cross-datacenter writes
T136224	T136224: OATHAuth doing DB master queries on HTTP GET	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review Sustainability (Tag) MW-1.28-release (WMF-deploy-2016-06-07_(1.28.0-wmf.5)) MediaWiki-extensions-OATHAuth (Backlog)		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T137272	T137272: Create BagOStuff subclass for HTTP	resolved	Medium (orange)	aaron (Aaron Schulz)	Smalyshev (Stas Malyshev)	Services (Backlog) SRE (Backlog) Sustainability (Tag) Patch-For-Review MW-1.28-release-notes Performance-Team (Radar) MW-1.28-release (WMF-deploy-2016-07-12_(1.28.0-wmf.10))		T134811: Consider REST with SSL (HyperSwitch/Cassandra) for session storage T140813: Protect sensitive user-related information with a UserData / auth / session service
T137326	T137326: Log post-send DB updates and make sure their frequency is acceptable	resolved	High (red)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MW-1.28-release (WMF-deploy-2016-06-14_(1.28.0-wmf.6)) MW-1.28-release-notes MW-1.28-release (WMF-deploy-2016-06-21_(1.28.0-wmf.7)) Patch-For-Review Performance-Team (Doing (old)) Sustainability (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T138778	T138778: Upgrade mariadb in deployment-prep from Precise/MariaDB 5.5 to Jessie/MariaDB 5.10	resolved	Medium (orange)	aaron (Aaron Schulz)	dduvall (Dan Duvall)	WorkType-Maintenance Release-Engineering-Team (In-progress) Beta-Cluster-Infrastructure (Backlog) DBA (Triage) Patch-For-Review	T147110: Delete deployment-db1 and deployment-db2	T135027: MASTER_POS_WAIT() alternative that works cross-DC
T150506	T150506: Avoid lazyImportLocalNames() master writes on GET requests (Run a script to backfill them once for all)	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (MediaWiki-MultiDC) (Discuss next) MW-1.36-notes (1.36.0-wmf.36; 2021-03-23) MediaWiki-extensions-CentralAuth (Incoming) User-Majavah (Done) Patch-For-Review Performance-Team (Radar) (Watching) MW-1.37-notes (1.37.0-wmf.4; 2021-05-04) Platform Team Workboards (Clinic Duty Team) (Waiting for Review)		T154552: ApiLogin should not open master connection to centralauth DB
T151466	T151466: Performance Q2 2017/18 goal: Install and use mcrouter in deployment-prep	resolved	Low (yellow)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Release-Engineering-Team (Watching / External) Beta-Cluster-Infrastructure (Backlog) Performance-Team (Doing (old)) Sustainability (MediaWiki-MultiDC) (Later)	T190979: build new version of mcrouter package T175418: Create new instances memc05 and memc06 running memcached	T175213: 2017/18 Annual Plan Program 8: Multi-datacenter support, Q2 goals
T154596	T154596: SpecialModifyEntity master queries on page views	duplicate	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-General Wikidata (incoming) Sustainability (MediaWiki-MultiDC) (Later)		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T171071	T171071: Perform testing for TLS effect on connection rate	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (MediaWiki-MultiDC) (Discuss next) SRE (Backlog) Performance-Team (Doing (old)) DBA (Blocked external/Not db team) Patch-For-Review	T175672: Make apache/maintenance hosts TLS connections to mariadb work	T134809: Apache mariadb SSL/TLS for cross-datacenter writes
T175418	T175418: Create new instances memc05 and memc06 running memcached	resolved	Low (yellow)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Beta-Cluster-Infrastructure (To Triage) Release-Engineering-Team (Watching / External) Sustainability (MediaWiki-MultiDC) (Later)		T151466: Performance Q2 2017/18 goal: Install and use mcrouter in deployment-prep
T175672	T175672: Make apache/maintenance hosts TLS connections to mariadb work	open	Medium (orange)	aaron (Aaron Schulz)		DBA (Backlog) Sustainability (MediaWiki-MultiDC) (Discuss next) Performance-Team (Radar) (Watching) Services (watching)		T171071: Perform testing for TLS effect on connection rate
T188801	T188801: Migrate wl_notificationtimestamp updates to the job queue	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-Watchlist (Backlog) Patch-For-Review Growth-Team (Inbox) MW-1.33-notes (1.33.0-wmf.22; 2019-03-19) Sustainability (MediaWiki-MultiDC) (Current: Performance Team)		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T193565	T193565: Foreign query for metawiki fails with "Table 'centralauth.page' doesn't exist" (DBConnRef mixup?)	open	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Incident Followup) Wikimedia-Rdbms (Rdbms library) Patch-For-Review Performance-Team (Doing: Prio Interrupt) Wikimedia-production-error (Older)	T269326: Create RequestTimeout library
T194225	T194225: Enable mcrouter on the memcached servers themselves	duplicate	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review Performance-Team (Doing (old))		T97562: WANObjectCache relay daemon or mcrouter support
T219592	T219592: Frequent Echo DB_MASTER write queries on HTTP GET	open	Medium (orange)	aaron (Aaron Schulz)	kostajh (Kosta Harlan)	Patch-For-Review Services (watching) Sustainability (MediaWiki-MultiDC) (Later) Performance-Team (Radar) (Perf recommendation) Notifications (Backlog) Growth-Team (Current Sprint) (Code Review)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T226785	T226785: Phase out use of vary-revision with more specific flags and improve related logging	resolved	High (red)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MW-1.34-notes (1.34.0-wmf.20; 2019-08-27) MediaWiki-Parser (Backlog) Performance-Team (Blocked (old)) Platform Team Workboards (Clinic Duty Team) (External Code Review Completed)
T227376	T227376: Move callers away from getMainObjectStash() that do not need it	open	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (MediaWiki-MultiDC) (Later) Platform Team Workboards (External Code Reviews) (External Code Review Needed) Patch-For-Review WMF-General-or-Unknown Performance-Team (Backlog: Maintenance)	T236414: CPT review/work for MediaWiki caching class maintenance ramp-up
T229062	T229062: Look into a simple way to have global keys with db-replicated	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-Cache (libs/objectcache) MW-1.35-notes (1.35.0-wmf.34; 2020-05-26) Performance-Team (Blocked (old))		T212129: Move MainStash out of Redis to a simpler multi-dc aware solution
T229694	T229694: Warning: EchoModerationController::moderate: transaction round 'MWCallableUpdate::doUpdate' still running	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Performance-Team (Blocked (old)) MediaWiki-General MW-1.34-notes (1.34.0-wmf.20; 2019-08-27) Platform Team Workboards (Clinic Duty Team) (External Code Review Completed) Regression
T232128	T232128: Make MultiHttpClient use CURLMOPT_MAX_HOST_CONNECTIONS and reuse connections	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Performance-Team (Radar) (Perf recommendation) MW-1.35-notes (1.35.0-wmf.1; 2019-10-08) MediaWiki-libs-HTTP Platform Team Workboards (Clinic Duty Team) (External Code Review Completed)	T192166: Drop HHVM support from MediaWiki
T235705	T235705: Add BagOStuff metrics for read/write operations (bytes, key "class") grouped by type/ID	resolved	High (red)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MW-1.36-notes (1.36.0-wmf.28; 2021-01-26) MediaWiki-Cache (libs/objectcache) Performance-Team (Doing (old))
T236412	T236412: Refactor BagOStuff to use a more storage/multi-DC aware interface hierarchy	open	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MW-1.35-notes (1.35.0-wmf.23; 2020-03-10) Performance-Team (Backlog: Future Goals) MediaWiki-Cache (libs/objectcache) Platform Engineering Roadmap Decision Making (Icebox) Patch-For-Review
T236414	T236414: CPT review/work for MediaWiki caching class maintenance ramp-up	open	Medium (orange)	aaron (Aaron Schulz)		Platform Team Workboards (External Code Reviews) (External Code Review Needed) Sustainability (MediaWiki-MultiDC) (Current: Platform Team) Performance-Team (Radar) (Watching)		T227376: Move callers away from getMainObjectStash() that do not need it
T253697	T253697: Support hash-based deduplication in KeyValueDependencyStore	declined	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-ResourceLoader (Accepted Enhancement) Performance-Team (Doing (old))		T113916: Switch ResourceLoader file dependency tracking to MultiDC-friendly backend
T265386	T265386: Rewrite LoadMonitor to better handle cache regeneration and improve separation of concern	open	Lowest (sky)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Wikimedia-Rdbms (Rdbms library) Performance-Team (Backlog: Maintenance) Patch-For-Review
T269161	T269161: Disallow direct "BEGIN"/"COMMIT"/"ROLLBACK" via Database::query()	open	Lowest (sky)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Platform Engineering (Tracking/Watching) Wikimedia-Rdbms (Rdbms library) Performance-Team (Backlog: Maintenance)
T274174	T274174: Add modtoken field and flags to objectcache table	resolved	High (red)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review Performance-Team (Doing: Goal-oriented) MediaWiki-Cache (libs/objectcache) MW-1.37-notes (1.37.0-wmf.15; 2021-07-19)	T288998: Significant ParserCache space increase after 2021-08-12 (1.37.0-wmf.18 regression)	T212129: Move MainStash out of Redis to a simpler multi-dc aware solution
T278392	T278392: Storage solution for cross-datacenter tokens	open	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review MediaWiki-extensions-OAuth (Backlog) Performance-Team (Next: Goal / Oct-Dec '21) MediaWiki-extensions-CentralAuth (Incoming) ConfirmEdit (CAPTCHA extension) (Backlog) Sustainability (MediaWiki-MultiDC) (Later)		T267270: Determine multi-dc strategy for CentralAuth
T283029	T283029: FlaggableWikiPage::preloadPreparedEdit() does not actually carry over the parser output, leading to double parses on save	open	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-Page-derived-data Platform Engineering (Tracking/Watching) MediaWiki-extensions-FlaggedRevs (Backlog) Performance-Team (Backlog: Maintenance)
T294969	T294969: Deprecate and remove Database::lockTables and Database::unlockTables	open	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Wikimedia-Rdbms (Rdbms library) Performance-Team (Backlog: Maintenance) MW-1.38-notes (1.38.0-wmf.17; 2022-01-10) Patch-For-Review
T297424	T297424: Reduce LBFactory::rollbackPrimaryChanges() callers in core	open	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Wikimedia-Rdbms (Wiring for MediaWiki) Performance-Team (Doing: Prio Interrupt) Platform Engineering (Inbox) Patch-For-Review		T281451: Wikimedia\Rdbms\DBTransactionError: Transaction round stage must be 'cursory' (not 'within-rollback-callbacks')
T70530	T70530: Many INSERT queries on some web requests	duplicate	Medium (orange)	aaron (Aaron Schulz)		MediaWiki-extensions-Translate (maintenance and operational issues)		T95753: Translate extensions uses the master a lot on page views
T88044	T88044: Make rollback use POST instead of GET (use AJAX in GUI)	stalled	High (red)	aaron (Aaron Schulz)		User-notice (Already announced/Archive) MediaWiki-Page-history (Backlog) MediaWiki-Page-diffs (Backlog) Performance-Team (Radar) (Watching)	T72059: Update mediawiki.api for new API token handling
T88445	T88445: MediaWiki active/active datacenter investigation and work (tracking)	open	Medium (orange)	aaron (Aaron Schulz)		User-mobrovac (Backlog) Platform Team Workboards (Initiatives) (Later) Sustainability (MediaWiki-MultiDC) (Later) Platform Team Initiatives (Multi-DC (TEC1)) Performance-Team (Radar) (Watching) Epic	T219592: Frequent Echo DB_MASTER write queries on HTTP GET T212129: Move MainStash out of Redis to a simpler multi-dc aware solution T221159: FY18/19 TEC1.6 Q4: Improve or replace the usage of GTID_WAIT with pt-heartbeat in MW T206016: Create a service for session storage T114271: Audit *all* datastores to see how DR failover is handled T164860: Update Echo's caching strategy for multi-dc compatibility T120543: Investigate write mode flag cleanup for Flow API modules T92863: Configure 'enqueue' job queue type to be DC-local and in a dedicated runner loop T89389: Try to avoid doCascadeProtectionUpdates() call on page view T88506: Make FileRepo file cache misses use slaves instead of the master T137326: Log post-send DB updates and make sure their frequency is acceptable T124795: codfw is in read only according to mediawiki T120009: Flow: Use WAN cache delete() and slave populations to avoid merge() T119642: Create a Master-master topology between datacenters for easier failover (setup circular replication dallas -> eqiad for mysql databases) T114273: Cleanup active-DC based MW config code and make it more robust and easy to change T111266: Make LoadBalancer slave lag check and read-only mode more robust (for example, using pt-heartbeat) T94028: DB master connections requested by Flow on GET/HEAD requests T91869: Implement a replication strategy for Swift T220170: Address Database hardware infrastructure blockers on datacenter switchover & multi-dc deployment T204245: Run MediaWiki media originals active/active T135027: MASTER_POS_WAIT() alternative that works cross-DC T134809: Apache mariadb SSL/TLS for cross-datacenter writes T127455: Enable HTTPS for Swift traffic T114398: Make and document DC switch-over scripts T113204: Smart caching logic for handling cross-DC network outages T113192: Consider using delayed rebound purges for CDN T112708: Support for master/slave FileBackend distinction in FileBackendMultiwrite T111575: Make $wgSessionCacheType and $wgMainStash caches multi-DC ready T134811: Consider REST with SSL (HyperSwitch/Cassandra) for session storage T108253: Make sure CentralAuth login tokens work with two datacenters T99208: Make sure $wgUseLocalMessageCache works with multiple DCs T97686: Keep TorExitNodes node list cache populated in *both* datacenters T97620: Convert various core/extension cache users to ReplicatedBagOStuff T97562: WANObjectCache relay daemon or mcrouter support T97335: Make CachingSiteStore use WANObjectCache T95126: Make RedisBagOStuff support tag name hashing T94480: Audit and fix extensions that call saveSettings() to lazy-set preferences when loaded T94448: Echo doing master queries on simple GET requests T93144: Check multi-datacenter compatibility with GettingStarted's use of Redis T93141: Convert various core/extension cache users to the WAN cache as needed T93006: Figure out a cross-DC strategy for the BloomFilter caches T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc T92007: Investigate a better alternative for making user_newtalk talk updates T91870: Figure out a replication strategy for ElasticSearch T91837: Consider moving various DB writes on page views to using local jobs T91820: Create HTTP verb and sticky cookie DC routing in VCL T91816: Add code to enable setting sticky DC cookies for POST requests T91819: Use local jobqueue class for jobs enqueued on pages views T91815: Audit cache usage to see what can be DC-local and what needs cross-DC purges T91284: Avoid wl_notificationtimestamp updates on page views T91279: Augment user_touched with an in-memory field T89308: Create a local job class that enqueues jobs to final location T89184: Remove cache anti-dependencies T88666: RFC: Master/slave datacenter strategy for MediaWiki T88635: ObjectCacheSessionHandler should avoid pointless writes in write() T88634: Make a ReplicatedBagOStuff class for multi-DC use T88493: Devise stashing strategy for multi-DC mediawiki T88492: Devise caching (memcached) strategy for multi-DC mediawiki T130946: Make ?action=markpatrolled require POST T119641: Split-brain strategy for services that use config managed by etcd T270223: FY2021-2022: Enable basic Multi-DC operations for read traffic (tracking)
T88492	T88492: Devise caching (memcached) strategy for multi-DC mediawiki	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-Cache (Untriaged) Performance-Team (Backlog: Maintenance) Sustainability (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T88493	T88493: Devise stashing strategy for multi-DC mediawiki	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	WMF-deploy-2015-07-21_(1.26wmf15) (Backlog) WMF-deploy-2015-06-30_(1.26wmf12) MW-1.26-release (Backlog) WMF-deploy-2015-08-11_(1.26wmf18) (Backlog) Patch-For-Review Sustainability (Doing) MediaWiki-Core-Team		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T88506	T88506: Make FileRepo file cache misses use slaves instead of the master	resolved	Needs Triage (violet)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review MediaWiki-Core-Team		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T88634	T88634: Make a ReplicatedBagOStuff class for multi-DC use	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-Core-Team Patch-For-Review		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T88635	T88635: ObjectCacheSessionHandler should avoid pointless writes in write()	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review MediaWiki-Core-Team		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T88666	T88666: RFC: Master/slave datacenter strategy for MediaWiki	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (MediaWiki-MultiDC) (Later) Performance-Team (Inbox) TechCom-RFC (TechCom-RFC-Closed) (Implemented)	T111877: incorporate master/slave datacenter guidelines into developer docs	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T89184	T89184: Remove cache anti-dependencies	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review MediaWiki-Core-Team		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T89308	T89308: Create a local job class that enqueues jobs to final location	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review MediaWiki-Core-Team		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T89389	T89389: Try to avoid doCascadeProtectionUpdates() call on page view	resolved	Needs Triage (violet)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-Core-Team		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T91279	T91279: Augment user_touched with an in-memory field	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-Core-Team MediaWiki-General		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T91284	T91284: Avoid wl_notificationtimestamp updates on page views	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Blocked) MediaWiki-Watchlist (Backlog) WMF-deploy-2015-07-21_(1.26wmf15) (Backlog) Patch-For-Review MW-1.26-release (Backlog)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T91815	T91815: Audit cache usage to see what can be DC-local and what needs cross-DC purges	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Doing) Patch-For-Review	T97335: Make CachingSiteStore use WANObjectCache	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T91816	T91816: Add code to enable setting sticky DC cookies for POST requests	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-General MW-1.27-release (WMF-deploy-2015-10-06_(1.27.0-wmf.2)) (Tag) Sustainability (Tag) MW-1.27-release-notes Patch-For-Review Performance-Team (Inbox)		T88445: MediaWiki active/active datacenter investigation and work (tracking) T91820: Create HTTP verb and sticky cookie DC routing in VCL
T91819	T91819: Use local jobqueue class for jobs enqueued on pages views	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MediaWiki-Core-JobQueue Sustainability (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T91820	T91820: Create HTTP verb and sticky cookie DC routing in VCL	open	Medium (orange)	aaron (Aaron Schulz)		Sustainability (MediaWiki-MultiDC) (Discuss next) Traffic-Icebox (Backlog) SRE (Acknowledged) Performance-Team (Radar) (Watching)	T91816: Add code to enable setting sticky DC cookies for POST requests T121440: Dedicated post-edit cache busting cookie to prevent stale reads (session consistency)	T270223: FY2021-2022: Enable basic Multi-DC operations for read traffic (tracking) T88445: MediaWiki active/active datacenter investigation and work (tracking)
T91837	T91837: Consider moving various DB writes on page views to using local jobs	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T91869	T91869: Implement a replication strategy for Swift	resolved	High (red)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	SRE (Backlog) MW-1.27-release (WMF-deploy-2016-03-08_(1.27.0-wmf.16)) Patch-For-Review codfw-rollout-Jan-Mar-2016 (Backlog) MW-1.27-release-notes codfw-rollout (Backlog) Sustainability (Tag) MW-1.27-release (WMF-deploy-2016-03-15_(1.27.0-wmf.17))	T125791: swiftrepl replication pass for thumbnails eqiad -> codfw T119651: Set $wmfSwiftCodfwConfig in PrivateSettings	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T91870	T91870: Figure out a replication strategy for ElasticSearch	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T92007	T92007: Investigate a better alternative for making user_newtalk talk updates	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review MW-1.26-release (Backlog) WMF-deploy-2015-07-21_(1.26wmf15) (Backlog) Sustainability (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T92357	T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc	open	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (MediaWiki-MultiDC) (Later) Performance-Team (Backlog: Maintenance) MediaWiki-General	T216287: BannerMessageGroup::registerGroupHook of CentralNotice must not query master on GET request (page views) T154795: CheckUser opens DB master connection when email is sent T154719: PageTriage opens master connection on GET for ArticleMetadata cache misses T154556: Babel autocreates category and system user on GET T154554: AbuseFilter "Examine past edits" feature opens master conn on GET in certain cases involving Scribunto T135170: Require POST in ?action=purge T129973: Dig through logs from 15 Mar 2016 read-only test and file bugs T103429: Investigation: Parser save hook handler does master writes in GETs T95753: Translate extensions uses the master a lot on page views T188801: Migrate wl_notificationtimestamp updates to the job queue T179760: File metadata gets refreshed when accessing the file description page T154596: SpecialModifyEntity master queries on page views T154555: Special:SetSiteLink, other SpecialModifyEntity subclasses open master connection on GET T136224: OATHAuth doing DB master queries on HTTP GET T134842: SpecialCentralAutoLogin calls User::saveSettings() on HTTP GET presend T134841: MessageGroupStats::queueUpdates trigger on page views T134608: CentralAuth uses master on POST requests for API/specialpages that return false for doesWrites() T133422: DB master queries for entities on parse T122708: ShortUrl must not write to master db on page views (DBPerformance warning) T119689: Enable $wgCentralAuthUseSlaves to avoid master queries T110399: WikiPageEntityMetaDataLookup querying DB master on HTTP GET T95232: High frequency of master queries on GET requests due to Flow T95156: Wikidata needlessly queries master DB to populate deprecated wbUserIsBlocked JS variable T94030: Avoid opening master db connection on special pages (e.g. Special:NewItem) when not needed T151903: Special:Search performs DB writes on GET request	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T92863	T92863: Configure 'enqueue' job queue type to be DC-local and in a dedicated runner loop	declined	Needs Triage (violet)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T93006	T93006: Figure out a cross-DC strategy for the BloomFilter caches	declined	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review MediaWiki-Core-Team		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T93141	T93141: Convert various core/extension cache users to the WAN cache as needed	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Epic WMF-deploy-2015-08-04_(1.26wmf17) (Backlog) Patch-For-Review Sustainability (Blocked)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T94028	T94028: DB master connections requested by Flow on GET/HEAD requests	resolved	High (red)	aaron (Aaron Schulz)	matthiasmullie (Matthias Mullie)	Collaboration-Team-Archive-2015-2016 (Product Review) Collaboration-Team-Triage (Untriaged) Sustainability (Tag) StructuredDiscussions (Backlog) MW-1.27-release (WMF-deploy-2015-11-03_(1.27.0-wmf.5)) (Backlog) Patch-For-Review	T101887: Flow issues write queries on GET (read) requests	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T94029	T94029: Spike: Avoid use of merge() in Flow caches	resolved	High (red)	aaron (Aaron Schulz)	matthiasmullie (Matthias Mullie)	Collaboration-Team-Triage (Freezer) Collaboration-Team-Archive-2015-2016 (Blocked) StructuredDiscussions (Backlog) Patch-For-Review Sustainability (Tag)		T120009: Flow: Use WAN cache delete() and slave populations to avoid merge()
T94030	T94030: Avoid opening master db connection on special pages (e.g. Special:NewItem) when not needed	resolved	Medium (orange)	aaron (Aaron Schulz)	aude	Wikidata-Sprint-2015-04-07 (Done) Patch-For-Review MediaWiki-extensions-WikibaseRepository (Backlog) Wikidata (ready to go) Sustainability (Tag)		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T94448	T94448: Echo doing master queries on simple GET requests	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Notifications (Needs code) Sustainability (Tag) Patch-For-Review Collaboration-Team-Triage (Untriaged)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T94480	T94480: Audit and fix extensions that call saveSettings() to lazy-set preferences when loaded	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Epic Patch-For-Review Sustainability (Tag) ContentTranslation (Needs Triage)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T95126	T95126: Make RedisBagOStuff support tag name hashing	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Tag) Patch-For-Review		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T95232	T95232: High frequency of master queries on GET requests due to Flow	duplicate	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Tag) Collaboration-Team-Triage (Resolved) StructuredDiscussions (Backlog)		T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T95753	T95753: Translate extensions uses the master a lot on page views	resolved	High (red)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	MW-1.27-release (WMF-deploy-2016-04-26_(1.27.0-wmf.22)) MW-1.27-release (WMF-deploy-2016-05-03_(1.27.0-wmf.23)) Sustainability (Tag) MW-1.27-release (WMF-deploy-2016-04-05_(1.27.0-wmf.20)) MediaWiki-extensions-Translate (maintenance and operational issues) MW-1.27-release (WMF-deploy-2016-03-22_(1.27.0-wmf.18)) MW-1.27-release (WMF-deploy-2016-04-12_(1.27.0-wmf.21)) Language-Engineering April-June 2016 (Translate)	T70530: Many INSERT queries on some web requests	T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc
T96113	T96113: Set up dedicated local-dc runners for 'enqueue' router jobs	invalid	Needs Triage (violet)	aaron (Aaron Schulz)		Sustainability (MediaWiki-MultiDC) (Later) WMF-JobQueue (Untriaged) Platform Engineering (Inbox)
T97335	T97335: Make CachingSiteStore use WANObjectCache	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Patch-For-Review Sustainability (Tag)		T88445: MediaWiki active/active datacenter investigation and work (tracking) T91815: Audit cache usage to see what can be DC-local and what needs cross-DC purges
T97562	T97562: WANObjectCache relay daemon or mcrouter support	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Wikimedia-Rdbms (Untriaged) Services (watching) Sustainability (MediaWiki-MultiDC) (Later) Performance-Team (Inbox)	T123954: Investigate proper set up for using Kafka MirrorMaker with new main Kafka clusters. T194225: Enable mcrouter on the memcached servers themselves T134554: Create a plugin for recent-changes daemon to be able to process purge events for memcache T134535: Create a class to make EventRelayer to send events to EventBus endpoint T125138: Create Kafka event relayer subclass able to handle WAN cache and CDN purges	T88445: MediaWiki active/active datacenter investigation and work (tracking)
T97620	T97620: Convert various core/extension cache users to ReplicatedBagOStuff	resolved	Medium (orange)	aaron (Aaron Schulz)	aaron (Aaron Schulz)	Sustainability (Doing) WMF-deploy-2015-09-01_(1.26wmf21) (Backlog) WMF-deploy-2015-07-14_(1.26wmf14) (Backlog) WMF-deploy-2015-08-11_(1.26wmf18) (Backlog) Patch-For-Review WMF-deploy-2015-08-18_(1.26wmf19) (Backlog) WMF-deploy-2015-08-25_(1.26wmf20) (Backlog) WMF-deploy-2015-07-21_(1.26wmf15) (Backlog)		T88445: MediaWiki active/active datacenter investigation and work (tracking)

... further results