[08:19:56] 10DBA, 10Data-Services: Provide a new s8 master for sanitarium - https://phabricator.wikimedia.org/T177274#3799039 (10Marostegui) The master will be db1087 which is already running ROW [09:29:13] 10DBA, 10monitoring, 10Epic, 10Patch-For-Review, 10Wikimedia-Incident: Reduce false positives on database pages - https://phabricator.wikimedia.org/T177782#3799107 (10jcrespo) [09:42:20] 10DBA, 10MediaWiki-Database, 10Tracking: Database replication lag issues (tracking) - https://phabricator.wikimedia.org/T3268#54368 (10Marostegui) Is there any point on keeping this open? It says tracking but the task is totally empty and has not been used much. [09:43:17] it is not really empty [09:44:50] fair [09:47:05] 10DBA, 10Operations, 10ops-eqiad: db1016 m1 master: Possibly faulty BBU - https://phabricator.wikimedia.org/T166344#3799118 (10Marostegui) We can probably clone db1056 from db1001. [10:11:22] I am rolling restarting db1095 and db1102. do you want to apply any changes there? is there any schema change ongoing? [10:15:10] no, you are good to go! [10:16:16] I will use db1044 for stopping slave there [10:16:40] so I "block" any maintenance there for the time [10:17:09] yeah, no worries [10:17:11] nothing going on on db1044 [10:36:06] 10DBA, 10Patch-For-Review: Support multi-instance on core hosts - https://phabricator.wikimedia.org/T178359#3799169 (10Marostegui) [10:40:48] 10DBA, 10Operations, 10Phabricator, 10hardware-requests, 10ops-eqiad: Decommission db1048 (was Move m3 slave to db1059) - https://phabricator.wikimedia.org/T175679#3799171 (10Marostegui) [10:51:07] 10DBA, 10Data-Services, 10Patch-For-Review: `pr_index`to be replicated to Labs public databases - https://phabricator.wikimedia.org/T113842#3799174 (10jcrespo) This is now done- we may need a rolling restart of sanitarium hosts, but the chance of a new proofread extension on a non-s3 wiki happening before th... [13:56:03] 10DBA, 10Data-Services, 10Patch-For-Review: `pr_index` to be replicated to Labs public databases - https://phabricator.wikimedia.org/T113842#3799750 (10Reedy) [14:22:32] 10DBA, 10Analytics-Kanban, 10Operations, 10Patch-For-Review, 10User-Elukey: Decommission old dbstore hosts (db1046, db1047) - https://phabricator.wikimedia.org/T156844#3799814 (10elukey) >>! In T156844#3786146, @Capt_Swing wrote: > The `shawn` table belonged to Shawn Walker, a research intern in 2011. Th... [14:49:58] 10DBA, 10MediaWiki-Database, 10Availability, 10Performance-Team (Radar): wfWaitForSlaves in JobRunner can massively slow down run rate if just a single slave is lagged - https://phabricator.wikimedia.org/T95799#3799877 (10jcrespo) p:05Low>03Normal I am going to put this back to normal because there is... [14:51:56] 10DBA, 10Operations, 10Epic: Eliminate SPOF at the main database infrastructure - https://phabricator.wikimedia.org/T119626#3799913 (10jcrespo) [15:03:42] 10DBA, 10Data-Services: Make Dispenser's principle_links table accessible in new Wiki replica cluster - https://phabricator.wikimedia.org/T180636#3799944 (10jcrespo) @Dispenser question- do you use the table on long-running queries (like gathering analytics) or on queries as part of a webrequest (quick ones),... [15:23:21] I was wondering what to do with the m4.hosts file [15:23:28] Now that db1046 and db1047 are going to be gone [15:23:35] And db1107 and db1108 do not replicate from production [15:23:40] Does it make sense to add them there? [15:23:46] elukey ^ [15:24:36] I guess I can add db1108 and db1107, leave dbstore1002 and remove db1046 and db1047 [15:24:44] seems good! [15:28:54] marostegui: ywa [15:28:57] *yes [15:29:20] that is just for listing them, although we almost don't use it [22:31:31] 10DBA, 10Data-Services, 10Patch-For-Review, 10cloud-services-team (Kanban): Prepare and check storage layer for amwikimedia (including dropping s7 version of the wiki) - https://phabricator.wikimedia.org/T176043#3801420 (10bd808) 05Open>03Resolved a:03bd808 ``` $ sql amwikimedia Reading table informa...