Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

install MariaDB instead of MySQL

Discussion in 'Database Discussion' started by Dev@SH, Jan 30, 2018.

Tags:
  1. Dev@SH

    Dev@SH Member

    Joined:
    Mar 11, 2014
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    DataCenter Provider
    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
    Code:
    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?
     
    #1 Dev@SH, Jan 30, 2018
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Code:
    mysql-version=10.1
    This will ensure MariaDB 10.1 is installed.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Jan 30, 2018
  3. Dev@SH

    Dev@SH Member

    Joined:
    Mar 11, 2014
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    DataCenter Provider
    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.
     
    #3 Dev@SH, Jan 30, 2018
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Jan 30, 2018
  5. Dev@SH

    Dev@SH Member

    Joined:
    Mar 11, 2014
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    DataCenter Provider
    #5 Dev@SH, Jan 30, 2018
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Jan 30, 2018
  7. Dev@SH

    Dev@SH Member

    Joined:
    Mar 11, 2014
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    DataCenter Provider
    Ok. Thank you. Problem solved!

    Can we get that a little clearer documentation?
     
    #7 Dev@SH, Jan 30, 2018
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelMichael, Jan 31, 2018
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 cPanelMichael, Feb 12, 2018
(You must log in or sign up to post here.)
Loading...
Similar Threads - install MariaDB instead
  1. iso99

    SOLVED MariaDB 10.2 new install, missing tokudb and jemalloc

    iso99, Jun 27, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    257
    cPanelLauren
    Jul 23, 2018
  2. sparek-3

    Install MariaDB 10.1 on cPanel v70?

    sparek-3, Jun 5, 2018, in forum: Database Discussion
    Replies:
    6
    Views:
    153
    cPanelMichael
    Jun 5, 2018
  3. Skhilled44

    Installing mySQL and MariaDB

    Skhilled44, Jul 22, 2017, in forum: Database Discussion
    Replies:
    3
    Views:
    679
    Skhilled44
    Jul 26, 2017
  4. ferdie palero

    Install cPanel use existing MySQL or MariaDB, Apache etc.

    ferdie palero, Sep 29, 2016, in forum: General Discussion
    Replies:
    3
    Views:
    944
    cPanelMichael
    Sep 30, 2016
  5. navhost

    reinstalling mysql

    navhost, Aug 16, 2018 at 3:32 PM, in forum: Database Discussion
    Replies:
    2
    Views:
    94
    cPanelMichael
    Aug 17, 2018 at 12:14 PM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice