Page MenuHomePhabricator
Create Task
Maniphest T322294

Migrate m5 section to MariaDB 10.6
Closed, ResolvedPublic
Actions

Description

  • db1176
  • db1106
  • db1183
  • db1117
  • db2135
  • db2160

We need a floating host to replace the current master.

Details

SubjectRepoBranchLines +/-
db1176: Migrate it to MariaDB 10.6operations/puppetproduction+1 -0
db1117: Migrate to mariadb 10.6operations/puppetproduction+1 -0
mariadb: Migrate db1106 to mariadb 10.6operations/puppetproduction+1 -0
mariadb: Migrate db1183 to mariadb 10.6operations/puppetproduction+1 -0
mariadb: Migrate db2135 to MariaDB 10.6operations/puppetproduction+1 -0
db2160: Migrate to MariaDB 10.6operations/puppetproduction+1 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

Marostegui created this task.Nov 3 2022, 10:38 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 3 2022, 10:38 AM
Marostegui triaged this task as Medium priority.Nov 3 2022, 10:39 AM
Marostegui moved this task from Triage to Blocked on the DBA board.
Marostegui added a subscriber: • jcrespo.

@jcrespo I think this is blocked on T319383: Mydumper incompatibility with MariaDB 10.6 (was: Logical recoveries (myloader) to db2098:s7 are failing with "Lock wait timeout exceeded; try restarting transaction") as db1117 and db2078 are used to take logical backups, right?

• jcrespo added a comment.Nov 3 2022, 11:36 AM

I would say so- up to you, but I cannot reliably recover a 10.6 host at the moment.

Marostegui added a comment.Nov 3 2022, 12:57 PM

Then yes, let's not proceed with this until that's in a better position

Marostegui moved this task from Blocked to In progress on the DBA board.Mar 13 2023, 6:49 AM

This can now proceed based on T330861#8663313

Marostegui updated the task description. (Show Details)Mar 13 2023, 7:45 AM
gerritbot added a comment.Mar 13 2023, 7:46 AM

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

[operations/puppet@production] db2160: Migrate to MariaDB 10.6

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

gerritbot added a project: Patch-For-Review.Mar 13 2023, 7:46 AM

Change 897768 merged by Marostegui:

[operations/puppet@production] db2160: Migrate to MariaDB 10.6

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

Marostegui updated the task description. (Show Details)Mar 13 2023, 7:54 AM
Maintenance_bot removed a project: Patch-For-Review.Mar 13 2023, 8:10 AM
Marostegui updated the task description. (Show Details)Mar 13 2023, 8:12 AM
Marostegui updated the task description. (Show Details)Mar 13 2023, 2:04 PM
Marostegui mentioned this in T331877: Switchover m5 master (db1176 -> db1106).Mar 13 2023, 2:07 PM
gerritbot added a comment.Mar 14 2023, 7:10 AM

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

[operations/puppet@production] mariadb: Migrate db2135 to MariaDB 10.6

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

gerritbot added a project: Patch-For-Review.Mar 14 2023, 7:10 AM

Change 898456 merged by Marostegui:

[operations/puppet@production] mariadb: Migrate db2135 to MariaDB 10.6

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

Marostegui updated the task description. (Show Details)Mar 14 2023, 7:14 AM
Stashbot added a comment.Mar 14 2023, 7:26 AM

Mentioned in SAL (#wikimedia-operations) [2023-03-14T07:25:59Z] <marostegui> Migrate db1183 to mariadb m5 eqiad dbmaint 10.6 T322294

gerritbot added a comment.Mar 14 2023, 7:26 AM

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

[operations/puppet@production] mariadb: Migrate db1183 to mariadb 10.6

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

gerritbot added a comment.Mar 14 2023, 7:27 AM

Change 898672 merged by Marostegui:

[operations/puppet@production] mariadb: Migrate db1183 to mariadb 10.6

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

Marostegui updated the task description. (Show Details)Mar 14 2023, 7:29 AM
Maintenance_bot removed a project: Patch-For-Review.Mar 14 2023, 7:30 AM
Marostegui updated the task description. (Show Details)Mar 14 2023, 7:30 AM
Marostegui closed subtask T331875: Move db1106 to m5 as Resolved.Mar 14 2023, 9:59 AM
gerritbot added a comment.Mar 15 2023, 5:53 AM

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

[operations/puppet@production] mariadb: Migrate db1106 to mariadb 10.6

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

gerritbot added a project: Patch-For-Review.Mar 15 2023, 5:53 AM
gerritbot added a comment.Mar 15 2023, 6:03 AM

Change 899191 merged by Marostegui:

[operations/puppet@production] mariadb: Migrate db1106 to mariadb 10.6

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

Marostegui updated the task description. (Show Details)Mar 15 2023, 6:05 AM
Maintenance_bot removed a project: Patch-For-Review.Mar 15 2023, 6:10 AM
gerritbot added a comment.Mar 15 2023, 7:24 AM

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

[operations/puppet@production] db1117: Migrate to mariadb 10.6

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

gerritbot added a project: Patch-For-Review.Mar 15 2023, 7:24 AM

Change 899399 merged by Marostegui:

[operations/puppet@production] db1117: Migrate to mariadb 10.6

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

Marostegui updated the task description. (Show Details)Mar 15 2023, 7:28 AM

Migrated db1117 (misc backup source to 10.6). So far it looks like it is being detected fine by haproxy.
To be sure, I will also add the future master (T331877) as standby for a few hours to make sure it is seen just fine too.

Maintenance_bot removed a project: Patch-For-Review.Mar 15 2023, 7:30 AM
Marostegui closed subtask T331877: Switchover m5 master (db1176 -> db1106) as Resolved.Mar 15 2023, 12:19 PM
gerritbot added a comment.Mar 15 2023, 12:22 PM

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

[operations/puppet@production] db1176: Migrate it to MariaDB 10.6

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

gerritbot added a project: Patch-For-Review.Mar 15 2023, 12:22 PM

Change 899575 merged by Marostegui:

[operations/puppet@production] db1176: Migrate it to MariaDB 10.6

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

Marostegui updated the task description. (Show Details)Mar 15 2023, 12:23 PM
Marostegui closed this task as Resolved.Mar 15 2023, 12:27 PM

This is done, pending switching back to db1176 which will be tracked at T332155

Maintenance_bot moved this task from In progress to Done on the DBA board.Mar 15 2023, 12:29 PM
Maintenance_bot removed a project: Patch-For-Review.Mar 15 2023, 12:32 PM
Marostegui closed subtask T332155: Switchover m5 master (db1106 -> db1176) as Resolved.Mar 16 2023, 6:07 AM
Marostegui mentioned this in T356960: Upgrade hosts to MariaDB 10.6.Feb 8 2024, 6:31 AM
Marostegui added a parent task: T356960: Upgrade hosts to MariaDB 10.6.
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 · Credits