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.

can't upgrade Mysql/MariaDB

Discussion in 'Database Discussions' started by stefanbc, Apr 14, 2015.

  1. stefanbc

    stefanbc Well-Known Member

    Joined:
    Apr 13, 2015
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    toronto
    cPanel Access Level:
    Root Administrator
    Hi,

    In my "MySQL/MariaDB Upgrade (Step 1 of 7)" section I see

    MySQL/MariaDB is a commonly-used relational database management system that is a core service on most cPanel systems. This interface allows you to upgrade your MySQL/MariaDB server to a newer version. cPanel will automatically upgrade your MySQL/MariaDB installation to newer point releases (the third digit in the version string) because these upgrades involve little risk to your users’ data. Upgrades to new major releases (the first two digits in the version string) are more involved because there is a substantial risk of data loss. This interface attempts to walk you through the major release upgrade process. If you wish to keep your existing major release and upgrade to its latest point release, please visit the Update Server Software interface instead..

    After you upgrade MySQL/MariaDB, there is no supported way to downgrade to the previous version.
    Your server is using MySQL Governor. You cannot use the MySQL/MariaDB Upgrade feature while your server is in this state. Please read the mysql upgrade documentation.


    And that is it. How can I upgrade MySql/mariaDB?
    I have CLOUDLINUX 6.6 x86_64 kvm WHM 11.48.3 (build 0)

    Note:
    Previously to running this, see last post I had some options that were marked with "Bloked" and I could not upgrade either.

    Unfortunately I could not find anything else about this problem.

    Thnak you
     
    #1 stefanbc, Apr 14, 2015
    Last edited: Apr 14, 2015
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    You should be able to follow the steps below to install MariaDB if you are using MySQL Governor:

    Code:
    yum install governor-mysql
    /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mariadb100
    /usr/share/lve/dbgovernor/mysqlgovernor.py --install
    Thank you.
     
  3. stefanbc

    stefanbc Well-Known Member

    Joined:
    Apr 13, 2015
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    toronto
    cPanel Access Level:
    Root Administrator
    Hi,

    I figured if I want to keep the governor I have to do it manually. Will try tonight to update to 10.1
    Not sure I need the governor and not sure MariaDb is better than MySql but will go with MariaDb

    Thank you
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  5. stefanbc

    stefanbc Well-Known Member

    Joined:
    Apr 13, 2015
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    toronto
    cPanel Access Level:
    Root Administrator
    well that did not go to well I think

    I got "mysql has failed. Please contact your system administrator if the service does not automagically recover." during the upgrade and going to "Restarting MySQL Server" from WHM says the same

    PhpMyAdmin reports
    Server: Localhost via UNIX socket
    Server type: MariaDB
    Server version: 5.5.40-MariaDB-cll-lve - MariaDB Server
    Protocol version: 10
    User: root@localhost
    Server charset: UTF-8 Unicode (utf8)


    So I don't think it worked but sites still work as expected. Not sure what to say maybe someone has an idea

    Thank you


    UPDATE:
    I'm confused. I ran
    mysqladmin -u root -p status
    Enter password:
    Uptime: 4046 Threads: 7 Questions: 5157 Slow queries: 0 Opens: 106 Flush tables: 1 Open tables: 115 Queries per second avg: 1.274

    So I guess it works, but still I don't think I am running the latest MariaDb.
     
    #5 stefanbc, Apr 15, 2015
    Last edited: Apr 15, 2015
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I suggest opening a ticket with Cloud Linux if upgrading to MariaDB is not working as intended using their installation steps:

    Cloud Linux Support

    Feel free to update this thread with the outcome after contacting them.

    Thank you.
     
  7. stefanbc

    stefanbc Well-Known Member

    Joined:
    Apr 13, 2015
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    toronto
    cPanel Access Level:
    Root Administrator
    It worked with some help from a sys admin, not sure exactly what he did. Only thing is I have a problem with is I see this in the MySQL/MariaDB Upgrade section

    Warning: The last run of the MySQL upgrade wizard failed. If you have corrected the problems that led to this failure it is highly recommended that you resume your previous upgrade rather than beginning a new one.
    Current step number: 4
    Starting MySQL/MariaDB version: 10.1
    Selected MySQL/MariaDB version: 10.0
    Upgrade Type: Unattended Upgrade


    and 2 buttons

    Resume Current Upgrade & Ignore Current Upgrade

    I will open a ticket when I have more time
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You shouldn't use the MySQL upgrade wizard if you are using Cloud Linux with MySQL governor. MySQL is handled through Cloud Linux, not cPanel, in such cases.

    Thank you.
     
  9. stefanbc

    stefanbc Well-Known Member

    Joined:
    Apr 13, 2015
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    toronto
    cPanel Access Level:
    Root Administrator
    Thank you. Will check to see if governor is still installed
     
  10. fiberit

    fiberit Registered

    Joined:
    Aug 1, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Romania
    cPanel Access Level:
    Root Administrator
    We try to upgrade from wizard and now mysql failed. How can we do it now ? We have the same problem. Any solution ?
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you provide more details? For instance, are you using Cloud Linux with MySQL Governor? What error message do you see in /var/lib/mysql/$hostname.err when MySQL fails to start?

    Thank you.
     
Loading...

Share This Page