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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,002
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,002
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,002
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,002
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,002
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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. dpsingh

    SOLVED Install MySQL 5.6 instead of MariaDB

    dpsingh, Apr 11, 2019, in forum: Database Discussion
    Replies:
    9
    Views:
    235
    cPanelMichael
    Apr 15, 2019
  2. vicos

    Does cPanel install mySQL or mariaDB by default?

    vicos, Jan 27, 2019, in forum: Database Discussion
    Replies:
    8
    Views:
    405
    cPanelLauren
    Jan 29, 2019
  3. iso99

    SOLVED MariaDB 10.2 new install, missing tokudb and jemalloc

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

    Install MariaDB 10.1 on cPanel v70?

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

    Installing mySQL and MariaDB

    Skhilled44, Jul 22, 2017, in forum: Database Discussion
    Replies:
    3
    Views:
    1,009
    Skhilled44
    Jul 26, 2017

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