⚓ T187543 Decommission db2012

Status	Assigned	Task
Resolved	Dzahn	T165620 Upload gerrit package to stretch apt.wm.org repo
Resolved	Dzahn	T168562 Reimage gerrit2001 as stretch
Resolved	Dzahn	T176532 Gerrit is failing to connect to db on gerrit2001 thus preventing systemd from working
		Restricted Task
Open	None	T120532 Use user-specific passwords for accessing EventLogging database
Open	aaron	T88445 MediaWiki active/active datacenter investigation and work (tracking)
Stalled	None	T134809 Apache <=> mariadb SSL/TLS for cross-datacenter writes
Open	None	T111653 Encrypt all the things
Resolved	jcrespo	T111654 Set up TLS for MariaDB replication
Open	None	T138562 Improve regular production database backups handling
Open	None	T151583 Use tls for dump backup generation
Open	None	T157702 Followup for TLS MariaDB server roll-out
Resolved	jcrespo	T177208 Provide dedicated database resources for wikidata
Resolved	None	T170662 Productionize 22 new codfw database servers
Resolved	None	T176243 Decommission database hosts <= db2031 (tracking)
Resolved	jcrespo	T183470 Setup newer machines and replace all old misc (m*) and x1 codfw machines
Resolved	Papaul	T187543 Decommission db2012

jcrespo triaged this task as Normal priority.Feb 16 2018, 1:09 PM

jcrespo created this task.

Change 411229 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] Mariadb: Schedule db1043 and db2012 for decommission

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

gerritbot added a project: Patch-For-Review.Feb 16 2018, 1:11 PM

Change 411229 merged by Jcrespo:
[operations/puppet@production] Mariadb: Schedule db1043 and db2012 for decommission

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

RobH moved this task from Backlog to Reclaim (Spares/Decommission) on the hardware-requests board.Feb 16 2018, 5:34 PM

RobH updated the task description. (Show Details)

Since this is pending the DBA team's work on stating the new host is online, I've appended in the DBA flag. Once the DBA team work is done (their sign off its ok to continue and the replacement is working & the decom steps flagged for them due to service interactions), this can be assigned to @RobH and the DBA team flag removed from the task.

(If anything of the above is incorrect in the use of the DBA tag, my apologies! It seemed the best way to ensure this stays on radar without directly pinging anyone.)

Marostegui moved this task from Triage to In progress on the DBA board.Feb 21 2018, 4:14 PM

jcrespo assigned this task to RobH.Feb 23 2018, 5:52 PM

jcrespo removed a project: Patch-For-Review.

jcrespo updated the task description. (Show Details)

jcrespo moved this task from In progress to Done on the DBA board.

Marostegui mentioned this in T176243: Decommission database hosts <= db2031 (tracking).Mar 13 2018, 9:37 AM

RobH updated the task description. (Show Details)Mar 14 2018, 11:28 PM

Change 419628 had a related patch set uploaded (by RobH; owner: RobH):
[operations/puppet@production] db2012 decom

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

Change 419628 merged by RobH:
[operations/puppet@production] db2012 decom

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

Change 419631 had a related patch set uploaded (by RobH; owner: RobH):
[operations/dns@master] db2012 decom, removing prod dns