Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
FLUSH_PRIVILEGES: A new dynamic privilege to execute FLUSH PRIVILEGES
MySQL 8.4 introduces a new privilege, FLUSH_PRIVILEGES, which allows database users to execute FLUSH PRIVILEGES statement without the need of RELOAD privilege.
How to use passkeys to authenticate to MySQL
MySQL 9.1 adds support for Windows Hello. And this supports passkeys stored on the OS store. Check how to set up and use one of these instead of the hardware based FIDO2 devices
The MySQL Hypergraph Optimizer Now Available in HeatWave MySQL
Starting with MySQL 9.0, users of HeatWave MySQL can now try the new hypergraph optimizer. Read on to learn how to enable the hypergraph optimizer, and to understand what it means for your query plans.
Impressed by Disabling InnoDB Redo Logging for Creating Tables as Fast as Possible
In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables. I already wrote a post about my work (Faster MySQL Startup with Many Tables). In that post, I link to a bug report (Bug #115988 : Too Much Disk Read on Startup, penalizing deployments with many tables). In that bug report, I write, without much details, that theJean-François Gagnéhttp://www.blogger.com/profile/12267071794432977020noreply@blogger.com0
MySQL NDB Cluster 8.4 - What's new
The MySQL NDB Cluster Development team is quite happy to announce that MySQL NDB Cluster 8.4 (LTS) is available for download. This release includes new features made available before under Innovation Releases - 8.1, 8.2 and 8.3 - and new features made available in 8.4.
MySQL Connector/J Observability with OpenTelemetry
The OpenTelemetry project is an open-source, vendor-neutral observability framework, providing a common observability standard. It enables users to instrument their applications in order to export observability data: traces, metrics, and logs, enabling increased granularity of debugging and testing. MySQL Connector/J now supports producing observability data, baked into the driver code, offering a more comprehensive and tightly integrated solution with the MySQL Enterprise Server.
FOSDEM 2025 MySQL Devroom - call for participation
This is the call for participation for the FOSDEM 2025 MySQL Devroom
October MySQL Meetups - Recap.
Oct 2024 Meetups Recap
Offline mode error improvement
This blog post describes work that landed in MySQL v9.0 and implements generic mechanism to attach key/value attributes to a global system variable, used to improve error messages related to "offline mode".
Zero Downtime: Upgrading MySQL Server in a Tungsten Cluster
Introduction
Tungsten Clustering allows for many types of maintenance to happen with no downtime at all.
This blog post will explore how to upgrade the actual MySQL Server on all cluster nodes with zero downtime. These same steps may be used to upgrade the MySQL server or patch the OS.
Zero-Downtime Upgrade Steps
This is a zero-downtime upgrade:
Pick a replica node and shun it, and take all replication offlinePages
Sources:
MySQL expert Diary