Productionize dbproxy200[5-8]
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Marostegui
	Jun 13 2024, 6:48 AM

Description

These are the first Supermicro dbproxies we'll have

dbproxy2005 replaces dbproxy2001
dbproxy2006 replaces dbproxy2002
dbproxy2007 replaces dbproxy2003
dbproxy2008 replaces dbproxy2004

Details

Related Changes in Gerrit:

Subject	Repo	Branch	Lines +/-
wmnet: Promote dbproxy2008 to m3-codfw master	operations/dns	master	+1 -1
report_users.sh: Add dbproxy2008 IP	operations/software	master	+1 -0
production-m5.sql.erb: Upgrade dbproxy grants	operations/puppet	production	+19 -19
wmnet: Promote dbproxy2007 to m3-codfw master	operations/dns	master	+1 -1
report_users.sh: Add dbproxy2007 IP	operations/software	master	+1 -0
production-m3.sql.erb: Replace dbproxy2003 with dbproxy2007	operations/puppet	production	+22 -22
wmnet: Promote dbproxy2006 to m2 master	operations/dns	master	+1 -1
report_users.sh: Add dbproxy2006 IP	operations/software	master	+1 -0
production-m2.sql.erb: Replaced dbproxy2002 with dbproxy2006	operations/puppet	production	+39 -39
wmnet: Update m1-master.codfw.wmnet CNAME	operations/dns	master	+1 -1
report_users.sh: Add dbproxy2005 IP	operations/software	master	+1 -0
production-m1.sql.erb: Upgrade grants	operations/puppet	production	+13 -13
mariadb: prod dbproxy200[5-8]	operations/puppet	production	+25 -2

Related Objects
Search...

Status	Subtype	Assigned	Task
Resolved		jcrespo	T376916 Upgrade backup hosts to Debian Bookworm 12.X
Resolved		jcrespo	T383902 Upgrade backup source or mediabackup database host os to Debian bookworm or decommission them
			Unknown Object (Task)
Resolved		Papaul	T362824 Q#:rack/setup/install dbproxy200[5-8]
			Unknown Object (Task)
Resolved		Marostegui	T373579 Productionize db22[21-40]
Resolved		Marostegui	T374623 Decommission db21[21-40]
Resolved		Marostegui	T368874 Productionize dbproxy102[89]
Resolved	Request	Jclark-ctr	T383025 decommission dbproxy1020.eqiad.wmnet
Resolved	Request	Jclark-ctr	T383033 decommission dbproxy1021.eqiad.wmnet
Resolved		Marostegui	T367380 Productionize dbproxy200[5-8]
Resolved		Marostegui	T381962 Decommission dbproxy200[1-4]
Resolved	Request	Jhancock.wm	T382867 decommission dbproxy2001.codfw.wmnet
Resolved	Request	Jhancock.wm	T382868 decommission dbproxy2002.codfw.wmnet
Resolved	Request	Jhancock.wm	T382875 decommission dbproxy2003.codfw.wmnet
Resolved	Request	Jhancock.wm	T382877 decommission dbproxy2004.codfw.wmnet
Resolved	Request	Jhancock.wm	T383388 decommission db2123.codfw.wmnet
Resolved	Request	Jhancock.wm	T383395 decommission db2126.codfw.wmnet
Resolved	Request	Jhancock.wm	T383426 decommission db2135.codfw.wmnet
Resolved	Request	Jhancock.wm	T383572 decommission db2128.codfw.wmnet
Resolved	Request	Jhancock.wm	T383697 decommission db2132.codfw.wmnet
Resolved	Request	Jhancock.wm	T383766 decommission db2130.codfw.wmnet
Resolved		Jhancock.wm	T383971 decommission db2139
Resolved	Request	Jhancock.wm	T384001 decommission db2131.codfw.wmnet
Resolved	Request	Jhancock.wm	T384343 decommission db2133.codfw.wmnet
Resolved	Request	Jhancock.wm	T384476 decommission db2134.codfw.wmnet
Resolved	Request	Jhancock.wm	T384479 decommission db2136.codfw.wmnet
Resolved	Request	Jhancock.wm	T384480 decommission db2140.codfw.wmnet

Event Timeline

Marostegui created this task.Jun 13 2024, 6:48 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 13 2024, 6:48 AM

Marostegui triaged this task as Medium priority.Jun 13 2024, 6:48 AM

Marostegui moved this task from Triage to Blocked on the DBA board.

Marostegui updated the task description. (Show Details)

Marostegui removed Marostegui as the assignee of this task.Jul 5 2024, 12:53 PM

