Install MySQL Enterprise on server with MySQL 5.5?

.Tyler

Registered
Jun 12, 2018
1
0
1
Wichita
cPanel Access Level
Root Administrator
Our server, which has WHM/CPanel installed, is running MySQL 5.5. After learning about the tools that MySQL Enterprises has, we would like to install it but not sure if this would break anything on our server. We have a support ticket in but am wondering if anyone else has installed this on their server with WHM/CPanel.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Hello @.Tyler,

Here's a copy of part of the response sent by one of our Technical Analysts on the support ticket you opened in-case others have the same question:

You should be able to install and use MySQL Enterprise on your server -- but there are some caveats you should know before you attempt it.

While it may be possible to install and use MySQL Enterprise Edition with WHM, we can not provide any assistance with installing it, and it is not tested by our developers. Any issues that arise as the result of using this version of MySQL would fall outside the scope of our support.

If you choose to install MySQL Enterprise Edition, you would need to instruct WHM not to upgrade, install, or uninstall MySQL 5.6. Disabling the MySQL 5.6 package management in WHM can be accomplished by running the following command:

/scripts/update_local_rpm_versions --add target_settings.MySQL56 unmanaged

If you need to disable MySQL 5.5, run this instead:

/scripts/update_local_rpm_versions --add target_settings.MySQL55 unmanaged

The above will prevent WHM from trying to manage the RPM packages of MySQL (but only the packages, not other functions of WHM & cPanel), so that you can replace them with custom packages. If you want to remove those settings so that WHM will manage the MySQL packages again:

/scripts/update_local_rpm_versions --del target_settings.MySQL56

The above would again allow WHM to upgrade, install, or uninstall MySQL 5.6 that is provided by cPanel. If you need to do with with 5.5 instead, simply change "56" to "55".

Additionally, before attempting to install MySQL Enterprise, I would highly recommend that you take full backups of all of your databases, so that you can restore them if anything goes wrong.
Additionally, I encourage you to vote and add feedback to the following feature request if you'd like to see native support for MySQL Enterprise installations:

Supporting MySQL Enterprise and MySQL Cluster CGE

Thank you.