can't upgrade Mysql/MariaDB

stefanbc

Well-Known Member
Apr 13, 2015
52
0
6
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
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,237
463
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.
 

stefanbc

Well-Known Member
Apr 13, 2015
52
0
6
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,237
463
Hello,

Note that for MariaDB 10.1 the command is:

Code:
/usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mariadb101
Thank you.
 

stefanbc

Well-Known Member
Apr 13, 2015
52
0
6
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: [email protected]
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.
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,237
463
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.
 

stefanbc

Well-Known Member
Apr 13, 2015
52
0
6
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,237
463
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,237
463
New We try to upgrade from wizard and now mysql failed. How can we do it now ? We have the same problem. Any solution ?
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.