Discussion of MySQL 5.7 Support

MadroosterTony

Member
PartnerNOC
Jan 14, 2007
17
9
153
I have confirmed that the change for MySQL 5.7 is only to do with the way user passwords are set. What everyone else has done is a simple If, else statement when creating users.

if (mysql_57) {
create_user_57();
} else {
create_user_normal();
}

The user creation for MySQL 8 is the same, but there are other small things that need to be done to support it fully, but the above simple change to cPanel's code would provide MySQL 5.7 support immediately, then allow them to plan for their long term solution.
 
  • Like
Reactions: eva2000

eva2000

Well-Known Member
Aug 14, 2001
339
16
318
Brisbane, Australia
cPanel Access Level
Root Administrator
Twitter
I have confirmed that the change for MySQL 5.7 is only to do with the way user passwords are set. What everyone else has done is a simple If, else statement when creating users.

if (mysql_57) {
create_user_57();
} else {
create_user_normal();
}

The user creation for MySQL 8 is the same, but there are other small things that need to be done to support it fully, but the above simple change to cPanel's code would provide MySQL 5.7 support immediately, then allow them to plan for their long term solution.
nice info there :)
 

MadroosterTony

Member
PartnerNOC
Jan 14, 2007
17
9
153
Due to the fact that we can not wait any longer, we have started to code our own MySQL 5.7 plugin for cPanel, much as we have done for MongoDB. The issue is in doing this, we lose the disk quotas on user accounts as cPanel does not know to count the database towards the overall quota.

With MongoDB, we wrote a simple audit script to dump database sizes periodically and if we see anything out of the ordinary we investigate.
 
  • Like
Reactions: eva2000

DWaters

Registered
Jun 30, 2017
3
0
1
United Kingdom
cPanel Access Level
Root Administrator
I've always recommended WHM/CPanel installs in the past but recently I just can't because you can guarantee new projects/clients are needing MySQL 5.7. Even clients that don't YET need this are asking "well what is the timeline on this?" and I can't give them one, so we're sadly working on migrating majority of our projects and clients to Plesk instead. Safe to say if CPanel add 5.7 support in a year those clients are lost for the foreseeable future regardless, it isn't that easy to explain to a client we need to drop Plesk and go back to CPanel as on a whim they now decided they'd like to support their users.

It's incredibly confusing why CPanel have made this decision, they must be losing a lot of money in lost licensing fees through reluctance to support industry standard software.
 

Miraenda

Well-Known Member
Jul 28, 2004
243
5
168
Coralville, Iowa USA
cPanel Access Level
Root Administrator
Steps to upgrade to MySQL 5.7 manually (includes a step to run mysql_upgrade). Confirmed these work in v66.

1. Remove mysql* from /etc/yum.conf

2. Install the RPM

On CentOS6:

Code:
rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm
On CentOS7:

Code:
rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
3. Enable Mysql 5.7

Code:
yum-config-manager --enable mysql57-community
4. Remove any old versions of MySQL

Code:
rpm -e MySQL55-client MySQL55-test MySQL55-server
5. Install the new MySQL 5.7

Code:
yum -y install mysql-community-server
6. Start MySQL 5.7

Code:
service mysqld start
7. Upgrade any tables

Code:
mysql_upgrade
cPanel will automatically pickup the changed version and start using it.
 
Last edited:
  • Like
Reactions: DWaters and Infopro

MadroosterTony

Member
PartnerNOC
Jan 14, 2007
17
9
153
Steps to upgrade to MySQL 5.7 manually (includes a step to run mysql_upgrade). Confirmed these work in v66.

1. Remove mysql* from /etc/yum.conf

2. Install the RPM

On CentOS6:

Code:
rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm
On CentOS7:

Code:
rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
3. Enable Mysql 5.7

Code:
yum-config-manager --enable mysql57-community
4. Remove any old versions of MySQL

Code:
rpm -e MySQL55-client MySQL55-test MySQL55-server
5. Install the new MySQL 5.7

Code:
yum -y install mysql-community-server
6. Start MySQL 5.7

Code:
service mysqld start
7. Upgrade any tables

Code:
mysql_upgrade
cPanel will automatically pickup the changed version and start using it.
Correct me if I am wrong, but cPanel will not create new users correctly in MySQL 5.7 with the current codebase.
 

Renato D.

Registered
Aug 16, 2017
1
0
1
Australia
cPanel Access Level
Reseller Owner
cPanel has always been a reference and leader in the hosting industry. It is really sad to see cPanel losing its edge due to poor management decision. And unfortunately it seems it will also start losing its clients. MySQL is by far the most important and used database for web applications. It is a very bad decision to delay the availability and support for MySQL 5.7.

We have been with cPanel for 7 years now and use it in over 6 of our own servers. In addition, we have over 300 clients using cPanel to manage their websites and they are all asking about MySQL 5.7. I investigated DirectAdmin and it seems to be an interesting option. We will need a new instance soon and we will give that a try. We want to have updated software and take advantage of all its benefits, specially the faster speeds of MySQL 5.7.

The reason why cPanel doesn't want to support it, considering it is such a small adjustment to their system, is still an unknown.

We would like to have an update on when (and if) MySQL 5.7 will be ever available in cPanel.
 

Robin Pretorius

