With this release, we add support for MySQL 8.0 on Hypernode. This is one of the requirements needed for Akeneo 4.0.
To prevent compatibility issues with older versions, we do not allow downgrading from MySQL 8.0 back to either 5.6 or 5.7.
Upgrading your Hypernode to MySQL 8.0
Upgrading your database to MySQL 8.0 can be done easily on your Hypernode. Simply run the command hypernode-systemctl settings mysql_version --value 8.0
and our automated systems will make sure that the given version is installed. Make sure to use the livelog
command to check the progress on the update job.
Note that upgrading to MySQL 8.0 is only possible from MySQL 5.7. If you’re not using this version yet, then you can use the following command to upgrade to version 5.7 first: hypernode-systemctl settings mysql_version --value 5.7
.
We do not allow downgrading your MySQL version back to either 5.6 or 5.7. This is to make sure that any changes that are made to your database which are done specifically for MySQL 8.0 will not break your database when switching back to older versions.
New features of MySQL 8.0
MySQL 8.0 offers a huge number of new features compared to MySQL 5.7. We’re not going to name them all in this post (but please have a look at the official MySQL 8.0 summary), but here’s a quick summary of some of the more notable features:
- Roles for easier managed of privileges per MySQL user (see the roles documentation)
- Improved JSON functionality with statements like
JSON_EXTRACT
orJSON_ARRAYAGG
- New default character set changed to
utf8mb4
. This also allows you to use some sweet emojis in your tables
Magento incompatibility
We do not recommend using MySQL 8.0 with Magento 1 or 2 as this is not yet compatible with these Magento versions. MySQL 8.0 can be used for Akeneo 4.0, Shopware 5 and 6 and OpenMage