Let's migrate db1143 (commonswiki) to mariadb 10.6
Description
Description
Details
Details
Related Changes in Gerrit:
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | • Marostegui | T301879 Test MariaDB 10.6 on Bullseye | |||
| Resolved | • Marostegui | T310114 Migrate a s4 DB host to mariadb 10.6 |
Event Timeline
Comment Actions
Change 803742 had a related patch set uploaded (by Marostegui; author: Marostegui):
[operations/puppet@production] db1143: Disable notifications
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2022-06-08T05:47:19Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1143 for migration to 10.6 T310114', diff saved to https://phabricator.wikimedia.org/P29493 and previous config saved to /var/cache/conftool/dbconfig/20220608-054718-root.json
Comment Actions
Change 803742 merged by Marostegui:
[operations/puppet@production] db1143: Disable notifications
Comment Actions
Change 803743 had a related patch set uploaded (by Marostegui; author: Marostegui):
[operations/puppet@production] db1143: Install mariadb 10.6
Comment Actions
Change 803743 merged by Marostegui:
[operations/puppet@production] db1143: Install mariadb 10.6
Comment Actions
db1143 got 10.6, I am doing some traffic captures before starting to pool it in order to catch any major query change it might produce.
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2022-06-08T07:31:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Pool db1143 on s4 with small weight after installing 10.6 T310114', diff saved to https://phabricator.wikimedia.org/P29504 and previous config saved to /var/cache/conftool/dbconfig/20220608-073132-root.json
Comment Actions
Change 803862 had a related patch set uploaded (by Marostegui; author: Marostegui):
[operations/puppet@production] db1143: Enable notifications
Comment Actions
Change 803862 merged by Marostegui:
[operations/puppet@production] db1143: Enable notifications
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2022-06-08T09:13:31Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Pool db1143 on s4 with small weight after installing 10.6 T310114', diff saved to https://phabricator.wikimedia.org/P29514 and previous config saved to /var/cache/conftool/dbconfig/20220608-091331-root.json
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2022-06-09T09:12:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Pool db1143 on s4 with small weight after installing 10.6 T310114', diff saved to https://phabricator.wikimedia.org/P29584 and previous config saved to /var/cache/conftool/dbconfig/20220609-091224-root.json
Comment Actions
So far all the analyzed queries are already reported as slow queries and are happening on 10.4. I have increased its LB weight to the 10% of its original weight in order to capture more traffic.