[00:52:04] 10DBA, 10Community-Tech, 10MediaWiki-User-management: Do test queries for range contributions to gauge performance of using different tables - https://phabricator.wikimedia.org/T156318#3403019 (10DannyH) [01:11:48] 10DBA, 10MediaWiki-extensions-Renameuser: Fix use of DB schema so RenameUser is trivial - https://phabricator.wikimedia.org/T33863#3403077 (10Krinkle) [02:02:19] 10DBA, 10MediaWiki-Database, 10Tracking: Duplicate key errors (tracking) - https://phabricator.wikimedia.org/T106854#3403136 (10Krinkle) [05:17:11] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3403264 (10Marostegui) s2 master has been altered on the fly with no major issues, as it was done early in the morning and I double checked its traffic at th... [05:17:26] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3403265 (10Marostegui) [05:24:26] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3403267 (10Marostegui) s6 master altered on the fly [05:24:39] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3403268 (10Marostegui) [05:29:03] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3403270 (10Marostegui) s5 master altered [05:29:14] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3403271 (10Marostegui) [07:04:08] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3403342 (10Marostegui) [07:04:25] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3371212 (10Marostegui) s7: All done but the primary master. Probably this one can also be altered on the master on an early morning. I have done tests with a... [07:06:55] 10DBA, 10Cloud-Services: Drop ukwikimedia from labsdb hosts (was: ukwikimedia still present on replicas dbs on labs hosts) - https://phabricator.wikimedia.org/T169488#3403344 (10Marostegui) The reason I suggested to use the script because it was pointed out to me that it could be easier just using it than doin... [11:41:01] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Convert unique keys into primary keys for some wiki tables on s7 - https://phabricator.wikimedia.org/T166208#3404011 (10Marostegui) [11:46:32] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3404018 (10Marostegui) [11:47:09] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3371223 (10Marostegui) s3 is done, and I believe the master can also be done early in the morning. It is a powerful one (512G RAM+SSD) and 64GB pooled slaves... [12:43:49] 10DBA: Refactor puppet mariadb class to support multi-instance hosts - https://phabricator.wikimedia.org/T169514#3404094 (10jcrespo) a:03jcrespo [12:46:40] 10DBA: Refactor puppet mariadb class to support multi-instance hosts - https://phabricator.wikimedia.org/T169514#3404098 (10jcrespo) [13:39:49] 10DBA, 10Cloud-Services, 10User-Urbanecm: Prepare and check storage layer for maiwikimedia - https://phabricator.wikimedia.org/T168788#3404282 (10Marostegui) Hi @Urbanecm, Once https://gerrit.wikimedia.org/r/361297 is merged tables will be created in production, right? Just making sure we do not miss it lik... [14:27:24] 10DBA, 10Cloud-Services, 10User-Urbanecm: Prepare and check storage layer for maiwikimedia - https://phabricator.wikimedia.org/T168788#3404542 (10Urbanecm) THat is true probably. I'm watching the task and will ping since I notice relevant change :). [14:27:49] 10DBA, 10Cloud-Services, 10User-Urbanecm: Prepare and check storage layer for maiwikimedia - https://phabricator.wikimedia.org/T168788#3404543 (10Marostegui) Great - thank you! [15:51:57] 10DBA: Implement cron-based mydumper backups on the dbstore role - https://phabricator.wikimedia.org/T169516#3404960 (10jcrespo) [15:51:59] 10DBA, 10Patch-For-Review: Refactor puppet mariadb class to support multi-instance hosts - https://phabricator.wikimedia.org/T169514#3404961 (10jcrespo) [15:52:07] 10DBA, 10Patch-For-Review: Setup dbstore2002 with 2 new mysql instances from production and enable GTID - https://phabricator.wikimedia.org/T169510#3404962 (10jcrespo) [16:50:03] 10DBA, 10Cloud-Services: Drop ukwikimedia from labsdb hosts (was: ukwikimedia still present on replicas dbs on labs hosts) - https://phabricator.wikimedia.org/T169488#3405130 (10jcrespo) a:03jcrespo Claiming for the actual data drop bits- will restart all sanitarium hosts's instances, which will create some... [16:59:15] 10DBA, 10Cloud-Services: Drop ukwikimedia from labsdb hosts (was: ukwikimedia still present on replicas dbs on labs hosts) - https://phabricator.wikimedia.org/T169488#3405138 (10jcrespo) Actually, no reloading was needed- the replication filters doesn't change because we do not include deleted wikis as part of... [17:13:09] 10DBA, 10Cloud-Services: Drop ukwikimedia from labsdb hosts (was: ukwikimedia still present on replicas dbs on labs hosts) - https://phabricator.wikimedia.org/T169488#3405176 (10jcrespo) a:05jcrespo>03None Dropped everywhere on labs- only waiting for replication to catch up on labsdb1003, and checking with... [17:13:23] 10DBA, 10Cloud-Services: Drop ukwikimedia from labsdb hosts (was: ukwikimedia still present on replicas dbs on labs hosts) - https://phabricator.wikimedia.org/T169488#3405178 (10jcrespo) p:05Triage>03Normal [17:15:53] 10DBA, 10Cloud-Services: Drop ukwikimedia from labsdb hosts (was: ukwikimedia still present on replicas dbs on labs hosts) - https://phabricator.wikimedia.org/T169488#3405180 (10Marostegui) Yes, labsdb1003 is delayed due to a big alter table going on, which I think will be finished in the next 24h more or less... [21:23:05] 10DBA, 10Operations, 10Wikimedia-Language-setup, 10Wikimedia-Site-requests, and 2 others: Reopen Wikinews Dutch - https://phabricator.wikimedia.org/T168764#3405605 (10Dereckson)