| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | MoritzMuehlenhoff | T213527 Prepare our base system layer for Debian buster | |||
| Resolved | Marostegui | T193224 Evaluate and decide the future of relational datastore at WMF after the upgrade of MariaDB 10.1 is finished | |||
| Resolved | jcrespo | T193226 Test MySQL 8.0 with production data and evaluate its fit for WMF databases | |||
| Resolved | Marostegui | T243081 Make Percona 8 report the basics on tendril | |||
| Resolved | jcrespo | T243265 Check why compare.py doesn't work with Percona 8.0 |
Change 449120 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] Test MariaDB 10.3 on core test hosts
Change 449120 merged by Jcrespo:
[operations/puppet@production] Test MariaDB 10.3 on core test hosts
Change 449196 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Test MariaDB 10.3 on db1118 (core test host)
Change 449196 merged by Jcrespo:
[operations/puppet@production] mariadb: Test MariaDB 10.3 on db1118 (core test host)
Change 449234 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Better support MariaDB 10.2 and 10.3 config on production
Change 449413 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] Test MySQL 8.0.12 on test-s1 host db1118
Change 449413 merged by Jcrespo:
[operations/puppet@production] Test MySQL 8.0.12 on test-s1 host db1118
Change 449234 merged by Jcrespo:
[operations/puppet@production] mariadb: Better support MariaDB 10.2 and 10.3 config on production
Change 494236 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Change the default arguments for buster
Change 494469 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] install_server: Reimage db1114 to buster
Change 494469 merged by Jcrespo:
[operations/puppet@production] install_server: Reimage db1114 to buster
Change 494236 merged by Jcrespo:
[operations/puppet@production] mysqld-prometheus-exporter: Change the default arguments for buster
Change 494759 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mysqld-prometheus-exporter: Fix typo on configuration
Change 494759 merged by Jcrespo:
[operations/puppet@production] mysqld-prometheus-exporter: Fix typo on configuration
Change 519066 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Upgrade db1114 (testing buster host) to MariaDB 10.3
Change 519066 merged by Jcrespo:
[operations/puppet@production] mariadb: Upgrade db1114 (testing buster host) to MariaDB 10.3
db1114: Version 10.3.16-MariaDB-log, Uptime 937s, read_only: True, 122.17 QPS, connection latency: 0.003587s, query latency: 0.000728s
Change 519073 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Prepare core for buster
Nice! Is it replicating from the master? It would be nice to let it replicate for a few weeks and see if we get some unexpected issues
Nice! Is it replicating from the master?
It is, although tendril doesn't seem to like it.
@jcrespo you ok if I copy dewiki.logging into db1114? I would like to see the behaviour of 10.3 optimizer in regards to the query planner bug observed at T71222: list=logevents slow for users with last log action long time ago
@jcrespo you ok if I copy dewiki.logging into db1114
Sure, if you do it in its own separate schema.
Ping @Anomie We have temporarily setup db1114 with MariaDB 10.3 and load it with an up-to-date replica of enwiki. While we will do proper regression testing if we decide to go for 10.3, we are notifying you in case that may help testing some of the other specific problematic queries to see if they do better in this version and/or give us any feedback. Note this testing is temporary, as db1114's real purpose is to test backups, not Mediawiki.
Other interesting features people may want to play/experiment with:
Change 519073 merged by Jcrespo:
[operations/puppet@production] mariadb: Prepare core for buster
Change 550647 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb-client: Install 10.4 on buster, unblock os upgrade
Change 550647 merged by Jcrespo:
[operations/puppet@production] mariadb-client: Install 10.4 on buster, unblock os upgrade
db1107 is now running the latest 10.3.20 from MariaDB replicating from s1 master and db1114 (which runs percona-server 8.0) replicates from it.
Change 554240 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] mariadb: Add wmf-mariadb104 as a possibility
Change 554240 merged by Marostegui:
[operations/puppet@production] mariadb: Add wmf-mariadb104,percona 8.0 as a possibility
Change 561264 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/software@master] control-mariadb*: Upgrade version
Change 561264 merged by jenkins-bot:
[operations/software@master] control-mariadb*: Upgrade version
Change 575483 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mariadb: Add example percona configuration for a core host
Change 575483 merged by Jcrespo:
[operations/puppet@production] mariadb: Add example percona configuration for a core host
Change 575496 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] mysql: Fix mysql server configuration for the percona flavour
Change 575496 merged by Jcrespo:
[operations/puppet@production] mysql: Fix mysql server configuration for the percona flavour
As per meetings, the decision was: no decision. Closing this in favour of the epic T250666.