Upgrading from MySQL to Maria. No MariaDB upgrade option in WHM

[TechBill]

Is there a way to upgrade from MySQL to MariaDB when there is no MariaDB option in the WHM MySQL upgrade setting?

Thank you
Bill

 

[cPRex]

Hey there! What version of MySQL are you running on the machine?

 

[Spirogg]

Great question @TechBill

I also have a question on this topic,

AlmaLinux 8.5.0 and cPanel 100.0.9 there is no option to select MariaDB at all, I switch from CentOS 7 and cPanel and just went with MySQL 8 while transferring over my cpanel accounts and its working.

--- But, If we do a fresh install of AlmaLinux 8.5.0 and cPanel right now 100.0.9 or even cPanel 102 can we configure cPanel to use MariaDB 10.3 or 4 or 5 instead of MySQL 8?
is there an option to do this or a way to get MariaDB to select from like before ?

Kind Regards,
Spiro

 

[TechBill]

Hey there! What version of MySQL are you running on the machine?

I have 2 cPanel servers ...

The first one it's running mySQL 5.7 and it does give me the option to upgrade to MariaDB 10.3 ot 10.5 or 10.6 (experimental)

The second one is mySQL 8.0 which is the one I wanted to upgrade to MariaDB first to test it to make sure it's supported by some older php scripts before upgrading it. I do have some new php script I want to install and use however it require MariaDB. I am told that older php scripts will most likely run under MariaDB as well too since it will see it as a mySQL.

I just want to test it first on the second server before upgrading the production server and the second server is showing mySQL 8 and there is no option listed to upgrade it to MariaDB on it like my first server.

it seems like ti ne that once it's at mySQL 8.0 then it can't be upgrade or switch over to MariaDB and the option disappear from list.

 

[cPRex]

From our docs:

"You cannot upgrade MySQL 8 to MariaDB 10.x due to incompatibilities between these versions. For more information, read MariaDB’s documentation. However, system administrators can choose either MySQL or MariaDB during the cPanel & WHM installation process. For more information, read our Installation Guide."

MySQL/MariaDB Upgrade | cPanel & WHM Documentation

This interface allows you to manage MySQL® or MariaDB® version upgrades (for example, when you upgrade from MySQL 5.6 to 5.7).

docs.cpanel.net

 

[cPRex]

@TechBill - thanks for that. That would apply to your system then - once you're on MySQL 8, you can't switch to MariaDB.

 

[TechBill]

@TechBill - thanks for that. That would apply to your system then - once you're on MySQL 8, you can't switch to MariaDB.

Is there a way to switch to MariaDB manually or outside of cPanel?

 

[cPRex]

While I'm sure anything is possible, it probably wouldn't end well, and would cause issues. There's some pretty major internal structure changes between those versions, which is why we made it not possible.

You could always create a new machine that had MariaDB from the start using the details here:

Customize Your Installation | cPanel & WHM Documentation

This document describes how to customize your cPanel & WHM installation.

docs.cpanel.net

 

[TechBill]

While I'm sure anything is possible, it probably wouldn't end well, and would cause issues. There's some pretty major internal structure changes between those versions, which is why we made it not possible.

You could always create a new machine that had MariaDB from the start using the details here:

Customize Your Installation | cPanel & WHM Documentation

This document describes how to customize your cPanel & WHM installation.

docs.cpanel.net

If I create a new machine with cPanel and MariaDB .. Will I be able to export and import DB from MySQL 8 to a new machine with MariaDB?

 

[cPRex]

In general, I would not expect that to work due to how the tables are structured.

 

[Spirogg]

From our docs:

"You cannot upgrade MySQL 8 to MariaDB 10.x due to incompatibilities between these versions. For more information, read MariaDB’s documentation. However, system administrators can choose either MySQL or MariaDB during the cPanel & WHM installation process. For more information, read our Installation Guide."

MySQL/MariaDB Upgrade | cPanel & WHM Documentation

This interface allows you to manage MySQL® or MariaDB® version upgrades (for example, when you upgrade from MySQL 5.6 to 5.7).

docs.cpanel.net

sorry for not specifying correctly. What I meant is that in a fresh install there is no option for MariaDB it’s only MySQL

 

[cPRex]

Right - you'd have to specify MariaDB before you even performed the cPanel install if you want that to happen.

 

[mark135uk]

" Right - you'd have to specify MariaDB before you even performed the cPanel install if you want that to happen. "

How?
what file do i edit to say i want mariadb instead of mysql, you cant use the whm upgrade as it 404s
i saw a post saying you change a file and put mariadbxxx in place of mysql and then re install whm but i cannot find that post now

 

[cPRex]

The file is /root/cpanel_profile/cpanel.config. It will not be present on a newly-installed operating system, so you'll need to create the /root/cpanel_profile/ directory and then the cpanel.config file inside it.

More details on that can be found here:

Customize Your Installation | cPanel & WHM Documentation

This document describes how to customize your cPanel & WHM installation.

docs.cpanel.net

 

[mark135uk]

hi thanks for your reply, there must be another file, i did it a few days ago on a fresh install, i never made any new docs or dirs, the file was already there

 

[cPRex]

This has to be done before the cPanel installation happens. Without cPanel, /root/cpanel_profile will not exist.

You'll need to ask your host for a plain AlmaLinux 8 installation, then create that directory and file, and then manually install cPanel.

 

[mark135uk]

i have root access, i can remove cpanel, but can you tell me what i need to put in the file please?

 

[cPRex]

You can't remove cPanel - you have to install a new operating system image.

In the file, you would put this:

mysql-version=10.6

 

[mark135uk]

i am now installing centos 7 without cpanel

so to confirm i make /root/cpanel_profile/cpanel.config

add
mysql-version=10.6

save, and then install whm/cpanel and it will install with mariadb and not mysql5.7?

 

[cPRex]

That is exactly correct. I might recommend AlmaLinux 8 instead of CentOS 7 just so you have a bit longer life with that machine, but that is completely up to you.