install MariaDB instead of MySQL

Dev@SH

• January 30, 2018 13:12

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

  • January 30, 2018 18:22

  [QUOTE="Dev@SH, post: 2522379, member: 526171">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.

  0
• 

  Dev@SH

  • January 30, 2018 18:32

  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.

  0
• 

  cPanelMichael

  • January 30, 2018 18:36

  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.

  0
• 

  Dev@SH

  • January 30, 2018 18:43

  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

  0
• 

  cPanelMichael

  • January 30, 2018 18:49

  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.

  0
• 

  Dev@SH

  • January 30, 2018 18:53

  Ok. Thank you. Problem solved! Can we get that a little clearer documentation?

  0
• 

  cPanelMichael

  • January 31, 2018 15:10

  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!

  0
• 

  cPanelMichael

  • February 12, 2018 13:58

  Hello @Dev@SH, 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!

  0

Please sign in to leave a comment.