Tasks By Assignee

Assignee: jcrespo (Jaime Crespo)

Switch to Active Tasks 19 Phabricator task(s).

Phabricator Link	Wiki Link	Status	Priority	Author	Assignee	Projects	Subtasks	Parent Tasks
T111654	T111654: Set up TLS for MariaDB replication	resolved	Medium (orange)	faidon (Faidon Liambotis)	jcrespo (Jaime Crespo)	SRE (Backlog) Patch-For-Review DBA (Meta/Epic)	T152595: Implement TLS expiration/validation checking for MariaDB certificates T156005: Reimage db1065 and db1066 T152029: Rolling restart of parsercache servers for TLS certificate update T151995: Rolling restart of external storage servers for TLS certificate update T120122: Perform a rolling restart of all MySQL slaves (masters too for those services with low traffic) T157702: Followup for TLS MariaDB server roll-out T128077: Create a PKI that can be used by Puppet and for general purpose certificates T152188: Restart pending mysql hosts with old TLS cert	T134809: Apache mariadb SSL/TLS for cross-datacenter writes
T119642	T119642: Create a Master-master topology between datacenters for easier failover (setup circular replication dallas -> eqiad for mysql databases)	resolved	High (red)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	SRE (Backlog) codfw-rollout-Jan-Mar-2016 (In Progress) codfw-rollout (Backlog) DBA (In progress)		T88445: MediaWiki active/active datacenter investigation and work (tracking)
T120122	T120122: Perform a rolling restart of all MySQL slaves (masters too for those services with low traffic)	resolved	High (red)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	DBA (In progress) Patch-For-Review SRE (Backlog)	T120689: es1019 and its management interface are unresponsive	T111654: Set up TLS for MariaDB replication
T124795	T124795: codfw is in read only according to mediawiki	resolved	High (red)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	Patch-For-Review codfw-rollout (Backlog) SRE (Backlog) MediaWiki-Configuration (Backlog) Release-Engineering-Team (INBOX) codfw-rollout-Jan-Mar-2016 (In Progress) DBA (In progress)		T114273: Cleanup active-DC based MW config code and make it more robust and easy to change T88445: MediaWiki active/active datacenter investigation and work (tracking)
T133385	T133385: Implement GTID replication on MariaDB 10 servers	resolved	Medium (orange)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	Performance Issue SRE (Backlog) Wikimedia-Rdbms (Untriaged) DBA (Pending comment)		T135027: MASTER_POS_WAIT() alternative that works cross-DC
T151995	T151995: Rolling restart of external storage servers for TLS certificate update	resolved	High (red)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	DBA (In progress) Patch-For-Review SRE (Backlog)		T111654: Set up TLS for MariaDB replication
T152029	T152029: Rolling restart of parsercache servers for TLS certificate update	resolved	High (red)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	DBA (In progress) SRE (Backlog) Patch-For-Review		T111654: Set up TLS for MariaDB replication
T152188	T152188: Restart pending mysql hosts with old TLS cert	resolved	Low (yellow)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	DBA (Backlog) Patch-For-Review SRE (Backlog)	T152364: db1047 out of disk space, eventlogging_sync spam	T111654: Set up TLS for MariaDB replication
T153440	T153440: Create a full backup of all external storage records that would be easy to restore/setup a temporary delayed slave	resolved	High (red)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	Patch-For-Review DBA (In progress) SRE (Backlog)		T107610: Setup separate logical External Store for Flow in production
T156005	T156005: Reimage db1065 and db1066	resolved	High (red)	Marostegui (Manuel Aróstegui)	jcrespo (Jaime Crespo)	Patch-For-Review DBA (In progress) SRE (Backlog)		T111654: Set up TLS for MariaDB replication
T160984	T160984: Reduce max execution time of interactive queries or a better detection and killing of bad query patterns	resolved	High (red)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	DBA (In progress) Patch-For-Review Sustainability (Incident Followup) Performance Issue		T163495: Mediawiki revision-related queries are failing with high rate for enwiki on codfw
T162138	T162138: How many revision comments are exactly the same? Get some stats.	resolved	Medium (orange)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	DBA (Done)		T153333: RFC: How should we store longer revision comments?
T183469	T183469: Setup newer machines and replace all old misc (m*) and x1 eqiad machines	resolved	Medium (orange)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	DBA (In progress) Patch-For-Review SRE (Backlog)	T190262: Decommission db1001 T189773: Decommission db1020 T189656: Switchover m2 master from db1020 to db1051 T189655: Switchover m1 master from db1016 to db1063 T189005: Failover m5 master from db1009 to db1073 T187542: Decommission db1043 T184704: Setup tendril database monitoring on 2 new hosts, one on eqiad and one on codfw T184703: Decommission db1011 T184054: Decommission db1029 and db1031	T157702: Followup for TLS MariaDB server roll-out
T183470	T183470: Setup newer machines and replace all old misc (m*) and x1 codfw machines	resolved	Medium (orange)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	SRE (Backlog) DBA (Pending comment) Patch-For-Review	T187886: Decommission db2011 T187722: Replace db2030 from m5 with another host (WAS: Degraded RAID on db2030) T187543: Decommission db2012	T157702: Followup for TLS MariaDB server roll-out
T184704	T184704: Setup tendril database monitoring on 2 new hosts, one on eqiad and one on codfw	resolved	Medium (orange)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	DBA (In progress) Patch-For-Review		T183469: Setup newer machines and replace all old misc (m*) and x1 eqiad machines T184703: Decommission db1011
T189655	T189655: Switchover m1 master from db1016 to db1063	resolved	Medium (orange)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	Patch-For-Review SRE (Backlog) DBA (In progress)	T190179: Decommission db1016	T183469: Setup newer machines and replace all old misc (m*) and x1 eqiad machines
T189656	T189656: Switchover m2 master from db1020 to db1051	resolved	Medium (orange)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	Patch-For-Review SRE (Backlog) DBA (In progress)		T183469: Setup newer machines and replace all old misc (m*) and x1 eqiad machines T189773: Decommission db1020
T193919	T193919: provide proxysql for stretch, add package to puppet	resolved	High (red)	Dzahn (Daniel Zahn)	jcrespo (Jaime Crespo)	Patch-For-Review SRE (Backlog)		T192092: setup replacements for maintenance_server (terbium, wasat) on Stretch
T257928	T257928: Create a parallel OTRS database with a frozen snapshot of the production one	resolved	Medium (orange)	jcrespo (Jaime Crespo)	jcrespo (Jaime Crespo)	SRE (Backlog) serviceops (Incoming 🐫) Znuny (Incoming) DBA (In progress)		T257540: Upgrade m2 to Buster and Mariadb 10.4