Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
WePay’s Journey to Enhanced Database Performance with MySQL Enterprise Edition
In an era where online payments dominate the financial landscape, ensuring security, reliability, and compliance is crucial. WePay, the integrated payments arm of JPMorgan Chase, has taken significant strides to enhance its database infrastructure by upgrading to MySQL Enterprise Edition. This transition not only addresses the challenges of operating a robust payment system but also […]
New JSON format for EXPLAIN
MySQL provides two great tools for analyzing query plans: EXPLAIN and EXPLAIN ANALYZE. EXPLAIN displays the execution plan chosen by the optimizer and stops before executing, while EXPLAIN ANALYZE actually executes the query and gathers statistics about processing time and number of rows returned by each operation. The output format can be tabular (TRADITIONAL), TREE […]
Using the MySQL “SET ROLE” to Enforce “Least Privilege” Principles
MySQL allows the grouping of grants and privileges using database ROLEs. A ROLE is a named collection of database privileges. Diagram 1: Users in MySQL can be GRANTED one or more ROLEs, ROLEs can be granted one or more Privilege A MySQL DBA can A MySQL application developer can DBAs should create job-related task-based […]
preFOSDEM MySQL Belgian Days 2025 – save the dates
As announced yesterday, the MySQL Devroom is back at FOSDEM! For people preparing for their travel to Belgium, we want to announce that the MySQL Belgian Days fringe event will be held on the Thursday and Friday before FOSDEM. This event will take place on January 30th and 31st, 2025, in Brussels at the usual […]
FLUSH_PRIVILEGES: A new dynamic privilege to execute FLUSH PRIVILEGES
Introduction MySQL has support for the RELOAD privilege. Now, imagine a database user who has been granted the RELOAD privilege, which allows this user to execute the FLUSH PRIVILEGES statement on the system. Suppose this user accidentally executes another powerful statement like RESET or FLUSH TABLES. The consequences could lead to some problems, right? Consider […]
How to use passkeys to authenticate to MySQL
FIDO2 WebAuthN is a modern, widely supported and increasingly useful standard getting us closer to The Passwordless Future. MySQL has supported multi-factor authentication (in the Enterprise Edition) since 8.0. And, as of 8.2, we added support for WebAuthN authentication. But the support was primarily geared towards using hardware based FIDO2 authenticator devices (e.g. Yubikeys). While […]
The MySQL Hypergraph Optimizer Now Available in HeatWave MySQL
Last year, in MySQL 8.0.31, we announced how HeatWave uses the new MySQL hypergraph optimizer to get better query plans. Since then, we have continued to work on the optimizer, and starting with MySQL 9.0, it has been enabled as an opt-in feature in HeatWave MySQL. This new feature is only available in HeatWave MySQL […]
MySQL Connector/J Observability with OpenTelemetry
Introduction In today’s increasingly complex software landscape, understanding and debugging the inner workings of distributed applications are more challenging than ever before. As applications become more distributed, spanning multiple services and environments, traditional monitoring approaches often fall short of providing comprehensive insights into system behavior and performance. This is where observability comes into play. Observability […]
MySQL NDB Cluster 8.4 – What’s new
The MySQL NDB Cluster Development team is happy to announce MySQL NDB Cluster 8.4 (LTS) is available for download. This release includes new features made available under Innovation Releases – 8.1, 8.2 and 8.3 – and new features released under 8.4 which are described below. MySQL NDB Cluster binary and source packages are available to […]
FOSDEM 2025 MySQL Devroom – call for participation
We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024. FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, […]