Page MenuHomePhabricator

Setup new dbprov hosts and decommission the old ones
Open, HighPublic

Description

Setup

  • dbprov1005
  • dbprov1006
  • dbprov2005
  • dbprov2006

Decom

  • dbprov1001
  • dbprov1002
  • dbprov2001
  • dbprov2002

Event Timeline

Change #1019673 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbprov: Setup dbprov2005

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

Change #1019673 merged by Jcrespo:

[operations/puppet@production] dbprov: Setup dbprov2005

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

Change #1019679 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Migrate s5 codfw snapshots to dbprov2005/db2201

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

Change #1019679 merged by Jcrespo:

[operations/puppet@production] dbbackups: Migrate s5 codfw snapshots to dbprov2005/db2201

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

Change #1019733 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] mariadb: Add dbprov2005 to the list of hosts that can access dbbackups db

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

Change #1019735 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Add dbprov2005 to the list of hosts that can backup m1

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

Change #1019733 merged by Jcrespo:

[operations/puppet@production] mariadb: Add dbprov2005 to the list of hosts with dbbackups db access

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

Mentioned in SAL (#wikimedia-operations) [2024-04-15T13:59:29Z] <jynus> update dbprov2005 dbbackups password T362509

Change #1019815 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] mariadb: Add dbprov2005 to the grants for s*, x* hosts

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

Change #1019816 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] installserver: Setup db and dbprov hosts back to reuse recipe

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

Change #1019816 merged by Jcrespo:

[operations/puppet@production] installserver: Setup db and dbprov hosts back to reuse recipe

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

Change #1020750 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Setup dbprov1005 as new host to send s3 and s5 backups

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

Change #1020750 merged by Jcrespo:

[operations/puppet@production] dbbackups: Setup dbprov1005 as new host to send s3 and s5 backups

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

Change #1021469 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Add dbprov1005 to adding access ddbackups database

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

Change #1021469 merged by Jcrespo:

[operations/puppet@production] dbbackups: Add ddbackups database grant access for dbprov1005

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

Mentioned in SAL (#wikimedia-operations) [2024-04-18T13:47:43Z] <jynus> add grants for dbprov1005 at dbbackups (m1) T362509

Change #1021903 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Add dbprov1005 to the hosts that can dump eqiad backup sources

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

Change #1021903 merged by Jcrespo:

[operations/puppet@production] dbbackups: Add dbprov1005 to the hosts that can dump eqiad backup sources

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

Change #1025695 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Setup dbprov1006 & dbprov2006 and do s4 & s7 dumps there

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

Change #1025695 merged by Jcrespo:

[operations/puppet@production] dbbackups: Setup dbprov1006 & dbprov2006 and do s4 & s7 dumps there

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

Change #1025710 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] mariadb: Upgrade db1150, db1171 and move s4, s7, s8 backups to 10.6

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

Change #1025710 merged by Jcrespo:

[operations/puppet@production] mariadb: Upgrade db1150, db1171 and move s4, s7, s8 backups to 10.6

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

jcrespo triaged this task as High priority.May 9 2024, 9:58 AM

Change #1030896 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Add stats grants for dbprov1006, dbprov2006 at m1:dbbackups

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

Change #1030896 merged by Jcrespo:

[operations/puppet@production] dbbackups: Add stats grants for dbprov1006, dbprov2006 at m1:dbbackups

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

Mentioned in SAL (#wikimedia-operations) [2024-05-13T09:05:57Z] <jynus> deploy new stat grants at m1:dbbackups T362509

Change #1037107 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Migrate s1 backups to MariaDB 10.6

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

Change #1037107 merged by Jcrespo:

[operations/puppet@production] dbbackups: Migrate s1 backups to MariaDB 10.6

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

Change #1038693 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Change correct port for s1 backups

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

Change #1038693 merged by Jcrespo:

[operations/puppet@production] dbbackups: Change correct port for s1 backups

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

Change #1039713 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Drain dbprov1001, dbprov1002, dbprov2001 & dbprov2002

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

Change #1039713 merged by Jcrespo:

[operations/puppet@production] dbbackups: Drain dbprov1001, dbprov1002, dbprov2001 & dbprov2002

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