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!

Does cPanel install mySQL or mariaDB by default?

Discussion in 'Database Discussion' started by vicos, Jan 27, 2019.

  1. vicos

    vicos Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    73
    Likes Received:
    1
    Trophy Points:
    158
    I just had a new Cpanel server installed by my ISP last week on Centos7.

    The installed database when I took delivery was mariaDB. Do new installations of Cpanel install mySQL or mariaDB?
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,372
    Likes Received:
    154
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    The default settings for the isntaller would install MySQL 5.7, but your provider may have specified something different or upgraded it.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. vicos

    vicos Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    73
    Likes Received:
    1
    Trophy Points:
    158
    Thanks. That's what I figured. Having a hard time getting getting a straight answer out of the ISP. Now, I need to try and determine if this is the ISP's standard build or the installer/tech took it upon himself to convert it to mariaDB.

    What really bugs me is that I spent hours researching whether or not it would be a good idea to convert to mariaDB and going back and forth with their tech asking questions. Then, later that day I restarted mySQL and it said mariaDB. My head almost exploded. The left hand doesn't know what the right hand is doing there.
     
  4. vicos

    vicos Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    73
    Likes Received:
    1
    Trophy Points:
    158
    Is there a relatively easy way I can determine if it was initially installed with mySQL and then upgraded to mariaDB or if mariaDB was installed by default?
     
  5. vacancy

    vacancy Well-Known Member

    Joined:
    Sep 20, 2012
    Messages:
    258
    Likes Received:
    30
    Trophy Points:
    28
    cPanel Access Level:
    Root Administrator
    /var/lib/mysql you can check the following files in.

    RPM_UPGRADE_HISTORY (upgrade log)
    RPM_UPGRADE_MARKER-LAST (upgrade log)
    mysql_upgrade_info (previous mysql version)
     
  6. vicos

    vicos Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    73
    Likes Received:
    1
    Trophy Points:
    158
    Thank you! A member of the build team got back to me and said their new installs all come with maria, although they're going to be offering mySQL again in the future. Interesting.

    Since I might have to live with mariaDB, the next thing to determine is if it is safe to stick with the version they installed (10.0.37) or if I need to upgrade now. We typically build a new server every 2 years.

    The 5 year boundary date for 10.0 is 31 Mar 2019, so there may be no more support in just 2 months.

    My other options are 10.1 and 10.2.

    Does anyone have any thoughts on upgrading to 10.1 or 10.2? I have some old applications and I need to maintain compatibility.

    My only concern with 10.2 is this: MariaDB enables "strict mode" by default as of version 10.2.

    I don't know enough to know if this might be a concern. My layman's thoughts are that I need to go to 10.1 where the 5 year boundary is 17 Oct 2020.

    Appreciate your feedback :)
     
  7. vacancy

    vacancy Well-Known Member

    Joined:
    Sep 20, 2012
    Messages:
    258
    Likes Received:
    30
    Trophy Points:
    28
    cPanel Access Level:
    Root Administrator
    Your sites running in Mysql will run on mariadb.

    It's just too old, joomla scripts are likely to have problems. I also saw mariadb use more cpu in some databases.

    I am not raising any of my servers to mariadb because of these personal experiences. The decision is yours.
     
  8. ES - George

    ES - George Well-Known Member PartnerNOC

    Joined:
    Jun 12, 2011
    Messages:
    175
    Likes Received:
    22
    Trophy Points:
    68
    Location:
    UK
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,815
    Likes Received:
    443
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    At this point in time, a lot of it is up to preference, though you can't roll back to MySQL. Updating MariaDB or MySQL on cPanel does not require a new build out but if you do all of these things at once with a new server then I'd suggest going with the newest available version within cPanel to maximize your relevancy.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice