|
Planet MySQL
|
Planet MySQL - https://planet.mysql.com
|
-
How ProxySQL 3.0.8 improves MySQL session-variable tracking
ProxySQL 3.0.8 extends session-variable tracking beyond parsed SET statements by consuming MySQL session-state notifications from backend OK packets.
-
Building an AI Vision Search Engine with MySQL HeatWave GenAI
Modern AI systems increasingly rely on multimodal data: text, images, documents, audio, and video. Among these modalities, image understanding has become one of the most important capabilities for AI-powered applications.
Traditionally, implementing these capabilities required specialized computer vision infrastructure, external vector databases, custom ML pipelines, and multiple frameworks.
With MySQL HeatWave GenAI, many of these capabilities can now be implemented directly inside SQL workflows using built-in AI routines.
In this article, we will build the foundations of a Vision Model Evaluation Assistant using MySQL HeatWave GenAI. The objective is not to create another image classifier, but rather a semantic image understanding platform.
The post Building an AI Vision Search Engine with MySQL HeatWave GenAI first appeared on dasini.net - Diary of a MySQL expert.
-
MySQL Community Update: Public Discussion #4, Design Proposals, and Contributor Summit
Following the strong engagement across the first three editions of our Public MySQL Community Discussion series, we’re pleased to invite you to Edition #4. We will focus on the upcoming contribution process changes and our Contributor Summit later in May. This ongoing series is part of our commitment to increase transparency, strengthen collaboration, and provide […]
-
MyVector v1.26.5: Component Architecture Arrives
MySQL 9.7 LTS Support Lands Released May 8, 2026 · GitHub Release
v1.26.5 introduces a MySQL Component build for MySQL 8.4 LTS and 9.7 LTS, a unified logging abstraction, and a set of plugin stability fixes. The plugin path for MySQL 8.0, 8.4, and 9.0 is unchanged.
Why the Component architecture matters
MySQL has been deprecating the legacy plugin API in favor of the Component architecture since 8.0. Components install via INSTALL COMPONENT, integrate through typed service interfaces, and are better isolated from server internals — meaning fewer breakages across MySQL minor versions and a supported path forward as the plugin API winds down. For MyVector, this move isn’t optional in the long run: the component model is where MySQL’s extension ecosystem is heading, and building on it now means users on 8.4 LTS and 9.7 LTS get a stable, upgrade-resilient foundation rather than a deprecated one.
What’s New
MySQL Component build. MyVector can now be installed via INSTALL COMPONENT on MySQL 8.4 and 9.7. The component ships UDF registration, binlog-driven index synchronization, and a query rewrite service hook — all backed by the same core vector index engine as the plugin. A new myvector_log.h abstraction unifies logging across both build modes, replacing scattered #ifdef blocks.
MySQL 9.7 LTS. The 9.x CI, release, and Docker targets move from 9.6 to 9.7 LTS. A new Docker image tag ghcr.io/askdba/myvector:mysql9.7 is now available. If you’re on :mysql9.6, switch to :mysql9.7.
Plugin stability fixes. gmtime() and asctime() replaced with their thread-safe _r variants; concurrency fixes in plugin init/deinit; null-guard added to myvector_ann_set row function. Also: config file permission hardening, a binary_log namespace conflict fix on 8.4/9.7, and a Quick Start wget URL correction (issue #89).
How to Install
Component — pre-built binaries (Linux amd64) are attached to this release:
bash
tar -xzf myvector-component-mysql8.4.8-linux-amd64.tar.gzcp libmyvector_component.so $(mysql_config --plugindir)/mysql -u root -p -e "INSTALL COMPONENT 'file://libmyvector_component';"
Also available: myvector-component-mysql9.7.0-linux-amd64.tar.gz and checksums.txt. To build from source, use scripts/build-component-8.4-docker.sh or scripts/build-component-9.7-docker.sh.
Plugin — Docker or build from source. Pre-built plugin .so files are not on the release page. Use Docker (multi-arch, amd64 + arm64):
bash
docker pull ghcr.io/askdba/myvector:mysql8.4 # or :mysql8.0, :mysql9.7
Or build from source with scripts/build-release.sh (requires MySQL dev headers).
Upgrade Notes
No schema or index migration required.
Docker tag change: :mysql9.6 → :mysql9.7.
The component path is the forward path for MySQL 8.4+. The plugin remains supported for 8.0/8.4/9.0 through their EOL dates.
Windows is not supported — use Linux container images.
See docs/BUILD_MODES.md and docs/COMPONENT_MIGRATION_PLAN.md for migration guidance. Bugs and feedback welcome on GitHub Issues.
-
A New Era of MySQL Monitoring: OpenTelemetry Metrics with Prometheus
In modern application development, observability is no longer optional. It is a core requirement for stable operations, faster troubleshooting, and better understanding of system behavior. Databases are especially important because they often sit at the center of application performance. When a database becomes slow, overloaded, or unavailable, the impact is usually felt across the entire […]
|
