[09:15:54] starting a schema change on a few hosts with Amir1's script [10:15:12] jynus: thanks for looking at the new swift front-ends (and, err, sorry it wasn't clear they're not in production yet) [10:17:03] one tip I can provide, if that helps -we do if for dbs- while a host is being setup, we had the hiera key: profile::monitoring::notifications_enabled: false until things are at 100% to avoid false positives on alerts :-) [10:18:52] I've not really had anything to do with the commissioning process thusfar [10:18:59] ah, ok [10:19:29] I will tell filippo that can be useful to prevent alerting noise [10:21:00] in my mind, I was running backups and so many failures were scary [10:22:16] (until Lukasz point me that they were not in service with the ticket) [10:33:38] I've got the monotonic thing on my "look at in my CFT" list [10:33:55] sorry, Copious Free Time [sarcastic] [10:39:30] o/ I'd like to get a list of all users with the sysop right across all public wikis. The users on this list will eventually be sent a message via MassMessage (see https://phabricator.wikimedia.org/T296338 for more detail). My first thought was to query user JOIN user_groups on all wikis using the expanddblist and sql commands on the maintenance server. Is that an acceptable approach? [10:41:20] phuedx: As long as you don't use a production pooled host, that is fine. You could use the dbstore hosts for such query [10:42:45] phuedx: I can provide a mapping of which dbstore has each section if that helps [10:43:26] marostegui: Thanks! I was about to ask. AIUI the sql command takes care of connecting to the appropriate section. In this case, I'd have to do that, right? [10:44:21] phuedx: I am not sure how that works with sql and dbstore hosts - Amir1 do you know if sql works with dbstore hosts? [10:44:24] Let me try [10:45:04] phuedx: there is an easier way [10:45:07] let me grab it [10:45:13] login to stat1x machine [10:46:10] https://wikitech.wikimedia.org/wiki/Analytics/Systems/MariaDB [10:46:28] I run expensive queries against analytics cluster [10:46:53] oh nice, I didn't know that wrapper existed! [10:47:57] Nice! Thanks Amir1 [10:58:32] marostegui, Amir1: Thanks, both. I've got everything I need to generate the list. I'll also document the approach on the task [10:58:44] phuedx: great! [13:31:00] kormat jynus https://phabricator.wikimedia.org/T296930#7543551 [13:31:15] I am reading it now [15:33:42] afk for a bit [19:46:09] https://lefred.be/content/mysql-8-0-innodb-parallel-threads-for-online-ddl-operations/ [19:46:28] this is very interesting, we'll see if mariadb do it too