cPanel & WHM Version 92 has been released, and brings a slew of great updates. Take a look at what is included, and then upgrade today!

Maria 10.4 support

Nuno shared this idea 21 months ago
Not Planned

As a Database Administrator, I would like to have support for MariaDB 10.4 so that I can upgrade my existing database server.


I know it's still in BETA at the moment, but I want to make sure this request is logged and that it can be implemented as soon as it's possible.

10.4 will bring several improvements, as always, and some of them are of my interest. :)

Best Answer
photo

The issues that have been experienced with recent MariaDB releases have caused notable concern in terms of impact for our customers. As a result of this, we are spending some time investigating our options which is in part why it’s taken an extended amount of time to deliver the next MariaDB upgrade. At this time we plan to skip MariaDB 10.4 and begin offering MariaDB 10.5 in 2021.

Comments (20)

photo
2

Is there any ETA for this request?MariaDB has already started on the development of 10.5.

photo
1

We don't have an ETA yet. If you follow this topic, you'll be the first to know.

photo
1

I don't see an upgrade option for MariaDB in v85.9999.61, does that mean it will not be avialable in v86? ;-(

photo
1

mariadb 10.4 support is not yet scheduled.

photo
2

MySQL 8 is coming to cPanel in v88, what about MariaDB 10.4 and 10.5?

photo
photo
1

I have already installed mariadb latest version on server from the instructions given in mariadb.com:

[root@host ~]# mariadb --versionmariadb

Ver 15.1 Distrib 10.4.8-MariaDB, for Linux (x86_64) using readline 5.1


The server seems to get "wings" after this update.


BUT...

Restore accounts is not working from within WHM.

It keeps failing as db mismatch without any reason.

photo
1

Have you opened a ticket for this issue yet? We've been away at the WebPros Summit and are just getting caught up.

photo
1

I already did that. Their response:

Thank you for your reply. Unfortunately, since the custom installation of MariaDB 10.4 is preventing the cPanel-provided restoration tools from working, the amount of assistance we can provide regarding this issue will be limited.

The reason that it still tries to connect to MySQL is to ensure the proper grants are configured for the cPanel user and any sub-users, though the MySQL data isn't being restored per the option.


MariaDB 10.4 may be supported in the future though I can't offer a guarantee and don't have much information to provide on it at this point. We have a feature request here if you'd like to weigh in with a comment and add your vote: https://features.cpanel.net/topic/maria-10-4-support (this topic)


For now, restoring the data would require unpacking the .tar.gz file manually from within the /home2/backup directory.

photo
2

Of course it is not their fault, but as you can see, I need urgently this update.

photo
2

Count me in on this one. MariaDB is the default db choice for WHM and has been for a while now if I'm not mistaken - it only makes sense to try and stay current with their stable releases. I briefly looked over the changes from 10.3 to 10.4 and I remember it saying something about the users is different now which may or may not cause an issue and require changes. Looking forward to this one.

photo
photo
2

MariaDB just published 10.5.0 so I opened a request for that version as well: https://features.cpanel.net/topic/mariadb-10-5-support

Thank you for voting :-)

photo
1

Hmm, is that link working? I get a 401 error.

photo
1

It wasn't yet approved. It should be working now that it's made it through the moderation queue and onto the site.

photo
photo
2

Any update on that?

photo
2

As I said a few weeks ago, mariadb 10.4 support is not yet scheduled. If you follow this topic, you'll get an update once it's planned.

photo
photo
4

How long we need to wait?

photo
1

We don't have an update to share at this time, but if you follow this topic, we will update here as soon as we have information.

photo
photo
2

It has been a year and a half! I just hope that version 90 will have it. That slow developent of cPanel is driving me crazy. 10.5 is about become GA!

photo
1

The reason why they can't just add MariaDB 10.4 and newer is because some things have changed and e.g. things like creating users and databases needs to be done in a different way. So they need to change (and test) a bunch of scripts that interface between cPanel and MariaDB.

But I agree, this is taking way to long for such an essential part of the product. Worst of all, MariaDB 10.4 really gives a great speed boost so this would be a quick win for everyone.

photo
photo
1