Marostegui moved this task from Blocked to Ready on the DBA board.Jul 31 2024, 11:53 AM

ABran-WMF subscribed.Aug 20 2024, 1:35 PM

ABran-WMF claimed this task.Sep 11 2024, 12:45 PM

ABran-WMF moved this task from Ready to In progress on the DBA board.

Change #1072195 had a related patch set uploaded (by Arnaudb; author: Arnaudb):

[operations/puppet@production] mariadb: prod dbproxy200[5-8]

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

gerritbot added a project: Patch-For-Review.Sep 11 2024, 12:55 PM

ABran-WMF moved this task from In progress to Blocked on the DBA board.Sep 19 2024, 2:07 PM

ABran-WMF added parent tasks: T374623: Decommission db21[21-40], T373579: Productionize db22[21-40].Oct 18 2024, 12:29 PM

Change #1072195 merged by Arnaudb:

[operations/puppet@production] mariadb: prod dbproxy200[5-8]

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

Maintenance_bot removed a project: Patch-For-Review.Nov 25 2024, 10:32 AM

ABran-WMF moved this task from Blocked to In progress on the DBA board.Nov 25 2024, 10:36 AM

Can we get this done before the end of the year?

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

[operations/puppet@production] production-m1.sql.erb: Upgrade grants

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

gerritbot added a project: Patch-For-Review.Dec 11 2024, 9:31 AM

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

[operations/software@master] report_users.sh: Add dbproxy2005 IP

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

Change #1102226 merged by Marostegui:

[operations/puppet@production] production-m1.sql.erb: Upgrade grants

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

Change #1102228 merged by Marostegui:

[operations/software@master] report_users.sh: Add dbproxy2005 IP

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

dbproxy2005 looking good:

mariadb,db2132,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,6,0,,1,2,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,0,0,0,,,0,,0,0,0,0,0,0,0,0,1,1,,,,-,0,0,0,,,,,,,,,,,,,,,,,,,,,,
mariadb,db2160:3321,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,0,1,0,0,6,0,,1,2,2,,0,,2,0,,0,L7OK,0,1,,,,,,,,,,,0,0,,,,,-1,,,0,0,0,0,,,,Layer7 check passed,,2,3,4,,,,,,tcp,,,,,,,,0,0,0,,,0,,0,0,0,0,0,0,0,0,1,1,,,,-,0,0,0,,,,,,,,,,,,,,,,,,,,,,
mariadb,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,1,,0,6,0,,1,2,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,0,0,0,,,,,0,0,0,0,0,,,,,1,0,0,0,-,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,

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

[operations/dns@master] wmnet: Update m1-master.codfw.wmnet CNAME

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

Change #1102233 merged by Marostegui:

[operations/dns@master] wmnet: Update m1-master.codfw.wmnet CNAME

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

dbproxy2005 has been promoted to master.

Marostegui updated the task description. (Show Details)Dec 11 2024, 9:46 AM

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

[operations/puppet@production] production-m2.sql.erb: Replaced dbproxy2002 with dbproxy2006

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

Change #1102242 merged by Marostegui:

[operations/puppet@production] production-m2.sql.erb: Replaced dbproxy2002 with dbproxy2006

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

dbproxy2006 is up

mariadb,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,2,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,0,,,,,,,,,,,0,,,,,,,,,-,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
mariadb,db2133,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,2,0,,1,2,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,0,0,0,,,0,,0,0,0,0,0,0,0,0,1,1,,,,-,0,0,0,,,,,,,,,,,,,,,,,,,,,,
mariadb,db2160:3322,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,0,1,0,0,2,0,,1,2,2,,0,,2,0,,0,L7OK,0,1,,,,,,,,,,,0,0,,,,,-1,,,0,0,0,0,,,,Layer7 check passed,,2,3,4,,,,,,tcp,,,,,,,,0,0,0,,,0,,0,0,0,0,0,0,0,0,1,1,,,,-,0,0,0,,,,,,,,,,,,,,,,,,,,,,
mariadb,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,1,,0,2,0,,1,2,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,0,0,0,,,,,0,0,0,0,0,,,,,1,0,0,0,-,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,

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

[operations/software@master] report_users.sh: Add dbproxy2006 IP

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

Change #1102244 merged by Marostegui:

[operations/software@master] report_users.sh: Add dbproxy2006 IP

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

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

[operations/dns@master] wmnet: Promote dbproxy2006 to m2 master

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

Change #1102245 merged by Marostegui:

[operations/dns@master] wmnet: Promote dbproxy2006 to m2 master

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

