Upgraded to MySQL 8.0 issue

[34ever]

Hey all,

Would you be so kind and help us solve the following issue. We updated Mysql on our server from 5.7 to 8.0 version.

Every website on our server works fine except the following (described below). This fatal error occurs, when we try to update Mysql/MariaDB via WHM panel.

-----------------------------------------------------------------------------------
get_installable_versions_for_version does not know about 8.0 at /usr/local/cpanel/Cpanel/MysqlUtils/Versions.pm line 99.
 at /usr/local/cpanel/Cpanel/MysqlUtils/Versions.pm line 99.
 Cpanel::MysqlUtils::Versions::get_installable_versions_for_version(8.0) called at whostmgr/bin/whostmgr.pl line 6524
 main::mysqlupgrade("mysqlupgrade") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 259
 Whostmgr::Dispatch::_do_call("mysqlupgrade", HASH(0x3efa388), HASH(0x3efcb80)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 157
 Whostmgr::Dispatch::dispatch("mysqlupgrade", 1, ARRAY(0x3efa550)) called at whostmgr/bin/whostmgr.pl line 582
-----------------------------------------------------------------------------------

Thank you

 

[rpvw]

I can't find anything in the cPanel change logs nor feature list that states that cPanel supports or provides MySQL 8

The following versions of MySQL are available:

• MySQL 5.5
• MySQL 5.6
• MySQL 5.7

The following versions of MariaDB are available:

• MariaDB 10.0
• MariaDB 10.1
• MariaDB 10.2

MySQL or MariaDB Upgrade - Version 76 Documentation - cPanel Documentation
76 Change Log - Change Logs - cPanel Documentation

If you have forced an upgrade to MySQL 8 using an unsupported method, I would not be surprised if you are experiencing issues.

You may need to open a support ticket to cPanel to allow them to revert your 'upgrade' ........ if possible !

 

[vacancy]

Who gave you this idea?

You're crazy.

 

[cPanelMichael]

We updated Mysql on our server from 5.7 to 8.0 version.

Hello @34ever,

MySQL version 8.0 is not offered as part of cPanel & WHM at this time. Did you manually install the RPMs to force it's installation? If so, I recommend reverting the actions you took and restoring MySQL to the state it was in prior to the upgrade.

You can follow the progress on support for MySQL 8.0 on the following feature request:

MySQL 8.0 Support

Thank you.

 

[34ever]

Hi, all,

Thank you for all of your replies, but no, I will not revert back to 5.7. Reason? All of the website are running smoothly and without any headaches I experienced when I tested MySql to MariaDB.

Also, I read so many issues with compatibility MySql upgrade to MariaDB, I cannot afford to put the websites in danger.

So, my conclusion is the following. Cpanel should support MySql 8 ASAP, since it is so much faster then previous versions and it is very stable.

If the support Will not be available any time soon, I Will have to find other solutions than Cpanel.

 

[cPanelMichael]

Hello @34ever,

We'll update the feature request with new information on the status of MySQL 8.0 support as soon as it's available. In the meantime, one supported option for MySQL version 8.0 (though it's in beta) is the MySQL Governor feature offered with CloudLinux:

Beta: MySQL 8.0 for MySQL Governor released

Thank you.

 

[34ever]

Hi,

I am writting once again, since I still use Mysql 8.0 (with Centos 7.6). Websites are on steroids, yet of course still isssues with WHM/Cpanel.

But, I am thinking the following:

• to switch CENTOS OS to Cloudlinux OS
  CloudLinux - Main | New template
  
  
• since Cloudlinux released MySQL Governor for MySQL 8 in beta, install this version
  Beta: MySQL 8.0 for MySQL Governor released

Any suggestions for this. Server managers from all over the world are having problems with me because of my deed since they cannot find me a proper solution (to migrate back to mysql 5.6 and restore all of my cpanel accounts in between).

Thank you

 

[cPanelMichael]

Hello @34ever,

If you wanted to revert back to MySQL 5.7, you could setup a new cPanel & WHM server with MySQL 5.7 and then transfer your accounts to it using WHM >> Transfer Tool. We're happy to help guide you through this process if you have any questions with the transfer process.

Using MySQL version 8.0 as part of the beta MySQL Governor feature offered by CloudLinux is likely the best choice if MySQL version 8 is an absolute requirement for the system, however note it's a beta product (not intended for a production environment) and CloudLinux warns it's not supported:

cPanel does not officially support MySQL 8.0, that is why we don’t recommend to use it on cPanel servers.

Thank you.