Yep. This is like waiting for Windows 7. I can't restore back ups, even when using the paid service of Jet Backups because 'its not supported'... And MariaDB just label it as 'Stable release'. So this needs a little bit of priority I think. What I do think is that its not a priority because the way db permissions work has changed, so its not an easy update, and then combine that with the fact most people will just use 10.3 this becomes a non priority

photo
6

I suppose we better all go vote on the 10.5 feature request thread here:

https://features.cpanel.net/topic/mariadb-10-5-support


Can someone from cpanel let us know if you plan to support 10.4 still or just skip it and go straight to 10.5?

photo
4

Judging by the fact that there is no explanation whatsoever, they did not even start working on 10.4. They'll probably start working on 10.5 with the release of 10.6, which will be availabe right before the release of 10.7 :]


Come on people!

photo
5

I mean. We've been waiting for the ability to have segmented access for cpanel logins so that contractors can get individual access to things like mysql without having the keys to every single account feature for 7 YEARS. SEVEN YEARS. I hate to say it but cPanels ability to reasonably respond to feature development has become dreadful.

photo
2

Magento 2.4 releases next month, and they recommend Mariadb 10.4 (10.3 is not listed in the official tech stack requirements).


I'm honestly considering switching panels if the panel is causing limitations of holding back upgrades for my customers.

photo
6

I've been actively keeping an eye on this one as I use MariaDB myself and this is getting kind of ridiculous. WHM 'supports' MariaDB and MySQL, but the key thing is once you upgrade to MariaDB you can't go back to MySQL. Databases are a key aspect of any server these days... so for those of us who decided to use MariaDB, with no worries in our head because it was supported, are now kind of screwed because we can't update to the latest version until cPanel allows it and we can't change to MySQL which is being kept current. Doesn't really sound like the definition of supported to me and all of us using MariaDB are left with literally no option/choice outside of provisioning new servers with MySQL, swapping, configuring, making changes to our code, and so on and so on. We all know that is usually not a simple and quick thing to do.

photo
4

I'd have to agree - this shouldn't be set to "open discussion".

CloudLinux supports installs of 10.4 already, however we all know cPanel needs to fix their scripts. I'm guessing they might need to start going in the direction of different code depending on if it's mysql or mariadb, just like they have for postgresql, since they're now more or less seperate from each other.

Sure - we need el8 support more than this (because c'mon, we dont want to migrate those el6 to el7 when el8 is around the corner), but cPanel has enough devops to go around, right? :D

And I remember you wrote about it a while back here:

https://blog.cpanel.com/being-a-good-open-source-community-member-why-we-hesitated-on-mysql-5-7/

We will also soon discontinue the building and shipping of our own MySQL RPMs (like we have done already with MariaDB) relying instead on the versions provided upstream. That will help ensure that we’re shipping things as soon as possible.

So please give us an ETA!

photo
1

This is what cPanel recommended me for an upgrade path but I did not try it. If anyone tries, please let us know.

https://downloads.mariadb.org/mariadb/repositories/

photo
2

I've read that it will work, but will break the backup function of WHM/Cpanel (and anything having to do with databases really, such as creating a new user/db in account Cpanel). I do manual backups and download them, but having the auto backup/restore feature is very, very convenient, and would rather not lose that function.

photo
6

The fact that this feature request was created 16 months ago is killing me.

photo
4

Yeah and who knows what else will break or break later on when an upgrade happens. Too many variables to take a chance on that in my opinion if having your site(s) actually running properly is of importance. I do not use the backup feature, but I do use a remote db connection - our database is on a completely different server than WHM - but of course the two need to 'talk' with one another still. Upgrading MariaDB for me would be a piece of cake since its on another server, but I can't use a version that isn't supported by WHM either because of the remote connection to it.

photo
photo
3

So we have now MariaDB 10.5.

photo
3

Is someone from Cpanel able to reply to my post from 33 days ago:

>Can someone from Cpanel let us know if you plan to support 10.4 still or just skip it and go straight to 10.5?

photo
1

Probably skip to MariaDB 10.5 as I really don't think they even wrote a line of code for 10.4.

photo
photo
2

The issues that have been experienced with recent MariaDB releases have caused notable concern in terms of impact for our customers. As a result of this, we are spending some time investigating our options which is in part why it’s taken an extended amount of time to deliver the next MariaDB upgrade. At this time we plan to skip MariaDB 10.4 and begin offering MariaDB 10.5 in 2021.