Showing entries 1 to 10 of 22511
10 Older Entries »
Displaying posts with tag: MySQL (reset)
Wireshark now can decode MySQL X Protocol

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/ 

 

 

Extending MySQL 8.0 support in MySQL HeatWave

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 […]

No More Hidden Changes: How MySQL 9.6 Transforms Foreign Key Management

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 […]

Rebuilding a Replica with MyDumper

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 […]

Scoped Vector Search with the MyVector Plugin for MySQL — Part III

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 …

[Read more]
joins... joins... everywhere

 

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 …

[Read more]
Separating FUD and Reality: Has MySQL Really Been Abandoned?

Over the past weeks, we have seen renewed discussion/concern in the MySQL community around claims that “Oracle has stopped developing MySQL” or that “MySQL is being abandoned.” These concerns were amplified by graphs showing an apparent halt in GitHub commits after October 2025, as well as by blog posts and forum discussions that interpreted these […]

Native Password Legacy for 9.6

In the previous article, I shared a solution for people who want to try the latest and greatest MySQL version. We just released MySQL Innovation 9.6, and for those willing to test it with their old application and require the unsafe old authentication method, here are some RPMs of the legacy authentication plugin for EL/OL […]

Where can you find MySQL during January to April 2026

As a follow-up to our previous blog post, we are excited to invite you to a variety of shows, meetups, and events that we will be participating in from January 2026 through April 2026. Below, you will find the specific dates and locations. We look forward to connecting with you and sharing valuable insights during […]

The 10 TB Scale Survival Guide for Percona Operator PXC on Kubernetes

"What happens when you run a 10 TB MySQL database on Kubernetes?" 


That's the question many of our customers and users asked and honestly, we were extremely curious ourselves.

So, we ditched the weekend plans, rolled up our sleeves, and jumped down the rabbit hole. What we found was far more challenging (and perhaps a bit more "psychedelic") than expected. We spent days rigorously testing the Percona Operator for PXC at massive scale. 

This blog post distills all our findings into the most critical, actionable advice you need to ensure your high-scale environment not only survives but operates reliably.

If you are lazy and prefer to watch a video, here is the presentation I did at the MySQL Belgian days in January 2026.

First of …

[Read more]
Showing entries 1 to 10 of 22511
10 Older Entries »