Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 1 to 10 of 22596 « Previous | Next »
Displaying posts with tag: MySQL (reset)
Crafting an Extension Framework for MySQL: a talk from MySQL BR Conf 2026

I opened my MySQL BR Conf 2026 talk creating a new data type that stock MySQL doesn’t have: ROT13. … OK, admittedly, it’s a silly type. With a ROT13 column, you insert plain strings and read back plain strings, but the table stores scrambled text. … OK, it’s very *very* silly. But the point of this example isn’t to convince you extensions are useful; it’s to show a tiny extension that allows exploring design choices we made in designing the VEF (VillageSQL Extension Framework).

What the talk covers

  • Simpler functions and aggregates. VDF’s (VEF-Defined Functions) resemble MySQL UDF’s (User-Defined Functions), but are easier to write. I explore how we made it both more ergonomic in C++ and also how we make it harder to mess up.
  • Types …
[Read more]
MySQL MCP Server v1.8.0 is out

On paper it’s a boring release. No new tools, no new flags, nothing to reconfigure. In practice it’s one I’m glad I didn’t skip: it closes 37 known vulnerabilities that the server could actually reach, and I found them more or less by accident.

It started as a compatibility check

I had MySQL 8.4, 9.7 and 26.7 running on my test box, plus MariaDB 12.3. So I pointed the MCP server’s test suite at all of them. Mostly to tick a box before moving on to something more fun.

The code was fine. Every version passed.

MySQL 26.7 and MariaDB 12.3 join the matrix

Every pull request now runs the full integration suite against six servers:

  • MySQL 8.0, 8.4, 9.7 and 26.7
  • MariaDB 11.4 and 12.3

26.7 is the first Innovation release under Oracle’s new calendar versioning. If you follow MyVector, you know I’ve …

[Read more]
Optimize OLTP and OLAP Workloads with MySQL HeatWave Autopilot

As businesses grow, their databases must support both fast transactions and timely analytics. OLTP workloads handle everyday operations such as orders and payments, while OLAP workloads analyze large datasets for reporting and planning. Without appropriate optimization, growing data volumes and competing resource demands can slow transactions and delay insights. MySQL HeatWave supports online transaction processing […]

What’s New in MySQL NDB Cluster 9.x – Better Visibility and Control in MySQL NDB Cluster

MySQL NDB Cluster 9.x continues to focus on the qualities that matter most in production: clear operational insight, predictable behaviour under failure, efficient application access, and faster recovery. This release series adds practical observability across the cluster, strengthens several exceptional paths, and expands the control available to users. Better visibility into cluster operation Diagnosing a […]

Benchmarking vector indexes in MySQL with vector-dev-bench

PostgreSQL has a rapidly evolving vector ecosystem. MySQL is earlier on that road, but the community is hard at work catching up. MariaDB ships its own HNSW index, Google engineers have shared a ScaNN-based vector index on MySQL's own vector index proposal, Percona is building an HNSW index inside InnoDB, and VillageSQL is building vector search as an extension with vsql-vector.

We want vector search on MySQL to be something that teams can …

[Read more]
MySQL October 2026 GA Releases Now Available

The October 2026 MySQL releases are now available, including: MySQL 26.10 brings additional capabilities to Community Edition, new options for building REST applications, and improvements to database operations and developer tools. MySQL 9.7.4 and MySQL 8.4.13 continue maintenance updates for the supported LTS release lines. October MySQL Server releases MySQL 26.10 Innovation delivers new functionality […]

Introducing the MySQL REST Service Component: Now Generally Available

With MySQL 26.10, we’re announcing the general availability of the MySQL REST Service (MRS) Component, an installable component that runs MRS directly inside MySQL Server. MRS: the MySQL REST Service Many modern applications, well, not just applications, but also tools, CLIs, CI pipelines, and automation, use HTTP and JSON to communicate with other systems. For […]

MySQL 26.10 Is Here: New Capabilities for Developers and DBAs

MySQL 26.10 is here! This release brings MySQL REST Service into the server, expands Community Edition capabilities, and adds more control for applications using JSON Relational Duality Views. Here’s a look at the highlights. MySQL REST Service joins the server MySQL REST Service (MRS) is now available as a MySQL Server component, enabling HTTPS endpoints […]

MySQL JSON Duality Views: Now with granular write and ETAG controls

JSON Duality Views (JDVs) let applications read and write JSON documents backed by relational tables (see our introductory JDV blog). MySQL handles the document-to-table mapping, reducing application code while preserving relational integrity. We still need to decide which parts of a document applications can change. Earlier JDVs offered limited choices: table writes were generally all-or-nothing, and […]

Troubleshooting MySQL with OpenTelemetry Metrics

In the first post, we exported native MySQL telemetry to Prometheus. In the second, we organized those metrics around DBA questions. In the third, we built a Grafana dashboard that makes those questions visible. This final post shows how to use that dashboard when an application slows down or a database signal changes. The goal […]

« Previous | Next »