MariaDB 10.4+ Upgrades Testing

The initial for Centmin Mod 130.00beta01 on EL8+ OSes is to still support MariaDB MySQL server major version release upgrades via centmin.sh menu option 11 as outlined at https://community.centminmod.com/threads/mariadb-10-1-upgrades-to-mariadb-10-2-10-3-and-10-4.17793/.

Right now MariaDB 10.3 is the default in 130.00beta01 for out of the box installations. But you can override this version provided the appropriate hidden variable enablement flags are set first via the persistent config file /etc/centminmod/custom_config.inc for either:

1. Initial install time or
2. Upgrade via centmin.sh menu option 11 after initial installation.

Both methods need testing during this beta testing too

Initial Install Default Override

For the initial install override, you'd have the following relevant variables to set in the persistent config file /etc/centminmod/custom_config.inc BEFORE initial Centmin Mod install. Any issues with this, I'd need the initial install logs for inspection as per https://community.centminmod.com/threads/how-to-troubleshoot-centmin-mod-initial-install-issues.102/

So for MariaDB 10.4 default

Code (Text):

MARIADB_INSTALLTENTHREE='n'
MARIADB_INSTALLTENFOUR='y'
MARIADB_INSTALLTENFIVE='n'
MARIADB_INSTALLTENSIX='n'

for MariaDB 10.5 default

Code (Text):

MARIADB_INSTALLTENTHREE='n'
MARIADB_INSTALLTENFOUR='n'
MARIADB_INSTALLTENFIVE='y'
MARIADB_INSTALLTENSIX='n'

for MariaDB 10.6 default

Code (Text):

MARIADB_INSTALLTENTHREE='n'
MARIADB_INSTALLTENFOUR='n'
MARIADB_INSTALLTENFIVE='n'
MARIADB_INSTALLTENSIX='y'

For Post Initial Install Upgrades

For upgrading MariaDB 10.3 default after the initial install, you have the following 3 variables to be set in the persistent config file /etc/centminmod/custom_config.inc BEFORE running centmin.sh menu option 11. Any issues, I'd need the MariaDB upgrade logs for inspecting which will be automatically saved at /root/centminlogs. You can use the below outlined cminfo listlogs command to find the log name quickly.

Code (Text):

ENABLE_MARIADBTENFOURUPGRADE='y'
ENABLE_MARIADBTENFIVEUPGRADE='y'
ENABLE_MARIADBTENSIXUPGRADE='y'

You can't skip major versions when upgrading. So to upgrade to MariaDB 10.6, you need to upgrade from 10.3 to 10.4, then 10.4 to 10.5 and then 10.5 to 10.6.

cminfo listlogs

cminfo command has many useful tools, one is the listlogs command

Code (Text):

cminfo listlogs

Running this command will list all auto saved logs at /root/centminlogs in date timestamp ascending order (latest logs are listed last).

So to find MariaDB upgrade logs from centmin.sh menu option 11 runs are easy.

Code (Text):

cminfo listlogs | grep mariadb
-rw-r--r--  1 root root    63 Oct 15  2020 centminmod_123.09beta01.b603_151020-233804_mariadb_10-1-to-10-2_upgrade.log
-rw-r--r--  1 root root   17K Oct 15  2020 centminmod_123.09beta01.b603_151020-233923_mariadb_10-1-to-10-2_upgrade.log
-rw-r--r--  1 root root   35K Oct 16  2020 centminmod_123.09beta01.b604_161020-010547_mariadb_10-2-to-10-3_upgrade.log

So centmin.sh menu option 11 run for MariaDB 10.2 to 10.3 upgrade on 123.09beta01.b604 increment version has a file name = centminmod_123.09beta01.b604_161020-010547_mariadb_10-2-to-10-3_upgrade.log located at /root/centminlogs/centminmod_123.09beta01.b604_161020-010547_mariadb_10-2-to-10-3_upgrade.log

On AlmaLinux 8 with Centmin Mod 13000beta01 upgrade runs from centmin.sh menu option 11 for submenu options 8, 9 and 10 for 10.3 to 10.4, 10.4 to 10.5 and 10.5 to 10.6 upgrades.

