Active Tasks By Author

Author: aaron (Aaron Schulz)

Switch to All Tasks 21 Phabricator task(s).

Phabricator Link	Wiki Link	Status	Priority	Author	Assignee	Projects	Subtasks	Parent Tasks
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)
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)
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
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)
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
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
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
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)
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
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
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)
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')
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)
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)
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)