[00:03:01] 10DBA, 10Data-Services, 10Goal, 10cloud-services-team (FY2017-18): Migrate all users to new Wiki Replica cluster and decommission old hardware - https://phabricator.wikimedia.org/T142807#3728380 (10bd808) [00:03:06] 10DBA, 10Operations, 10cloud-services-team, 10Patch-For-Review, 10Scoring-platform-team (Current): Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3728377 (10bd808) 05Open>03Resolved >>! In T168584#3725668, @MoritzMuehlenhoff wrote: > Let's just keep 1003 running w/o r... [08:30:38] 10DBA, 10Patch-For-Review: Migrate some s4 hosts to file per table - https://phabricator.wikimedia.org/T161088#3728742 (10Marostegui) [08:38:58] 10DBA, 10Patch-For-Review: Support multi-instance on core hosts - https://phabricator.wikimedia.org/T178359#3728791 (10Marostegui) db2085.s3 is now replicating. [09:28:37] 10DBA, 10Operations, 10ops-eqiad: Decommission db1033 and db1028 - https://phabricator.wikimedia.org/T174076#3728895 (10Marostegui) a:03Cmjohnson [09:42:04] 10DBA, 10Patch-For-Review: Migrate some s4 hosts to file per table - https://phabricator.wikimedia.org/T161088#3728938 (10Marostegui) 05Open>03Resolved db1091 is done and its original traffic weight is restored. [09:43:23] 10Blocked-on-schema-change, 10DBA, 10Data-Services, 10Dumps-Generation, 10MediaWiki-Platform-Team (MWPT-Q2-Oct-Dec-2017): Schema change for refactored comment storage - https://phabricator.wikimedia.org/T174569#3728940 (10Marostegui) a:05Anomie>03Marostegui [10:14:22] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Drop now redundant indexes from pagelinks and templatelinks - https://phabricator.wikimedia.org/T174509#3728984 (10Marostegui) >>! In T174509#3718640, @Marostegui wrote: > Optimized s5 master: > dewiki.pagelinks (10G) > dewiki.templatelinks (30G) > wiki... [10:14:36] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Drop now redundant indexes from pagelinks and templatelinks - https://phabricator.wikimedia.org/T174509#3728985 (10Marostegui) [10:36:57] 10Blocked-on-schema-change, 10DBA, 10Data-Services, 10Dumps-Generation, 10MediaWiki-Platform-Team (MWPT-Q2-Oct-Dec-2017): Schema change for refactored comment storage - https://phabricator.wikimedia.org/T174569#3729008 (10Marostegui) Hi, I have tested this on one of the oldest versions we have, 10.0.22... [10:49:16] 10Blocked-on-schema-change, 10DBA, 10Data-Services, 10Dumps-Generation, 10MediaWiki-Platform-Team (MWPT-Q2-Oct-Dec-2017): Schema change for refactored comment storage - https://phabricator.wikimedia.org/T174569#3729017 (10Marostegui) [10:51:25] 10Blocked-on-schema-change, 10DBA, 10Data-Services, 10Dumps-Generation, 10MediaWiki-Platform-Team (MWPT-Q2-Oct-Dec-2017): Schema change for refactored comment storage - https://phabricator.wikimedia.org/T174569#3729019 (10Marostegui) [11:01:58] 10DBA: Add an index on rc_this_oldid - https://phabricator.wikimedia.org/T179199#3716689 (10daniel) Is this the same as {T139012}? [12:46:30] 10DBA, 10Analytics, 10Operations: Prep to decommission old dbstore hosts (db1046, db1047) - https://phabricator.wikimedia.org/T156844#3729337 (10elukey) All right we are ready to outline the next steps with some deadlines (tentative): * November 6th: the analytics-slave CNAME moves from db1047 to db1108 * N... [12:46:44] marostegui: --^ [12:55:09] 10DBA, 10Analytics, 10Operations, 10User-Elukey: Prep to decommission old dbstore hosts (db1046, db1047) - https://phabricator.wikimedia.org/T156844#3729344 (10elukey) [13:02:19] elukey: nice!!! [13:02:52] 10DBA, 10Analytics, 10Operations, 10User-Elukey: Prep to decommission old dbstore hosts (db1046, db1047) - https://phabricator.wikimedia.org/T156844#3729360 (10Marostegui) >>! In T156844#3729337, @elukey wrote: > All right we are ready to outline the next steps with some deadlines (tentative): > > * Novem... [13:06:06] 10DBA, 10Patch-For-Review: Support multi-instance on core hosts - https://phabricator.wikimedia.org/T178359#3729364 (10Marostegui) [13:13:21] 10DBA, 10Patch-For-Review: Support multi-instance on core hosts - https://phabricator.wikimedia.org/T178359#3729391 (10Marostegui) [13:35:32] 10DBA, 10Patch-For-Review: Support multi-instance on core hosts - https://phabricator.wikimedia.org/T178359#3729515 (10Marostegui) [14:10:49] 10DBA, 10Patch-For-Review: Support multi-instance on core hosts - https://phabricator.wikimedia.org/T178359#3729663 (10Marostegui) [14:12:32] 10DBA: Add an index on rc_this_oldid - https://phabricator.wikimedia.org/T179199#3729668 (10Anomie) I wonder how I missed that when searching for an existing bug. [14:12:45] 10DBA: Add an index on rc_this_oldid - https://phabricator.wikimedia.org/T179199#3729671 (10Anomie) [14:21:31] 10DBA, 10Wikimedia-Site-requests, 10Tracking: Database table cleanup (tracking) - https://phabricator.wikimedia.org/T18660#3729703 (10Marostegui) [14:36:21] 10DBA, 10Cloud-Services, 10Cloud-VPS, 10Toolforge: Make (redacted) log_search table available on ToolLabs - https://phabricator.wikimedia.org/T85756#953798 (10Marostegui) Is this still needed? [18:27:30] 10DBA, 10Data-Services: Make (redacted) log_search table available on ToolLabs - https://phabricator.wikimedia.org/T85756#3730480 (10Luke081515) [23:53:27] 10DBA, 10Operations, 10cloud-services-team, 10Patch-For-Review, 10Scoring-platform-team (Current): Labsdb* servers need to be rebooted - https://phabricator.wikimedia.org/T168584#3731324 (10madhuvishy) fyi @Cmjohnson We are not doing the labsdb1003 reboot on Tuesday Nov 7, due to T179464. [23:53:43] 10DBA, 10Data-Services, 10Goal, 10cloud-services-team (FY2017-18): Migrate all users to new Wiki Replica cluster and decommission old hardware - https://phabricator.wikimedia.org/T142807#3731325 (10bd808) [23:55:07] 10DBA, 10Data-Services, 10Goal, 10cloud-services-team (FY2017-18): Migrate all users to new Wiki Replica cluster and decommission old hardware - https://phabricator.wikimedia.org/T142807#2546917 (10bd808)