Registered
Sep 18, 2017
1
0
1
Randburg
cPanel Access Level
Root Administrator
Isn't it lovely when you are developing integration systems only to find out you cannot support a technology in your databases because you are limited to MySQL5.6 by the control panel software being used.

Q3 of 2017 is coming to a close, yet no timeline or even action towards supporting this version?

CPANEL is the only option provided by my hosting supplier, so if this doesn't get resolved by year end, I guess ill just end up saving some money every month and start doing things the old fashioned without progress limiting management software.

Please CPANEL team could you make a decision, as whilst you don't seem keen to grow your own business any further and would rather see a client base decline, some of us are keen to grow our businesses and can merely stop using your software to do so.
 

ribo

Well-Known Member
Oct 15, 2015
66
2
8
Greece
cPanel Access Level
Root Administrator
Hello, i don t understand why to not have the option in cpanel to choose MySQL or Mariadb. I think that cpanel must think very seriously to support MySQL 5.7
 

Nirjonadda

Well-Known Member
May 8, 2013
724
27
78
cPanel Access Level
Root Administrator
I think that cpanel must think very seriously to support MySQL 5.7

I think cPanel thinking its Slowly, Slowly and More Slowly, cPanel are not care that what we are looking for ...:mad: Lot of feature requests are now out of date ... ;)
 

Samet Chan

Well-Known Member
Jun 24, 2016
359
32
103
cPanel Access Level
Root Administrator
Twitter
MariaDB is a drop in replacement for MySQL, MariaDB are not MySQL ... ;)
You're right, But it's my favorite old MySQL then now both best of MariaDB and MySQL as well,

I just found from official MySQL and MariaDB which they are not the same DB.

Is MariaDB compatible with MySQL? - Nov 17 said:
Although MariaDB is supposed to be compatible with MySQL, for one reason or the other there are quite a few compatibility issues and different features: MariaDBincludes all popular open source engines, no InnoDB though, XtraDB acts as a drop-in replacement, MariaDB claims several speed improvements over MySQL.
Read more: What's the difference between MariaDB and MySQL?
 

Hosted Power

Member
PartnerNOC
Sep 11, 2015
13
0
51
Belgium
cPanel Access Level
DataCenter Provider
I don't understand why it seems STILL not supported ??

cPanel made so many other and even incompatible changes that made us furious. This change could be done without interfering with anything, but it's still not done?
 

Altimatum

Registered
Sep 26, 2017
1
0
1
United Kingdom
cPanel Access Level
Root Administrator
I have a client who has built a website that relies on JSON field types in MySQL 5.7.

I'm surprised that there have been 18 releases, marked as General Availability, and no support by CPanel.

Even version 8 is due out soon?

What do I do?
 

mtindor

Well-Known Member
Sep 14, 2004
1,363
65
178
inside a catfish
cPanel Access Level
Root Administrator
An example of one of the points of discussion: will we continue to support both MySQL and MariaDB long term and absorb the development time and cost related to that
I would sure hope cPanel doesn't abandon MariaDB. I guess I need to look and see exactly what MySQL provides that MariaDB doesn't provide. I switched all servers I manage to MariaDB over the past couple of years and have never looked back. The performance of MariaDB (at least at the time of the switch) was magnitudes better than the available versions of MySQL.

Unless MySQL (a) provides serious features that MariaDB has no intent/ability to support _and_ (b) is at least as fast as the latest mainstream MariaDB, then I'd never have any desire to switch back. My customers love the performance that they now have with MariaDB but didn't have with MySQL. Granted, none of them have likely used MySQL 5.7 on a shared hosting server, and I haven't either.

I hope the discussion you all have internally is a very serious one, as I'm sure that a large portion of your customers are using MariaDB right now.

Mike
 

kwdamp

Active Member
Dec 7, 2017
30
3
8
usa
cPanel Access Level
Root Administrator
I'm appalled there has been no movement on this thread in almost 3 months. The date support ends for mysql 5.6 is a mere 2 months away.

I understand you don't want to pin yourselves (cpanel) into a corner, but it has gotten to the point that even more important than what your decision is; is that you make a decision in a timely manner.

We, unfortunately, will be migrating off of cpanel servers if mysql 5.7 isn't supported very soon.

I understand (some of) the reasoning behind cpanel pushing forward with MariaDB instead of mysql. But as I customer I'm VERY disappointed that cpanel failed to see that while they might be saving some dev headaches they are pushing those headaches onto their CUSTOMERS tenfold.

Even if MariaDB works with 99.9% of all applications we have to support, there is still an insane amount of overhead involved in communicating that to customers as well as migrating and testing numerous databases and customer applications. That COSTS US MONEY, even if it goes smoothly; which there is no guarantee it will.

It's very disappointing that Cpanel has failed to see that. And have now exacerbated the problem by mulling this over for over a year now with no end in sight.
 
C

cPanelUser-Inactive

Guest
Hi all! I'm so sorry for my lack of update here. We have definitely heard all of your concerns, and we are now planning to support MySQL 5.7. It looks like MySQL 5.7 support will be added as of Version 70. I don't want to promise yet, but it seems very, very likely. We're planning the first EDGE release of Version 70 as early as next week, and we should know for sure by then. We'll update both here and the feature request when we know for sure!

Additionally: we plan to support both MariaDB and MySQL going forward.