Code (Text):

cminfo listlogs | grep mariadb
-rw-r--r--. 1 root root   42 Sep 22 17:08 centminmod_130.00beta01.b203_220922-170805_mariadb_10-3-to-10-4_upgrade.log
-rw-r--r--. 1 root root  31K Sep 22 17:18 centminmod_130.00beta01.b204_220922-171640_mariadb_10-3-to-10-4_upgrade.log
-rw-r--r--. 1 root root  33K Sep 22 17:21 centminmod_130.00beta01.b204_220922-171937_mariadb_10-4-to-10-5_upgrade.log
-rw-r--r--. 1 root root  33K Sep 22 17:24 centminmod_130.00beta01.b204_220922-172230_mariadb_10-5-to-10-6_upgrade.log

To find the initial install log, it would usually be the very first entry named *_install.log in the date ascending listing.

Code (Text):

cminfo listlogs | grep _install.log | head -n1

Example of centmin.sh menu option 11 MariaDB 10.3 to 10.4 to 10.5 to 10.6 final update

Code (Text):

mysqladmin ver
mysqladmin  Ver 9.1 Distrib 10.6.10-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.6.10-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 1 min 14 sec

Threads: 1  Questions: 2  Slow queries: 0  Opens: 17  Open tables: 10  Queries per second avg: 0.027

Code (Text):

rpm -qa MariaDB-* galera-*

MariaDB-common-10.6.10-1.el8.x86_64
MariaDB-server-10.6.10-1.el8.x86_64
galera-4-26.4.12-1.el8.x86_64
MariaDB-devel-10.6.10-1.el8.x86_64
MariaDB-compat-10.6.10-1.el8.x86_64
MariaDB-client-10.6.10-1.el8.x86_64
MariaDB-shared-10.6.10-1.el8.x86_64

Code (Text):

mysqlstatus
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB 10.6.10 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf, notifyaccess.conf, openfileslimit.conf, protecthome.conf
   Active: active (running) since Thu 2022-09-22 17:24:36 UTC; 7min ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 515829 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 8 (limit: 24752)
   Memory: 40.2M
   CGroup: /system.slice/mariadb.service
           └─515829 /usr/sbin/mariadbd

Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] InnoDB: 10.6.10 started; log sequence number 1637412; transaction id 39
Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] Plugin 'FEEDBACK' is disabled.
Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] InnoDB: Buffer pool(s) load completed at 220922 17:24:36
Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] Server socket created on IP: '0.0.0.0'.
Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] Server socket created on IP: '::'.
Sep 22 17:24:36 build.domain.com mariadbd[515829]: 2022-09-22 17:24:36 0 [Note] /usr/sbin/mariadbd: ready for connections.
Sep 22 17:24:36 build.domain.com mariadbd[515829]: Version: '10.6.10-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
Sep 22 17:24:36 build.domain.com systemd[1]: Started MariaDB 10.6.10 database server.

---

 

Made it slightly easier to test EL8 based Centmin Mod 130.00beta01 with default MariaDB 10.4+ with specific installers for it as well for testing in light of https://community.centminmod.com/threads/official-mariadb-10-3-yum-repo-eol-may-25-2023.23756/.

Similar to https://community.centminmod.com/th...-mod-on-almalinux-8-rocky-linux-8-oses.23261/ initial installs, just specific installers for:

MariaDB 10.4 default with PHP 8.0 default

Code (Text):

yum -y update
curl -4sL https://centminmod.com/installer-el8x-mariadb10.4.sh -o installer-el8x-mariadb10.4.sh; bash installer-el8x-mariadb10.4.sh

MariaDB 10.5 default with PHP 8.0 default

Code (Text):

yum -y update
curl -4sL https://centminmod.com/installer-el8x-mariadb10.5.sh -o installer-el8x-mariadb10.5.sh; bash installer-el8x-mariadb10.5.sh

MariaDB 10.6 default with PHP 8.0 default

Code (Text):

yum -y update
curl -4sL https://centminmod.com/installer-el8x-mariadb10.6.sh -o installer-el8x-mariadb10.6.sh; bash installer-el8x-mariadb10.6.sh