install MariaDB instead of MySQL

[[email protected]]

Is there a way to specify in the /root/cpanel_profile/cpanel.config file : install MariaDB10.1 instead of MySQL 5.6?

I know there was an option in cpanel.config for: mysql-version and you could do it there but that has been deprecated in favor updating /var/cpanel/rpm.versions.d/local.versions with that information.

I know, from the CLI, you could do

whmapi1 start_background_mysql_upgrade version=10.1

and that would upgrade SQL from my default to MariaDB 10.1 but I'm trying to avoid the extra step.


Question: does the /var/cpanel/rpm.versions.d/local.versions file get read in before cpanel install?

Endgame: I would love to specify which version of a SQL server I am installing by default - during cpanel install. How?

 

[cPanelMichael]

Is there a way to specify in the /root/cpanel_profile/cpanel.config file : install MariaDB10.1 instead of MySQL 5.6?

Hello,

You can simply add the following value to the /root/cpanel_profile/cpanel.config prior to starting the installation:

mysql-version=10.1

This will ensure MariaDB 10.1 is installed.

Thank you.

 

[[email protected]]

Thank you. Are you still recommending this even though the feature is deprecated per the docs? I'll use it, just want to make sure it's going to work for a while.

 

[cPanelMichael]

Hello,

We still document that method at:

Installation Guide - Customize Your Installation - Version 70 Documentation - cPanel Documentation

Can you verify the specific document that references this method as deprecated?

Thank you.

 

[[email protected]]

The cpanel.config File - Version 68 Documentation - cPanel Documentation

"

• This variable is deprecated, and we will remove it in a later version of cPanel & WHM. If you use this variable in customcode, update that code to use the rpm.versions system as soon as possible to avoid problems. For more information, read our How to Override the rpm.versions System documentation."

 

[cPanelMichael]

Hello,

The modification of /var/cpanel/cpanel.config as a means of manually upgrading the existing MySQL/MaraDB version on a system is deprecated, but that's not the same file as /root/cpanel_profile/cpanel.config. You can still use /root/cpanel_profile/cpanel.config to define the version of MySQL/MariaDB installed as part of the installation process.

Thank you.

 

[[email protected]]

Ok. Thank you. Problem solved!

Can we get that a little clearer documentation?

 

[cPanelMichael]

Hello,

I've opened internal case DOC-10246 with our Documentation Team to see if we can clarify that a little better. I'll update this thread with the outcome of the case once it's available.

Thanks!

 

[cPanelMichael]

Hello @[email protected],

The following document is now updated to note that we still support configuring the MySQL/MariaDB version prior to installation:

Installation Guide - Customize Your Installation - Version 70 Documentation - cPanel Documentation

Thanks!