Page MenuHomePhabricator
Create Task
Maniphest T337812

Productionize dbproxy10[22-27]
Closed, ResolvedPublic
Actions

Description

  • dbproxy1022 to replace dbproxy1012 (m1) A6
  • dbproxy1023 to replace dbproxy1013 (m2) B6
  • dbproxy1024 to replace dbproxy1014 (m1) C6
  • dbproxy1025 to replace dbproxy1015 (m2) D6
  • dbproxy1026 to replace dbproxy1016 (m3) E1
  • dbproxy1027 to replace dbproxy1017 (m5) F1

Details

SubjectRepoBranchLines +/-
dbproxy1027: Remove commentsoperations/puppetproduction+0 -1
dbproxy1027: Enable notificationsoperations/puppetproduction+0 -1
wmnet: Failover m5-masteroperations/dnsmaster+1 -1
wmnet: Failover m2-master to dbproxy1025operations/dnsmaster+1 -1
dbproxy1025: Enable notificationsoperations/puppetproduction+0 -1
dbproxy1024: Enable notificationsoperations/puppetproduction+0 -1
wmnet: Failover m1-masteroperations/dnsmaster+1 -1
production-m5.sql.erb: Add dbproxy1027operations/puppetproduction+34 -34
dbproxy1026: Disable notificationsoperations/puppetproduction+1 -2
wmnet: Failover m3-masteroperations/dnsmaster+1 -1
mariadb: Productionize dbproxy1027operations/puppetproduction+8 -7
report_users.sh: Add dbproxy1027operations/softwaremaster+1 -1
report_users.sh: Add dbproxy1026operations/softwaremaster+1 -1
production-m3.sql: Replace dbproxy1016 with dbproxy1026operations/puppetproduction+27 -27
mariadb: Productionize dbproxy1026operations/puppetproduction+7 -3
production-m2.sql.erb: Add dbproxy1025operations/puppetproduction+40 -40
report_users.sh: Add dbproxy1025operations/softwaremaster+1 -1
mariadb: Productionize dbproxy1025operations/puppetproduction+8 -3
dbproxy1023: Enable notificationsoperations/puppetproduction+0 -2
report_users: Add dbproxy1023operations/softwaremaster+1 -1
wmnet: Failover m2-masteroperations/dnsmaster+1 -1
production-m2.sql.erb: Add dbproxy1023operations/puppetproduction+0 -0
production-m2.sql.erb: Add dbproxy1023operations/puppetproduction+40 -40
mariadb: Productionize dbproxy1023operations/puppetproduction+9 -3
production-m1.sql.erb: Add dbproxy1024 IPoperations/puppetproduction+22 -22
dbproxy1022: Enable notificationsoperations/puppetproduction+0 -2
wmnet: Failover m1 masteroperations/dnsmaster+1 -1
report_users.sh: Add dbproxy1024operations/softwaremaster+1 -5
mariadb: Productionize dbproxy1024operations/puppetproduction+8 -3
production-m1.sql.erb: Replace dbproxy1012 with dbproxy1022operations/puppetproduction+17 -17
report_users.sh: Add dbproxy1022operations/softwaremaster+2 -2
site.pp: Remove dbproxy1022 from insetupoperations/puppetproduction+1 -1
dbproxy1022: Productionizeoperations/puppetproduction+8 -2
Show related patches Customize query in gerrit

Related Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
gerritbot added a project: Patch-For-Review.Jun 27 2023, 5:09 AM
gerritbot added a comment.Jun 27 2023, 5:11 AM

Change 933215 merged by Marostegui:

[operations/puppet@production] production-m1.sql.erb: Replace dbproxy1012 with dbproxy1022

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

gerritbot added a comment.Jun 27 2023, 5:13 AM

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

[operations/puppet@production] mariadb: Productionize dbproxy1024

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

gerritbot added a comment.Jun 27 2023, 5:27 AM

Change 933216 merged by Marostegui:

[operations/puppet@production] mariadb: Productionize dbproxy1024

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

Maintenance_bot removed a project: Patch-For-Review.Jun 27 2023, 5:30 AM
gerritbot added a comment.Jun 27 2023, 6:19 AM

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

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

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

gerritbot added a project: Patch-For-Review.Jun 27 2023, 6:19 AM

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

