MariaDB Anyone using MariaDB 10.4.8 on live and busy site?

yeah MariaDB for last few major versions hasn't been offering up benchmarks as much like they use to unfortunately

---

Given how troublesome 10.4 has been, I'd recommend folks hold off of 10.5 until it's gone through at least 20+ minor revision releases and maybe even more given now they have a big plate of work to do for so many major versions they have now.

MariaDB 10.4+ and higher seem one way upgrades not too easy to downgrade or switch to earlier versions or between forks like Oracle MySQL and Percona MySQL. Personally, I'd probably be sticking with MariaDB 10.3 for much longer.

 

Centmin Mod 123.09beta01 and higher support MariaDB 10.4 optional upgrades and eventually will for MariaDB 10.5 MariaDB - MariaDB 10.1 upgrades to MariaDB 10.2, 10.3 and 10.4. but 10.3 is default for stability. The problem is early MariaDB 10.4 and even recent releases have performance regressions which folks may or may not notice (discussed in this thread).

For stable performance, MariaDB 10.3 seems to be the one to use right now. Haven't tested MariaDB 10.5 yet and 10.4 limited tests myself. I've also got far future plans to support Oracle MySQL/Percona MySQL 8.0.x series too which like MariaDB 10.4/10.5, are not drop-in backwards compatible so choosing any of these would/may be one way upgrade/switches.

An example switch script for a paid client of mine wanting to switch Centmin Mod over to Oracle MySQL 8 out of the box

Code (Text):

./switch-mysql8.sh

Usage:

switch-mysql8.sh backup
switch-mysql8.sh check
switch-mysql8.sh swap

Check for backups prior to swapping MariaDB 10.3 YUM packages for Oracle MySQL 8.0 YUM packages

Code (Text):

./switch-mysql8.sh swap

No backup completion file found at /home/mariadb-to-mysql8-backups

Did you backup your MariaDB MySQL databases first ?

Code (Text):

mysqladmin  Ver 8.0.18 for Linux on x86_64 (MySQL Community Server - GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version          8.0.18
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 1 hour 4 min 5 sec

Threads: 2  Questions: 12278  Slow queries: 0  Opens: 347  Flush tables: 3  Open tables: 267  Queries per second avg: 3.193

 

add it to your /etc/my.cnf under the [mariadb-10.4] group and then restart MariaDB 10.4 mysql server

FYI, newer 123.09beta01 and higher builds MariaDB 10.4 upgrade routines already have that set by default i.e.

Code (Text):

[mariadb-10.4]
#innodb_file_format = Barracuda
innodb_default_row_format = dynamic
innodb_file_per_table = 1
# performance regressions
# https://jira.mariadb.org/browse/MDEV-16337
# https://jira.mariadb.org/browse/MDEV-20697
#join_cache_level=0
optimizer_use_condition_selectivity=1

 

Centmin Mod doesn't have MariaDB 10.5 upgrade routine in it's centmin.sh menu yet