Mariadb 10.5.x Support has Expired - How to Upgrade Manually ?

[Andrew C]

Hello,

My current CWP install has mariadb 10.5.27.

And I correct in thinking mariadb 10.5.x support has expired recently ?

Do the developers have any plans to update mariadb to 10.11 or possibly 11.x any time soon in an update preserving database contents ?

Or do the developers and or anyone in the community have a set of working instruction on how to update mariadb to 10.11 or possibly 11.x for Almalinux 9.5 that does not break the CWP install ?

Thanks.

[Starburst]

MariaDB 10.11 is a LTS version

MariaDB after 11.4 changed some commands, and hasn't been tested with CWP yet.



Here's how to upgrade it manually.
Make sure to follow every step, or it will fail.

https://starburst.help/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-with-cwp-on-almalinux-9/

[overseer]

Here's a good matrix of support windows for MariaDB versions. I am running MariaDB 10.11 LTS across all my servers. (11.x branch will wait for another day...)
https://endoflife.date/mariadb

[Starburst]

Interesting how 11.8 LTS ends before 11.4 LTS does.

But that's also when they implemented their 'Enterprise' paid support.

What I noticed in testing 11.4, it was running in compatibility mode because of some of the commands coming from CWP to MariaDB.
I think I mentioned that in another thread long ago, that CWP will have to update the coding, but then could to be backwards compatible to prior MariaDB versions.

But they have until the end of Q2 2029 to figure that one out.

[Andrew C]

I'm running AlmaLinux 9.5.x

Are mariadb 10.11.x LTS and 11.4.x LTS both suitable for CWP in production ?

And do the above upgrade instructions work for both versions of mariadb ?

If I installed a fresh copy of CWP which version of MariaDB would be installed by default today?

Thanks.

[overseer]

It's your choice to use either 10.11.x or 11.4.x -- both are LTS versions and both are suitable for use with CWP in a production setting. Here is a guide for updating EL7, EL8 or EL9 distributions to 10.11:
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/
(I was using 10.11 on my servers up until recently when Starburst assured that 11.4 offers full compatibility with CWP and full backwards compatibility with previous versions SQL syntax.)

[Andrew C]

Thanks for the mariadb upgrade instructions.

The first step is to remove the old version of the mariadb.

Before doing that surely the running websites on the cwp server need shutting down somehow etc... ? How can that be done easily ?

Or do you just follow the instructions step by step and remove mariadb with the website running ? That does not seem to be a safe way to proceed ?

Thanks.

[Starburst]

Just FOLLOW that guide Step By Step, and do NOT deviate from it, and you will be fine.

Nothing else needs to be done.

If you start deviating from it, then all hell will break loose, and you will corrupt your server.

That being said, you should always make a snapshot/backup of your server BEFORE any upgrades.

[overseer]

And just to reassure you, Sandeep over at AlphaGNU is a CWP developer, so he is offering you good advice if you choose the 10.11.x upgrade. As he confirms at the beginning of his guide, you are simply removing the MariaDB server & client applications, not your DB info. So you should only be facing 2-5 min of total downtime with your sites as you execute the upgrade process.

[Andrew C]

The web apps I'm running recommended mariadb 11.4 over 10.11 so I decided to go with 11.4.

I followed the instructions step by step and it installed fine - no observable errors so far.

All websites appear to be running normally but noticeably faster on the same hardware which is a bonus.

The only thing I have observed is that on the CWP dashboard the database is now reporting 15.2 and not 11.4. Whereas it was reporting 10.5.x before the upgrade. Do you observe the same thing on your servers ?

However the web apps correctly identify mariadb 11.4 and they appear to be working normally.

Thanks to everyone for your help.

[Starburst]

That is correct, in MariaDB 11.x they changed the line to show the whole DB version.

To check from the CLI:

Code Select Expand

mariadb --version

[Andrew C]

The output from mariadb --version is
mariadb from 11.4.8-MariaDB, client 15.2 for Linux (x86_64) using  EditLine wrapper

Therefore the CWP dashboard, bottom left is reporting the client version 15.2 and not the mariadb version 11.4.8

Is that a bug or is it by design ?

Thanks.

[overseer]

Seems to be a bug or by design -- my servers (running 11.4. report 15.2 in the dashboard as well. (And yes, the MySQL nomenclature is deprecated as well -- in future versions it will always be referred to as mariadb -- all binaries and tools.)