Planet for the MySQL Community

Dolt 2.0 ^{(from DoltHub Blog)}

Almost exactly three years ago, we announced Dolt 1.0. Today, we announce Dolt 2.0. [...]

Published Monday, 11. May 2026 00:00 • over a year ago

MyVector v1.26.5: Component Architecture Arrives ^{(from AskDba)}

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

Published Saturday, 09. May 2026 08:08 • a day ago

Custom Model Context Protocol (MCP) for NL2SQL: A Rigorous Evaluation Framework on Oracle Database ^{(from DZone)}

pWhen you let an LLM turn natural language into SQL, you need to know: is it correct, will it run on your database, and is it efficient? SQLclMCP is an open-source framework that answers those questions by comparing LLM-generated SQL to human-written baselines on Oracle Database — using the Model Context Protocol (MCP) and a 500-question TPC-H benchmark. MCP keeps “how SQL is generated” behind [...]

Published Friday, 08. May 2026 15:00 • 2 days ago

Dealing with caching_sha2_password as authentication method in MariaDB Server ^{(from lefred's blog)}

MariaDB Server supports different authentication methods just like MySQL. Depending on your installation, the number of available and active authentication plugins can vary. But you should always have those 3 by default: If we compare with MySQL 9.7, we can see only 2 default authentication plugins: About caching_sha2_password module In some packaging, the caching_sha2_password auhentication […] [...]

Published Friday, 08. May 2026 10:09 • 2 days ago

Unleashing Innovation Through Plugins ^{(from MariaDB Foundation Blog)}

pOne of the corner stones in MariaDB Foundation’s mission is:/p pWe strive to increase adoption by users and across use cases, platforms and means of deployment. … /p pContinue reading \"Unleashing Innovation Through Plugins\"/p pThe post Unleashing Innovation Through Plugins appeared first on MariaDB.org./p [...]

Published Friday, 08. May 2026 09:23 • 2 days ago

Bringing pt-query-digest-Style Slow Query Analysis to PostgreSQL with pg_enhanced_query_logging ^{(from Percona Database Blog)}

pIn this blog post, we are going to briefly discuss pg_enhanced_query_logging (PEQL for short), a PostgreSQL extension that produces slow query logs in the same format MySQL and Percona Server users have been feeding into pt-query-digest for years. The idea is simple: reuse the tried-and-true tools and concepts we have been using for performing full … Continued/p pThe post Bringing pt-query-d [...]

Published Friday, 08. May 2026 01:52 • 2 days ago

What is a Context Platform? A New Pattern for AI Agents in Production ^{(from PingCAP Blog)}

pThe stories sound the same in every engineering review. A team ships a working AI prototype in a week. The demo is impressive. Leadership greenlights production. Six months later, the app is still not in production. The failure rarely traces back to the model. The team did not pick the wrong LLM. They did not […]/p pThe post What is a Context Platform? A New Pattern for AI Agents in Producti [...]

Published Thursday, 07. May 2026 21:03 • 3 days ago

Time-travel SQL for MySQL, finally ^{(from dbtrail Blog)}

pA time ago I argued MySQL is the only major OLTP database without time-travel queries. Here’s what’s changed. Last month I mapped out how every major OLTP except…/p pThe post Time-travel SQL for MySQL, finally appeared first on dbtrail Blog./p [...]

Published Thursday, 07. May 2026 13:22 • 3 days ago

Meet the Percona Community team ^{(from Percona Community Blog)}

We’ve just landed on X and Mastodon, and before the first real post goes out, we wanted to do something we don’t do often enough: introduce ourselves. [...]

Published Thursday, 07. May 2026 09:00 • 3 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 5 ^{(from lefred's blog)}

We are concluding our series related to new data types using the Type_handler framework, with some limitations that are not yet covered by the framework: It would have been handy for our MONEY datatype to have the possibility to define, for example, the currency to show. Or the format to have something like this: Unfortunately, […] [...]

Published Thursday, 07. May 2026 08:57 • 3 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 4 ^{(from lefred's blog)}

This is part 4 of a series related to extending MariaDB with a custom data type using the Type_handler framework. You can find the previous articles below: Overriding Existing Types In the previous examples, our MONEY data type inherits from DOUBLE and then we override some methods. But all the methods of every type cannot […] [...]

Published Thursday, 07. May 2026 08:53 • 3 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 3 ^{(from lefred's blog)}

In the previous article, we wrote, compiled, and tested our first custom data type for MariaDB using the Type_handler framework. But currently, aside from allowing the use of its new name (MONEY) and listing it in the metadata, our new data type behaves exactly like a DOUBLE, the class it inherits from. In this article, […] [...]

Published Thursday, 07. May 2026 08:36 • 3 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 2 ^{(from lefred's blog)}

After having discovered the Type_hander framework and learned how to build MariaDB Server from source, it’s time to code our first data type! We will create a MariaDB plugin that registers a new MONEY type and instantiates a custom field object. Our component won’t be exciting, but we want to understand how to use the […] [...]

Published Thursday, 07. May 2026 07:35 • 3 days ago

February 2026 Recap: Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pWe're excited to share a summary of the Azure Database for MySQL updates from the last couple of months./p Extended Support Timeline Update pBased on customer feedback requesting additional time to complete major version upgrades, we have extended the grace period before extended support billing begins for Azure Database for MySQL:/p ul liMySQL 5.7: Extended support billing start date moved from A [...]

Published Thursday, 07. May 2026 07:15 • 3 days ago

A New Era of MySQL Monitoring: OpenTelemetry Metrics with Prometheus ^{(from The Oracle MySQL Blog)}

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

Published Thursday, 07. May 2026 01:58 • 3 days ago

Announcing DumboDB: A MongoDB Clone Built on Dolt ^{(from DoltHub Blog)}

MongoDB and Git had a baby, and it's named Dumbo. Release 0.1 is now public! [...]

Published Thursday, 07. May 2026 00:00 • 3 days ago

Problem solving with PlanetScale Insights ^{(from PlanetScale Blog)}

The best way for you and your agents to see how your database actually performs in production. [...]

Published Thursday, 07. May 2026 00:00 • 3 days ago

Slot-based Buffer Manager 的设计 — 从 Pin 的本质说起 ^{(from Chen Zongzhi's GitHub blog)}

最近在看 PostgreSQL 的 buffer manager 代码, 把 InnoDB 那边对应的实现也对照着读了一遍, 发现两边其实是同一种架构: Slot-based Buffer Manager. 这种架构直接决定了 Pin (PG 里叫 PinBuffer, InnoDB 里叫 buf_block_fix) 这个语义为什么必须存在, 以及它真正保护的是什么. [...]

Published Thursday, 07. May 2026 00:00 • 3 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 1 ^{(from lefred's blog)}

This is the first part of the series about how to add a new data type to MariaDB using the Type_handler framework. A preliminary article has already been published to start the series; it covers how to set up your development environment and compile MariaDB Server: Adding a New Data Type to MariaDB with Type_handler […] [...]

Published Wednesday, 06. May 2026 19:21 • 4 days ago

Replication Internals: Decoding the MySQL Binary Log Part 10: ROTATE_EVENT — Closing the File and Pointing at the Next One ^{(from Readyset Blog)}

Part 10 of Readyset's MySQL binary log series decodes the ROTATE_EVENT — the bookmark MySQL leaves at the end of every binary log file. Learn how it works on disk, when it's written, and how to tell a real ROTATE_EVENT apart from the artificial one sent to replicas on connect. [...]

Published Wednesday, 06. May 2026 14:00 • 4 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 5 ^{(from MariaDB Foundation Blog)}

pWe are concluding our series related to new data types using the Type_handler framework, with some limitations that are not yet covered by the framework:br It would have been handy for our MONEY datatype to have the possibility to define, for example, the currency to show. … /p pContinue reading \"Adding a New Data Type to MariaDB with Type_handler – Part 5\"/p pThe post Adding a New D [...]

Published Wednesday, 06. May 2026 13:51 • 4 days ago

The End of SaaS - Except for a Few Types ^{(from siddontang on Medium)}

pWhy workflow SaaS gets compressed by AI — while infrastructure, networks, and outcomes become more valuable./ppContinue reading on Medium »/p [...]

Published Wednesday, 06. May 2026 13:38 • 4 days ago

Database as the Runtime Layer for AI Agents — Why Storage Is No Longer Enough ^{(from siddontang on Medium)}

pWhy AI agents need databases to become memory, coordination, and execution infrastructure./ppContinue reading on Medium »/p [...]

Published Wednesday, 06. May 2026 13:37 • 4 days ago

MySQL 9.7 is out and the community wins ^{(from AskDba)}

May 2026 · 5 min read. Alkin Tezuysal Cross blog from Oracle blogs.oracle.com/mysql/mysql-9-7-is-out-and-the-community-wins MySQL 9.7 came out on April 21 and I’ve been going through the release notes so you don’t have to. The short version: Oracle has made several previously Enterprise-only features available in the Community Edition; the Hypergraph Optimizer is now free for everyone; [...]

Published Wednesday, 06. May 2026 11:37 • 4 days ago

MySQL 9.7 Is Out and the Community Wins ^{(from The Oracle MySQL Blog)}

Alkin Tezuysal Director of Services at Altinity Inc. MySQL 9.7 came out on April 21 and I’ve been going through the release notes so you don’t have to. The short version: Oracle has made several previously Enterprise-only features available in the Community Edition, the Hypergraph Optimizer is now free for everyone, and if you’re still on MySQL 8.0, it […] [...]

Published Wednesday, 06. May 2026 10:39 • 4 days ago

Announcing Azure Private Link Support for Hosted Dolt ^{(from DoltHub Blog)}

Hosted Dolt now supports Azure Private Link. You can create a new Hosted Dolt instance on Azure with Private Link support in just a few clicks. [...]

Published Wednesday, 06. May 2026 00:00 • 4 days ago

MySQL in N-Dimensions: High-Complexity Data with vsql-cube ^{(from VillageSQL)}

Unlock n-dimensional data processing in MySQL with vsql-cube. Learn how to handle high-complexity geometry, multi-attribute containment, and similarity scoring up to 100 dimensions. [...]

Published Tuesday, 05. May 2026 20:18 • 5 days ago

PSMDB Sandbox: A Browser-Based UI for Deploying MongoDB with Terraform and Ansible ^{(from Percona Database Blog)}

pIf you’ve ever wrestled with .tfvars files, juggled Ansible inventory paths, or tried to remember the exact command sequence for a MongoDB setup — this post is for you. PSMDB Sandbox is a lightweight web frontend built in Go that ships inside the Percona MongoDB Automation repository. It puts a clean browser interface on top … Continued/p pThe post PSMDB Sandbox: A Browser-Based UI for [...]

Published Tuesday, 05. May 2026 17:12 • 5 days ago

AI finds 20-year-old bugs in PostgreSQL and MariaDB ^{(from InfoWorld)}

pOpen-source databases are facing a bit of a memory problem as AI helps surface decades-old buffer overflow issues in widely used components. Security researchers have disclosed a set of high and critical-severity vulnerabilities affecting PostgreSQL and MariaDB, with two bugs reportedly tracing their roots back more than 20 years./p pAt Wiz’s zeroday.cloud hacking event, [...]

Published Tuesday, 05. May 2026 11:57 • 5 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 4 ^{(from MariaDB Foundation Blog)}

pThis is part 4 of a series related to extending MariaDB with a custom data type using the Type_handler framework.br You can find the previous articles below:br Overriding Existing Typesbr In the previous examples, our MONEY data type inherits from DOUBLE and then we override some methods. … /p pContinue reading \"Adding a New Data Type to MariaDB with Type_handler – Part 4\"/p pThe post Addi [...]

Published Tuesday, 05. May 2026 09:30 • 5 days ago

On benchmarking ^{(from PlanetScale Blog)}

Benchmarking is hard. Done wrong it is very misleading, and unfortunately it is frequently done wrong. Let's explore how not to make silly mistakes. [...]

Published Tuesday, 05. May 2026 00:00 • 5 days ago

Transparency in benchmarking ^{(from PlanetScale Blog)}

Transparent database benchmarks help customers make better decisions and push vendors to build better products. [...]

Published Tuesday, 05. May 2026 00:00 • 5 days ago

Why Your Application Should Not Use One MySQL User for Everything ^{(from The Oracle MySQL Blog)}

Many applications start with a simple database setup: create one MySQL user, give it access to the application schema, put the credentials in the app config, and move on. That may work at first, but it is not a good long-term security model. A better approach is to use separate MySQL users for separate application […] [...]

Published Monday, 04. May 2026 20:48 • 6 days ago

April Product Update ^{(from Readyset Blog)}

pril was a big month at Readyset. We launched rdst, an AI-powered CLI for diagnosing database performance issues, shipped MySQL GTID support with zero-downtime failover, and hit Part 9 of our MySQL binary log series. Here's everything that shipped. [...]

Published Monday, 04. May 2026 17:30 • 6 days ago

For a Database, survive used to mean “The server stays up”. With AI Agents, that’s not enough anymore ^{(from dbtrail Blog)}

pOne of the 3 promise that a database do is: I will Survive. Traditionally it was physical: disk, memory, replication, OOM. The hardware side. With agents, that definition…/p pThe post For a Database, survive used to mean “The server stays up”. With AI Agents, that’s not enough anymore appeared first on dbtrail Blog./p [...]

Published Monday, 04. May 2026 15:54 • 6 days ago

An AI Agent is talking to your MySQL. And the database doesn’t know who is that! – Agent Era, Part 3 ^{(from dbtrail Blog)}

pYou’re still running agents against MySQL. So am I. Last time we walked through what happens when an agent doesn’t understand the query it’s running. This week, what…/p pThe post An AI Agent is talking to your MySQL. And the database doesn’t know who is that! – Agent Era, Part 3 appeared first on dbtrail Blog./p [...]

Published Monday, 04. May 2026 14:59 • 6 days ago

Long live to dbdeployer! ^{(from lefred's blog)}

As you know, MySQL-Sandbox and then dbdeployer have always been part of the Swiss Army knife for DBAs trying to evaluate, test, or reproduce issues with a certain version of their database. The author, Giuseppe Maxia, aka the datacharmer, produced incredible work on these two projects. Unfortunately, Giuseppe decided to archive the project in 2023. […] [...]

Published Monday, 04. May 2026 14:22 • 6 days ago

Long live to dbdeployer! ^{(from MariaDB Foundation Blog)}

pAs you know, MySQL-Sandbox and then dbdeployer have always been part of the Swiss Army knife for DBAs trying to evaluate, test, or reproduce issues with a certain version of their database. … /p pContinue reading \"Long live to dbdeployer!\"/p pThe post Long live to dbdeployer! appeared first on MariaDB.org./p [...]

Published Monday, 04. May 2026 14:22 • 6 days ago

I Know Kung Fu ^{(from Percona Database Blog)}

pYou might find this hard to believe, but AI has become kind of a thing around here. Bennie published a post on our Build with AI competition last week, in which he shared that I was lucky enough to land the second place prize. Genuinely flattered, and a real thank you to Peter F, PZ, … Continued/p pThe post I Know Kung Fu appeared first on Percona./p [...]

Published Monday, 04. May 2026 12:43 • 6 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 3 ^{(from MariaDB Foundation Blog)}

pIn the previous article, we wrote, compiled, and tested our first custom data type for MariaDB using the Type_handler framework.br But currently, aside from allowing the use of its new name (MONEY) and listing it in the metadata, our new data type behaves exactly like a DOUBLE, the class it inherits from. … /p pContinue reading \"Adding a New Data Type to MariaDB with Type_handler – Part 3\" [...]

Published Monday, 04. May 2026 06:27 • 6 days ago

Curious case of PXC node that refused to start due to SSL ^{(from Percona Database Blog)}

pIn this blog, I am going to share a real-world debugging case study where a routine Percona XtraDB Cluster node restart led to an unexpected failure. I will walk through what we observed, what we checked, and how we ultimately identified the root cause. Let’s see how the maintenance goes. It was supposed to be … Continued/p pThe post Curious case of PXC node that refused to start due to SSL [...]

Published Monday, 04. May 2026 05:45 • 6 days ago

Building Query Analysis and Insights Dashboard in PMM ^{(from Percona Database Blog)}

pPercona Monitoring and Management is a great open source database monitoring, observability, and management tool. Query analytics is one of the prominent features DBA uses actively to trace the incidents and query performance identification. We all know and love the Query Analytics (QAN) dashboard… It’s the first place we look when an incident alert fires … Continued/p pThe post Buildi [...]

Published Monday, 04. May 2026 05:00 • 6 days ago

Database Insurance ^{(from DoltHub Blog)}

Use a Dolt replica for database insurance against catastrophe or more mundane bad writes. In the human operator era, a Dolt replica was nice to have. In the agentic operator era, a Dolt replica is essential. [...]

Published Monday, 04. May 2026 00:00 • 6 days ago

Disaster Recovery Run Books for GCC-Owned Database Platforms ^{(from MinervaDB Blog)}

database disaster recovery GCC: how a GCC platform team owns the design, runbooks, and SLOs across a regulated multi-engine estate. [...] [...]

Published Sunday, 03. May 2026 09:00 • 7 days ago

When Databases Start Eating Software — The Paradigm Shift in the AI Era ^{(from siddontang on Medium)}

pSoftware Once Ate the World/ppContinue reading on Medium »/p [...]

Published Sunday, 03. May 2026 01:53 • 7 days ago

SaaS is Dead — The Rise of Result as a Service ^{(from siddontang on Medium)}

pThe SaaS Era Was Perfect — Until It Wasn't/ppContinue reading on Medium »/p [...]

Published Sunday, 03. May 2026 01:49 • 7 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 2 ^{(from MariaDB Foundation Blog)}

pAfter having discovered the Type_hander framework and learned how to build MariaDB Server from source, it’s time to code our first data type! … /p pContinue reading \"Adding a New Data Type to MariaDB with Type_handler – Part 2\"/p pThe post Adding a New Data Type to MariaDB with Type_handler – Part 2 appeared first on MariaDB.org./p [...]

Published Saturday, 02. May 2026 18:12 • 8 days ago

InnoDB Redo Log Sizing: Stop Guessing, Start Measuring ^{(from Percona Community Blog)}

Introduction Many MySQL configurations inherit redo log sizing from defaults, aging blog posts, or configuration folklore. [...]

Published Saturday, 02. May 2026 00:00 • 8 days ago

Village News: MySQL/Database News (1 May 2026) ^{(from VillageSQL)}

Stay ahead with the latest MySQL & database news! Get the scoop on MySQL 9.7 LTS, the new hypergraph optimizer, and upcoming events like Percona Live ‘26. [...]

Published Friday, 01. May 2026 17:09 • 9 days ago

How We Built mem9: Lessons From Shipping Persistent Memory for AI Agents ^{(from PingCAP Blog)}

pIn early March 2026, a customer asked us for something that sounded simple and turned out to be one of the hardest problems in the agent stack: Make agents remember. We did not start with a polished roadmap, a heavyweight architecture review, or a six-month product plan. We started the way many products do: With […]/p pThe post How We Built mem9: Lessons From Shipping Persistent Memory for A [...]

Published Friday, 01. May 2026 16:00 • 9 days ago

Run an ALTER TABLE for a huge table in Aurora ^{(from Percona Database Blog)}

pRecently, we received an alert for one of our Managed Services customers indicating that the auto_increment value for the table was 80% of its maximum capacity. The column was INT UNSIGNED, which has a limit of 4,294,967,295. At 80%, we have enough time to change it to BIGINT.…. Right? Let’s see. So we used pt-online-schema-change … Continued/p pThe post Run an ALTER TABLE for a huge table i [...]

Published Friday, 01. May 2026 01:55 • 9 days ago

Managing Valkey Cluster in Kubernetes ^{(from Percona Database Blog)}

pOver the last several years, Percona has introduced several rock-star Kubernetes Operators for managing MySQL, Percona XtraDB Cluster, MongoDB, and PostgreSQL. For Valkey, we are actively working with the community to contribute our knowledge, and experience to help brainstorm, develop, and test the official Valkey Operator for Kubernetes. While the Valkey Operator has not yet … Continued/p [...]

Published Thursday, 30. April 2026 23:05 • 9 days ago

How Tungsten Cluster Achieves Data Integrity With Asynchronous Replication ^{(from Continuent Blog)}

Technical overview of how Tungsten Cluster achieves data integrity with asynchronous replication, focusing on replication state management, coordinated failover, and strategies to minimize data loss in HA environments.Tags: tungsten clusterdata protectionAsynchronous Replicationfailover [...]

Published Thursday, 30. April 2026 20:52 • 10 days ago

MySQL Tuning on OCI HeatWave: What Still Matters, What OCI Manages, and What You Should Actually Tune ^{(from The Oracle MySQL Blog)}

Once you move from self-managed MySQL to a MySQL DB System with HeatWave on OCI, the tuning story changes in an important way. On a self-managed server, you worry about two layers: MySQL and the operating system. On OCI MySQL DB Systems with HeatWave, Oracle runs your MySQL instance as a fully-managed service and explicitly […] [...]

Published Thursday, 30. April 2026 20:13 • 10 days ago

When AI Agent Memory Outgrows SQLite: How to Tell, and What to Move to Next ^{(from PingCAP Blog)}

pCoding agents now run for hours, span multiple tools, and move between machines and sessions. However, the agent memory layer underneath them has not kept up. Most still look the way they did in the first prototype: SQLite for notes and records, local files for summaries, and embeddings bolted on later if they are needed […]/p pThe post When AI Agent Memory Outgrows SQLite: How to Tell, and [...]

Published Thursday, 30. April 2026 18:54 • 10 days ago

Three Promises in the Agent Era, Part 2: Agents on production MySQL are fine. Until they’re not. ^{(from dbtrail Blog)}

pYou’re running agents against MySQL. So am I. It’s where we are. Sooner or later you’re going to be recovering data because of something one of them did.…/p pThe post Three Promises in the Agent Era, Part 2: Agents on production MySQL are fine. Until they’re not. appeared first on dbtrail Blog./p [...]

Published Thursday, 30. April 2026 11:56 • 10 days ago

Continued Commitment to Percona XtraDB Cluster ^{(from Percona Database Blog)}

pAt Percona, our priority has always been to provide the open source database solutions that our users can count on for the long term. Percona XtraDB Cluster (PXC) is a core part of that promise, delivering the high availability, scalability, and data integrity that mission-critical MySQL deployments depend on. MariaDB has announced that September 30, … Continued/p pThe post Continued Commitm [...]

Published Thursday, 30. April 2026 09:53 • 10 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 0 ^{(from lefred's blog)}

Welcome to this new series about extending MariaDB. This series covers the addition of a new data type using the Type_handler. The goal of the entire series is to create a new plugin data type MONEY to store and display amounts with currency. Something like: Of course, the ultimate goal is to teach how to […] [...]

Published Thursday, 30. April 2026 09:35 • 10 days ago

From Ecosystem to Architecture: Expanding How We Look at MariaDB ^{(from MariaDB Foundation Blog)}

pOver the past month, one question has been coming up with increasing frequency:br What is the MySQL / MariaDB ecosystem?br In most discussions, the answer tends to focus on contributors to the source code: engineers, committers, and core developers shaping the database itself. … /p pContinue reading \"From Ecosystem to Architecture: Expanding How We Look at MariaDB\"/p pThe post From Ecosyst [...]

Published Thursday, 30. April 2026 07:46 • 10 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 1 ^{(from MariaDB Foundation Blog)}

pThis is the first part of the series about how to add a new data type to MariaDB using the Type_handler framework. A preliminary article has already been published to start the series; … /p pContinue reading \"Adding a New Data Type to MariaDB with Type_handler – Part 1\"/p pThe post Adding a New Data Type to MariaDB with Type_handler – Part 1 appeared first on MariaDB.org./p [...]

Published Thursday, 30. April 2026 06:12 • 10 days ago

No More Silent Foreign Key Cascades: MySQL 9.7 Lets Child Triggers Speak Up ^{(from The Oracle MySQL Blog)}

MySQL 9.7 introduces a long-requested improvement: Child table triggers are executed during SQL-layer foreign key cascades. Historically, cascades executed inside InnoDB did not invoke child table triggers, which created gaps in auditing, derived data maintenance, and observability. When a parent row change triggered cascading changes in child tables, those child table triggers were not execut [...]

Published Thursday, 30. April 2026 05:37 • 10 days ago

RLS sounds great until it isn't ^{(from PlanetScale Blog)}

PostgreSQL's Row Level Security sounds like a clean way to enforce access control at the database layer, but the foot-guns, pooling incompatibilities, and performance traps often make it more trouble than it's worth. [...]

Published Thursday, 30. April 2026 00:00 • 10 days ago

Announcing Vitess 24 ^{(from Vitess)}

Announcing Vitess 24 # The Vitess maintainers are happy to announce the release of version 24.0.0, along with version 2.17.0 of the Vitess Kubernetes Operator. Version 24.0.0 expands query serving capabilities for sharded keyspaces, modernizes Vitess's observability stack, and introduces faster replica provisioning through native MySQL CLONE support. The companion v2.17.0 operator release brings si [...]

Published Thursday, 30. April 2026 00:00 • 10 days ago

AI Is Raising the Bar for MySQL Database Security ^{(from The Oracle MySQL Blog)}

Best practices for MySQL customers and users in an AI-accelerated security landscape: A practical guide to hardening MySQL and the environment around it Oracle recently described how AI is transforming vulnerability detection and response. The latest generation of AI is increasing the speed and scale at which vulnerabilities can be identified and remediated. Oracle is […] [...]

Published Wednesday, 29. April 2026 23:51 • 10 days ago

Amazon RDS for MySQL announces Innovation Release 9.6 in Amazon RDS Database Preview Environment ^{(from AWS What's New)}

pAmazon RDS for MySQL now supports community MySQL Innovation Release 9.6 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MySQL. You can deploy MySQL 9.6 in the Amazon RDS Database Preview Environment which provides the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases. [...]

Published Wednesday, 29. April 2026 20:37 • 11 days ago

XtraBackup incremental prepare phase is 2x-3x faster! ^{(from Percona Database Blog)}

pTL;DR Percona XtraBackup is a 100% open-source backup solution for Percona Server for MySQL and MySQL®. It is designed for high-availability environments, performing online, non-blocking, and highly secure backups of transactional systems without interrupting your production traffic. While full backups work for small databases, large-scale systems rely on incremental backups to save space and time [...]

Published Wednesday, 29. April 2026 18:52 • 11 days ago

TiDB Cloud Premium Public Preview: Predictable Performance, Elastic Scale, Enterprise Isolation ^{(from PingCAP Blog)}

pCloud-native databases have made it easier to ship transactional applications. Managed services, automatic failover, and elastic storage are now table stakes. The harder problems show up later: When a multi-tenant SaaS app starts hitting tail-latency spikes during compaction, when a serverless tier saturates a noisy neighbor, or when a dedicated cluster sits at 30% utilization […]/p pThe pos [...]

Published Wednesday, 29. April 2026 18:23 • 11 days ago

Orchestrator’s Next Chapter: What It Means for Percona Customers ^{(from Percona Database Blog)}

pLast week, ProxySQL announced that they are taking over the maintenance and development of Orchestrator, the MySQL high-availability and topology management tool originally authored by Shlomi Noach. You can read their announcement here: Announcing the future of Orchestrator. We want to briefly share Percona’s position on the news. We welcome this Orchestrator became the de … Continued/ [...]

Published Wednesday, 29. April 2026 17:55 • 11 days ago

Replication Internals: Decoding the MySQL Binary Log Part 9: XID_EVENT — Transaction Commit ^{(from Readyset Blog)}

The XID_EVENT is only 31 bytes, but it's what makes MySQL replication crash-safe. Part 9 of Readyset's binlog internals series decodes it field by field and explains how a single 8-byte transaction identifier ties the binary log and InnoDB redo log together for two-phase commit recovery. [...]

Published Wednesday, 29. April 2026 14:00 • 11 days ago

Introducing the Change Stream Applier (CSA): A New MySQL Replication Applier in Labs ^{(from The Oracle MySQL Blog)}

Introduction Replication performance depends on every stage in the pipeline, from the source database to transport and ultimately to commit on the replica. On the replica side, much of that performance comes down to how efficiently changes are read, scheduled, and applied under real operational pressure. In practice, that directly affects steady-state lag, backlog recovery […] [...]

Published Wednesday, 29. April 2026 13:39 • 11 days ago

Adding a New Data Type to MariaDB with Type_handler – Part 0 ^{(from MariaDB Foundation Blog)}

pWelcome to this new series about extending MariaDB. This series covers the addition of a new data type using the Type_handler.br The goal of the entire series is to create a new plugin data type MONEY to store and display amounts with currency. … /p pContinue reading \"Adding a New Data Type to MariaDB with Type_handler – Part 0\"/p pThe post Adding a New Data Type to MariaDB with Type_handl [...]

Published Wednesday, 29. April 2026 09:37 • 11 days ago

Running MySQL on Kubernetes in Regulated Environments: Security, Compliance, and Auditability ^{(from Continuent Blog)}

Learn how to run MySQL on Kubernetes in regulated environments. This guide covers security controls, compliance requirements, auditability, encryption, access management, and operational best practices for production-grade deployments.Tags: kubernetesregulationsCompliance [...]

Published Wednesday, 29. April 2026 07:57 • 11 days ago

Announcing Functional Indexes in Dolt ^{(from DoltHub Blog)}

Dolt now supports functional indexes, allowing you to index expressions and function results for faster queries on computed values. [...]

Published Wednesday, 29. April 2026 00:00 • 11 days ago

Part 2 - PgBouncer to ProxySQL: A Brief Feature Comparison ^{(from ProxySQL Blog)}

Part 2 of the PgBouncer to ProxySQL series. A direct comparison of what each tool does, focused on responsibilities PgBouncer deliberately leaves alone and that ProxySQL pulls into the proxy itself. Reflects ProxySQL 3.0.8 and PgBouncer 1.25.1 at time of writing. [...]

Published Wednesday, 29. April 2026 00:00 • 11 days ago

How Readyset Rewrites Your SQL: Inside the Query Transformation Pipeline ^{(from Readyset Blog)}

A deep dive into Readyset's query rewrite pipeline. How SQL is transformed into a form the dataflow engine can compile and incrementally maintain, covering decorrelation, derived table inlining, join reordering, and three-valued logic handling. [...]

Published Tuesday, 28. April 2026 19:56 • 12 days ago

MySQL with AI Inside ^{(from VillageSQL)}

Learn how to use the VillageSQL vsql-ai extension to run AI models like Claude, Gemini, ChatGPT, and local within MySQL (VillageSQL). [...]

Published Tuesday, 28. April 2026 16:34 • 12 days ago

The hypergraph optimizer is now available in MySQL 9.7 Community Edition ^{(from Øystein on MySQL Optimizer)}

I have written a new post on the MySQL blog about the hypergraph optimizer, which is now available in MySQL 9.7 Community Edition. The post gives a high-level technical overview of what is different from the classic join optimizer, why it can produce better plans for some multi-table queries, and where it is most useful to try. It also includes early benchmark results and some caveats, since the f [...]

Published Tuesday, 28. April 2026 14:15 • 12 days ago

Introducing rdst: The Client-Side SQL Performance Toolkit ^{(from Readyset Blog)}

rdst is a free CLI toolkit that audits your RDS fleet, shows you what's driving load, and tells you exactly which read replicas you can eliminate. One command. Full report in your inbox. [...]

Published Tuesday, 28. April 2026 13:10 • 12 days ago

An update on GitHub availability ^{(from The GitHub Blog)}

pHere’s what we’ve done—and what we’re still doing—to improve our availability and reliability./p pThe post An update on GitHub availability appeared first on The GitHub Blog./p [...]

Published Tuesday, 28. April 2026 10:01 • 12 days ago

Three Promises in the Agent Era, Part 1: The Frame, Reread ^{(from dbtrail Blog)}

pThe series: A few time ago I wrote that a database does three things: It executes queries. It manages relationships. It survives the physical machine it runs on.…/p pThe post Three Promises in the Agent Era, Part 1: The Frame, Reread appeared first on dbtrail Blog./p [...]

Published Tuesday, 28. April 2026 02:31 • 12 days ago

Part 1 - PgBouncer to ProxySQL: Rethinking the PostgreSQL Middle Tier ^{(from ProxySQL Blog)}

Part 1 of the PgBouncer to ProxySQL series. Focus: architecture and operator model, not a full feature matrix. Reflects ProxySQL 3.0.7 and PgBouncer 1.25.1 at time of writing. [...]

Published Tuesday, 28. April 2026 00:00 • 12 days ago

Strengthening the MySQL Community: Highlights from Our Third Public Discussion ^{(from The Oracle MySQL Blog)}

On April 21, 2026, our third public discussion continued the conversation around transparency, participation, and the future of MySQL. Building on the momentum from earlier sessions, the discussion focused on progress and improvements to increase community transparency and practical ways for community members to get involved. At the center of the discussion was the MySQL […] [...]

Published Monday, 27. April 2026 23:56 • 12 days ago

The hypergraph optimizer is now available in MySQL 9.7 Community Edition ^{(from The Oracle MySQL Blog)}

MySQL 9.7 Community Edition now includes the hypergraph optimizer as an alternative to the classic join optimizer, making this capability available across all MySQL editions. This is not a cosmetic change. The hypergraph optimizer uses a new join-planning framework aimed at queries where plan shape can make a real difference, particularly for multi-table joins, workloads […] [...]

Published Monday, 27. April 2026 17:19 • 13 days ago

Database Trends: What is changing in the database world (besides AI) ^{(from MariaDB Foundation Blog)}

pEarlier this month, I had a half-hour chat with Kellyn Gorman, a Database and AI Advocate and Engineer at Redgate. … /p pContinue reading \"Database Trends: What is changing in the database world (besides AI)\"/p pThe post Database Trends: What is changing in the database world (besides AI) appeared first on MariaDB.org./p [...]

Published Monday, 27. April 2026 13:48 • 13 days ago

What an AI Agent Harness Actually Needs Beyond a Model ^{(from PingCAP Blog)}

pFor the first wave of AI applications, the model was the only architectural question that mattered. Which model reasons better. Whose code is cleaner. Whose tool calls are more reliable. Where is the context window largest. What costs less per task. That conversation still matters. It is just no longer enough. The systems attracting serious […]/p pThe post What an AI Agent Harness Actually N [...]

Published Monday, 27. April 2026 13:01 • 13 days ago

Lemit Trusts Readyset to Reach 100K QPS on MySQL, Without Changing a Single Line of Code ^{(from Readyset Blog)}

Lemit deployed Readyset to break past MySQL's vertical scaling ceiling, reaching 109K QPS with sub-millisecond latency and zero application code changes. [...]

Published Monday, 27. April 2026 12:38 • 13 days ago

Why DoltLite? ^{(from DoltHub Blog)}

DoltLite redefines what is possible for local-first software. You can now use Git-style merges instead of CRDTs in sync engines. [...]

Published Monday, 27. April 2026 00:00 • 13 days ago

Announcing ProxySQL 3.0.8, 3.1.8, and 4.0.8 ^{(from ProxySQL Blog)}

ProxySQL 3.0.8 introduces MySQL session-variable tracking, PostgreSQL Cluster Sync, per-server backend SSL, and mid-transaction recovery. Also announcing 3.1.8 and 4.0.8. [...]

Published Monday, 27. April 2026 00:00 • 13 days ago

New Observability Tables in ProxySQL 3.0.7: stats_proxysql_global and stats_tls_certificates ^{(from ProxySQL Blog)}

ProxySQL 3.0.7 introduces two new statistics tables for TLS certificate tracking and global proxy metrics. [...]

Published Saturday, 25. April 2026 00:00 • 15 days ago

MySQL Tuning: Is It Mostly MySQL, or Does the Operating System Matter Also? ^{(from The Oracle MySQL Blog)}

When people ask me how to tune MySQL, they usually mean, “Which variables should I change in my.cnf?” (the MySQL configuration file) That certainly is a reasonable place to start, because most day-to-day performance tuning really is driven by MySQL itself: memory allocation, redo flushing, connection handling, temporary tables, and InnoDB I/O behavior. But the […] [...]

Published Friday, 24. April 2026 20:15 • 16 days ago

Not enough space for using ODABR? Reduce /u01 and /opt size on your ODA ^{(from dbi Blog)}

pIntroduction The patching of an Oracle Database Appliance needs to be secured. This is because it won’t limit to patching the databases: there is plenty of other components embedded with the patch, the goal being to keep everything updated. A possible rollback may be needed. For sure, there is no possible rollback for firmwares, BIOS […]/p pL’article Not enough space for using ODABR? R [...]

Published Friday, 24. April 2026 06:42 • 16 days ago

Security Hardening in ProxySQL 3.0.7 ^{(from ProxySQL Blog)}

A deep dive into the protocol hardening, credential protection, and validation improvements in ProxySQL 3.0.7. [...]

Published Friday, 24. April 2026 00:00 • 16 days ago

C++ StringView 优化字符串比较 ^{(from Chen Zongzhi's GitHub blog)}

DuckDB / Velox / Umbra 里面常见的字符串表示方式. 和传统的 SimpleStr (ptr, len) 相比, 都是 16 字节, 但是 layout 不同. [...]

Published Friday, 24. April 2026 00:00 • 16 days ago

Github And DBeaver ^{(from Dave's MySQL Stuff)}

p Hopefully, you are regularly using both DBeaver and GitHub. But did you know that you can link them together?/ppIf you are running DBeaver Community, you will have to install some software that is built into the Pro versions. /p♦brp/p1. Install Git Extension (Community Edition) ulliGo to Help -> Install New Software./liliIn the "Work with" field, en [...]

Published Thursday, 23. April 2026 19:29 • 17 days ago

AWS Compute Optimizer supports 162 new EC2 instance types and 32 new RDS DB instance classes ^{(from AWS What's New)}

pAWS Compute Optimizer now supports the latest generation of Amazon Elastic Compute Cloud (Amazon EC2) and Amazon Relational Database Service (Amazon RDS) instance types. This expansion enables Compute Optimizer to help you take advantage of the price-to-performance improvements offered by the newest EC2 and RDS instance types./p pAWS Compute Optimizer has expanded support to include the latest ge [...]

Published Thursday, 23. April 2026 18:28 • 17 days ago

Upcoming MySQL Events and Webinars (Updated list for April–May 2026) ^{(from The Oracle MySQL Blog)}

As an update to our recent blog post, “Where can you find MySQL next? (Updated events list for March–May 2026)” we’d like to share the latest confirmed MySQL events and webinars, including newly added ones plus refreshed details for sessions we already announced. Since plans and agendas evolve quickly, this post is intended to provide […] [...]

Published Thursday, 23. April 2026 18:26 • 17 days ago

Bringing External Data into MySQL with the vsql-http Extension ^{(from VillageSQL)}

Bring HTTP client functions to MySQL with vsql-http. Fetch external data, trigger slack webhooks, and process JSON directly within SQL. [...]

Published Thursday, 23. April 2026 18:16 • 17 days ago

A Clearer Path Forward for GridGain Customers ^{(from MariaDB Corporation Blog)}

This blog was originally published on GridGain’s website. When MariaDB evaluated and acquired GridGain, we noticed something important: GridGain is […] [...]

Published Thursday, 23. April 2026 17:12 • 17 days ago

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 5: Backup, Recovery, and Node Reconfiguration ^{(from ReliaDB)}

Configure weekly AWS Backup for the PMM EC2 instance, walk through the full recovery procedure after a failure, and reconfigure PMM client agents on x86_64 and aarch64 nodes after a PMM server IP change. [...]

Published Thursday, 23. April 2026 13:00 • 17 days ago

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 4: Alerting with PagerDuty and CloudWatch ^{(from ReliaDB)}

Configure PMM alerting end-to-end: custom MetricsQL alert templates, PagerDuty contact points, notification policies, CloudWatch data sources via IAM role assumption, and amtool for silence management. [...]

Published Thursday, 23. April 2026 12:00 • 17 days ago

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 3: Installing PMM Server and Registering Services ^{(from ReliaDB)}

Install PMM Server on Docker, deploy PMM clients on x86_64 and aarch64 nodes, create monitoring users, and register MySQL, ProxySQL, and MariaDB RDS services at scale. [...]

Published Thursday, 23. April 2026 11:00 • 17 days ago

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 2: IAM Roles and Users ^{(from ReliaDB)}

Configure cross-account IAM roles for PMM CloudWatch access and IAM users for Aurora OS metrics. Includes full trust policy, permissions policy, and Terraform references. [...]

Published Thursday, 23. April 2026 10:00 • 17 days ago

Why LLMs Write Incorrect SQL (and What That Means for Your Database) ^{(from Readyset Blog)}

LLM-generated SQL looks right, runs, and returns results. But incorrect joins, wrong aggregations, and missing filters quietly hit your database at full execution cost. Here is what teams are doing about it. [...]

Published Thursday, 23. April 2026 09:00 • 17 days ago

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 1: Architecture and TGW Setup ^{(from ReliaDB)}

Set up centralized RDS monitoring across multiple AWS accounts using Percona Monitoring and Management (PMM) and AWS Transit Gateway. Full network, routing, and security group walkthrough. [...]

Published Thursday, 23. April 2026 09:00 • 17 days ago

MySQL Community Roadmap Update and Invitation: MySQL Contributor Summit ^{(from The Oracle MySQL Blog)}

As part of our MySQL community engagement plan, which includes delivering new features into MySQL Community Edition, increasing collaboration and transparency, and expanding and growing the MySQL Ecosystem, we have created a new rhythm of public MySQL Community Discussions—starting with our first session on February 25 and continuing with our second session on March 23, […] [...]

Published Thursday, 23. April 2026 07:36 • 17 days ago

Clustering Tradeoffs in Practice: Galera, Tungsten, and the Jepsen Findings ^{(from Continuent Blog)}

A practical comparison of MySQL clustering technologies, analyzing Galera and Tungsten using Jepsen findings to highlight trade-offs in consistency, durability, and high availability design.Tags: Galera [...]

Published Thursday, 23. April 2026 07:29 • 17 days ago

TiDB and the Rise of the AI-Native Database ^{(from PingCAP Blog)}

pEditor’s note: This post originally appeared on The New Stack and is republished with permission. The original version is available here. When enterprises talk about artificial intelligence, the attention usually points to models: larger parameters, faster inference, cheaper tokens. But we at next-gen database maker PingCAP contend that this framing misses the most consequential change now [… [...]

Published Thursday, 23. April 2026 02:19 • 17 days ago

Big O for MySQL: Why the Same Query Gets Slow at Scale ^{(from Another Boring Tech Blog)}

pBig O for MySQL, explained visually: how O(1), O(log n), O(n), O(n log n), O(n²), and O(2ⁿ) decide whether your query stays fast as your data grows./p pO post Big O for MySQL: Why the Same Query Gets Slow at Scale apareceu primeiro em Another Boring Tech Blog./p [...]

Published Wednesday, 22. April 2026 22:12 • 18 days ago

Introducing Dynamic Data Masking in MySQL: Protect Sensitive Data Without App Changes ^{(from The Oracle MySQL Blog)}

Production data is invaluable for day-to-day operations—support, troubleshooting, analytics, and development. But when that data contains sensitive fields such as SSNs, emails, phone numbers, or other identifiers, broad read access can quickly become unnecessary exposure. Just as importantly, many organizations operate under regulatory and contractual requirements that expect strong [...]

Published Wednesday, 22. April 2026 21:56 • 18 days ago

Readyset Is Ready for MySQL 9.7 - Three Commands With rdst ^{(from Readyset Blog)}

MySQL 9.7.0 LTS is live and Readyset supports it. See how to connect, deploy, and benchmark cached reads against a real 9.7.0 upstream in three commands using rdst. [...]

Published Wednesday, 22. April 2026 15:00 • 18 days ago

Percona Live 2026 is Back in the Bay Area — Here’s Why You Don’t Want to Miss It ^{(from Percona Database Blog)}

pWe’re thrilled to welcome the open source database community back in person for Percona Live 2026, taking place May 27–29 in the Bay Area. After the energy of past events, there’s nothing like being together again — swapping war stories over coffee, sketching architectures on napkins, and learning from the people building and running databases … Continued/p pThe post Percona Live 2026 is Bac [...]

Published Wednesday, 22. April 2026 11:42 • 18 days ago

Upgrade to OpenSSL 3.5 ^{(from The Oracle MySQL Blog)}

Overview Some MySQL distribution packages, such as the generic Linux build, bundle an OpenSSL dependency within the same .tar.gz archive. With the new MySQL 8.0.46, 8.4.9 and 9.7.0 releases, we are upgrading those bundled packages from using OpenSSL 3.0 to the new OpenSSL 3.5 LTS branch. Native OS packages, such as .rpm and .deb, continue […] [...]

Published Wednesday, 22. April 2026 05:28 • 18 days ago

MySQL Performance : OpenSSL-3.5.5 Evaluation ^{(from DimitriK's (dim) Weblog)}

pThe following report is covering performance evaluation of the currently available OpenSSL releases when they are used by MySQL in CPU-intensive OLTP workloads. However, the main focus is on OpenSSL-3.5.5, which will be used by default in the next MySQL releases./p pRead more... (19 min remaining to read)/p [...]

Published Wednesday, 22. April 2026 04:50 • 18 days ago

Orchestrator for PostgreSQL: the HA brain, now first-party ^{(from ProxySQL Blog)}

How ProxySQL for PostgreSQL handles unplanned primary failure [...]

Published Wednesday, 22. April 2026 00:00 • 18 days ago

The Extensibility Tax: Decisions, Principles, & Lessons in Teaching MySQL New Tricks ^{(from VillageSQL)}

Why is it so hard to teach an old database new tricks? VillageSQL CTO Steve Schirripa breaks down a year of engineering hurdles, debugging nightmares, and core principles discovered while building the VillageSQL Extension Framework. [...]

Published Tuesday, 21. April 2026 17:52 • 19 days ago

MySQL 9.7.0 LTS Is Now Available: Expanded Community Capabilities and Dynamic Data Masking for Enterprise ^{(from The Oracle MySQL Blog)}

With MySQL 9.7.0 LTS, MySQL establishes its next long-term support release line, expands key capabilities in Community Edition, and introduces Dynamic Data Masking for Enterprise users. The April releases mark an important milestone for MySQL. With the GA of MySQL 9.7.0 LTS, MySQL moves from the 9.x innovation series to a new Long-Term Support release line. This begins […] [...]

Published Tuesday, 21. April 2026 16:00 • 19 days ago

Expanding board of directors – Kurt Daniel, CEO at Virtuozzo ^{(from MariaDB Foundation Blog)}

pThe MariaDB Foundation is pleased to welcome Kurt Daniel, five-time CEO and current CEO of Virtuozzo, to its Board—bringing in a perspective shaped at the very heart of the database industry. … /p pContinue reading \"Expanding board of directors – Kurt Daniel, CEO at Virtuozzo\"/p pThe post Expanding board of directors – Kurt Daniel, CEO at Virtuozzo appeared first on Maria [...]

Published Tuesday, 21. April 2026 13:50 • 19 days ago

Percona Operator for MySQL 1.1.0: PITR, Incremental Backups, and Compression ^{(from Percona Database Blog)}

pThe latest release of the Percona Operator for MySQL, 1.1.0, is here. It brings point-in-time recovery, incremental backups, zstd backup compression, configurable asynchronous replication retries, and a set of stability fixes. This post walks through the highlights and how they help your MySQL deployments on Kubernetes. Percona Operator for MySQL 1.1.0 Running stateful databases … Con [...]

Published Tuesday, 21. April 2026 13:21 • 19 days ago

Approaches to tenancy in Postgres ^{(from PlanetScale Blog)}

There are many ways to slice a Postgres database for multi-tenant applications. Let's look at the three most common approaches and the trade-offs. [...]

Published Tuesday, 21. April 2026 00:00 • 19 days ago

ProxySQL for PostgreSQL — Surviving an unplanned primary failure ^{(from ProxySQL Blog)}

How ProxySQL for PostgreSQL handles unplanned primary failure [...]

Published Tuesday, 21. April 2026 00:00 • 19 days ago

Every Major OLTP Has Time Travel. Except MySQL ^{(from dbtrail Blog)}

pIf you’ve worked on Oracle, you know Flashback. Run a SELECT ... AS OF TIMESTAMP, get the row as it existed yesterday at 2pm. Find who touched it…/p pThe post Every Major OLTP Has Time Travel. Except MySQL appeared first on dbtrail Blog./p [...]

Published Monday, 20. April 2026 19:41 • 20 days ago

Deploying Cross-Site Replication in Percona Operator for MySQL (PXC) ^{(from Percona Database Blog)}

pHaving a separate DR cluster for production databases is a modern day requirement or necessity for tech and other related businesses that rely heavily on their database systems. Setting up such a [DC -> DR] topology for Percona XtraDB Cluster (PXC), which is a virtually- synchronous cluster, can be a bit challenging in a complex … Continued/p pThe post Deploying Cross-Site Replication in [...]

Published Monday, 20. April 2026 13:15 • 20 days ago

How Dolt Represents and Evaluates Queries: A Case Study ^{(from DoltHub Blog)}

We look at a recent bug fix to understand how Dolt actually represents queries internally. It turns out, database engines and compilers have a lot in common. [...]

Published Monday, 20. April 2026 00:00 • 20 days ago

MySQL MCP Server v1.7.0 is out ^{(from AskDba)}

April 19, 2026 It took three release candidates and more CI tweaks than I’d like to admit, but v1.7.0 is finally tagged GA. Here’s what actually changed and why it matters. The thing I kept getting asked about: add_connection Almost every multi-database user hits the same wall: you configure your connections at startup, and that’s […] [...]

Published Sunday, 19. April 2026 21:00 • 21 days ago

MySQL HeatWave Consulting and Managed Services ^{(from MinervaDB Blog)}

MySQL HeatWave Consulting and Managed Services: Engineering Real-Time Analytics at Scale Oracle MySQL HeatWave collapses the traditional boundary between OLTP and OLAP workloads into a single, in-database engine — eliminating the ETL pipelines, data warehouse [...] [...]

Published Sunday, 19. April 2026 15:49 • 21 days ago

The Provider Architecture — How dbdeployer Learned to Speak PostgreSQL ^{(from ProxySQL Blog)}

A deep dive into the Provider interface that makes dbdeployer multi-database. How we abstracted MySQL, added PostgreSQL, and made it extensible for any database. [...]

Published Sunday, 19. April 2026 00:00 • 21 days ago

Instant Strapi Performance Without Changing Your Code ^{(from Another Boring Tech Blog)}

pHow to scale your Strapi data layer using a wire compatible caching proxy and what the results look like on 43,000 real restaurants. Strapi is an excellent tool for building content driven applications quickly. As a project grows and data becomes more interconnected, keeping the API layer snappy is a common goal for development teams. […]/p pO post Instant Strapi Performance Without Changing [...]

Published Saturday, 18. April 2026 19:31 • 22 days ago

What’s New At Releem - March 2026 ^{(from Releem Blog)}

We spent March focused on expanding query optimization, building out partner integrations, continuing PostgreSQL testing, and improve the overall experience for hosting providers and teams using Releem. [...]

Published Saturday, 18. April 2026 11:16 • 22 days ago

ProxySQL for PostgreSQL — the failover model ^{(from ProxySQL Blog)}

First blog post of a series about ProxySQL for PostgreSQL and how it handles failover [...]

Published Saturday, 18. April 2026 00:00 • 22 days ago

Incremental backups in Percona Kubernetes Operator for MySQL ^{(from Percona Community Blog)}

Starting with version 1.1.0, the Percona Kubernetes Operator for MySQL now supports incremental backups. This feature lets you backup only the changed data since the last backup, instead of copying your entire dataset each time. The result is dramatically smaller backup sizes, faster backup windows, and lower cloud storage costs. [...]

Published Friday, 17. April 2026 10:00 • 23 days ago

MariaDB’s Snapshot Isolation: A Fix That Breaks More Than It Fixes ^{(from Percona Database Blog)}

pJepsen’s analysis of MySQL 8.0.34 walked through a set of concurrency and isolation anomalies in InnoDB. MariaDB, which inherits the same codebase, took the report seriously and shipped a response: a new server variable called innodb_snapshot_isolation, turned on by default starting in 11.8. The announcement claims that with the flag enabled, Repeatable Read in MariaDB … Continued/p pT [...]

Published Friday, 17. April 2026 07:58 • 23 days ago

Where Do Users Get MariaDB Server From? ^{(from MariaDB Foundation Blog)}

pWe recently asked the community a simple but important question:/p pWhat is the main source of the MariaDB Server you use?/p pThe answers provide a very interesting snapshot of how MariaDB is consumed in the real world today—and, perhaps more importantly, how different installation methods reflect different use cases and priorities. … /p pContinue reading \"Where Do Users Get MariaDB S [...]

Published Friday, 17. April 2026 06:52 • 23 days ago

ProxySQL's prepared statement cache refactor, explained ^{(from ProxySQL Blog)}

A walk-through of the PostgreSQL prepared-statement cache refactor — what was slow, why, and how the redesign turned a contended path into a contention-free one [...]

Published Friday, 17. April 2026 00:00 • 23 days ago

Build resilient Kerberos authentication for Aurora Global Database without joining Active Directory domain ^{(from AWS Database Blog)}

In this post, we show you how to build a multi-Region Kerberos authentication system that matches your Aurora Global Database’s resilience using AWS Directory Service for Microsoft Active Directory (AWS Managed Microsoft AD) with multi-Region replication and a one-way forest trust to your on-premises Active Directory, so your Linux clients can authenticate without joining the AD domain. [...]

Published Thursday, 16. April 2026 17:13 • 24 days ago

How GitHub uses eBPF to improve deployment safety ^{(from The GitHub Blog)}

pLearn how Github uses eBPF to detect and prevent circular dependencies in its deployment tooling. /p pThe post How GitHub uses eBPF to improve deployment safety appeared first on The GitHub Blog./p [...]

Published Thursday, 16. April 2026 16:00 • 24 days ago

Introducing MySQL GTID Support and Zero-Downtime Failover in Readyset ^{(from Readyset Blog)}

Readyset now fully supports MySQL GTIDs, enabling zero-downtime failover without restarting or losing your cache. Learn how GTID replication works in Readyset and how to script failover into your existing MySQL high availability setup. [...]

Published Thursday, 16. April 2026 12:00 • 24 days ago

Inside MySQL: 20 Years of Source Code, Open Source Contributions, and What Comes Next. A Conversation with Marcelo Altmann ^{(from ODBMS.org)}

Q1. Marcelo, congratulations on being named MySQL Rockstar 2025! You’ve spent nearly 20 years working with MySQL — from the LAMP stack era when InnoDB was “the new kid” to today’s cloud-native, multi-terabyte production environments.... [...]

Published Thursday, 16. April 2026 11:48 • 24 days ago

zstd Compression Support in ProxySQL 3.0.7 ^{(from ProxySQL Blog)}

ProxySQL 3.0.7 adds native zstd compression for the MySQL protocol, offering better compression ratios and lower CPU overhead compared to zlib. [...]

Published Thursday, 16. April 2026 00:00 • 24 days ago

Dissecting the MySQL 8.0 Performance Regression on oltp_update_non_index ^{(from Zhao Song's Blog)}

The performance regression in MySQL 8.0 is well known, but it is still not fully understood. That is because it is not a regression caused by one obvious bottleneck. MySQL 8.0 introduced many new designs and refactored major subsystems, so the gap comes from a combination of configuration defaults, architectural trade-offs, and many small overheads spread across different layers. [...]

Published Thursday, 16. April 2026 00:00 • 24 days ago

What Happens to a Database When the User is an AI agent ^{(from PingCAP Blog)}

pEditor’s note: This post originally appeared on The New Stack and is republished with permission. The original version is available here. In the past, we judged enterprise databases by how useful they were to people like us. We rated them on how well they helped architects create schemas, DBAs plan capacity, and analysts build queries. We […]/p pThe post What Happens to a Database When [...]

Published Wednesday, 15. April 2026 21:38 • 25 days ago

Symlinks are Unsafe since MySQL 8.0.39 (and maybe even before) ^{(from J-F Gagné's MySQL Blog)}

You read this right, symbolic links (symlinks) are unsafe in MySQL since at least 8.0.39. As always, it is a little more complicated than that, but if you are using symbolic links and in certain conditions, you risk a crash. I think it is important to raise awareness on this, hence this post. My attention was brought to this via the now private Bug #120156: MySQL 8.0.39/8.0.42 [...]

Published Tuesday, 14. April 2026 19:53 • 26 days ago | Updated Wednesday, 15. April 2026 13:20 • 25 days ago

Monitoring MySQL data locks, or the tip of the iceberg ^{(from The Oracle MySQL Blog)}

Monitoring MySQL data locks, or the tip of the iceberg This story is about recent (*) performance improvements implemented in MySQL, related to monitoring of data locks. (*) Originally written in Feb 2025. Refresher What is a data lock? When a user session connects to the MySQL database, it executes SQL queries. The query runs; […] [...]

Published Wednesday, 15. April 2026 13:13 • 25 days ago

Tutorial: Building AI Agents That Talk to Your Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pWhat if you could ask your database a question in plain English and get the answer instantly, without writing a single line of SQL?/p pIn this tutorial, you'll build a Python-based AI agent that connects to Azure Database for MySQL server and uses OpenAI's function calling to translate natural language questions into SQL queries, execute them, and return human-readable answers. The agent can explo [...]

Published Wednesday, 15. April 2026 13:00 • 25 days ago

What changed between MySQL 9.7.0-er and 9.7.0-er2 ^{(from Laurynas Biveinis' blog)}

p Oracle has published the second MySQL 9.7.0 early access release! /p p Previously I wrote about building and testing the first one under macOS. This time I won't do that, because I cannot, because of a showstopper bug #120246 (XCode 26.4 fails to build 9.7.0-er2). Using a different compiler does not help this time because some of the errors appear libc-related. /p p So, this time I'll be lookin [...]

Published Wednesday, 15. April 2026 12:16 • 25 days ago | Updated Wednesday, 15. April 2026 12:16 • 25 days ago

Replication Internals: Decoding the MySQL Binary Log - Part 8: Row Events — WRITE_ROWS, UPDATE_ROWS, and DELETE_ROWS ^{(from Readyset Blog)}

Part 8 of Readyset's MySQL binary log internals series decodes WRITE_ROWS, UPDATE_ROWS, and DELETE_ROWS events, covering row images, column bitmaps, null bitmaps, and how MySQL stores INSERT, UPDATE, and DELETE operations byte by byte. [...]

Published Wednesday, 15. April 2026 10:00 • 25 days ago

Multi-Region MySQL on Kubernetes: Architecture Patterns for Global Scale ^{(from Continuent Blog)}

A deep dive into multi-region MySQL deployment patterns on Kubernetes, exploring replication models, failover strategies, and the operational trade-offs required to achieve global scale and resilience.Tags: kubernetesArchitecture [...]

Published Wednesday, 15. April 2026 08:51 • 25 days ago

Ask Claude what happened to your MySQL ^{(from dbtrail Blog)}

pMost teams running MySQL in production don’t have a DBA. They have a developer who set up RDS two years ago, automated snapshots they’ve never tested a restore…/p pThe post Ask Claude what happened to your MySQL appeared first on dbtrail Blog./p [...]

Published Wednesday, 15. April 2026 02:49 • 25 days ago

Improving storage with additional storage volumes in Amazon RDS for SQL Server ^{(from AWS Database Blog)}

As SQL Server workloads grow on Amazon Relational Database Service (Amazon RDS) for Db2, the 64 TiB storage limit can force architectural issues that constrain business growth and create performance bottlenecks when transaction logs compete with data for I/O resources. The additional storage volumes feature in Amazon RDS for SQL Server solves these challenges. You can use Amazon RDS for SQL Server [...]

Published Tuesday, 14. April 2026 16:16 • 26 days ago

Accelerate database migration to Amazon Aurora DSQL with Kiro and Amazon Bedrock AgentCore ^{(from AWS Database Blog)}

In this post, we walk through the steps to set up the custom migration assistant agent and migrate a PostgreSQL database to Aurora DSQL. We demonstrate how to use natural language prompts to analyze database schemas, generate compatibility reports, apply converted schemas, and manage data replication through AWS DMS. As of this writing, AWS DMS does not support Aurora DSQL as target endpoint. To ad [...]

Published Tuesday, 14. April 2026 16:15 • 26 days ago

Village News: MySQL/Database News (14 April 2026) ^{(from VillageSQL)}

pAs part of building the MySQL Community, we are going to publish a curated overview of MySQL and database news that you might have missed over the last period./ppIf you want to get these updates, just subscribe to the blog. /ppEnjoy!/pMySQL News:pNote: Aggregated MySQL news can/p [...]

Published Tuesday, 14. April 2026 14:00 • 26 days ago

What Our Survey Says About MariaDB Preview Releases ^{(from lefred's blog)}

Preview releases are among the clearest ways an open-source community can shape the future of a database before it becomes a production reality. They give users early access to new features, a chance to validate upgrade paths, and an opportunity to catch issues while the change is still inexpensive. In our recent survey, we asked […] [...]

Published Tuesday, 14. April 2026 10:10 • 26 days ago

Auditing Login Attempts in MySQL and MariaDB ^{(from Percona Database Blog)}

pMy colleague Miguel wrote about ways to audit login attempts in MySQL over 13 years ago, and this is still a relevant subject. I decided to refresh this topic to include some important changes since then. Very often, it is important to track login attempts to our databases due to security reasons as well as … Continued/p pThe post Auditing Login Attempts in MySQL and MariaDB appeared first o [...]

Published Monday, 13. April 2026 21:08 • 27 days ago

Google Cloud introduces QueryData to help AI agents create reliable database queries ^{(from InfoWorld)}

pA new tool from Google Cloud aims to improve the accuracy of AI agents querying databases in multi-agent systems or applications./p pQueryData, which translates natural language into database queries with what the company claims is “near 100% accuracy,” is being pitched as an alternative to direct generation of queries by large language models (LLMs), which Google says ca [...]

Published Monday, 13. April 2026 16:50 • 27 days ago

Options for changing AWS KMS encryption key for Amazon RDS databases ^{(from AWS Database Blog)}

In this post, we review the options for changing the AWS KMS key on your Amazon RDS database instances and on your Amazon RDS and Aurora clusters. We start with the most common approach, which is the snapshot method, and then we include additional options to consider when performing this change on production instances and clusters that can mitigate downtime. Each of the approaches mentioned in this [...]

Published Monday, 13. April 2026 15:52 • 27 days ago

Join the Public MySQL Community Discussion Webinar (Edition #3) ^{(from The Oracle MySQL Blog)}

Following the strong participation in the first two editions of our Public MySQL Community Discussion webinar series, we’re excited to invite you to Edition #3. These sessions are part of our ongoing commitment to increase transparency, strengthen collaboration, and make it easier for the community to provide input that helps shape the evolution of MySQL’s. […] [...]

Published Monday, 13. April 2026 09:28 • 27 days ago

MariaDB Foundation releases the BETA of the Test Automation Framework (TAF) 2.5 ^{(from MariaDB Foundation Blog)}

pThe MariaDB Foundation is releasing the BETA version of the Test Automation Framework (TAF) 2.5. This release represents a significant architectural upgrade, strengthening the framework’s lifecycle model, profiling capabilities, extraction and install pipeline, and reporting consistency. … /p pContinue reading \"MariaDB Foundation releases the BETA of the Test Automation Framework (TAF [...]

Published Sunday, 12. April 2026 13:39 • 28 days ago

How a MySQL UPDATE Actually Works: InnoDB Internals Animated ^{(from ReliaDB)}

Step-by-step animation of what happens inside MySQL when you run an UPDATE. From client packet to redo log fsync — every layer of InnoDB explained with interactive visualization. [...]

Published Sunday, 12. April 2026 10:00 • 28 days ago

Writing My Own Extension For Village SQL Part II ^{(from Dave's MySQL Stuff)}

p Writing my own extension for Village SQL has been a learning experience. Extensions are a big part of the PostgreSQL ecosystem, and the idea of bringing them to the MySQL ecosystem is a source of hope for the 'most popular database'. /ppbr/pThe Good NewspI was able to build my extension, vsql_cube, and get it into the server! Yeah! /pmysql> select * from [...]

Published Saturday, 11. April 2026 14:35 • 29 days ago

MySQL EXPLAIN Output Explained: The Complete Guide (2026) ^{(from ReliaDB)}

Every column of MySQL EXPLAIN output decoded with real examples from a 680K-row production database. Learn what each access type means, when to worry, and how to fix the slow ones. [...]

Published Saturday, 11. April 2026 10:00 • 29 days ago

Navigating Business Challenges: Insights from Sailing ^{(from AskDba)}

Some experiences can be simulated. Sailing cannot, and it ever changes. At first glance, a sailboat feels like leisure, wind, sea, and escape from reality. But the moment you take responsibility on board, that illusion disappears. A sailboat is not an escape from life. It is a lifestyle full of responsibilities. As we enter the […] [...]

Published Friday, 10. April 2026 18:32 • 30 days ago

MySQL 9.7.0 vs sysbench on a small server ^{(from Small Datum)}

pThis has results from sysbench on a small server with MySQL 9.7.0 and 8.4.8. Sysbench is run with low concurrency (1 thread) and a cached database. The purpose is to search for changes in performance, often from new CPU overheads.brbrI tested MySQL 9.7.0 with and without the hypergraph optimizer enabled. I don't expect it to help much because the queries run here are simple. I hope to learn it doe [...]

Published Friday, 10. April 2026 18:00 • 30 days ago | Updated Friday, 10. April 2026 18:00 • 30 days ago

What Our Survey Says About MariaDB Preview Releases ^{(from MariaDB Foundation Blog)}

pPreview releases are among the clearest ways an open-source community can shape the future of a database before it becomes a production reality. They give users early access to new features, a chance to validate upgrade paths, and an opportunity to catch issues while the change is still inexpensive. … /p pContinue reading \"What Our Survey Says About MariaDB Preview Releases\"/p pThe post Wh [...]

Published Friday, 10. April 2026 07:33 • 1 months ago

Keeping a Postgres queue healthy ^{(from PlanetScale Blog)}

Dead tuples from high-churn job queues can silently degrade your Postgres database when vacuum falls behind—especially alongside competing workloads. Traffic Control keeps cleanup on track. [...]

Published Friday, 10. April 2026 00:00 • 1 months ago

Sysbench vs MySQL on a small server: another way to view the regressions ^{(from Small Datum)}

pThis post provides another way to see the performance regressions in MySQL from versions 5.6 to 9.7. It complements what I shared in a recent post. The workload here is cached by InnoDB and my focus is on regressions from new CPU overheads. /ppThe good news is that there are few regressions after 8.0. The bad news is that there were many prior to that and these are unlikely to be undone. [...]

Published Thursday, 09. April 2026 19:31 • 1 months ago | Updated Thursday, 09. April 2026 19:32 • 1 months ago

S3 is the New Network: Rethinking Data Architecture for AI Agents ^{(from PingCAP Blog)}

pEditor’s note: This post originally appeared on The New Stack and is republished with permission. The original version is available here. For decades, database designers have built distributed databases around the assumption that storage must live close to compute. The farther data travels over the network, the reasoning goes, the greater the potential for delay. Local […]/p pThe post S3 is [...]

Published Thursday, 09. April 2026 18:52 • 1 months ago

Amazon RDS Blue/Green Deployments now supports Amazon RDS Proxy ^{(from AWS What's New)}

pAmazon RDS Blue/Green Deployments now supports Amazon RDS Proxy, enabling faster application recovery during switchover by eliminating DNS propagation delays. Blue/Green Deployments create a fully managed staging environment (Green) that allows you to deploy and test production changes, keeping your current production database (Blue) safe. When ready, you can switchover to the new production envir [...]

Published Thursday, 09. April 2026 17:00 • 1 months ago

Amazon RDS Blue/Green Deployments now supports Amazon RDS Proxy ^{(from AWS What's New)}

pAmazon RDS Blue/Green Deployments now supports Amazon RDS Proxy, enabling faster application recovery during switchover by eliminating DNS propagation delays. Blue/Green Deployments create a fully managed staging environment (Green) that allows you to deploy and test production changes, keeping your current production database (Blue) safe. When ready, you can switchover to the new production envir [...]

Published Thursday, 09. April 2026 17:00 • 1 months ago

When “Committed” Doesn’t Mean Durable: What Jepsen Found in Galera Cluster ^{(from Continuent Blog)}

Jepsen found write loss, stale reads, and lost updates in MariaDB Galera Cluster. This article examines what commit actually guarantees and why ordering impacts durability and consistency. [...]

Published Thursday, 09. April 2026 16:58 • 1 months ago

We Built a Free MySQL EXPLAIN Analyzer — Here's What It Catches That You're Missing ^{(from ReliaDB)}

Free MySQL & MariaDB EXPLAIN ANALYZE visualizer with 49 detection rules, smart index recommendations, and impact simulation. Tested against AI analysis on 50 unseen queries. 100% client-side. [...]

Published Thursday, 09. April 2026 10:00 • 1 months ago

Bringing databases and Kubernetes together ^{(from InfoWorld)}

pRunning databases on Kubernetes is popular. For cloud-native organizations, Kubernetes is the de facto standard approach to running databases. According to Datadog, databases are the most popular workload to deploy in containers, with 45 percent of container-using organizations using this approach. The Data on Kubernetes Community found that production deployments were now c [...]

Published Thursday, 09. April 2026 09:00 • 1 months ago

MariaDB Vector: How it works. Part IV ^{(from MariaDB Foundation Blog)}

pThis is the last post in the “MariaDB Vector: How it works” series. The first three were about storage, in-memory representation, HNSW modifications. … /p pContinue reading \"MariaDB Vector: How it works. Part IV\"/p pThe post MariaDB Vector: How it works. Part IV appeared first on MariaDB.org./p [...]

Published Thursday, 09. April 2026 06:42 • 1 months ago

Announcing the future of Orchestrator: ProxySQL takes takes the helm ^{(from ProxySQL Blog)}

ProxySQL officially takes over the maintenance and development of Orchestrator, ensuring a bright future for the industry-standard database topology management tool. [...]

Published Thursday, 09. April 2026 00:00 • 1 months ago

The Insert Benchmark vs MariaDB 10.2 to 13.0 on a 32-core server ^{(from Small Datum)}

pThis has results for MariaDB versions 10.2 through 13.0 vs the Insert Benchmark on a 32-core server. The goal is to see how performance changes over time to find regressions or highlight improvements. My previous post has results from a 24-core server. Differences between these servers include:br/pulliRAM - 32-core server has 128G, 24-core server has 64G/lilifsync latency - 32-core [...]

Published Wednesday, 08. April 2026 21:41 • 1 months ago | Updated Wednesday, 08. April 2026 22:05 • 1 months ago

The Insert Benchmark vs MariaDB 10.2 to 13.0 on a 24-core server ^{(from Small Datum)}

pThis has results for MariaDB versions 10.2 through 13.0 vs the Insert Benchmark on a 24-core server. The goal is to see how performance changes over time to find regressions or highlight improvements./ppMariaDB 13.0.0 is faster than 10.2.30 on most benchmark steps and otherwise as fast as 10.2.30. This is a great result./pptl;dr/pp/pullifor a CPU-bound workload/liullithe write-heavy step [...]

Published Wednesday, 08. April 2026 01:39 • 1 months ago | Updated Wednesday, 08. April 2026 21:28 • 1 months ago

Village News: MySQL/Database News (8 April 2026) ^{(from VillageSQL)}

MySQL news: 8.0 EOL options, ProxySQL updates, Azure Fabric Mirroring, and Anthropic AI security alerts. Plus, 2026 database event schedules. [...]

Published Wednesday, 08. April 2026 20:06 • 1 months ago

Replication Internals: Decoding the MySQL Binary Log Part 7: TABLE_MAP_EVENT – Table Metadata for Row-Based Replication ^{(from Readyset Blog)}

Learn how MySQL's TABLE_MAP_EVENT maps table IDs to database names and column layouts before row-based replication events. Includes a full byte-level breakdown of column types, null bitmaps, and optional metadata. [...]

Published Wednesday, 08. April 2026 14:00 • 1 months ago

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 5: Execution, Validation, Cutover, and Cleanup ^{(from ReliaDB)}

Run the AWS DMS migration task, enable data validation, perform the cutover from MariaDB to Aurora MySQL, recreate indexes, and clean up all temporary AWS resources. [...]

Published Wednesday, 08. April 2026 14:00 • 1 months ago

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 4: DMS Endpoints, Task Configuration, and Assessments ^{(from ReliaDB)}

Configure AWS DMS source and target endpoints, set up DMS users, create the migration task with correct LOB and table mapping settings, and run pre-migration assessments. [...]

Published Wednesday, 08. April 2026 13:00 • 1 months ago

Celebrating 30 Years of MySQL: Free Training & Certification Results ^{(from The Oracle MySQL Blog)}

In 2025, MySQL celebrated its 30th anniversary—and to mark the milestone, Oracle University (together with the MySQL Community team) offered free MySQL training and free certification exams from April 20 through July 31, 2025. The goal was simple: make it easy for developers, DBAs, architects, and newcomers to build practical skills and validate them with […] [...]

Published Wednesday, 08. April 2026 12:25 • 1 months ago

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 3: Schema and User Migration ^{(from ReliaDB)}

Migrate schema and users from MariaDB 10.6 to Aurora MySQL 8.0. Covers mysqldump compatibility pipeline, incompatible object cleanup, index strategy for DMS, and user export with pt-show-grants. [...]

Published Wednesday, 08. April 2026 12:00 • 1 months ago

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 2: AWS DMS Infrastructure Setup ^{(from ReliaDB)}

Set up AWS DMS for MariaDB to Aurora MySQL migration. Step-by-step guide to IAM roles, replication instance sizing, VPC configuration, and security group rules. [...]

Published Wednesday, 08. April 2026 11:00 • 1 months ago

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 1: Pre-Migration Requirements ^{(from ReliaDB)}

Pre-migration checklist for migrating from MariaDB 10.6 to Amazon Aurora MySQL 8.0 via AWS DMS. Covers timeout settings, binlog configuration, and target validation. [...]

Published Wednesday, 08. April 2026 10:00 • 1 months ago

Thanks AWS Open Source ^{(from J-F Gagné's MySQL Blog)}

I would like to thank AWS Open Source for their support. For some time, I am maintaining Planet for the MySQL Community, a blog / news aggregator for the MySQL Community/Ecosystem. I am also maintaining a similar aggregator for the Valkey Community. Maintaining blog / news aggregators is not free. It incurs hosting, domain registration, and other costs (in addition to time, [...]

Published Tuesday, 07. April 2026 20:11 • 1 months ago | Updated Tuesday, 07. April 2026 20:11 • 1 months ago

Monitor custom database metrics in Amazon RDS for SQL Server using Amazon CloudWatch ^{(from AWS Database Blog)}

In this post, we demonstrate how to create custom Amazon RDS for SQL Server CloudWatch metrics. You accomplish this by using SQL Server Agent jobs and CloudWatch Logs integration. We walk through an example of monitoring table size within a SQL Server database however, this approach works for various other metrics. You can adapt this approach to track row counts, database size, job counts, user ses [...]

Published Tuesday, 07. April 2026 18:29 • 1 months ago

The AWS Lambda ‘Kiss of Death’ ^{(from Shattered Silicon OSDB Blog)}

pOur story begins as most database issues start: with hands on foreheads, internally or externally, saying ‘WTF is going on?’. We observed a series of database freezes on our production environment. It was quite severe. Connections spiked, writes were stalled and at some point, a large database freeze and they cleared. Being a Galera environment, […]/p pThe post The AWS Lambda ‘Kiss of [...]

Published Tuesday, 07. April 2026 18:15 • 1 months ago

Writing My Own Extension for Village SQL Part I ^{(from Dave's MySQL Stuff)}

pSince my previous post on Village SQL, life has been filled with too many other things. But finally I was able this past weekend to circle back and try to write my own extension./ppThe Village SQL TL;DR -> MySQL with PostgreSQL like extensions. /ppThe documentation on writing new extensions seems complete, but I have run into issues that are probably caused by me, and not the d [...]

Published Tuesday, 07. April 2026 13:46 • 1 months ago

Reducing P999 Latency in Distributed Databases with TiDB 8.5 ^{(from PingCAP Blog)}

pReducing P999 latency in distributed databases is one of the hardest challenges in modern OLTP systems. A handful of slow requests can cascade across services, break SLOs, and directly impact business outcomes, especially in latency-sensitive environments like trading platforms and real-time applications. This is the challenge of tail latency. As systems scale, variability compounds: queueing [ [...]

Published Tuesday, 07. April 2026 13:00 • 1 months ago

What enterprise devops teams should learn from SaaS ^{(from InfoWorld)}

pMany enterprise devops teams struggle to deploy frequently, increase test automation, and ensure reliable releases. What can they learn from SaaS companies, where developing and deploying software for thousands of customers is core to their revenue and business operations?/p pSaaS companies must have robust testing, observability, deployment, and monitoring capabilities. [...]

Published Tuesday, 07. April 2026 09:00 • 1 months ago

Announcing ProxySQL 3.0.7, 3.1.7, and 4.0.7 ^{(from ProxySQL Blog)}

ProxySQL 3.0.7 brings protocol hardening, zstd compression, TLS certificate tracking, and new security improvements. Also announcing 3.1.7 and 4.0.7. [...]

Published Tuesday, 07. April 2026 00:00 • 1 months ago

Starting from PostgreSQL’s fsync Failure ^{(from Chen Zongzhi's Medium blog)}

♦IntroductionpIn 2018, the PostgreSQL community discovered a severe problem that had existed for 20 years: when fsync() fails, PostgreSQL's handling could lead to silent data loss. This incident, known as "fsyncgate", not only revealed an architectural flaw in PostgreSQL itself, but also exposed a deep conflict between the Linux kernel, file systems, and databases regarding I/O error [...]

Published Monday, 06. April 2026 21:00 • 1 months ago

Tournament of Databases: The Winner! ^{(from VillageSQL)}

MySQL beats PostgreSQL to win our Tournament of Databases. See how multi-threaded architecture and replication carried MySQL to the championship. [...]

Published Monday, 06. April 2026 19:00 • 1 months ago

Optimize full-text search in Amazon RDS for MySQL and Amazon Aurora MySQL ^{(from AWS Database Blog)}

In this post, we show you how to optimize full-text search (FTS) performance in Amazon RDS for MySQL and Amazon Aurora MySQL-Compatible Edition through proper maintenance and monitoring. We discuss why FTS indexes require regular maintenance, common issues that can arise, and best practices for keeping your FTS-enabled databases running smoothly. [...]

Published Monday, 06. April 2026 18:11 • 1 months ago

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 5: Change Management, Troubleshooting, and Complete Checklist ^{(from ReliaDB)}

Complete MySQL 8.4 upgrade checklist with 41 items, 8 common troubleshooting scenarios, project timeline estimates, and change management templates for production upgrades. [...]

Published Monday, 06. April 2026 14:00 • 1 months ago

MySQL Tools for Performance Tuning and Test Data Generation ^{(from Kedar MySQL Blog)}

pAs a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to…/p The post MySQL Tools for Performance Tuning and Test Data Generation first appeared on Change Is Inevitable. [...]

Published Monday, 06. April 2026 14:00 • 1 months ago

Your MySQL Backups Won’t Pass a Compliance Audit Alone ^{(from dbtrail Blog)}

pEvery compliance framework that touches data recovery says some version of the same thing: you need to be able to restore data, prove that you can, and show…/p pThe post Your MySQL Backups Won’t Pass a Compliance Audit Alone appeared first on dbtrail Blog./p [...]

Published Monday, 06. April 2026 13:08 • 1 months ago

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 4: Rollback Strategy and Post-Upgrade Validation ^{(from ReliaDB)}

Plan your MySQL 8.4 rollback strategy before you start. Plus the complete post-upgrade validation checklist — version checks, replication health, optimizer stats, and monitoring. [...]

Published Monday, 06. April 2026 13:00 • 1 months ago

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 3: Upgrade Execution ^{(from ReliaDB)}

Three MySQL upgrade approaches compared — replication-based, in-place, and rolling replica. Step-by-step commands, configuration templates, and time estimates for each method. [...]

Published Monday, 06. April 2026 12:00 • 1 months ago

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 2: Upgrade Testing ^{(from ReliaDB)}

Learn how to test your MySQL 8.0 to 8.4 upgrade using pt-upgrade, dry-run procedures, application compatibility checks, and canary testing before touching production. [...]

Published Monday, 06. April 2026 11:00 • 1 months ago

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 1: Pre-Upgrade Preparation ^{(from ReliaDB)}

MySQL 8.0 reached EOL on April 6, 2026. This guide covers every pre-upgrade step — backups, upgrade checker, removed parameters, authentication migration, and schema fixes. [...]

Published Monday, 06. April 2026 10:00 • 1 months ago

Sysbench vs MariaDB on a small server: using the same charset for all versions ^{(from Small Datum)}

pThis has results for sysbench vs MariaDB on a small server. I repeated tests using the same charset (latin1) for all versions as explained here. In previous results I used a multi-byte charset for modern MariaDB (probably 11.4+) by mistake and that adds a 5% CPU overhead for many tests./pptl;dr/pp/pulliMariaDB has done much better than MySQL at avoid regressions from code bloat./liliThere are seve [...]

Published Monday, 06. April 2026 03:38 • 1 months ago | Updated Monday, 06. April 2026 03:38 • 1 months ago

Planet for the MySQL Community

A blog / news aggregator for the MySQL Community / Ecosystem

Monday, 11. May 2026

Dolt 2.0 (from DoltHub Blog)

Saturday, 09. May 2026

MyVector v1.26.5: Component Architecture Arrives (from AskDba)

Friday, 08. May 2026

Custom Model Context Protocol (MCP) for NL2SQL: A Rigorous Evaluation Framework on Oracle Database (from DZone)

Dealing with caching_sha2_password as authentication method in MariaDB Server (from lefred's blog)

Unleashing Innovation Through Plugins (from MariaDB Foundation Blog)

Bringing pt-query-digest-Style Slow Query Analysis to PostgreSQL with pg_enhanced_query_logging (from Percona Database Blog)

Thursday, 07. May 2026

What is a Context Platform? A New Pattern for AI Agents in Production (from PingCAP Blog)

Time-travel SQL for MySQL, finally (from dbtrail Blog)

Meet the Percona Community team (from Percona Community Blog)

Adding a New Data Type to MariaDB with Type_handler – Part 5 (from lefred's blog)

Adding a New Data Type to MariaDB with Type_handler – Part 4 (from lefred's blog)

Adding a New Data Type to MariaDB with Type_handler – Part 3 (from lefred's blog)

Adding a New Data Type to MariaDB with Type_handler – Part 2 (from lefred's blog)

February 2026 Recap: Azure Database for MySQL (from Azure for MySQL Blog)

A New Era of MySQL Monitoring: OpenTelemetry Metrics with Prometheus (from The Oracle MySQL Blog)

Announcing DumboDB: A MongoDB Clone Built on Dolt (from DoltHub Blog)

Problem solving with PlanetScale Insights (from PlanetScale Blog)

Slot-based Buffer Manager 的设计 — 从 Pin 的本质说起 (from Chen Zongzhi's GitHub blog)

Wednesday, 06. May 2026

Adding a New Data Type to MariaDB with Type_handler – Part 1 (from lefred's blog)

Replication Internals: Decoding the MySQL Binary Log Part 10: ROTATE_EVENT — Closing the File and Pointing at the Next One (from Readyset Blog)

Adding a New Data Type to MariaDB with Type_handler – Part 5 (from MariaDB Foundation Blog)

The End of SaaS - Except for a Few Types (from siddontang on Medium)

Database as the Runtime Layer for AI Agents — Why Storage Is No Longer Enough (from siddontang on Medium)

MySQL 9.7 is out and the community wins (from AskDba)

MySQL 9.7 Is Out and the Community Wins (from The Oracle MySQL Blog)

Announcing Azure Private Link Support for Hosted Dolt (from DoltHub Blog)

Tuesday, 05. May 2026

MySQL in N-Dimensions: High-Complexity Data with vsql-cube (from VillageSQL)

PSMDB Sandbox: A Browser-Based UI for Deploying MongoDB with Terraform and Ansible (from Percona Database Blog)

AI finds 20-year-old bugs in PostgreSQL and MariaDB (from InfoWorld)

Adding a New Data Type to MariaDB with Type_handler – Part 4 (from MariaDB Foundation Blog)

On benchmarking (from PlanetScale Blog)

Transparency in benchmarking (from PlanetScale Blog)

Monday, 04. May 2026

Why Your Application Should Not Use One MySQL User for Everything (from The Oracle MySQL Blog)

April Product Update (from Readyset Blog)

For a Database, survive used to mean “The server stays up”. With AI Agents, that’s not enough anymore (from dbtrail Blog)

An AI Agent is talking to your MySQL. And the database doesn’t know who is that! – Agent Era, Part 3 (from dbtrail Blog)

Long live to dbdeployer! (from lefred's blog)

Long live to dbdeployer! (from MariaDB Foundation Blog)

I Know Kung Fu (from Percona Database Blog)

Adding a New Data Type to MariaDB with Type_handler – Part 3 (from MariaDB Foundation Blog)

Curious case of PXC node that refused to start due to SSL (from Percona Database Blog)

Building Query Analysis and Insights Dashboard in PMM (from Percona Database Blog)

Database Insurance (from DoltHub Blog)

Sunday, 03. May 2026

Disaster Recovery Run Books for GCC-Owned Database Platforms (from MinervaDB Blog)

When Databases Start Eating Software — The Paradigm Shift in the AI Era (from siddontang on Medium)

SaaS is Dead — The Rise of Result as a Service (from siddontang on Medium)

Saturday, 02. May 2026

Adding a New Data Type to MariaDB with Type_handler – Part 2 (from MariaDB Foundation Blog)

InnoDB Redo Log Sizing: Stop Guessing, Start Measuring (from Percona Community Blog)

Friday, 01. May 2026

Village News: MySQL/Database News (1 May 2026) (from VillageSQL)

How We Built mem9: Lessons From Shipping Persistent Memory for AI Agents (from PingCAP Blog)

Run an ALTER TABLE for a huge table in Aurora (from Percona Database Blog)

Thursday, 30. April 2026

Managing Valkey Cluster in Kubernetes (from Percona Database Blog)

How Tungsten Cluster Achieves Data Integrity With Asynchronous Replication (from Continuent Blog)

MySQL Tuning on OCI HeatWave: What Still Matters, What OCI Manages, and What You Should Actually Tune (from The Oracle MySQL Blog)

When AI Agent Memory Outgrows SQLite: How to Tell, and What to Move to Next (from PingCAP Blog)

Three Promises in the Agent Era, Part 2: Agents on production MySQL are fine. Until they’re not. (from dbtrail Blog)

Continued Commitment to Percona XtraDB Cluster (from Percona Database Blog)

Adding a New Data Type to MariaDB with Type_handler – Part 0 (from lefred's blog)

From Ecosystem to Architecture: Expanding How We Look at MariaDB (from MariaDB Foundation Blog)

Adding a New Data Type to MariaDB with Type_handler – Part 1 (from MariaDB Foundation Blog)

No More Silent Foreign Key Cascades: MySQL 9.7 Lets Child Triggers Speak Up (from The Oracle MySQL Blog)

RLS sounds great until it isn't (from PlanetScale Blog)

Announcing Vitess 24 (from Vitess)

Wednesday, 29. April 2026

AI Is Raising the Bar for MySQL Database Security (from The Oracle MySQL Blog)

Amazon RDS for MySQL announces Innovation Release 9.6 in Amazon RDS Database Preview Environment (from AWS What's New)

XtraBackup incremental prepare phase is 2x-3x faster! (from Percona Database Blog)

Dolt 2.0 ^{(from DoltHub Blog)}

MyVector v1.26.5: Component Architecture Arrives ^{(from AskDba)}

Custom Model Context Protocol (MCP) for NL2SQL: A Rigorous Evaluation Framework on Oracle Database ^{(from DZone)}

Dealing with caching_sha2_password as authentication method in MariaDB Server ^{(from lefred's blog)}

Unleashing Innovation Through Plugins ^{(from MariaDB Foundation Blog)}

Bringing pt-query-digest-Style Slow Query Analysis to PostgreSQL with pg_enhanced_query_logging ^{(from Percona Database Blog)}

What is a Context Platform? A New Pattern for AI Agents in Production ^{(from PingCAP Blog)}

Time-travel SQL for MySQL, finally ^{(from dbtrail Blog)}

Meet the Percona Community team ^{(from Percona Community Blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 5 ^{(from lefred's blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 4 ^{(from lefred's blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 3 ^{(from lefred's blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 2 ^{(from lefred's blog)}

February 2026 Recap: Azure Database for MySQL ^{(from Azure for MySQL Blog)}

A New Era of MySQL Monitoring: OpenTelemetry Metrics with Prometheus ^{(from The Oracle MySQL Blog)}

Announcing DumboDB: A MongoDB Clone Built on Dolt ^{(from DoltHub Blog)}

Problem solving with PlanetScale Insights ^{(from PlanetScale Blog)}

Slot-based Buffer Manager 的设计 — 从 Pin 的本质说起 ^{(from Chen Zongzhi's GitHub blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 1 ^{(from lefred's blog)}

Replication Internals: Decoding the MySQL Binary Log Part 10: ROTATE_EVENT — Closing the File and Pointing at the Next One ^{(from Readyset Blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 5 ^{(from MariaDB Foundation Blog)}

The End of SaaS - Except for a Few Types ^{(from siddontang on Medium)}

Database as the Runtime Layer for AI Agents — Why Storage Is No Longer Enough ^{(from siddontang on Medium)}

MySQL 9.7 is out and the community wins ^{(from AskDba)}

MySQL 9.7 Is Out and the Community Wins ^{(from The Oracle MySQL Blog)}

Announcing Azure Private Link Support for Hosted Dolt ^{(from DoltHub Blog)}

MySQL in N-Dimensions: High-Complexity Data with vsql-cube ^{(from VillageSQL)}

PSMDB Sandbox: A Browser-Based UI for Deploying MongoDB with Terraform and Ansible ^{(from Percona Database Blog)}

AI finds 20-year-old bugs in PostgreSQL and MariaDB ^{(from InfoWorld)}

Adding a New Data Type to MariaDB with Type_handler – Part 4 ^{(from MariaDB Foundation Blog)}

On benchmarking ^{(from PlanetScale Blog)}

Transparency in benchmarking ^{(from PlanetScale Blog)}

Why Your Application Should Not Use One MySQL User for Everything ^{(from The Oracle MySQL Blog)}

April Product Update ^{(from Readyset Blog)}

For a Database, survive used to mean “The server stays up”. With AI Agents, that’s not enough anymore ^{(from dbtrail Blog)}

An AI Agent is talking to your MySQL. And the database doesn’t know who is that! – Agent Era, Part 3 ^{(from dbtrail Blog)}

Long live to dbdeployer! ^{(from lefred's blog)}

Long live to dbdeployer! ^{(from MariaDB Foundation Blog)}

I Know Kung Fu ^{(from Percona Database Blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 3 ^{(from MariaDB Foundation Blog)}

Curious case of PXC node that refused to start due to SSL ^{(from Percona Database Blog)}

Building Query Analysis and Insights Dashboard in PMM ^{(from Percona Database Blog)}

Database Insurance ^{(from DoltHub Blog)}

Disaster Recovery Run Books for GCC-Owned Database Platforms ^{(from MinervaDB Blog)}

When Databases Start Eating Software — The Paradigm Shift in the AI Era ^{(from siddontang on Medium)}

SaaS is Dead — The Rise of Result as a Service ^{(from siddontang on Medium)}

Adding a New Data Type to MariaDB with Type_handler – Part 2 ^{(from MariaDB Foundation Blog)}

InnoDB Redo Log Sizing: Stop Guessing, Start Measuring ^{(from Percona Community Blog)}

Village News: MySQL/Database News (1 May 2026) ^{(from VillageSQL)}

How We Built mem9: Lessons From Shipping Persistent Memory for AI Agents ^{(from PingCAP Blog)}

Run an ALTER TABLE for a huge table in Aurora ^{(from Percona Database Blog)}

Managing Valkey Cluster in Kubernetes ^{(from Percona Database Blog)}

How Tungsten Cluster Achieves Data Integrity With Asynchronous Replication ^{(from Continuent Blog)}

MySQL Tuning on OCI HeatWave: What Still Matters, What OCI Manages, and What You Should Actually Tune ^{(from The Oracle MySQL Blog)}

When AI Agent Memory Outgrows SQLite: How to Tell, and What to Move to Next ^{(from PingCAP Blog)}

Three Promises in the Agent Era, Part 2: Agents on production MySQL are fine. Until they’re not. ^{(from dbtrail Blog)}

Continued Commitment to Percona XtraDB Cluster ^{(from Percona Database Blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 0 ^{(from lefred's blog)}

From Ecosystem to Architecture: Expanding How We Look at MariaDB ^{(from MariaDB Foundation Blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 1 ^{(from MariaDB Foundation Blog)}

No More Silent Foreign Key Cascades: MySQL 9.7 Lets Child Triggers Speak Up ^{(from The Oracle MySQL Blog)}

RLS sounds great until it isn't ^{(from PlanetScale Blog)}

Announcing Vitess 24 ^{(from Vitess)}

AI Is Raising the Bar for MySQL Database Security ^{(from The Oracle MySQL Blog)}

Amazon RDS for MySQL announces Innovation Release 9.6 in Amazon RDS Database Preview Environment ^{(from AWS What's New)}

XtraBackup incremental prepare phase is 2x-3x faster! ^{(from Percona Database Blog)}

TiDB Cloud Premium Public Preview: Predictable Performance, Elastic Scale, Enterprise Isolation ^{(from PingCAP Blog)}

Orchestrator’s Next Chapter: What It Means for Percona Customers ^{(from Percona Database Blog)}

Replication Internals: Decoding the MySQL Binary Log Part 9: XID_EVENT — Transaction Commit ^{(from Readyset Blog)}

Introducing the Change Stream Applier (CSA): A New MySQL Replication Applier in Labs ^{(from The Oracle MySQL Blog)}

Adding a New Data Type to MariaDB with Type_handler – Part 0 ^{(from MariaDB Foundation Blog)}

Running MySQL on Kubernetes in Regulated Environments: Security, Compliance, and Auditability ^{(from Continuent Blog)}

Announcing Functional Indexes in Dolt ^{(from DoltHub Blog)}

Part 2 - PgBouncer to ProxySQL: A Brief Feature Comparison ^{(from ProxySQL Blog)}

How Readyset Rewrites Your SQL: Inside the Query Transformation Pipeline ^{(from Readyset Blog)}

MySQL with AI Inside ^{(from VillageSQL)}

The hypergraph optimizer is now available in MySQL 9.7 Community Edition ^{(from Øystein on MySQL Optimizer)}

Introducing rdst: The Client-Side SQL Performance Toolkit ^{(from Readyset Blog)}

An update on GitHub availability ^{(from The GitHub Blog)}

Three Promises in the Agent Era, Part 1: The Frame, Reread ^{(from dbtrail Blog)}