We’re excited to announce that MySQL 8.4 is now supported on Hypernode for Debian Bookworm!
What’s New
-
MySQL 8.4 support across the Hypernode platform and API.
-
Authentication plugin checks for MySQL users:
-
If any users are using unsupported auth plugins (anything other than
caching_sha2_password), the upgrade will be not be possible. -
Upgrading to 8.4 is only supported from MySQL 8.0.
-
How to upgrade
Upgrading your database to MySQL 8.4 can be done easily on your Hypernode. Simply run the command hypernode-systemctl settings mysql_version 8.4 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.4 is only possible from MySQL8.0. If you’re not using this version yet, then you can use the following command to upgrade to version 8.0 first: hypernode-systemctl settings mysql_version 8.0.
How to Upgrade Your MySQL Version
If any users are using unsupported auth plugins (anything other than caching_sha2_password), the upgrade will not be possible.
Changing the Authentication Plugin for a Custom MySQL User
New Features in MySQL 8.4
-
Default deprecation of
mysql_native_password– It’s no longer enabled by default. -
Improved InnoDB defaults for performance and scalability (e.g.
innodb_io_capacity,innodb_log_buffer_size, NUMA interleaving). -
Clone plugin now allows cross-patch version cloning (e.g. from 8.4.0 to 8.4.14).
-
Group Replication improvements, including more robust DDL tracking and memory usage instrumentation.
-
New privileges:
-
FLUSH_PRIVILEGES(granular control over privilege flush operations) -
OPTIMIZE_LOCAL_TABLE(required for local table optimizations)
-
-
Automatic histogram updates for better query planning.
-
Better shutdown and startup logging, including plugin/component lifecycle tracking.
-
TLS certificate enforcement option (
tls-certificates-enforced-validation)
Let us know if you run into any issues or have questions via our support.