[operations/dns@master] wmnet: Failover m1 master

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

gerritbot added a comment.Jun 27 2023, 6:21 AM

Change 933225 merged by jenkins-bot:

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

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

gerritbot added a comment.Jun 27 2023, 6:21 AM

Change 933226 merged by Marostegui:

[operations/dns@master] wmnet: Failover m1 master

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

Stashbot added a comment.Jun 27 2023, 6:22 AM

Mentioned in SAL (#wikimedia-operations) [2023-06-27T06:22:07Z] <marostegui> Failover m1-master to dbproxy1022 T337812

gerritbot added a comment.Jun 27 2023, 6:26 AM

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

[operations/puppet@production] dbproxy1022: Enable notifications

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

Marostegui updated the task description. (Show Details)Jun 27 2023, 6:26 AM

dbproxy1022 is now m1-master

gerritbot added a comment.Jun 27 2023, 6:27 AM

Change 933228 merged by Marostegui:

[operations/puppet@production] dbproxy1022: Enable notifications

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

Maintenance_bot removed a project: Patch-For-Review.Jun 27 2023, 6:30 AM
gerritbot added a comment.Jun 27 2023, 6:30 AM

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

[operations/puppet@production] production-m1.sql.erb: Add dbproxy1024 IP

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

gerritbot added a project: Patch-For-Review.Jun 27 2023, 6:30 AM
gerritbot added a comment.Jun 27 2023, 6:33 AM

Change 933235 merged by Marostegui:

[operations/puppet@production] production-m1.sql.erb: Add dbproxy1024 IP

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

Marostegui added a comment.Jun 27 2023, 6:37 AM

dbproxy1024 is ready, pending testing it as a master

gerritbot added a comment.Jun 27 2023, 6:38 AM

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

[operations/puppet@production] mariadb: Productionize dbproxy1023

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

gerritbot added a comment.Jun 27 2023, 6:39 AM

Change 933322 merged by Marostegui:

[operations/puppet@production] mariadb: Productionize dbproxy1023

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

gerritbot added a comment.Jun 27 2023, 6:41 AM

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

[operations/software@master] report_users: Add dbproxy1023

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

gerritbot added a comment.Jun 27 2023, 6:43 AM

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

[operations/puppet@production] production-m2.sql.erb: Add dbproxy1023

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

gerritbot added a comment.Jun 27 2023, 7:02 AM

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

[operations/puppet@production] production-m2.sql.erb: Add dbproxy1023

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

gerritbot added a comment.Jun 27 2023, 7:04 AM

Change 933381 merged by Marostegui:

[operations/puppet@production] production-m2.sql.erb: Add dbproxy1023

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

gerritbot added a comment.Jun 27 2023, 7:06 AM

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

[operations/dns@master] wmnet: Failover m3-master

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

gerritbot added a comment.Jun 27 2023, 7:51 AM

Change 933373 merged by Marostegui:

[operations/puppet@production] production-m2.sql.erb: Add dbproxy1023

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

Stashbot added a comment.Jun 27 2023, 8:29 AM

Mentioned in SAL (#wikimedia-operations) [2023-06-27T08:29:11Z] <marostegui> Failover m2-master to dbproxy1022 T337812

gerritbot added a comment.Jun 27 2023, 8:30 AM

Change 933382 merged by Marostegui:

[operations/dns@master] wmnet: Failover m2-master

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

gerritbot added a comment.Jun 27 2023, 8:30 AM

Change 933372 merged by jenkins-bot:

[operations/software@master] report_users: Add dbproxy1023

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

Marostegui added a comment.Jun 27 2023, 8:58 AM

dbproxy1023 is now m2-master

gerritbot added a comment.Jun 27 2023, 8:58 AM

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

[operations/puppet@production] dbproxy1023: Enable notifications

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

gerritbot added a comment.Jun 27 2023, 8:59 AM

Change 933389 merged by Marostegui:

[operations/puppet@production] dbproxy1023: Enable notifications

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

Marostegui updated the task description. (Show Details)Jun 27 2023, 8:59 AM
Maintenance_bot removed a project: Patch-For-Review.Jun 27 2023, 9:12 AM
gerritbot added a comment.Jun 27 2023, 9:13 AM

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

[operations/puppet@production] mariadb: Productionize dbproxy1025

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

gerritbot added a project: Patch-For-Review.Jun 27 2023, 9:13 AM

Change 933393 merged by Marostegui:

[operations/puppet@production] mariadb: Productionize dbproxy1025

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

gerritbot added a comment.Jun 27 2023, 9:15 AM

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

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

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

gerritbot added a comment.Jun 27 2023, 9:17 AM

Change 933395 merged by jenkins-bot:

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

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

gerritbot added a comment.Jun 27 2023, 9:18 AM

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

[operations/puppet@production] production-m2.sql.erb: Add dbproxy1025

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

Marostegui added a comment.Jun 27 2023, 9:21 AM
In T337812#8966392, @Marostegui wrote:

dbproxy1024 is ready, pending testing it as a master

Same for dbproxy1025

gerritbot added a comment.Jun 27 2023, 9:23 AM

Change 933396 merged by Marostegui:

[operations/puppet@production] production-m2.sql.erb: Add dbproxy1025

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

Maintenance_bot removed a project: Patch-For-Review.Jun 27 2023, 9:30 AM
Marostegui updated the task description. (Show Details)Jun 27 2023, 11:01 AM
gerritbot added a comment.Jun 27 2023, 12:29 PM

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

[operations/puppet@production] mariadb: Productionize dbproxy1026

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

gerritbot added a project: Patch-For-Review.Jun 27 2023, 12:29 PM

Change 933443 merged by Marostegui:

[operations/puppet@production] mariadb: Productionize dbproxy1026

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

gerritbot added a comment.Jun 27 2023, 12:34 PM

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

[operations/puppet@production] production-m3.sql: Replace dbproxy1016 with dbproxy1026

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

gerritbot added a comment.Jun 27 2023, 12:35 PM

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

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

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

gerritbot added a comment.Jun 27 2023, 12:36 PM

Change 933445 merged by Marostegui:

[operations/puppet@production] production-m3.sql: Replace dbproxy1016 with dbproxy1026

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

gerritbot added a comment.Jun 27 2023, 12:37 PM

Change 933446 merged by jenkins-bot:

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

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

Marostegui updated the task description. (Show Details)Jun 27 2023, 12:37 PM
gerritbot added a comment.Jun 27 2023, 12:45 PM

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

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

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

gerritbot added a comment.Jun 27 2023, 12:46 PM

Change 933448 merged by jenkins-bot:

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

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

gerritbot added a comment.Jun 27 2023, 12:47 PM

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

[operations/puppet@production] mariadb: Productionize dbproxy1027

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

gerritbot added a comment.Jun 27 2023, 12:48 PM

Change 933450 merged by Marostegui:

[operations/puppet@production] mariadb: Productionize dbproxy1027

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

Marostegui updated the task description. (Show Details)Jun 27 2023, 12:51 PM
gerritbot added a comment.Jun 27 2023, 12:57 PM

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

[operations/dns@master] wmnet: Failover m3-master

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

Stashbot added a comment.Jun 27 2023, 12:57 PM

Mentioned in SAL (#wikimedia-operations) [2023-06-27T12:57:23Z] <marostegui> Failover m3-master to dbproxy1026 T337812

gerritbot added a comment.Jun 27 2023, 12:58 PM

Change 933454 merged by Marostegui:

[operations/dns@master] wmnet: Failover m3-master

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

gerritbot added a comment.Jun 27 2023, 1:00 PM

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

[operations/puppet@production] dbproxy1026: Disable notifications

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

gerritbot added a comment.Jun 27 2023, 1:01 PM

Change 933455 merged by Marostegui:

[operations/puppet@production] dbproxy1026: Disable notifications

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

Maintenance_bot removed a project: Patch-For-Review.Jun 27 2023, 1:11 PM
Marostegui updated the task description. (Show Details)Jun 27 2023, 1:32 PM
gerritbot added a comment.Jun 28 2023, 6:37 AM

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

[operations/puppet@production] production-m5.sql.erb: Add dbproxy1027

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

gerritbot added a project: Patch-For-Review.Jun 28 2023, 6:37 AM
Marostegui updated the task description. (Show Details)Jun 28 2023, 6:39 AM
gerritbot added a comment.Jun 28 2023, 6:39 AM

Change 933847 merged by Marostegui:

[operations/puppet@production] production-m5.sql.erb: Add dbproxy1027

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

gerritbot added a comment.Jun 28 2023, 6:40 AM

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

[operations/dns@master] wmnet: Failover m1-master

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

gerritbot added a comment.Jun 28 2023, 6:41 AM

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

[operations/puppet@production] dbproxy1024: Enable notifications

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

gerritbot added a comment.Jun 28 2023, 6:41 AM

Change 933848 merged by Marostegui:

[operations/dns@master] wmnet: Failover m1-master

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

gerritbot added a comment.Jun 28 2023, 6:42 AM

Change 933849 merged by Marostegui:

[operations/puppet@production] dbproxy1024: Enable notifications

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

Stashbot added a comment.Jun 28 2023, 6:42 AM

Mentioned in SAL (#wikimedia-operations) [2023-06-28T06:42:24Z] <marostegui> Failover m1-master to dbproxy1024 T337812

Marostegui updated the task description. (Show Details)Jun 28 2023, 6:43 AM
gerritbot added a comment.Jun 28 2023, 6:48 AM

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

[operations/dns@master] wmnet: Failover m2-master to dbproxy1025

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

gerritbot added a comment.Jun 28 2023, 6:54 AM

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

[operations/puppet@production] dbproxy1025: Enable notifications

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

gerritbot added a comment.Jun 28 2023, 6:54 AM

Change 933851 merged by Marostegui:

[operations/puppet@production] dbproxy1025: Enable notifications

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

Stashbot added a comment.Jun 28 2023, 8:07 AM

Mentioned in SAL (#wikimedia-operations) [2023-06-28T08:07:21Z] <marostegui> Failover m2-master to dbproxy1025 T337812

gerritbot added a comment.Jun 28 2023, 8:07 AM

Change 933850 merged by Marostegui:

[operations/dns@master] wmnet: Failover m2-master to dbproxy1025

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

Marostegui updated the task description. (Show Details)Jun 28 2023, 8:11 AM
gerritbot added a comment.Jun 28 2023, 8:14 AM

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

[operations/dns@master] wmnet: Failover m5-master

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

gerritbot added a comment.Jun 28 2023, 8:15 AM

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

[operations/puppet@production] dbproxy1027: Enable notifications

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

gerritbot added a comment.Jun 28 2023, 8:15 AM

Change 933857 merged by Marostegui:

[operations/dns@master] wmnet: Failover m5-master

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

Stashbot added a comment.Jun 28 2023, 8:15 AM

Mentioned in SAL (#wikimedia-operations) [2023-06-28T08:15:40Z] <marostegui> Failover m5-master to dbproxy1027 T337812

gerritbot added a comment.Jun 28 2023, 8:15 AM

Change 933858 merged by Marostegui:

[operations/puppet@production] dbproxy1027: Enable notifications

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

Maintenance_bot removed a project: Patch-For-Review.Jun 28 2023, 8:31 AM
Marostegui updated the task description. (Show Details)Jun 29 2023, 5:15 AM
gerritbot added a comment.Jun 29 2023, 5:16 AM

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

[operations/puppet@production] dbproxy1027: Remove comments

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

gerritbot added a project: Patch-For-Review.Jun 29 2023, 5:16 AM
gerritbot added a comment.Jun 29 2023, 5:26 AM

Change 934037 merged by Marostegui:

[operations/puppet@production] dbproxy1027: Remove comments

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

Marostegui closed this task as Resolved.Jun 29 2023, 5:29 AM

This is all done. Pending is the decommissioning which I will track in a different task

Maintenance_bot removed a project: Patch-For-Review.Jun 29 2023, 5:30 AM
Maintenance_bot moved this task from In progress to Done on the DBA board.Jun 29 2023, 6:15 AM
akosiaris mentioned this in T340843: WikiKube: Investigate how to abstract misc Mariadb clusters host/ip information so that no deployment of apps is needed when a master is failed over.Jun 30 2023, 1:17 PM
Marostegui mentioned this in T341117: cxserver: Section Mapping Database (m5) not accessible by certain region.Jul 5 2023, 9:41 AM
Marostegui closed subtask T341121: Decommission dbproxy10[12-17] as Resolved.Nov 2 2023, 8:07 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL