Planet for the MySQL Community

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 • 13 hours 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 • 15 hours 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 • 16 hours 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 hours 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 • a day 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 • a day 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 • a day 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 • a day 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 • 2 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 • 2 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 • 2 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 • 3 days ago | Updated Wednesday, 15. April 2026 13:20 • 2 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 • 2 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 • 2 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 • 2 days ago | Updated Wednesday, 15. April 2026 12:16 • 2 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 • 3 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 • 3 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 • 3 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 • 3 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 • 3 days ago

Village News: MySQL/Database News (8 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 • 3 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 • 4 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 • 4 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 • 4 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 • 4 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 • 5 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 • 5 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 • 6 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 • 6 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 • 7 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 • 7 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 • 7 days ago | Updated Friday, 10. April 2026 18:00 • 7 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 • 8 days 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 • 8 days 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 • 8 days ago | Updated Thursday, 09. April 2026 19:32 • 8 days 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 • 8 days 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 • 8 days 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 • 8 days 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 • 8 days 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 • 9 days 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 • 9 days 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 • 9 days 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 • 9 days 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 • 9 days ago | Updated Wednesday, 08. April 2026 22:05 • 9 days 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 • 10 days ago | Updated Wednesday, 08. April 2026 21:28 • 9 days 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 • 9 days 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 • 9 days 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 • 9 days 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 • 9 days 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 • 9 days 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 • 9 days 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 • 10 days 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 • 10 days 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 • 10 days ago | Updated Tuesday, 07. April 2026 20:11 • 10 days 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 • 10 days 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 • 10 days 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 • 10 days 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 • 10 days 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 • 11 days 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 • 11 days 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 • 11 days 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 • 11 days 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 • 11 days 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 • 11 days 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 • 11 days 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 • 11 days 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 • 11 days 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 • 11 days 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 • 12 days 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 • 12 days 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 • 12 days ago | Updated Monday, 06. April 2026 03:38 • 12 days ago

Sysbench vs MySQL on a small server: no new regressions, many old ones ^{(from Small Datum)}

pThis has performance results for InnoDB from MySQL 5.6.51, 5.7.44, 8.0.X, 8.4.8 and 9.7.0 on a small server with sysbench microbenchmarks. The workload here is cached by InnoDB and my focus is on regressions from new CPU overheads. /ppIn many cases, MySQL 5.6.51 gets about 1.5X more QPS than modern MySQL (8.0.x thru 9.7). The root cause is new CPU overhead, possibly from code bloat./pptl;dr/p [...]

Published Tuesday, 24. March 2026 21:31 • 24 days ago | Updated Monday, 06. April 2026 02:43 • 12 days ago

从 PostgreSQL fsync EIO 失败处理说起 ^{(from Chen Zongzhi's GitHub blog)}

2018 年, PostgreSQL 社区发现了一个存在了 20 年的严重问题: 当 fsync() 失败时, PostgreSQL 的处理方式可能导致静默数据丢失. 这个被称为 “fsyncgate” 的事件, 不仅揭示了 PostgreSQL 自身的架构缺陷, 更暴露了 Linux 内核, 文件系统与数据库之间在 I/O 错误处理上的深层矛盾. [...]

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

A response to Percona’s 2026 MySQL ecosystem benchmark: useful data, but not a realistic MariaDB comparison ^{(from lefred's blog)}

Percona’s new 2026 benchmark report is interesting because it puts several MySQL-family releases on the same graphs and shares a public repository for the test harness. That openness is welcome. But after reading both the article and the published scripts, I do not think the post supports broad conclusions about “ecosystem performance,” and I especially […] [...]

Published Sunday, 05. April 2026 08:42 • 13 days ago

What's Coming to dbdeployer ^{(from ProxySQL Blog)}

A preview of the features we're shipping — from InnoDB Cluster to PostgreSQL support. This is just the beginning. [...]

Published Sunday, 05. April 2026 00:00 • 13 days ago

How to fix write latency in MySQL 8.4 Upgrade ^{(from Kedar MySQL Blog)}

pDuring any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if…/p The post How to fix write latency in MySQL 8.4 Upgrade first appeared on Change Is Inevitable. [...]

Published Saturday, 04. April 2026 17:01 • 13 days ago

CPU-bound sysbench on a large server: Postgres, MySQL and MariaDB ^{(from Small Datum)}

pThis post has results for CPU-bound sysbench vs Postgres, MySQL and MariaDB on a large server using older and newer releases. /ppThe goal is to measure:br/pullihow performance changes over time from old versions to new versions/liliperformance between modern MySQL, MariaDB and Postgres/li/ulp/ppThe context here is a collection of microbenchmarks using a large server with high concurrency. Res [...]

Published Saturday, 04. April 2026 02:30 • 14 days ago | Updated Saturday, 04. April 2026 02:36 • 14 days ago

Why dbdeployer Matters to Me — and Why ProxySQL Took Over Its Maintenance ^{(from ProxySQL Blog)}

A first look at why this project matters, why we decided to maintain it, and why supporting tools for both MySQL and PostgreSQL is part of our broader open source commitment [...]

Published Saturday, 04. April 2026 00:00 • 14 days ago

How to Enable MySQL HeatWave Telemetry and Analyze Logs with OCI Log Analytics ^{(from The Oracle MySQL Blog)}

MySQL HeatWave Service on Oracle Cloud Infrastructure (OCI) provides built-in telemetry and logging capabilities that help organizations monitor database activity, troubleshoot issues, and maintain operational health. These logs are valuable not only for operations and performance tuning, but also for governance and regulatory compliance, where audit logging can be essential for tracking database a [...]

Published Friday, 03. April 2026 18:06 • 14 days ago

Monthly Product Pulse: April 2026—Oracle Technical Resources ^{(from Oracle ACE Program)}

Momentum builds when useful resources meet real-world use cases. In this April edition of Monthly Product Pulse, we’re bringing together practical developer-focused updates across Oracle AI Database and Autonomous AI Database, SQL and Ask TOM learning resources, Select AI and in-database machine learning innovations, along with MySQL community news and upcoming events. Oracle AI Database: […] [...]

Published Friday, 03. April 2026 12:48 • 14 days ago

A response to Percona’s 2026 MySQL ecosystem benchmark: useful data, but not a realistic MariaDB comparison ^{(from MariaDB Foundation Blog)}

pPercona’s new 2026 benchmark report is interesting because it puts several MySQL-family releases on the same graphs and shares a public repository for the test harness. … /p pContinue reading \"A response to Percona’s 2026 MySQL ecosystem benchmark: useful data, but not a realistic MariaDB comparison\"/p pThe post A response to Percona’s 2026 MySQL ecosystem benchmark: useful data, but [...]

Published Friday, 03. April 2026 07:35 • 15 days ago

Percona Bug Report: March 2026 ^{(from Percona Community Blog)}

At Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter along the way. [...]

Published Friday, 03. April 2026 00:00 • 15 days ago

Vibe-Coded Agents for Vibe-Coded Issues ^{(from DoltHub Blog)}

Gas Town's vibe-coded agents introduced a plethora of new issues to Dolt. I vibe-coded a Go CLI to fight back: parallel agents to reproduce the issues agents caused. [...]

Published Friday, 03. April 2026 00:00 • 15 days ago

ProxySQL 3.1.6: Embedded TSDB for Built-in Time-Series Metrics ^{(from ProxySQL Blog)}

Built-in Time-Series Metrics, No Prometheus Required. Query Your Metrics History Directly from ProxySQL [...]

Published Friday, 03. April 2026 00:00 • 15 days ago

We ran an internal AI demo competition: Here are the winners! ^{(from MariaDB Corporation Blog)}

As developers, we are skeptical of “AI marketing”. We want to see it run. We want to see the actual […] [...]

Published Thursday, 02. April 2026 15:53 • 15 days ago

Query Hints: Let Your Application Decide What Gets Cached ^{(from Readyset Blog)}

Readyset Query Hints let developers embed caching directives directly in their MySQL SQL queries, no admin connection, no separate deployment, no waiting on a change request. GA now for MySQL, coming soon for PostgreSQL. [...]

Published Thursday, 02. April 2026 15:29 • 15 days ago

Oracle Ignites AI Innovation at TEDAI San Francisco ^{(from The Oracle MySQL Blog)}

Oracle was proud to sponsor and participate in TEDAI San Francisco, a sold-out event that brought together over 1,200 attendees from across industries to explore, debate, and celebrate the transformative potential of artificial intelligence. Through a mix of key panels, a 48-hour hackathon, and thought leadership engagement, Oracle showcased its commitment to responsible AI innovation […] [...]

Published Thursday, 02. April 2026 14:45 • 15 days ago

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

pIn the previous parts of this series we’ve seen how MariaDB stores vector indexes in a table and how to implement HNSW for a good performance. … /p pContinue reading \"MariaDB Vector: How it works. Part III\"/p pThe post MariaDB Vector: How it works. Part III appeared first on MariaDB.org./p [...]

Published Thursday, 02. April 2026 06:46 • 16 days ago

Announcing Fabric Mirroring integration for Azure Database for MySQL - Public Preview at FabCon 2026 ^{(from Azure for MySQL Blog)}

pAt FabCon 2026, we’re excited to announce the Public Preview of Microsoft Fabric Mirroring integration for Azure Database for MySQL. This integration makes it easier than ever to analyze MySQL operational data using Fabric’s unified analytics platform, without building or maintaining ETL pipelines./p pThis milestone brings near real-time data replication from Azure Database for MySQL into Microsof [...]

Published Thursday, 02. April 2026 04:43 • 16 days ago

InnoDB Buffer Pool Tuning: From Rule-of-Thumb to Real Signals ^{(from Percona Community Blog)}

Introduction Many MySQL setups begin life with a familiar incantation: [...]

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

Patterns for Postgres Traffic Control ^{(from PlanetScale Blog)}

Practical patterns for leveraging Database traffic Control [...]

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

MariaDB Java Connector 3.5.8 now available ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/J 3.5.8 release. Release Notes and Changelogs MariaDB Connector/J […] [...]

Published Wednesday, 01. April 2026 22:35 • 16 days ago

Percona Operator for PostgreSQL 2.9.0: PostgreSQL 18 Default, PVC Snapshot Backups, LDAP Support, and More! ^{(from Percona Database Blog)}

pWe are excited to announce Percona Operator for PostgreSQL 2.9.0! In this release, we bring significant improvements across database lifecycle management, security, backup/restore, and operational observability, making it easier than ever to run production PostgreSQL on Kubernetes. Here’s a deep dive into what’s new. Percona Operator for PostgreSQL 2.9.0 PostgreSQL 18 Is Now the [...]

Published Wednesday, 01. April 2026 21:50 • 16 days ago

Benchmarking MyRocks vs. InnoDB in Memory-Constrained Environments ^{(from Percona Database Blog)}

pBenchmarking MyRocks vs. InnoDB in Memory-Constrained Environments It is a well-known fact in the database world that InnoDB is incredibly fast when the entire database fits into memory. But what happens when your data grows beyond your available RAM? MyRocks, built on RocksDB, is frequently recommended as a superior choice for environments constrained by memory, … Continued/p pThe post Benc [...]

Published Wednesday, 01. April 2026 21:42 • 16 days ago

March Product Update ^{(from Readyset Blog)}

See what's new at Readyset in March 2026, including Shallow Caching now on by default, the Skip Cache hint, smarter query visibility, and how Hussle Technology eliminated peak-season database load with QueryPilot. [...]

Published Wednesday, 01. April 2026 17:30 • 16 days ago

Replication Internals: Decoding the MySQL Binary Log - Part 6: QUERY_EVENT — DDL Statements and Transaction Boundaries ^{(from Readyset Blog)}

Understand how MySQL's binary log captures DDL statements and transaction boundaries using QUERY_EVENT. Includes field-by-field decoding of headers, status variables, and SQL mode flags. [...]

Published Wednesday, 01. April 2026 14:00 • 16 days ago

MySQL 8.0 Is Reaching End of Life. Here Are Your Options. ^{(from VillageSQL)}

MySQL 8.0 reaches EOL in April 2026. Your options: cloud-extended support, Percona contracts, or upgrading to MySQL 8.4 LTS. Here's what to know. [...]

Published Wednesday, 01. April 2026 13:00 • 16 days ago

Know a MariaDB champion? Submit a nomination ^{(from lefred's blog)}

One of the things I really like about open source is that a project is never only about the software. Yes, code is important. Very important. But a project like MariaDB exists and grows because of people. People who contribute code, of course, but also people who help users, review bugs, write blog posts, speak […] [...]

Published Wednesday, 01. April 2026 11:27 • 16 days ago

Using PHP and Readyset for the First Time with MySQL ^{(from Another Boring Tech Blog)}

pSpeed up your PHP application without changing a single query. A few days ago I set out to answer a simple question: how much faster can a PHP app go if you drop a SQL cache in front of MySQL — without touching application code? The answer is below. On a four-table join aggregating revenue.../p pO post Using PHP and Readyset for the First Time with MySQL apareceu primeiro em Another Boring Tech Bl [...]

Published Tuesday, 31. March 2026 21:18 • 17 days ago

CPU efficiency for MariaDB, MySQL and Postgres on TPROC-C with a small server ^{(from Small Datum)}

pI started to use TPROC-C from HammerDB to test MariaDB, MySQL and Postgres and published results for MySQL and Postgres on small and large servers. This post provides more detail on CPU overheads for MariaDB, MySQL and Postgres on a small server./pptl;dr/pp/pulliPostgres get the most throughput and the difference is large./liliMariaDB gets more throughput than MySQL/liliThroughput improves for Mar [...]

Published Monday, 16. March 2026 19:35 • 1 months ago | Updated Tuesday, 31. March 2026 20:57 • 17 days ago

MySQL Metadata Store service not able to start on an ODA ^{(from dbi Blog)}

pI was recently doing some consulting on some ODA at one of our customers, and I faced an issue with the DCS Agent and the MySQL Metadata Store. In this blog, I will show you the problem and how I could resolved it. Problem description On an Oracle Database Appliance, the DCS agent is the […]/p pL’article MySQL Metadata Store service not able to start on an ODA est apparu en premier sur dbi B [...]

Published Tuesday, 31. March 2026 20:32 • 17 days ago

gcc vs clang for sysbench on a small server with Postgres, MySQL and MariaDB ^{(from Small Datum)}

pThis has results for sysbench on a small server and compares performanc for Postgres, MySQL and MariaDB compiled using clang vs using gcc./pptl;dr/pp/pulliThroughput with clang and gcc is similar/li/ulp/pBuilds, configuration and hardwarep/pp/pp/pI compiled Postgres 18.3, MySQL 8.4.8 and MariaDB 11.8.6 from source. The server has 8 AMD cores with SMT disabled and 32G of RAM. The OS is Ubuntu 24.04 [...]

Published Tuesday, 31. March 2026 20:28 • 17 days ago | Updated Tuesday, 31. March 2026 20:28 • 17 days ago

MySQL Automatic Failover: When to Automate vs. Manual Intervention ^{(from Continuent Blog)}

A practical guide to MySQL failover strategies, comparing automated and manual approaches, and examining risks such as replication lag, split-brain, and incorrect promotion in high availability environments.Tags: failoverautomation [...]

Published Tuesday, 31. March 2026 17:51 • 17 days ago

What’s New in MariaDB AI RAG 1.1: Ingestion, Reranking, and Docker Deployment ^{(from MariaDB Corporation Blog)}

Moving a RAG (Retrieval-Augmented Generation) application from a local prototype to a production-grade system requires solving for data messy ingestion, […] [...]

Published Tuesday, 31. March 2026 17:38 • 17 days ago

Introducing MySQL HeatWave Telemetry data with OCI Log Analytics ^{(from The Oracle MySQL Blog)}

Announcing MySQL HeatWave Telemetry data publishing into OCI Log Analytics — the easiest way to view , analyze the MYSQL Heatwave Logs New build-in feature to publish the MySQL Logs to OCI Log Analytics Telemetry Data: The Following data will be published based on the user selection1. Error log: Contains a record of mysqld startup and shutdown […] [...]

Published Tuesday, 31. March 2026 16:00 • 17 days ago

Village News: MySQL/Database News (31 March 2026) ^{(from VillageSQL)}

MySQL and database news for March 31, 2026: Oracle community updates, Percona Live details, vector database progress, and upcoming conferences. [...]

Published Tuesday, 31. March 2026 13:56 • 17 days ago

PostgreSQL Internals for the MySQL DBA ^{(from Rendiment)}

PostgreSQL internals explained for MySQL DBAs. MVCC, heap vs clustered index, VACUUM, WAL, and replication, all mapped to their InnoDB equivalents. [...]

Published Tuesday, 31. March 2026 04:00 • 18 days ago

MySQL at a Crossroads: Oracle Control, Community Frustration, and MariaDB’s Rise ^{(from One-Time MySQL Community/Ecosystem Posts)}

For more than two decades, MySQL has been one of the pillars of modern web infrastructure. According to the Stack Overflow Developer Survey, it continues to rank among the most widely used databases worldwide. It powered early startups, supported the rise of PHP applications, and became a default choice for teams that needed a reliable relational database without enterprise complexity. Today, that [...]

Published Tuesday, 31. March 2026 00:00 • 18 days ago

Graceful degradation in Postgres ^{(from PlanetScale Blog)}

Not all traffic is created equal.When a database is overwhelmed, you want the important queries to keep executing, even if that means shedding lower-priority work.This is a much better outcome than the alternative: a total database outage. [...]

Published Tuesday, 31. March 2026 00:00 • 18 days ago

Know a MariaDB champion? Submit a nomination ^{(from MariaDB Foundation Blog)}

pOne of the things I really like about open source is that a project is never only about the software.br Yes, code is important. Very important. … /p pContinue reading \"Know a MariaDB champion? Submit a nomination\"/p pThe post Know a MariaDB champion? Submit a nomination appeared first on MariaDB.org./p [...]

Published Monday, 30. March 2026 14:01 • 18 days ago

Contributions As a Cost-saver ^{(from MariaDB Foundation Blog)}

pThe economics of open source contribution development. And some questions./p pThe post Contributions As a Cost-saver appeared first on MariaDB.org./p [...]

Published Monday, 30. March 2026 12:18 • 18 days ago

Hussle Technology Trusts Readyset QueryPilot to Handle Peak-Season MySQL Load ^{(from Readyset Blog)}

See how Hussle Technology eliminated peak-season database pressure across 1,700 queries and 11 databases, with zero application changes and no additional read replicas, using ReadySet QueryPilot. [...]

Published Monday, 30. March 2026 11:00 • 19 days ago

High memory usage in Postgres is good, actually ^{(from PlanetScale Blog)}

A high memory percentage in PlanetScale Postgres is not necessarily a problem. Let's compare how memory and CPU usage are different, how not all memory usage is created equal, and which signals actually require attention. [...]

Published Monday, 30. March 2026 00:00 • 19 days ago

Talking PostgreSQL with ProxySQL at Percona Live SF 2026 ^{(from ProxySQL Blog)}

ProxySQL Is Coming to Percona Live 2026 – And It's Not Just for MySQL Anymore [...]

Published Monday, 30. March 2026 00:00 • 19 days ago

Technical Analysis: Why 0.2ms Queries Can Still Result in Low QPS ^{(from Another Boring Tech Blog)}

pIt is a classic trap: you spend a week fine-tuning your cache and your database hits only to realize your application is essentially running with the handbrake on. I saw this with my tests: MySQL and Readyset were returning rows in 0.2 ms, but the application throughput remained capped at 40 queries per second (QPS). The database isn’t.../p pO post Technical Analysis: Why 0.2ms Queries Can S [...]

Published Sunday, 29. March 2026 20:29 • 19 days ago

MyVector v1.26.3: Maintenance, CI, and Readiness for MySQL 9.7 ^{(from AskDba)}

In my recent series on Scoped Vector Search, we looked at the query patterns that make vector search a first-class citizen in MySQL. While the logic for those searches is now established, the infrastructure supporting them requires constant attention as the MySQL ecosystem moves toward its new release model. Today, I’m announcing MyVector v1.26.3. This is a foundational release […] [...]

Published Sunday, 29. March 2026 18:38 • 19 days ago

Selecting a character set for MySQL and MariaDB clients ^{(from Small Datum)}

p MySQL and MariaDB have many character-set related options, perhaps too many:/pp/pollicharacter_set_client/lilicharacter_set_connection/lilicharacter_set_database/lilicharacter_set_filesystem/lilicharacter_set_results/lilicharacter_set_server/lilicharacter_set_system/li/olThis is a topic that I don't know much about and I am still far from an expert. My focus has been other DBMS topics. But I [...]

Published Sunday, 29. March 2026 00:26 • 20 days ago | Updated Sunday, 29. March 2026 00:26 • 20 days ago

If you're running MySQL on a symlink... ^{(from One-Time MySQL Community/Ecosystem Posts)}

If you're running MySQL on a symlink and using versions 8.0.34 through 9.6.0, it's important to be aware of a critical bug that can cause MySQL to crash after executing a TRUNCATE command. [...]

Published Sunday, 29. March 2026 00:00 • 20 days ago

MySQL Performance Tuning for High-Traffic Applications ^{(from MinervaDB Blog)}

MySQL Performance Tuning & Scalability Services for High-Traffic Applications In today’s digital landscape, high-traffic applications and growth-stage SaaS platforms demand robust, responsive, and scalable database solutions. MySQL, as one of the most popular open-source relational [...] [...]

Published Saturday, 28. March 2026 19:23 • 20 days ago

MySQL HeatWave observability updates in OCI ^{(from The Oracle MySQL Blog)}

Moving from Ops Insights/Database Management to OCI Monitoring and Unified Log Analytics OCI is updating the recommended approach for observing MySQL HeatWave. This includes changes to existing integrations, along with a path forward that provides stronger log analytics and AI-assisted analysis—while continuing to use OCI Monitoring as the foundational layer for metrics and alarms. What’s […] [...]

Published Friday, 27. March 2026 20:36 • 21 days ago

MariaDB observability – results from the poll: the community has clearly chosen its default stack ^{(from lefred's blog)}

Before I share my takeaway from this MariaDB observability poll, I would like to thank all participants and highlight that these recent polls are very popular, and your participation makes us happy. That said, we recently asked the MariaDB community the following question: Which observability tools do you use for MariaDB? I like polls like […] [...]

Published Friday, 27. March 2026 16:49 • 21 days ago

Tournament of Databases: Round 2 ^{(from VillageSQL)}

Round 2 is set: Oracle vs. MongoDB, MySQL vs. DuckDB, PostgreSQL vs. Snowflake, SQL Server vs. Databricks. DuckDB's run continues. Who makes the Final Four? [...]

Published Friday, 27. March 2026 14:00 • 21 days ago

2026 – MySQL Ecosystem Performance Benchmark Report ^{(from Percona Database Blog)}

pBy Percona Lab Results · 2026 · MySQL MariaDB Percona Benchmark Database MySQL Ecosystem Performance Benchmark Report 2026 Comparative Analysis of InnoDB-Compatible Engines — Percona Lab Results Repository: github.com/Percona-Lab-results/2026-interactive-metrics Interactive graphs available: Explore the full dataset dynamically — click any graph below to open the interactive version. OLTP Read [...]

Published Thursday, 26. March 2026 21:28 • 22 days ago

Skeema v2 updates and timeline ^{(from Skeema Blog)}

pAs the community looks ahead to new LTS releases of both MySQL and MariaDB over the next couple months, the timeline for Skeema v2 has finally taken shape. In this post, we’ll reveal the preliminary schedule, and also cover some important changes to EOL database support, download URLs, and more./p [...]

Published Thursday, 26. March 2026 21:26 • 22 days ago

Four Data Architecture Decisions That Make or Break Agentic Systems ^{(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. Data teams that thrived in the last wave of Software as a Service (SaaS) platform scale weren’t the ones that chased hype. They were the ones that made a few smart decisions: They adopted cloud-first […]/p pThe post Four Data Architecture Decisions That Ma [...]

Published Thursday, 26. March 2026 20:48 • 22 days ago

Binary Log Compression is Safe since MySQL 8.0.34 ^{(from J-F Gagné's MySQL Blog)}

This is a quick one. My attention was recently brought (thanks Simon) on a relatively recent comment (25 Nov 2025) in Bug #103672 - Binlog compression transaction payload event exceeds max allowed packet : The underlying server bug was fixed in 8.0.34 in BUG#33588473. The server now falls back to writing the transaction without compression, if the compressed size would [...]

Published Thursday, 26. March 2026 20:41 • 22 days ago | Updated Thursday, 26. March 2026 20:41 • 22 days ago

Understanding MySQL Views & HeatWave In-Memory Execution ^{(from The Oracle MySQL Blog)}

In the world of database management, MySQL HeatWave offers powerful in-memory analytics capabilities that can supercharge your OLTP queries. But what happens when you introduce views into the mix? A common question I get is: “If I create a view in MySQL, does this view run against the data stored in the tables in HeatWave […] [...]

Published Thursday, 26. March 2026 17:56 • 22 days ago

Unified MySQL Monitoring Across HeatWave and On-Prem with Grafana Dashboard ^{(from The Oracle MySQL Blog)}

MySQL observability is essential in modern enterprises, whether you run a few critical databases or operate at massive scale. With the right real‑time monitoring, teams reduce MTTD/MTTR, avoid cascading failures, and continuously track workload health—CPU, memory, I/O, buffer pool efficiency, session contention, transaction/replication lag, error rates, and query latency. This Grafana monitoring te [...]

Published Thursday, 26. March 2026 15:32 • 22 days ago

MariaDB Keeps Climbing: Community, Adoption, and Momentum ^{(from lefred's blog)}

If you’ve been around the MariaDB community for a while, you can probably feel it already: things are moving in the right direction. And no, I’m not talking about one vanity metric, one lucky spike, or one noisy social post. I’m talking about a broader trend. The latest Adoption Index data shows something I really […] [...]

Published Thursday, 26. March 2026 12:28 • 22 days ago

2026 – MySQL Ecosystem Performance Benchmark Report ^{(from Percona Database Blog)}

By Percona Lab Results · 2026 · MySQL MariaDB Percona Benchmark Database MySQL Ecosystem Performance Benchmark Report 2026 Comparative Analysis of InnoDB-Compatible Engines — Percona Lab Results Repository: github.com/Percona-Lab-results/2026-interactive-metrics Interactive graphs available: Explore the full dataset dynamically — click any graph below to open the interactive version. OLTP Read- [...]

Published Thursday, 26. March 2026 10:04 • 23 days ago

MariaDB observability – results from the poll: the community has clearly chosen its default stack ^{(from MariaDB Foundation Blog)}

pBefore I share my takeaway from this MariaDB observability poll, I would like to thank all participants and highlight that these recent polls are very popular, and your participation makes us happy. … /p pContinue reading \"MariaDB observability – results from the poll: the community has clearly chosen its default stack\"/p pThe post MariaDB observability – results from the poll: the communi [...]

Published Thursday, 26. March 2026 08:35 • 23 days ago

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

pIn the first post of this series, I’ve described how the vector index is stored in a table and how it achieves full transactional behavior and ACID properties compatible with the storage engine of the table the user created. … /p pContinue reading \"MariaDB Vector: How it works. Part II\"/p pThe post MariaDB Vector: How it works. Part II appeared first on MariaDB.org./p [...]

Published Thursday, 26. March 2026 07:34 • 23 days ago

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

On March 23, 2026, the MySQL Community Team hosted our second public discussion focused on shaping a new era of MySQL community engagement. With over 50 attendees participating, the session brought together members of the MySQL ecosystem to share feedback, discuss priorities, and help guide future efforts. Building on our earlier session, this webinar continued […] [...]

Published Thursday, 26. March 2026 06:00 • 23 days ago

Stripe Projects partnership: Provision PlanetScale Postgres and MySQL databases from the Stripe CLI ^{(from PlanetScale Blog)}

PlanetScale is a co-design and launch partner for the Stripe Projects developer preview, allowing you or your coding agents to provision and manage databases and other dev tools directly from the Stripe CLI. [...]

Published Thursday, 26. March 2026 00:00 • 23 days ago

[In preview] Public Preview: Fabric Mirroring integration for Azure Database for MySQL ^{(from Azure Updates)}

We are excited to announce the public preview of Fabric Mirroring integration for Azure Database for MySQL – Flexible Server. You can now replicate MySQL operational data into Microsoft Fabric in near real time, without building or maintaining ETL pipelin [...]

Published Wednesday, 25. March 2026 17:45 • 23 days ago

Announcing VillageSQL Server 0.0.3 ^{(from VillageSQL)}

VillageSQL 0.0.3 adds parametrized types, MySQL 8.4.8 LTS support, expanded SQL compatibility, and ChatGPT and Ollama inference via the vsql-ai extension. [...]

Published Wednesday, 25. March 2026 16:27 • 23 days ago

Datography Joins MariaDB Foundation as Silver Sponsor ^{(from MariaDB Foundation Blog)}

pWe are pleased to welcome Datography as a Silver Sponsor of the MariaDB Foundation.br Datography focuses on helping organizations understand, map, and manage complex data environments. … /p pContinue reading \"Datography Joins MariaDB Foundation as Silver Sponsor\"/p pThe post Datography Joins MariaDB Foundation as Silver Sponsor appeared first on MariaDB.org./p [...]

Published Wednesday, 25. March 2026 14:42 • 23 days ago

Replication Internals: Decoding the MySQL Binary Log Part 5: GTID_LOG_EVENT — The Global Transaction Identifier ^{(from Readyset Blog)}

Decode the GTID_LOG_EVENT byte by byte: how MySQL assigns unique transaction IDs, drives parallel replication, and keeps replicas in sync. [...]

Published Wednesday, 25. March 2026 14:00 • 23 days ago

MySQL Archiving: 3 Ways to Clear the Bloat ^{(from Continuent Blog)}

Practical guide to reducing MySQL data bloat through three archiving approaches: controlled deletes, partitioning, and replication-based offloading, with trade-offs and operational considerations.Tags: archivingpartitioningperformance [...]

Published Wednesday, 25. March 2026 12:56 • 23 days ago

MariaDB Keeps Climbing: Community, Adoption, and Momentum ^{(from MariaDB Foundation Blog)}

pIf you’ve been around the MariaDB community for a while, you can probably feel it already: things are moving in the right direction.br And no, I’m not talking about one vanity metric, one lucky spike, or one noisy social post. … /p pContinue reading \"MariaDB Keeps Climbing: Community, Adoption, and Momentum\"/p pThe post MariaDB Keeps Climbing: Community, Adoption, and Momentum [...]

Published Wednesday, 25. March 2026 09:59 • 24 days ago

MariaDB Curiosity: Since When in MariaDB do we use REPLICA? ^{(from lefred's blog)}

As a former MySQL DBA, I am less familiar with some MariaDB details. Also, the evolution of MariaDB Server is ongoing, with many new features, data types, and syntax, and more… I decided then to create a new blog series for those like me who need to reinforce their MariaDB knowledge and be unbeatable during […] [...]

Published Wednesday, 25. March 2026 09:28 • 24 days ago

MySQL at 30 – does it still have a future? QnA ^{(from One-Time MySQL Community/Ecosystem Posts)}

Last year MySQL marked its 30th birthday, but with end of life for the current version (8.0) coming up next month and moves towards a community edition what does the future hold for the platform? We spoke to Peter Zaitsev, founder of database support specialist Percona, to discuss what MySQL users should be doing now and whether there’s still life in the old database yet. [...]

Published Wednesday, 25. March 2026 00:00 • 24 days ago

Lessons from Using Claude Code to Implement Double Write Buffer in PostgreSQL ^{(from Chen Zongzhi's Medium blog)}

pI’ve been exploring how to use Claude Code to help write database kernel code. The specific task was implementing a Double Write Buffer in PostgreSQL, modeled after InnoDB’s implementation. Claude was fast at writing the code, but I ran into a problem along the way: it can’t do design./ppThe Buffer I/O vs Direct I/O Gap/ppI asked Claude to implement a DWB in PostgreSQL following InnoDB’s approach. [...]

Published Tuesday, 24. March 2026 22:30 • 24 days ago

Automatically scale storage for Amazon RDS Multi-AZ DB clusters using AWS Lambda ^{(from AWS Database Blog)}

In this post, we walk you through building an automated storage scaling solution for Amazon RDS Multi-AZ clusters with two readable standbys. We use AWS Lambda to execute scaling logic, Amazon CloudWatch to detect and alarm on storage thresholds, and Amazon SNS to deliver timely notifications. This combination provides event-driven automation, native AWS integration, and operational visibility with [...]

Published Tuesday, 24. March 2026 21:46 • 24 days ago

Your monitoring knows how your database is doing. It has no idea what happened to your data. ^{(from dbtrail Blog)}

pYou’ve got Grafana dashboards. PMM is collecting metrics. Datadog has agents on every host. CloudWatch alarms are set up. You know your CPU is at 34%, your queries…/p pThe post Your monitoring knows how your database is doing. It has no idea what happened to your data. appeared first on dbtrail Blog./p [...]

Published Tuesday, 24. March 2026 18:52 • 24 days ago

MySQL Early Access Release Builds Available: What to Test and How to Share Feedback ^{(from The Oracle MySQL Blog)}

Last week, we published MySQL Early Access Release builds available for community testing and feedback ahead of the upcoming stable releases. Early Access builds are ideal for developers and DBAs who want to validate compatibility, behavior, and performance in non-production environments—and help us catch regressions early or identify areas where the documentation could be clearer. We […] [...]

Published Tuesday, 24. March 2026 18:06 • 24 days ago

MariaDB Doesn't Depend on MySQL ^{(from DZone)}

pWhen MariaDB was first announced in 2009 by Michael “Monty” Widenius, it was positioned as a “fork of MySQL”. I think that was a Bad Idea™. Okay, maybe it wasn’t a bad idea as such. After all, MariaDB indeed is a fork of MySQL. But what is a fork in the software sense, and how is this reflected in MariaDB? /p pA fork is a software project that takes the source code of another project and cont [...]

Published Tuesday, 24. March 2026 16:00 • 24 days ago

Building and testing MySQL 9.7.0 early access build on macOS ^{(from Laurynas Biveinis' blog)}

p Oracle released 9.7.0 community early access build, which is a part of their work towards fulfilling their new promises to the community. This is great news for community testing and I did my part in my usual way (previously: 8.0.45 / 8.4.8 / 9.6.0). /p Build p No changes from 9.6.0: the current Xcode (26.3) builds the 9.7.0 early access build fine, LLVM 21 still fails (bug #119246). /p Test [...]

Published Tuesday, 24. March 2026 14:25 • 24 days ago | Updated Tuesday, 24. March 2026 14:25 • 24 days ago

MariaDB 13.0 Preview Now Available ^{(from lefred's blog)}

We are pleased to announce the availability of a preview of the MariaDB 13.0 series. MariaDB 13.0 is a preview rolling release, published on 23 March 2026, and it continues the work started in 12.3 while adding a solid set of entirely new features. And this one is interesting. This preview release brings a nice […] [...]

Published Tuesday, 24. March 2026 13:02 • 24 days ago

The Agentic Era: Why Infrastructure is the New Innovation Frontier ^{(from MariaDB Corporation Blog)}

Eighteen months ago, when I joined MariaDB, the industry was already feeling the first tremors of the AI boom. While […] [...]

Published Tuesday, 24. March 2026 13:02 • 24 days ago

MariaDB 13.0 Preview Now Available ^{(from MariaDB Foundation Blog)}

pWe are pleased to announce the availability of a preview of the MariaDB 13.0 series. MariaDB 13.0 is a preview rolling release, published on 23 March 2026, and it continues the work started in 12.3 while adding a solid set of entirely new features. … /p pContinue reading \"MariaDB 13.0 Preview Now Available\"/p pThe post MariaDB 13.0 Preview Now Available appeared first on MariaDB.org./p [...]

Published Tuesday, 24. March 2026 12:49 • 24 days ago

DBaasNow Joins MariaDB Foundation as Silver Sponsor ^{(from MariaDB Foundation Blog)}

pWe are pleased to welcome DBaasNow as a Silver Sponsor of the MariaDB Foundation.br As the MariaDB ecosystem continues to expand across cloud, hybrid, and on-premise environments, the need for consistent, reliable, and scalable database operations has never been more important. … /p pContinue reading \"DBaasNow Joins MariaDB Foundation as Silver Sponsor\"/p pThe post DBaasNow Joins MariaDB F [...]

Published Tuesday, 24. March 2026 07:05 • 25 days ago

TiDB Cloud Zero Public Preview: Get a Database in 1 Second, Claim It in 3 Clicks ^{(from PingCAP Blog)}

pWe’re excited to announce that TiDB Cloud Zero is now available in Public Preview. TiDB Cloud Zero is designed for a new generation of AI agents and developers who want instant access to a real production-grade database without the traditional onboarding friction. With TiDB Cloud Zero, you can: This blog walks through the entire flow from zero to a claimed […]/p pThe [...]

Published Tuesday, 24. March 2026 05:32 • 25 days ago

Enhanced tagging in Postgres Query Insights ^{(from PlanetScale Blog)}

Introducing query tagging improvements in Postgres Query Insights [...]

Published Tuesday, 24. March 2026 00:00 • 25 days ago

A Guide to Multi-Region Disaster Recovery with MariaDB Cloud ^{(from MariaDB Corporation Blog)}

Recent global events remind us of a difficult truth: infrastructure failures rarely happen at convenient times. From geopolitical conflicts and […] [...]

Published Monday, 23. March 2026 21:54 • 25 days ago

MariaDB Python Connector 2.0.0rc2 ^{(from MariaDB Corporation Blog)}

Today’s release candidate for MariaDB Connector/Python 2.0 marks a transition from the architecture used in version 1.1. Although the previous […] [...]

Published Monday, 23. March 2026 18:31 • 25 days ago

MariaDB/MySQL Environment MyEnv 3.0.0 has been released ^{(from Shinguz's Blog)}

pFromDual has the pleasure to announce the release of the new version 3.0.0 of its popular MariaDB, MySQL and PostgreSQL multi-instance environment MyEnv./p pThe new MyEnv can be downloaded here. How to install MyEnv is described in the MyEnv Installation Guide./p pIn the inconceivable case that you find a bug in the MyEnv please report it to us by sending an email./p pAny feedback, statements and [...]

Published Monday, 23. March 2026 16:42 • 25 days ago

Queen Shrugged ^{(from MariaDB Foundation Blog)}

pIt’s easy to be a queen. Why? Because you can always count on your true selfless friends. I learned this already as a young princess. Nothing brightens a ball quite like a comment from one of your most trusted girlfriends:br It’s beautiful. … /p pContinue reading \"Queen Shrugged\"/p pThe post Queen Shrugged appeared first on MariaDB.org./p [...]

Published Monday, 23. March 2026 16:33 • 25 days ago

Behind the scenes: How Database Traffic Control works ^{(from PlanetScale Blog)}

Learn how Traffic Control enforces real-time limits on Postgres queries. [...]

Published Monday, 23. March 2026 16:00 • 25 days ago

MariaDB Innovation: InnoDB-Based Binary Log ^{(from lefred's blog)}

I am starting a new series on what makes MariaDB Server distinct from MySQL, highlighting innovations that make the difference. MariaDB 12.3 introduces a new binary log implementation that stores binlog events directly in InnoDB-managed tablespaces rather than in separate flat files on disk. This is an incredible innovation; for a long time, binary logs […] [...]

Published Monday, 23. March 2026 08:03 • 26 days ago

Introducing Database Traffic Control ^{(from PlanetScale Blog)}

Enforce real-time limits on your Postgres query traffic to protect your database from runaway queries and unexpected load spikes. [...]

Published Monday, 23. March 2026 00:00 • 26 days ago

ProxySQL 3.1.6: Full Query Observability in Fast Forward Mode with FFTO ^{(from ProxySQL Blog)}

Fast Forward Mode Is No Longer a Blind Spot [...]

Published Monday, 23. March 2026 00:00 • 26 days ago

用 Claude Code 在 PostgreSQL 实现 Double Write Buffer 遇到的一些问题 ^{(from Chen Zongzhi's GitHub blog)}

最近一直在探索怎么用 Claude Code 来帮忙写数据库内核的代码. 一开始是直接让 Claude code 在 PostgreSQL 上实现一套 Double Write Buffer, 参考 InnoDB 的实现. 代码 Claude 确实写得挺快, 但过程中发现一个问题: 它不会做设计. [...]

Published Monday, 23. March 2026 00:00 • 26 days ago

Continued Momentum Leading up to MySQL Community Edition Release ^{(from The Oracle MySQL Blog)}

More MySQL Worklogs and MySQL Developer Guide published As we ramp up to the MySQL Community Edition release in April, and as part of your our updated community engagement approach (see: A New Era of MySQL Community Engagement), we are announcing more MySQL worklogs, a MySQL Developer Guide and a reminder to please provide feedback […] [...]

Published Friday, 20. March 2026 16:11 • 28 days ago

I spent 4 hours restoring a backup for one deleted row ^{(from dbtrail Blog)}

pSomeone ran a DELETE without the right WHERE clause. One row gone. One customer record. And I spent the next four hours of my life getting it back.…/p pThe post I spent 4 hours restoring a backup for one deleted row appeared first on dbtrail Blog./p [...]

Published Friday, 20. March 2026 15:42 • 28 days ago

DuckDB Storage Engine for MariaDB: Full-Speed Analytics Inside Your Database ^{(from One-Time MySQL Community/Ecosystem Posts)}

MariaDB has long been celebrated for its pluggable storage engine architecture — the same design that lets you run InnoDB, Aria, ColumnStore, and other engines within a single server. Now there's a new player joining the lineup: the DuckDB Storage Engine, bringing the full power of DuckDB's columnar analytical engine right inside MariaDB. [...]

Published Friday, 20. March 2026 00:00 • 29 days ago

Migrating Etsy’s database sharding to Vitess ^{(from Etsy Code as Craft)}

pEtsy has maintained a sharded MySQL architecture since around 2010. This database cluster contains most of Etsy’s online data and is made up of ~1,000 tables distributed across ~1,000 shards. Over the last 16 years, it has grown significantly: combined, these tables have over 425 TB of data and receive roughly 1.7 million requests per second. /p pEtsy engineers access our MySQL data through a prop [...]