Page MenuHomePhabricator
Create Task
Maniphest T282662

Clean up references to labsdb* hosts in puppet repo
Open, MediumPublic
Actions

Description

Apart from the normal puppet hosts files, that we need to clean up after we've run the decommissioning process.
There are several files with hardcoded hostnames that need clean up.

mysqld process is stopped on labsdb hosts and hopefully will never be switched on again, so maybe this clean up can already start.
These are the files I have found:

hieradata/regex.yaml
modules/profile/files/wmcs/nfs/maintain-dbusers.py
modules/profile/files/wmcs/db/wikireplicas/maintain-meta_p.py
modules/profile/manifests/wmcs/nfs/maintain_dbusers.pp
modules/profile/files/prometheus/mysqld_exporter_config.py
modules/profile/templates/cumin/aliases.yaml.erb

Details

Show related patches Customize query in gerrit

Related Objects
Search...

Event Timeline

• Marostegui created this task.May 12 2021, 9:59 AM
Restricted Application edited projects, added cloud-services-team (Kanban); removed cloud-services-team. · View Herald TranscriptMay 12 2021, 9:59 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
• Marostegui added parent tasks: T282522: decommission labsdb1009.eqiad.wmnet, T282523: decommission labsdb1010.eqiad.wmnet, T282524: decommission labsdb1011.eqiad.wmnet.May 12 2021, 10:00 AM
• Marostegui updated the task description. (Show Details)May 12 2021, 10:02 AM
gerritbot added a comment.May 12 2021, 10:10 AM

Change 689732 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] site.pp: Remove labsdb comments

https://gerrit.wikimedia.org/r/689732

gerritbot added a project: Patch-For-Review.May 12 2021, 10:10 AM

Change 689732 merged by Marostegui:

[operations/puppet@production] site.pp: Remove labsdb comments

https://gerrit.wikimedia.org/r/689732

Maintenance_bot removed a project: Patch-For-Review.May 12 2021, 11:10 AM
gerritbot added a comment.May 13 2021, 10:40 AM

Change 690402 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] prometheus-mysqld-exporter: Update generator to remove multisource exception

https://gerrit.wikimedia.org/r/690402

gerritbot added a project: Patch-For-Review.May 13 2021, 10:40 AM
gerritbot added a comment.May 17 2021, 6:50 AM

Change 692246 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] install_server: Remove labsdb entry

https://gerrit.wikimedia.org/r/692246

gerritbot added a comment.May 17 2021, 9:33 AM

Change 692246 merged by Marostegui:

[operations/puppet@production] install_server: Remove labsdb entry

https://gerrit.wikimedia.org/r/692246

gerritbot added a comment.May 17 2021, 9:44 AM

Change 692269 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] analytic.pp: s/labsdb/clouddb

https://gerrit.wikimedia.org/r/692269

gerritbot added a comment.May 17 2021, 9:45 AM

Change 692269 merged by Marostegui:

[operations/puppet@production] analytic.pp: s/labsdb/clouddb

https://gerrit.wikimedia.org/r/692269

gerritbot added a comment.May 17 2021, 12:32 PM

Change 690402 merged by Marostegui:

[operations/puppet@production] prometheus-mysqld-exporter: Update generator to remove multisource exception

https://gerrit.wikimedia.org/r/690402

jcrespo subscribed.May 17 2021, 4:41 PM

Arturo's presentation reminded me we should restore/revert some network/VPN configuration that was needed due to these hosts. Do you know if cloud team will take care of that (sorry to ask here, but this was the more relevant ticket I found)?

gerritbot added a comment.May 18 2021, 5:38 AM

Change 692472 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] mariadb: Decommission labsdb1009

https://gerrit.wikimedia.org/r/692472

• Marostegui added a subscriber: LSobanski.May 18 2021, 5:41 AM

I would expect that to be done by cloud-services-team as they know what was done and what was reused by clouddb hosts. We've been cleaning up all the related DB code, once we've decommissioned the hosts, there will be only WMCS code + any other networking firewalls (if any) pending.

gerritbot added a comment.May 18 2021, 5:53 AM

Change 692472 merged by Marostegui:

[operations/puppet@production] mariadb: Decommission labsdb1009

https://gerrit.wikimedia.org/r/692472

gerritbot added a comment.May 18 2021, 8:45 AM

Change 692571 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] check_private_data_report: Remove labsdb* support

https://gerrit.wikimedia.org/r/692571

gerritbot added a comment.May 18 2021, 8:52 AM

Change 692571 merged by Marostegui:

[operations/puppet@production] check_private_data_report: Remove labsdb* support

https://gerrit.wikimedia.org/r/692571

