The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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?????
     
    #1 craigedmonds, Feb 22, 2016
  2. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    752
    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!
     
    #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.
     
    #4 craigedmonds, Feb 23, 2016
  5. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    314
    Likes Received:
    2
    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.
     
    #5 sahostking, Feb 23, 2016
  6. kernow

    kernow Well-Known Member

    Joined:
    Jul 23, 2004
    Messages:
    896
    Likes Received:
    12
    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
     
    #6 kernow, Feb 23, 2016
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    35,600
    Likes Received:
    1,128
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #7 cPanelMichael, Feb 23, 2016
(You must log in or sign up to post here.)

Share This Page