Active Tasks By Project

Project: DBA

Switch to All Tasks 22 Phabricator task(s).

Phabricator Link	Wiki Link	Status	Priority	Author	Assignee	Projects	Subtasks	Parent Tasks
T120242	T120242: Consistent MediaWiki state change events \| MediaWiki events as source of truth	open	Medium (orange)	Eevans (Eric Evans)		Event-Platform (Radar) DBA (Blocked) Platform Team Legacy (Later) Services (later) Analytics (Event Platform) Data-Engineering (Ingest) WMF-Architecture-Team (0 Pre-Initiative)	T215001: Revisions missing from mediawiki_revision_create	T201068: Modern Event Platform: Stream Intake Service
T129093	T129093: SHOW SLAVE STATUS as a health check should have a low timeout	open	Low (yellow)	jcrespo (Jaime Crespo)		Wikimedia-Rdbms (Rdbms: MySQL support) Performance-Team (Backlog: Maintenance) DBA (Blocked external/Not db team) EngProd-Virtual-Hackathon (Backlog)	T195792: Add support for setting individual query timeout in wikimedia/rdbms
T133523	T133523: Decide how to improve parsercache replication, sharding and HA	open	Medium (orange)	jcrespo (Jaime Crespo)	Marostegui (Manuel Aróstegui)	Performance-Team (Radar) (Perf recommendation) Sustainability (Incident Followup) SRE (Acknowledged) DBA (Meta/Epic) Epic	T210725: Replace parsercache keys to something more meaningful on db-XXXX.php	T277831: Evaluate WMF's ParserCache database setup for 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)
T152427	T152427: Create a check/calendar alert for MariaDB TLS certs	open	Medium (orange)	Marostegui (Manuel Aróstegui)		DBA (Backlog) observability (Radar)		T157702: Followup for TLS MariaDB server roll-out
T157702	T157702: Followup for TLS MariaDB server roll-out	open	Medium (orange)	jcrespo (Jaime Crespo)		observability (Radar) DBA (Backlog) Patch-For-Review	T183470: Setup newer machines and replace all old misc (m) and x1 codfw machines T183469: Setup newer machines and replace all old misc (m) and x1 eqiad machines T152427: Create a check/calendar alert for MariaDB TLS certs	T111654: Set up TLS for MariaDB replication
T164382	T164382: Evaluate the need for FORCE INDEX (ls_field_val) [now IGNORE INDEX (ls_log_id)], delete the index hint if not needed anymore	open	Low (yellow)	jcrespo (Jaime Crespo)		Sustainability (Incident Followup) Platform Engineering (Inbox) DBA (Backlog) MediaWiki-Logevents (Backlog)
T172497	T172497: Fix mediawiki heartbeat model, change pt-heartbeat model to not use super-user, avoid SPOF and switch automatically to the real master without puppet dependency	open	Medium (orange)	jcrespo (Jaime Crespo)		Platform Team Legacy (Watching / External) Sustainability (Incident Followup) Services (watching) Performance-Team (Radar) (Watching) Wikimedia-Rdbms (Rdbms library) DBA (Backlog)
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
T196378	T196378: Investigate solutions for MySQL connection pooling	open	Medium (orange)	jcrespo (Jaime Crespo)		Sustainability (MediaWiki-MultiDC) (Later) Performance-Team (Radar) (Watching) DBA (Backlog)		T134809: Apache mariadb SSL/TLS for cross-datacenter writes
T222224	T222224: RFC: Normalize MediaWiki link tables	open	Medium (orange)	Ladsgroup (Amir Sarabadani)		TechCom-RFC (P3: Explore) Schema-change (Unsorted) DBA (Blocked external/Not db team) MediaWiki-Page-derived-data Patch-For-Review Platform Engineering (Tracking/Watching)
T246069	T246069: Slow query on 10.4: SpecialRecentChanges::doMainQuery	open	Medium (orange)	Marostegui (Manuel Aróstegui)	Marostegui (Manuel Aróstegui)	DBA (Blocked) Upstream (Reported Upstream) mariadb-optimizer-bug (Currently not fixed)		T250666: Upgrade WMF database-and-backup-related hosts to buster
T249683	T249683: Redefine mysql GRANTs for wikiadmin	open	Medium (orange)	Marostegui (Manuel Aróstegui)		DBA (Ready) Sustainability (Incident Followup)		T157651: sql.php must not run LoadExtensionSchemaUpdates
T263127	T263127: Remove groups from db configs	open	Medium (orange)	Kormat (Stevie Beth Mhaol)	Marostegui (Manuel Aróstegui)	Platform Engineering Roadmap Decision Making (Code Jam) Performance-Team (Radar) (Watching) Platform Engineering Code Jam (Not Ready, later) DBA (In progress)	T267077: Document remaining database load groups
T270101	T270101: Grants not working with DB hosts with to ipv6	open	Medium (orange)	Marostegui (Manuel Aróstegui)		netbox (Discussion / Design / Consensus Making) DBA (Backlog) Infrastructure-Foundations (Backlog)
T272512	T272512: Apply outstanding schema changes for "objectcache" tables in production (exptime, flags, modtoken)	stalled	Medium (orange)	Ladsgroup (Amir Sarabadani)		Patch-For-Review Blocked-on-schema-change (Unclear/blocked to proceed) DBA (Blocked)	T298039: Migrate TwoColConflict usage of objectcache away from the table
T277831	T277831: Evaluate WMF's ParserCache database setup for Multi DC	open	Medium (orange)	Krinkle (Timo Tijhof)	Krinkle (Timo Tijhof)	Performance-Team (Backlog: Future Goals) DBA (Backlog)	T133523: Decide how to improve parsercache replication, sharding and HA	T270223: FY2021-2022: Enable basic Multi-DC operations for read traffic (tracking)
T291332	T291332: Alert when auto-increment fields on any MW-related databases reach a threshold	open	Medium (orange)	Krinkle (Timo Tijhof)		DBA (Ready) Sustainability (Incident Followup) Performance-Team (Radar) (Watching) Platform Engineering (Inbox)
T293530	T293530: Improve slow read query handling	open	Medium (orange)	Legoktm (Legoktm)		Platform Engineering (Inbox) SRE (Backlog) Sustainability (Incident Followup) DBA (Blocked)	T195792: Add support for setting individual query timeout in wikimedia/rdbms T293536: MediaWiki should support setting a read query time limit T293534: Reimplement HHVM-like slow query log T293532: Improve automatic query killer under high load T293533: Lower automatic query killing threshold to 55 seconds T293531: Monitor/dashboard number of queries killed by the automatic query killer T295706: Improve TransactionProfiler as replacement for tendril's slow queries T297708: Set max execution time for several expensive mediawiki actions
T293532	T293532: Improve automatic query killer under high load	open	Medium (orange)	Legoktm (Legoktm)		DBA (Refine) Sustainability (Incident Followup)		T293530: Improve slow read query handling
T298485	T298485: MW scripts should reload the database config	open	Medium (orange)	Marostegui (Manuel Aróstegui)	Ladsgroup (Amir Sarabadani)	MediaWiki-Maintenance-system (Backlog) DBA (Ready) User-Ladsgroup (Incoming) Performance-Team (Inbox)
T298687	T298687: Query caller comments /* Class::method */ not available in slow queries logstash dashboard	open	Medium (orange)	Lucas_Werkmeister_WMDE (Lucas Werkmeister (WMDE))	Ladsgroup (Amir Sarabadani)	Performance-Team (Backlog: Maintenance) Developer Productivity Wikimedia-Rdbms (Rdbms library) DBA (In progress) User-Ladsgroup (Incoming)