The latest from the MySQL community

I am continuing my blog post series on using indexes — or tables — as queues.  In this post, I cover Row Deletion Jobs (I do not call these purge jobs, to avoid confusion with the InnoDB Purge).  Such jobs are tempting to implement using an index, but this might be a wrong / suboptimal way.  I write about the right / better / cheaper way

In traditional MySQL, analytics require data to be ingested into InnoDB tables and processed on a single primary instance using row-based storage engine and limited parallelism. Scaling analytical workloads typically involves replicas, ETL pipelines, or even external analytics system.  With MySQL HeatWave, Oracle’s fully managed service in the cloud, analytics execution is offloaded to a […]

In traditional MySQL, analytics require data to be ingested into InnoDB tables and processed on a single primary instance using row-based storage engine and limited parallelism. Scaling analytical workloads typically involves replicas, ETL pipelines, or even external analytics system.  With MySQL HeatWave, Oracle’s fully managed service in the cloud, analytics execution is offloaded to a […]

As we set out to help the MySQL ecosystem assert greater independence from Oracle by establishing a vendor-neutral industry association, we had to confront a deceptively simple question:

What exactly is the MySQL ecosystem?

There are many views on this question.

Some argue it should revolve strictly around the MySQL brand—meaning MariaDB would be excluded. Others believe it should be defined by codebase lineage—therefore ruling out systems like TiDB. Still others insist it must center exclusively on open-source software, which would exclude offerings such as AWS Aurora for MySQL.

We believe this kind of exclusivity is counterproductive. It shifts the focus to boundaries instead of outcomes.

What truly matters are MySQL users: the …

As discussed in the earlier blog post A new Era of Community Engagement, there are many ways to connect with the MySQL Community.  MySQL Community: Ways to Learn, Connect, and Contribute (and See What’s Next)  MySQL is shaped by the people who use it—developers, DBAs, educators, user group leaders, and contributors around the world. The […]

I am starting a blog post series on using indexes — or tables — as queues.  I had this series in the back of my mind for some time.  This started a few years back when I worked on optimizing a row deletion job (I do not call this a purge job, to avoid confusion with the InnoDB Purge).  Such jobs can be generalized to using indexes (or tables) as queues (this is

This guide explains how to subtract days from dates across MySQL, H2, and other databases with different SQL dialects. Learn how to standardize behavior using compatibility modes, wrapper functions, and unified tooling so the same logic works reliably even when multiple database engines run side by side.

The post Mastering Cross-Database Date Manipulation: Subtracting Days in MySQL and H2  appeared first on Devart Blog.

MySQL Security Best Practices: A Practical Guide for Locking Down Your Database Introduction

MySQL runs just about everywhere. I’ve seen it behind small personal projects, internal tools, SaaS platforms, and large enterprise systems handling serious transaction volume. When your database sits at the center of everything, it becomes part of your security perimeter whether you planned it that way or not. And that makes it a target.

Securing MySQL isn’t about flipping one magical setting and calling it done. It’s about layers. Tight access control. Encrypted connections. Clear visibility into what’s happening on the server. And operational discipline that doesn’t drift over time.

In this guide, I’m going to walk through practical MySQL security best practices that you can apply right away. These are the kinds of checks and hardening steps that reduce real risk in real environments, and help build a database …

One question that surfaces regularly in the Percona forums: Does every node in a Percona XtraDB Cluster (PXC) need to have XtraBackup installed? It's a fair question, especially when managing a mixed environment or trying to minimize the software footprint on certain nodes. Here is what the actual mechanics and testing confirm.

The Short Answer (But Read On)

It depends on what you want that node to do. The nuance matters quite a bit here, so it is worth walking through how State Snapshot Transfer (SST) works in PXC and why XtraBackup's presence — or absence — on a given node is significant.

A Quick Refresher on SST in PXC

When a new node joins a Percona XtraDB Cluster, or when an existing node has been down long enough that Incremental State Transfer (IST) is no longer possible, the cluster performs a State Snapshot Transfer (SST). This is essentially a full data …

The MySQL ODBC driver is what keeps BI tools, reporting systems, and ETL pipelines connected to MySQL without errors. Teams have depended on it for years, and it’s still vital today, especially with MySQL ranked #2 worldwide in February 2026.  However, not all ODBC drivers are built alike. There are two categories: open-source options and commercial ones. While both connect applications to […]

The post ODBC Driver for MySQL: Open-Source vs Commercial (2026)  appeared first on Devart Blog.