Page MenuHomePhabricator

Migrate an active DC parsercache host to MariaDB 10.6
Closed, ResolvedPublic

Description

Let's get a parsercache host in eqiad to serve traffic.
Probably the easiest would be to migrate pc1014 (spare) and let it serve traffic instead of pc1011. If we need to roll back we can promote pc1011 back to pc1 master.

Event Timeline

Marostegui triaged this task as Medium priority.May 31 2022, 1:25 PM
Marostegui moved this task from Triage to In progress on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2022-06-06T06:38:57Z] <marostegui> Migrate pc1014 to mariadb 10.6.8 T309612

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

[operations/puppet@production] pc1014: Install MariaDB 10.6.8

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

Change 803084 merged by Marostegui:

[operations/puppet@production] pc1014: Install MariaDB 10.6.8

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

I have migrated pc1014 to 10.6.8. Doing a few tests before pooling it to serve traffic.

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

[operations/mediawiki-config@master] ProductionServices.php: Promote pc1014 to pc1 master

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

root@cumin1001:~# db-mysql pc1014 -e "show master status\G"
*************************** 1. row ***************************
            File: pc1014-bin.091037
        Position: 670186528
    Binlog_Do_DB:
Binlog_Ignore_DB:

Change 803088 merged by jenkins-bot:

[operations/mediawiki-config@master] ProductionServices.php: Promote pc1014 to pc1 master

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

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

[operations/puppet@production] pc1011,pc1014: Promote pc1014 to pc1 master

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

Change 803229 merged by Marostegui:

[operations/puppet@production] pc1011,pc1014: Promote pc1014 to pc1 master

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

Mentioned in SAL (#wikimedia-operations) [2022-06-06T07:41:24Z] <marostegui@deploy1002> Synchronized wmf-config/ProductionServices.php: Promote pc1014 to pc1 master T309612 (duration: 02m 53s)

pc1014 is now serving as pc1 master with 10.6.8.
pc1011 has been reconfigured as a slave of pc1014 so the keys aren't lost and once it needs to go back as master it will have the same content.