MySQL 8.0 Support
Completed
As a cPanel user, I would like support for MySQL version 8 as this version provides a large number of quality of life improvements over MySQL Version 5.7.
I like this idea 
cPanel, WebHost Manager and WHM are registered trademarks of cPanel, L.L.C. for providing its computer software that facilitates the management and configuration of Internet web servers.
This is a good idea because MYSQL 8 is 3 times more powerful than MYSQL 5.7
This is a good idea because MYSQL 8 is 3 times more powerful than MYSQL 5.7
Any update on this support?
It's much faster than MySQL 5.7.
https://www.mysql.com/products/enterprise/database/
Any update on this support?
It's much faster than MySQL 5.7.
https://www.mysql.com/products/enterprise/database/
It's been a year since GA - MySQL 8.0.11 (2018-04-19, General Availability). Hope to see it soon in cPanel.
It's been a year since GA - MySQL 8.0.11 (2018-04-19, General Availability). Hope to see it soon in cPanel.
I'm curious about MYSQL 8 as well and curious how you guys feel about it compared to MariaDB.
I'm curious about MYSQL 8 as well and curious how you guys feel about it compared to MariaDB.
We were promised that this was around the corner when we had a meeting in march in Cloudfest.
Whats the hold up?
We were promised that this was around the corner when we had a meeting in march in Cloudfest.
Whats the hold up?
I'm waiting for this.
MySQL 8 availability in cPanel would be a great.
I'm waiting for this.
MySQL 8 availability in cPanel would be a great.
Please, remove the 8 characters prefix restriction, like in MariaDB.
Please, remove the 8 characters prefix restriction, like in MariaDB.
Any update?
Any update?
Also, MySQL8 has JSON document management capability that 5.7 has not (limited). My application wants to use the JSON related functionality that is now not accessible via cPanel (and hosts that offer cPanel).
Also, MySQL8 has JSON document management capability that 5.7 has not (limited). My application wants to use the JSON related functionality that is now not accessible via cPanel (and hosts that offer cPanel).
Here is what MySQL 8 offers, which I can run on my local machine but sadly not on cPanel.
JSONMySQL 8.0 adds new JSON functions and improves performance for sorting and grouping JSON values.
There are over 10 new extremely useful JSON functions. Which would have helped me insanely while building a "Survey Application". Due to lack of these functions I had to write 100-200 lines of SQL queries.
RANK()
This function is the craziest of all for me, without any exceptions, I have a place where I need to rank a table, in all of my apps. Without this I need to do some extremely unreadable and clunky extra coding. https://stackoverflow.com/questions/3333665/rank-function-in-mysql
There is no need to mention indexing improvements.
Here is what MySQL 8 offers, which I can run on my local machine but sadly not on cPanel.
JSONMySQL 8.0 adds new JSON functions and improves performance for sorting and grouping JSON values.
There are over 10 new extremely useful JSON functions. Which would have helped me insanely while building a "Survey Application". Due to lack of these functions I had to write 100-200 lines of SQL queries.
RANK()
This function is the craziest of all for me, without any exceptions, I have a place where I need to rank a table, in all of my apps. Without this I need to do some extremely unreadable and clunky extra coding. https://stackoverflow.com/questions/3333665/rank-function-in-mysql
There is no need to mention indexing improvements.
Any update? at least let us know when you are providing this update?
Any update? at least let us know when you are providing this update?
Is it possible to create a dump from MariaDB and import it back in MYSQL8?
Is it possible to create a dump from MariaDB and import it back in MYSQL8?
To be able to use the "cPanel migration tool" without errors, i.e. to migrate a cPanel account from a MariaDB server to a MySQL 8 server, it is important to remove the 8 character limit in the database prefix for MySQL 8 servers.
As MySQL 8 has a 64 character limit on database names, there is no reason for cPanel to impose a forced limit like in MySQL 5.x
I hope that cPanel developers understand the importance of this situation.
To be able to use the "cPanel migration tool" without errors, i.e. to migrate a cPanel account from a MariaDB server to a MySQL 8 server, it is important to remove the 8 character limit in the database prefix for MySQL 8 servers.
As MySQL 8 has a 64 character limit on database names, there is no reason for cPanel to impose a forced limit like in MySQL 5.x
I hope that cPanel developers understand the importance of this situation.
Replies have been locked on this page!