cPanel & WHM version 88 and Mysql 8 question?

[Spirogg]

Hello, I have 2 quick Questions for the next release of cPanel & WHM ver. 88

I've read that it will support Mysql 8

1st question : if we have already updated to MariaDB 10.3 is there a way to upgrade to Mysql 8 or not possible ?

2nd question : is there a huge speed difference between Mysql 5.7 and Mysql 8

will it be worth the upgrade to Mysql 8 ? Is it more Secure & Faster than 5.7 ?

or will MariaDB still be faster or more the asked for database than Mysql 8 and should we avoid Mysql 8 ?

any thoughts or comment are much appreciated
Thank in advance

Regards,
Spiro

 

[vacancy]

If it is not wrong information, you cannot upgrade from mariadb to mysql 8. Mysql can be upgraded from 5.7 to 8.

According to some tests, mysql 8 seems to have better performance than mariadb, but this may differ depending on database structures and query types.

DimitriK's (dim) Weblog : MySQL Performance : 8.0 and UTF8 impact

Benchmarking InnoDB and MyRocks Performance using Sysbench

Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering

minervadb.com

 

[Spirogg]

@vacancy Thank you for your response... Seems promising your link of benchmarks - I will stay with 5.7 now and Ill wait till version 88 to try Mysql 8 and see the difference

hopefully at that point we can upgrade to MariaDB as well from Mysql 8
or
I can always create a dummy test vps to see how thing workout before doing anything stupid on my server keep it safe

 

[cPanelLauren]

Because MariaDB is considered and upgrade from MySQL it is not available to update to MySQL 8 from MariaDB 10.3

I have an edge server running
Current Version
MariaDB 10.3.22-MariaDB



MySQL 8 is not an available option when running MariaDB.

 

[splaquet]

is it possible to upgrade from mariadb 10.3 to mysql 8? i've been having a very difficult time finding any 'Official cPanel: MySQL 8 Upgrade from MariaDB 10.3' info. i've found random articles throughout the web, but would preferably like to keep it aligned with cPanel releases.

 

[vacancy]

is it possible to upgrade from mariadb 10.3 to mysql 8? i've been having a very difficult time finding any 'Official cPanel: MySQL 8 Upgrade from MariaDB 10.3' info. i've found random articles throughout the web, but would preferably like to keep it aligned with cPanel releases.

It is not possible to switch from mariadb versions to mysql versions.

However, you can make a custom switch by removing mariadb and installing mysql rpm's. Cpanel does not recommend this transition.

 

[splaquet]

thank you kindly @vacancy

...not sure if this is kosure to post, but here's the MySQL install info for CentOS7
https://centos.pkgs.org/7/mysql-8.0...-server-8.0.11-1.el7.x86_64.rpm.html#download
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html