A lot of changes have gone through since the COVID-19 period; one deals with some significant changes for cPanel.
Besides the constantly increasing price, cPanel due to the changes in CentOS after RedHat’s decision to drop the community-free version of CentOS, cPanel had to add support for more flavours of the Linux OS.
There are two versions that are doing really well in the current market and those are AlmaLinux and RockyLinux.
Some of our clients faced an issue already discussed several times within the cPanel forums and that is, installing a fresh server with MariaDB 10.x instead of the default MySQL 8.x
First of all, MariaDB is supported so if you ended up installing your server and tried to switch from MySQL 8.x to MariaDB only to find out that the option is not there (under your WHM configuration menu) don’t worry, you don’t have to reinstall everything in order to get MariaDB.
MySQL 8.x is actually an upgrade from MariaDB 10.x and this is the reason why the option to “upgrade” is not there!
But for those who want MariaDB here’s the solution that works 100% on a fresh server! *It will also work on a server already installed and having several Databases but here’s where you definitely need to have your backup updated before anything else.
- For a server that you haven’t installed cPanel/WHM already, cPanel provides a method to customize before the installation.
You can follow those steps here:
a) mkdir /root/cpanel_profile
b) touch /root/cpanel_profile/cpanel.config
Once you do that you can add the following line : mysql-version=10.6
Before you decide on your SQL version, make sure your OS and cPanel agree with this, you can read more here: Customize your cPanel Installation