[08:56:36] 10DBA: Reimage & upgrade db1064 - https://phabricator.wikimedia.org/T144723#2608312 (10jcrespo) [08:56:53] ^marostegui [08:57:13] 10DBA: Reimage & upgrade db1064 - https://phabricator.wikimedia.org/T144723#2608325 (10Marostegui) a:03Marostegui [08:57:18] :) [08:57:42] 10DBA: Reimage & upgrade db1064 - https://phabricator.wikimedia.org/T144723#2608327 (10jcrespo) a:05Marostegui>03None [08:58:12] 10DBA: Reimage & upgrade db1064 - https://phabricator.wikimedia.org/T144723#2608312 (10jcrespo) a:03Marostegui [08:58:24] sorry, for some reason editing it at the same time has a race condition [08:58:29] haha [08:58:30] no worries [08:58:48] on wikis it warns if you edit an older version [08:59:17] 10DBA: Reimage & upgrade db1064 - https://phabricator.wikimedia.org/T144723#2608312 (10jcrespo) p:05Triage>03Normal [09:01:48] jynus: of course if I can be useful in any way (TLS maybe?) for marostegui onboarding just let me know ;) [09:03:13] marostegui, meet the person that setup our TLS-mysql setup [09:03:18] 10DBA: Reimage & upgrade db1064 - https://phabricator.wikimedia.org/T144723#2608337 (10Marostegui) Self note: - Belongs to s4 - Has 0 weight in config [09:03:43] volans: Thanks for the offering, I might pick your brain indeed later :) [09:04:15] marostegui: sure, when you want [09:05:06] note to yourself marostegui: db1064 has 0 weight but is part of special role (vslow and dump) ;) [09:05:36] volans, do not blame him for crazy syntax [09:05:42] haha [09:05:53] I already suggested that, if we migrate to etcd-backed weight [09:06:11] Yeah, I saw the comments, thanks for the heads up though, as a n00b any hint is welcome :) [09:06:21] jynus: not blaming at all :) just introducing to the crazy syntax the hard way :D [09:07:10] we should do dbXXXX => [ s1 => [ main => 0, vslow => 100 ], ], ], [09:09:36] git grep is your friend marostegui: git grep -B10 db1064 [09:10:38] BTW, marostegui, the reimage proposed is not because it is a dull proces, but because 90% of the problems are solved by cloning [09:13:30] volans: yeah, I was doing that right now and found: 'db1064' => '10.64.48.19', #do not remove or comment out in: wmf-config/db-codfw.php [09:14:04] I also see that db1064 is the only server in s4 that receives vslow and dump, so I assume I need to replace that one with another one so we can still provide that "service"? [09:14:06] yep, do not remove or comment out [09:14:16] yes [09:14:22] yeah, that's part of the crazy syntax... they are defined in both codfw and eqiad files [09:14:48] well, there is a reason for that, which is use ips instead of dns [09:15:45] we may end up with a single file in the end if we have multi-dc support? [14:18:41] 10DBA, 13Patch-For-Review: Reimage & upgrade db1064 - https://phabricator.wikimedia.org/T144723#2609056 (10Marostegui) Deployment to depool db1064 is done, db1019 takes over it temporarily . [15:02:36] AaronSchulz, https://phabricator.wikimedia.org/P3981 is the list you asked for; I only printed the to 20 warnings on s1-master, for starters [15:48:27] 10DBA, 10MediaWiki-extensions-WikibaseRepository, 10Wikidata, 05Goal: Remove numeric entity IDs from database schema - https://phabricator.wikimedia.org/T114902#2609364 (10thiemowmde) p:05Triage>03Low I believe we all know about these and we have migration paths for all of them.