Page MenuHomePhabricator

Repurpose db1107 as a generic database
Closed, ResolvedPublic

Description

db1107 will at some point stop being part of eventlogging and will be able to be used as a spare DB.
It would need re-image.

Details

Related Gerrit Patches:

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptTue, Nov 12, 4:47 PM
Marostegui changed the task status from Open to Stalled.Tue, Nov 12, 4:48 PM
Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board.

This is currently blocked and needs to wait for the green light from @elukey

Ottomata added a subscriber: Ottomata.

T231858 is done so this is unblocked, woohoo!

Marostegui changed the task status from Stalled to Open.Thu, Nov 21, 6:12 AM

Thank you!
I am going to stop MySQL on db1107 and leave it for a few days to make sure nothing really breaks, before reimagining this host.

Mentioned in SAL (#wikimedia-operations) [2019-11-21T06:13:10Z] <marostegui> Stop MySQL on db1107 T238113

Change 553884 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: Reimage db1107 and place it as core_test

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

Change 553884 merged by Marostegui:
[operations/puppet@production] mariadb: Reimage db1107 and place it as core_test

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

Script wmf-auto-reimage was launched by marostegui on cumin1001.eqiad.wmnet for hosts:

['db1107.eqiad.wmnet']

The log can be found in /var/log/wmf-auto-reimage/201912020750_marostegui_180849.log.

Completed auto-reimage of hosts:

['db1107.eqiad.wmnet']

and were ALL successful.

Marostegui closed this task as Resolved.Mon, Dec 2, 2:26 PM
Marostegui claimed this task.

db1107 has been reimaged into buster and placed on test-s1 with MariaDB 10.3.20 with replicating from enwiki master and being an intermediate master for db1114 (running percona mysql 8)