Page MenuHomePhabricator

Migrate db_inventory section to MariaDB 10.6
Closed, ResolvedPublic

Description

  • db1115
  • db2093

These hosts have:

+--------------------+
| Database           |
+--------------------+
| heartbeat          |
| information_schema |
| mysql              |
| orchestrator       |
| percona            |
| performance_schema |
| sys                |
| zarcillo           |
| zarcillotest       |
+--------------------+

Event Timeline

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

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

[operations/puppet@production] db2093: Install MariaDB 10.6

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

Mentioned in SAL (#wikimedia-operations) [2023-01-31T09:20:43Z] <marostegui> dbmaint Install MariaDB 10.6 on db2093 (db_inventory) T328408

Change 885278 merged by Marostegui:

[operations/puppet@production] db2093: Install MariaDB 10.6

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

Marostegui added a subscriber: jcrespo.

@jcrespo db2093 has been migrated to 10.6, let me know if the logical backups run fine during the next few days. I don't want to upgrade db1115 (primary master) before we are fine with db2093.

Mentioned in SAL (#wikimedia-operations) [2023-02-06T10:36:37Z] <marostegui> Upgrade db1115 (db_inventory master) to 10.6. T328408

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

[operations/puppet@production] db1115: Migrate to 10.6

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

Change 886838 merged by Marostegui:

[operations/puppet@production] db1115: Migrate to 10.6

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

I am going to leave this open until @jcrespo confirms everything looks good backup-wise