gerritbot added a comment.May 19 2021, 6:38 AM

Change 692757 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] maintain_dbusers.pp: Remove labsdb1010

https://gerrit.wikimedia.org/r/692757

gerritbot added a comment.May 19 2021, 6:39 AM

Change 692757 merged by Marostegui:

[operations/puppet@production] maintain_dbusers.pp: Remove labsdb1010

https://gerrit.wikimedia.org/r/692757

gerritbot added a comment.May 20 2021, 5:25 AM

Change 693058 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] maintain_dbusers.pp: Remove reference to labsdb1011

https://gerrit.wikimedia.org/r/693058

gerritbot added a comment.May 20 2021, 5:42 AM

Change 693058 merged by Marostegui:

[operations/puppet@production] maintain_dbusers.pp: Remove reference to labsdb1011

https://gerrit.wikimedia.org/r/693058

gerritbot added a comment.May 20 2021, 5:58 AM

Change 693059 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] cumin: Remove labsdb*

https://gerrit.wikimedia.org/r/693059

gerritbot added a comment.May 20 2021, 6:31 AM

Change 693060 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] check_private_data_report: Remove references to labsdb

https://gerrit.wikimedia.org/r/693060

gerritbot added a comment.May 20 2021, 6:32 AM

Change 693060 merged by Marostegui:

[operations/puppet@production] check_private_data_report: Remove references to labsdb

https://gerrit.wikimedia.org/r/693060

gerritbot added a comment.May 20 2021, 7:25 AM

Change 693123 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] orchestrator.conf.json: Remove labsdb*

https://gerrit.wikimedia.org/r/693123

gerritbot added a comment.May 20 2021, 9:00 AM

Change 693123 merged by Marostegui:

[operations/puppet@production] orchestrator.conf.json: Remove labsdb*

https://gerrit.wikimedia.org/r/693123

gerritbot added a comment.May 20 2021, 9:20 AM

Change 693059 merged by Marostegui:

[operations/puppet@production] cumin: Remove labsdb*

https://gerrit.wikimedia.org/r/693059

• Marostegui added a comment.May 20 2021, 9:41 AM

DBA side of things are done.

gerritbot added a comment.May 24 2021, 4:36 AM

Change 693635 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] alias.yaml.erb: Fix new clouddb* replicas alias

https://gerrit.wikimedia.org/r/693635

gerritbot added a comment.May 24 2021, 4:41 AM

Change 693635 merged by Marostegui:

[operations/puppet@production] alias.yaml.erb: Fix new clouddb* replicas alias

https://gerrit.wikimedia.org/r/693635

gerritbot added a comment.May 24 2021, 7:13 AM

Change 693666 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] aliases.yaml.erb: Remove wikireplicas aliases

https://gerrit.wikimedia.org/r/693666

gerritbot added a comment.May 24 2021, 7:14 AM

Change 693666 merged by Marostegui:

[operations/puppet@production] aliases.yaml.erb: Remove wikireplicas aliases

https://gerrit.wikimedia.org/r/693666

gerritbot added a comment.Jun 11 2021, 5:24 AM

Change 699329 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] regex.yaml: Remove labsdb references

https://gerrit.wikimedia.org/r/699329

gerritbot added a comment.Jun 11 2021, 6:09 AM

Change 699329 merged by Marostegui:

[operations/puppet@production] regex.yaml: Remove labsdb references

https://gerrit.wikimedia.org/r/699329

gerritbot added a comment.Jun 11 2021, 9:12 AM

Change 699386 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] labsdb: Remove some labsdb entries

https://gerrit.wikimedia.org/r/699386

gerritbot added a comment.Jun 11 2021, 9:14 AM

Change 699386 merged by Marostegui:

[operations/puppet@production] labsdb: Remove some labsdb entries

https://gerrit.wikimedia.org/r/699386

gerritbot added a comment.Jun 11 2021, 9:24 AM

Change 699389 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] maintain-dbusers.py: Remove labsdb references

https://gerrit.wikimedia.org/r/699389

gerritbot added a comment.Jun 11 2021, 9:25 AM

Change 699389 merged by Marostegui:

[operations/puppet@production] maintain-dbusers.py: Remove labsdb references

https://gerrit.wikimedia.org/r/699389

• nskaggs triaged this task as Medium priority.Aug 10 2021, 10:06 PM
fnegri edited projects, added cloud-services-team; removed cloud-services-team (Kanban).Jan 18 2023, 6:51 PM
fnegri moved this task from Kanban to Inbox on the cloud-services-team board.
Pppery removed a project: Patch-For-Review.Apr 2 2023, 12:52 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL