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!

Redhat has retired MySQL 5 in favor of Mariadb. Recommend using Mariadb 5 or above???

Discussion in 'General Discussion' started by craigedmonds, Feb 22, 2016.

  1. craigedmonds

    craigedmonds Well-Known Member

    Joined:
    Oct 29, 2007
    Messages:
    112
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Europe
    cPanel Access Level:
    Root Administrator
    Twitter:
    I have just leased a new server and it has centos 7.2 installed and seems to have mysql installed and I am trying to install a piece of firewall software and get the error message...

    package MySQL-server is not installed
    package MySQL51-server is not installed
    package MySQL55-server is not installed
    MySQL56-server-5.6.29-1.cp1148.x86_64
    Error: MySQL is not supported on EL7.
    Redhat has retired MySQL 5 in favor of Mariadb.
    Recommend using Mariadb 5 or above.
    Exiting...

    The software vendor has unhelpfully said "Yes, you will need to switch to the database supported by the OS vendor, in your case that is MariaDB. Redhat has replaced mysql with mariadb. Mariadb is supported with cpanel".

    What happens if I switch to MariaDB? Is mysql gone? Can I run my wordpress sites as usual?

    Whats going on?????
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 craigedmonds, Feb 22, 2016
  2. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    751
    Likes Received:
    11
    Trophy Points:
    143
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Howdy,

    MariaDB is a drop in replacement for MySQL. It looks almost exactly the same.

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 Eric, Feb 22, 2016
  3. cotswoldphoto

    cotswoldphoto Active Member

    Joined:
    Feb 20, 2015
    Messages:
    25
    Likes Received:
    3
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    I have been using all my WordPress sites on Mariadb 10 for over a year now. Also, make sure your default engine is innodb, and convert any tables that aren't. Innodb does not corrupt anywhere as much as MyIsam.
     
    #3 cotswoldphoto, Feb 22, 2016
  4. craigedmonds

    craigedmonds Well-Known Member

    Joined:
    Oct 29, 2007
    Messages:
    112
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Europe
    cPanel Access Level:
    Root Administrator
    Twitter:
    So I am pretty safe to simply switch to mariadb?

    None of my users will turn around and say "oh no...you dont have mysql!!!!! This is bad!!!"

    I run a shared hosting service so just a little concerned that user might complain about not having the availability of mysql.

    Just wondering if I should reinstall the server to centos 6.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 craigedmonds, Feb 23, 2016
  5. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    330
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    we are also a web hosting provider and have been using mariadb for over a year now with no issues.

    We had no issues in switching - I remember we had customers however say their select queries are faster when we changed. So they were happier.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 sahostking, Feb 23, 2016
  6. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    931
    Likes Received:
    17
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    After updating to mariadb through WHM you should check your /etc/my.cnf as the cpanel upgrade script has an irritating habit of adding:
    Code:
    default-storage-engine=MyISAM
    Iritating because the default engine for mariadb is innodb which is better/faster
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 kernow, Feb 23, 2016
  7. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,453
    Likes Received:
    1,962
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    This is an upgrade that does not require manual intervention from your users. We have a document that explains the process at:

    MySQL/MariaDB Upgrade - Documentation - cPanel Documentation

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 cPanelMichael, Feb 23, 2016
(You must log in or sign up to post here.)

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