Right before FOSDEM kicked off, the preFOSDEM MySQL Belgian Days returned to the usual place in Brussels for two packed days (Jan 29-30, 2026). The format stayed true to what makes this event special: a friendly, hallway-track-heavy gathering with serious technical content — this year running two parallel tracks and the grand final: the RockStars […]

We are pleased to introduce the ability to export MySQL HeatWave backup data directly to an OCI Object Storage bucket in your tenancy, enabling a one-step process to create an exported backup via the Console or API. This process creates a logical dump from the backup without utilizing DB system resources, thereby minimizing the impact on the […]

As we mark the milestone of MySQL’s 30-year anniversary, the celebrations around the globe have been a testament to the widespread impact and popularity of the Dolphin. This week’s annual preFOSDEM MySQL Belgian Days in Brussels are not only an opportunity to celebrate, but also a chance for Oracle to share some key updates on […]

The new protocol dissector for X Protocol in MySQL was just merged to the master branch in Wireshark. To get it build Wireshark from the master branch or wait for the next release.

This protocol is using Google Protobuf, which makes it much easier to work with than the regular MySQL protocol.

See also: https://dev.mysql.com/doc/dev/mysql-server/latest/page_mysqlx_protocol.html 

If you like what Wireshark does, consider donating on https://wiresharkfoundation.org/donate/ 

MySQL 8.0 is scheduled for End of Life (EOL) in April 2026. In line with this milestone, we previously announced in this Oracle blog post that all existing MySQL HeatWave instances running version 8.0 would be automatically upgraded to the latest supported 8.4 release after April 2026. However, understanding the operational realities and planning cycles […]

MySQL is taking a significant step forward by rethinking how foreign key constraints and cascades are managed. Starting with MySQL 9.6, foreign key checks and cascade operations will be handled directly by the SQL engine rather than the InnoDB storage engine. This improvement addresses long-standing challenges with change tracking, binary log replication, and data consistency, making […]

When a replica fails due to corruption or drift, the standard solution is to rebuild it from a fresh copy of the master when pt-table-sync is not an option. Traditionally, when we need to build a new replica, we use a physical backup for speed, but there are some cases where you still need logical backups. For instance, when you migrate to a specific vendor (i.e.: MariaDB to MySQL) or storage engines (in the past MyISAM to InnoDB and nowadays from InnoDB to RocksDB), upgrade to a new database version or move to a cloud based solution. This is where a logical backup shines, offering portability and simplicity, but only if it can be performed quickly. MyDumper emerges as the essential, modern solution, delivering the best of both worlds: the cross-platform, cross-version flexibility of a logical dump combined with the parallel, multi-threaded speed previously reserved for physical methods, making it the clear choice for rapidly rebuilding a consistent …

In this blog post, we will show you how to reset the MySQL root Password on a Linux operating system. ...

Read More

The post How to Reset MySQL Root Password appeared first on RoseHosting.

From Concepts to Production: Real-World Patterns, Query Plans, and What’s Next

In Part I, we introduced scoped vector search in MySQL using the MyVector plugin, focusing on how semantic similarity and SQL filtering work together.

In Part II, we explored schema design, embedding strategies, HNSW indexing, hybrid queries, and tuning — and closed with a promise to show real-world usage and execution behavior.

This final part completes the series.

Semantic Search with Explicit Scope

In real systems, semantic search is almost never global. Results must be filtered by tenant, user, or domain before ranking by …

I have a curse. My curse is curiosity. 

Here in Percona I found one person that is very “dangerous” for me, and he and I also share the same first name, well almost, Marcos Albe. 

Marcos is a smart guy with a lot of ideas, and he is not shy to share them. One day we were talking about sysbench, and he mentioned to me: you know it would be nice to have a test for joins in sysbench. I wonder why we don’t have it; it will be so useful to identify regressions in that area.
You see where this is going right? He put that in my mind, luckily I was busy with other stuff and I forgot. Until one day. That day I had to take a more in-depth look at some claims about joins performance regressions. In that moment Marcos voice comes back as an echo resonating in my mind … it would be useful to identify regressions… 

That’s it. Ok let’s do it, let’s build this joins test and see how …