Page MenuHomePhabricator

Drop the ipoid database from MariaDB m5
Closed, ResolvedPublic

Description

Summary

Per T416623: Decommission NodeJS IPoid service, the NodeJS IPoid service is being decommissioned. Once decommissioned, the ipoid database on the m5 shard will be unused and can be dropped as unused

Acceptance criteria

  • The ipoid database is dropped from the m5 cluster

DBA follow up:

  • Delete grants

Event Timeline

Change #1307208 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[operations/puppet@production] MariaDB grants: Drop ipoid database users

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

Deferring to DBA to delete the database. It should be fine to drop the database now as the service has been undeployed, but may be best to wait until the chart definition has been removed (hopefully Tuesday the 7th of July)

Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to Blocked on the DBA board.
Marostegui subscribed.

Deferring to DBA to delete the database. It should be fine to drop the database now as the service has been undeployed, but may be best to wait until the chart definition has been removed (hopefully Tuesday the 7th of July)

I will wait for the 8th then.

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

[operations/puppet@production] production-m5.sql.erb: Remove ipoid grants

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

Change #1307208 abandoned by Dreamy Jazz:

[operations/puppet@production] MariaDB grants: Drop ipoid database users

Reason:

Now a duplicate change

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

Change #1307440 merged by Marostegui:

[operations/puppet@production] production-m5.sql.erb: Remove ipoid grants

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

To confirm the service has been fully removed from production (the only item left for the parent task is to remove the URL from ProductionServices.php which is just cleanup)

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

[operations/puppet@production] dumps-eqiad-m5.sql.erb: Remove grants

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

Marostegui updated the task description. (Show Details)

Database dropped, grants removed, backup grants removed too.
Just pending to merge this noop: https://gerrit.wikimedia.org/r/c/operations/puppet/+/1309900

Change #1309900 merged by Marostegui:

[operations/puppet@production] dumps-eqiad-m5.sql.erb: Remove grants

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