hypernode-systemctltool to give you the ability to upgrade your MySQL version to
Upgrading your Hypernode to MySQL 5.7
If you want to upgrade your existing Hypernode from MySQL 5.6 to MySQL 5.7, you can simply run the following command via the CLI:
hypernode-systemctl settings mysql_version --value 5.7
This will post an update job to our systems which will automatically transition your existing database to the new version. Note: this will temporarily turn off your database as we need to install the new MySQL version.
Once you upgraded to MySQL 5.7 you can no longer downgrade to MySQL 5.6. We disallow this downgrade as we cannot guarantee a smooth transition back to this older version because of incompatible changes that are being made.
What’s new in MySQL 5.7
Besides adding support for Akeneo and Shopware, MySQL 5.7 also gives you several features that might be a great addition for your Hypernode. Below is a summary of some of the noticable changes:
- The new default
sql_modeis set to
STRICT_TRANS_TABLES, which will set stricter constraint when setting values in your database. This will result in clearer data constraint errors; MySQL 5.6 tends to not complain when an invalid value was set for a given field.
- Performance metrics of your database are moved from the
information_schema.global_statustable to the
passwordfield in the
mysql.usertable is renamed to
- Database and table names can now be a maximum of 32 characters long, up from 16 characters.
For a full list of changes compared to MySQL 5.6 please have a look at the changelog from MySQL.