Page MenuHomePhabricator

Clean up references to labsdb* hosts in puppet repo
Open, Needs TriagePublic

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

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

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

Change 689732 merged by Marostegui:

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

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

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

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

Change 692246 merged by Marostegui:

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

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

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

Change 692269 merged by Marostegui:

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

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

Change 690402 merged by Marostegui:

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

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

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)?

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

[operations/puppet@production] mariadb: Decommission labsdb1009

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

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.

Change 692472 merged by Marostegui:

[operations/puppet@production] mariadb: Decommission labsdb1009

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

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

Change 692571 merged by Marostegui:

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

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

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

Change 692757 merged by Marostegui:

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

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

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

Change 693058 merged by Marostegui:

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

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

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

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

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

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

Change 693060 merged by Marostegui:

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

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

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

Change 693123 merged by Marostegui:

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

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

Change 693059 merged by Marostegui:

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

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

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

Change 693635 merged by Marostegui:

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

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

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

Change 693666 merged by Marostegui:

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

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

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

Change 699329 merged by Marostegui:

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

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

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

Change 699386 merged by Marostegui:

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

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

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

Change 699389 merged by Marostegui:

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

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