dbproxy2006 has been promoted to m2 master.

Marostegui updated the task description. (Show Details)Dec 11 2024, 10:18 AM

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

[operations/puppet@production] production-m3.sql.erb: Replace dbproxy2003 with dbproxy2007

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

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

[operations/dns@master] wmnet: Promote dbproxy2007 to m3-codfw master

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

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

[operations/software@master] report_users.sh: Add dbproxy2007 IP

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

Change #1102250 merged by Marostegui:

[operations/puppet@production] production-m3.sql.erb: Replace dbproxy2003 with dbproxy2007

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

Change #1102253 merged by jenkins-bot:

[operations/software@master] report_users.sh: Add dbproxy2007 IP

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

dbproxy2007 is up and has been promoted to master:

mariadb,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,2,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,0,,,,,,,,,,,0,,,,,,,,,-,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
mariadb,db2134,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,1,0,,1,2,1,,0,,2,0,,0,L7OK,0,1,,,,,,,,,,,0,0,,,,,-1,,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,0,0,0,,,0,,0,0,0,0,0,0,0,0,1,1,,,,-,0,0,0,,,,,,,,,,,,,,,,,,,,,,
mariadb,db2160:3323,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP 1/3,1,0,1,0,0,1,0,,1,2,2,,0,,2,0,,0,INI,,,,,,,,,,,,,0,0,,,,,-1,,,0,0,0,0,,,,Initializing,,2,3,2,,,,,,tcp,,,,,,,,0,0,0,,,0,,0,0,0,0,0,0,0,0,0,1,,,,-,0,0,0,,,,,,,,,,,,,,,,,,,,,,
mariadb,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,1,,0,1,0,,1,2,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,0,0,0,,,,,0,0,0,0,0,,,,,1,0,0,0,-,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,

Change #1102251 merged by Marostegui:

[operations/dns@master] wmnet: Promote dbproxy2007 to m3-codfw master

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

Marostegui updated the task description. (Show Details)Dec 11 2024, 10:37 AM

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

[operations/puppet@production] production-m5.sql.erb: Upgrade dbproxy grants

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

Change #1102260 merged by Marostegui:

[operations/puppet@production] production-m5.sql.erb: Upgrade dbproxy grants

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

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

[operations/software@master] report_users.sh: Add dbproxy2008 IP

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

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

[operations/dns@master] wmnet: Promote dbproxy2008 to m3-codfw master

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

dbproxy2008 is now up

mariadb,FRONTEND,,,0,0,5000,0,0,0,0,0,0,,,,,OPEN,,,,,,,,,1,2,0,,,,0,0,0,0,,,,,,,,,,,0,0,0,,,0,0,0,0,,,,,,,,,,,,,,,,,,,,,tcp,,0,0,0,,0,0,0,,,,,,,,,,,0,,,,,,,,,-,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
mariadb,db2135,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,1,0,0,0,272,0,,1,2,1,,0,,2,0,,0,L7OK,0,0,,,,,,,,,,,0,0,,,,,-1,,,0,0,0,0,,,,Layer7 check passed,,99999999,20,100000018,,,,,,tcp,,,,,,,,0,0,0,,,0,,0,0,0,0,0,0,0,0,1,1,,,,-,0,0,0,,,,,,,,,,,,,,,,,,,,,,
mariadb,db2160:3325,0,0,0,0,,0,0,0,,0,,0,0,0,0,UP,1,0,1,0,0,272,0,,1,2,2,,0,,2,0,,0,L7OK,0,1,,,,,,,,,,,0,0,,,,,-1,,,0,0,0,0,,,,Layer7 check passed,,2,3,4,,,,,,tcp,,,,,,,,0,0,0,,,0,,0,0,0,0,0,0,0,0,1,1,,,,-,0,0,0,,,,,,,,,,,,,,,,,,,,,,
mariadb,BACKEND,0,0,0,0,500,0,0,0,0,0,,0,0,0,0,UP,1,1,1,,0,272,0,,1,2,0,,0,,1,0,,0,,,,,,,,,,,,,,0,0,0,0,0,0,-1,,,0,0,0,0,,,,,,,,,,,,,,tcp,,,,,,,,0,0,0,,,,,0,0,0,0,0,,,,,1,0,0,0,-,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,

Change #1102261 merged by Marostegui:

[operations/software@master] report_users.sh: Add dbproxy2008 IP

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

Change #1102262 merged by Marostegui:

[operations/dns@master] wmnet: Promote dbproxy2008 to m3-codfw master

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