Planet for the MySQL Community

Does Every PXC Node Need XtraBackup Installed? ^{(from Another MySQL DBA)}

pOne question that surfaces regularly in the Percona forums: Does every node in a Percona XtraDB Cluster (PXC) need to have XtraBackup installed? It's a fair question, especially when managing a mixed environment or trying to minimize the software footprint on certain nodes. Here is what the actual mechanics and testing confirm./p The Short Answer (But Read On) pIt depends on what you want that n [...]

Published Sunday, 01. March 2026 19:11 • 2 hours ago | Updated Sunday, 01. March 2026 19:11 • an hour ago

Reflections on Product Quality — Quality in the AI Era ^{(from siddontang on Medium)}

pIn previous articles, I shared many of my thoughts on product quality. Over time, new ideas have emerged — especially in the AI era./ppIt is not an exaggeration to say that after entering 2026, the rapid development of AI has significantly refreshed my understanding. I suddenly realized that many of my previous thoughts on software quality and testing need to be updated./ppAs usual, a few disclaim [...]

Published Sunday, 01. March 2026 07:20 • 13 hours ago

Your AI Agent Forgot Everything. Here’s How We Fixed It. ^{(from siddontang on Medium)}

pOpenClaw and similar agent frameworks are becoming increasingly popular./ppBut if you’re actually running agents in the real world, you’ve probably hit one (or both) of these problems:/pulliYour laptop crashes. You reinstall the agent on a new machine — and it has zero memory. Everything starts from scratch./liliYou run multiple agents — OpenClaw, NanoClaw, KimiClaw — across multiple devices. Each [...]

Published Sunday, 01. March 2026 07:19 • 13 hours ago

ODBC Driver for MySQL: Open-Source vs Commercial (2026) ^{(from Devart MySQL Tool Blog)}

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

Published Saturday, 28. February 2026 18:21 • a day ago

Determining the Correct innodb_buffer_pool_chunk_size ^{(from Another Boring Tech Blog)}

pA common source of instability in MySQL environments is the unexpected growth of memory usage at startup. You might set your innodb_buffer_pool_size to 16GB, only to find the process consuming 18GB or 20GB. This happens because MySQL enforces a strict geometric relationship between the total size, the number of instances, and the chunk size. If.../p pO post Determining the Correct innodb_buffer_po [...]

Published Saturday, 28. February 2026 14:10 • a day ago

Foreign Keys and Schema Changes: The Constraint You Didn’t Plan For ^{(from Rendiment)}

MySQL foreign key constraints extend metadata locks to related tables and eliminate gh-ost for DDL. dbsafe surfaces the full FK impact before you alter. [...]

Published Saturday, 28. February 2026 05:00 • a day ago

SingleStore vs TiDB: A Guide to Choosing the Right Distributed SQL Database ^{(from PingCAP Blog)}

pAs data volumes explode and applications demand real-time insights alongside high-throughput transactions, teams increasingly turn to distributed SQL databases that promise to handle both OLTP and OLAP workloads in a unified system. SingleStore (formerly MemSQL) and TiDB are leading players in this space, offering MySQL compatibility, horizontal scalability, and Hybrid Transactional/Analytical Pro [...]

Published Friday, 27. February 2026 21:30 • 2 days ago

MariaDB Community Server 12.3 Will Include Galera Cluster ^{(from MariaDB Corporation Blog)}

Community feedback is an important part of MariaDB, and recently, you made your voices heard regarding the inclusion of Galera […] [...]

Published Friday, 27. February 2026 15:21 • 2 days ago

SQLSTATE [HY000] [2006] Galera has gone away ^{(from The consistent voice)}

pTL:DR : i find this move detrimental to MariaDB as a whole/ppMariaDB plc’s decision to pull Galera, its synchronous multi-master replication solution, out of the open-source ecosystem in MariaDB 12.3 LTS has been quietly shaking the extended MariaDB community lately./ppGalera has been a critical component for high-availability MariaDB deployments, enabling robust scaling and fault tolerance. But w [...]

Published Friday, 27. February 2026 13:28 • 2 days ago

Operational guide to migrating to ClickHouse ^{(from Severalnines Blog)}

pOrganizations frequently migrate to ClickHouse when they determine that their existing databases or analytics stacks are inadequate for accommodating escalating analytical requirements. This transition is predicated on the fact that ClickHouse is a purpose-built OLAP engine specifically engineered to meet such demands. In this post, I will outline the operational blueprint for migrating high-volum [...]

Published Friday, 27. February 2026 08:00 • 3 days ago

Improving Index Selection For Join Queries ^{(from DoltHub Blog)}

An overview of recent improvements to how Dolt selects indexes in join planning. [...]

Published Friday, 27. February 2026 00:00 • 3 days ago

Video Conferencing with Postgres ^{(from PlanetScale Blog)}

Stream real time video and audio through PostgreSQL on PlanetScale. [...]

Published Friday, 27. February 2026 00:00 • 3 days ago

Solving the Distributed Backup Headache: How TiDB Delivers Transactional Consistency ^{(from PingCAP Blog)}

pDistributed database backups are not just about coordinating the copying of files from multiple machines. It is capturing a single, consistent point in time across a system that is actively processing transactions. In TiDB, data is distributed across many nodes. Transactions use MVCC with a two-phase commit protocol. Transactions may touch multiple partitions at once. […]/p pThe post Solving [...]

Published Thursday, 26. February 2026 23:54 • 3 days ago

A Friendly Reset: Understanding the MariaDB Foundation’s Role ^{(from lefred's blog)}

Over the last few days, I’ve seen more than a few comments and questions about what the MariaDB Foundation is supposed to do — and what it should do when something in the wider MariaDB ecosystem changes. I am referring here to what I call the “Galera Case“. Instead of replying to every thread with […] [...]

Published Thursday, 26. February 2026 20:55 • 3 days ago

Introducing MariaDB Enterprise Cluster on MariaDB Cloud ^{(from MariaDB Corporation Blog)}

The modern enterprise doesn’t just run on data, it survives on the absolute certainty of that data. As applications become […] [...]

Published Thursday, 26. February 2026 20:27 • 3 days ago

Introducing Tungsten Cluster & Tungsten Replicator v8.0.3 ^{(from Continuent Blog)}

Announcing Tungsten Cluster and Tungsten Replicator v8.0.3. This maintenance release delivers stability improvements, Java compatibility fixes, real-time replication performance monitoring, security library upgrades, and installation workflow enhancements.Tags: tungsten clustertungsten replicatorReleaseupgrade [...]

Published Thursday, 26. February 2026 09:46 • 3 days ago

More than Flushing (also Caching) for innodb_flush_method, and Missing Release Candidate ^{(from J-F Gagné's MySQL Blog)}

Something changed in MySQL 8.4 related to caching, and it is easy to miss, so it deserves a post. And a subject adjacent to this is the missing Release Candidate for MySQL 8.4 LTS, with my hope that the next LTS will have a Release Candidate, so I also cover this topic below. (if you are not interested in Caching and Flushing, you can jump directly to the section about Release Candidate) [...]

Published Wednesday, 25. February 2026 20:57 • 4 days ago | Updated Wednesday, 25. February 2026 21:14 • 4 days ago

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

In the first month of the new year, we focused on practical improvements for the Dashboard, Platform, and Agent, while continuing development on a set of larger integrations that are nearing release. [...]

Published Wednesday, 25. February 2026 19:53 • 4 days ago

Percona Operator for MongoDB 1.22.0: Automatic Storage Resizing, Vault Integration, Service Mesh Support, and More! ^{(from Percona Database Blog)}

♦The latest release of the Percona Operator for MongoDB, 1.22.0 is here. It brings automatic storage resizing, HashiCorp Vault integration for system user credentials, better integration with service meshes, improved backup and restore options, and more. This post walks through the highlights and how they can help your MongoDB deployments on Kubernetes. Percona Operator for MongoDB […] [...]

Published Wednesday, 25. February 2026 17:09 • 4 days ago

The Rising Tide of Community Contributions to MariaDB Server ^{(from MariaDB Foundation Blog)}

pI wanted to share with you all some statistics on the incoming community contributions for the MariaDB server in the last year or so. And some of my thoughts looking at the data. … /p pContinue reading \"The Rising Tide of Community Contributions to MariaDB Server\"/p pThe post The Rising Tide of Community Contributions to MariaDB Server appeared first on MariaDB.org./p [...]

Published Wednesday, 25. February 2026 13:45 • 4 days ago

The best new features in MariaDB ^{(from InfoWorld)}

pMariaDB may have started as a MySQL fork, following Oracle’s acquisition of MySQL, but with time it’s charted its own path. Over the last few major revisions, the open source RDBMS has added unique functions, greater compatibility with MySQL, and a suite of behaviors designed to make it a migration target for Oracle SQL users. Here’s a quick look at some of the best and most [...]

Published Wednesday, 25. February 2026 09:00 • 4 days ago

ON DELETE CASCADE: The Foreign Key Change MySQL Doesn’t Log ^{(from Rendiment)}

MySQL InnoDB's ON DELETE CASCADE bypasses the binlog, audit plugins, and triggers — the three blind spots explained plus a trigger-based workaround for 8.x. [...]

Published Wednesday, 25. February 2026 05:00 • 5 days ago

Amazon RDS Snapshot Export to S3 now available in AWS GovCloud (US) Regions ^{(from AWS What's New)}

pAmazon RDS Snapshot Export to S3 is now available in AWS GovCloud (US) regions, enabling you to export snapshot data in Apache Parquet format for analytics, data retention, and machine learning use cases.br br Snapshot export to S3 supports all DB snapshot types (manual, automated system, and AWS Backup snapshots) and runs directly on the snapshot without impacting database performance. The export [...]

Published Tuesday, 24. February 2026 18:26 • 5 days ago

Vibe Coding a High-Performance App with Readyset QueryPilot ^{(from Readyset Blog)}

In this post, we vibe code a Go CRM app with AI-generated SQL and show how QueryPilot auto-identifies and caches MySQL queries. [...]

Published Tuesday, 24. February 2026 17:58 • 5 days ago

SQL history lesson with Oracle V2 ^{(from Daniël's Database Blog)}

pI recently stubmbled upon this website that hosts a publicly available Oracle RDBMS instance running Oracle v2.3.2, which according to this Wikipedia article is the first commercially available version of Oracle. This version is not written in C, but in PDP-11 assembly. The website also has the manuals available. At this time the company was called Relational Software Incorporated or RSI for short [...]

Published Tuesday, 24. February 2026 14:38 • 5 days ago | Updated Tuesday, 24. February 2026 15:00 • 5 days ago

A checklist for enterprise database success ^{(from InfoWorld)}

pWith every passing year, data continues to grow more important and more central to practically every aspect of corporate operations. As the AI race continues full-steam ahead, it will be mission-critical for CIOs and other technical business decision-makers to get things right when it comes to their data infrastructure./p pWithout the right plumbing, even the best, most r [...]

Published Tuesday, 24. February 2026 09:00 • 5 days ago

MariaDB innovation: vector index performance ^{(from Small Datum)}

pLast year I shared many posts documenting MariaDB performance for vector search using ann-benchmarks. Performance was great in MariaDB 11 and this blog post explains that it is even better in MariaDB 12. This work was done by Small Datum LLC and sponsored by the MariaDB Foundation. My previous posts were published in January and February 2025./pptl;dr/pp/pulliVector search recall vs prec [...]

Published Monday, 23. February 2026 16:54 • 6 days ago | Updated Tuesday, 24. February 2026 00:05 • 6 days ago

Always Have an Exit Strategy: dbsafe Automatic Rollback Plans ^{(from Rendiment)}

Learn how dbsafe auto-generates rollback SQL for every schema change — with data loss warnings for DROP COLUMN and INSTANT drop notes for MySQL 8.0.29+. [...]

Published Monday, 23. February 2026 05:00 • 7 days ago

How to Write a System Prompt ^{(from DoltHub Blog)}

Agent mode in the Dolt Workbench relies on a carefully constructed system prompt that defines the agent's role and capabilities. In this article, we'll discuss the dangers of the system prompt and what it took to arrive at the one we're using today. [...]

Published Monday, 23. February 2026 00:00 • 7 days ago

RAG Series – Embedding Versioning with pgvector: Why Event-Driven Architecture Is a Precondition to AI data workflows ^{(from dbi Blog)}

pIntroduction “Make it simple.” This is a principle I keep repeating, and I’ll repeat it again here. Because when it comes to keeping your RAG system’s embeddings fresh, the industry has somehow made it complicated. External orchestrators, custom Python cron jobs, microservices that call microservices, Airflow DAGs with 47 tasks, all to answer a simple […]/p pL’article [...]

Published Sunday, 22. February 2026 14:23 • 7 days ago

When MySQL Rebuilds Your Table: Understanding COPY Algorithm DDL ^{(from Rendiment)}

Understand MySQL COPY algorithm DDL that rebuilds entire tables. Learn why MODIFY COLUMN and charset conversions are dangerous, and how dbsafe mitigates risk. [...]

Published Sunday, 22. February 2026 05:00 • 8 days ago

MySQL + Neo4j for AI Workloads: Why Relational Databases Still Matter ^{(from Another MySQL DBA)}

pSo I figured it was about time I documented how to build persistent memory for AI agents using the databases you already know. Not vector databases - MySQL and Neo4j./p pThis isn't theoretical. I use this architecture daily, handling AI agent memory across multiple projects. Here's the schema and query patterns that actually work./p The Architecture pAI agents need two types of memory:/p ul [...]

Published Sunday, 22. February 2026 00:01 • 8 days ago | Updated Sunday, 22. February 2026 00:01 • 8 days ago

MySQL 8.0 JSON Functions: Practical Examples and Indexing ^{(from Another MySQL DBA)}

pThis post covers a hands-on walkthrough of MySQL 8.0's JSON functions. JSON support has been in MySQL since 5.7, but 8.0 added a meaningful set of improvements — better indexing strategies, new functions, and multi-valued indexes — that make working with JSON data considerably more practical. The following documents several of the most commonly needed patterns, including EXPLAIN output and perform [...]

Published Saturday, 21. February 2026 22:39 • 8 days ago | Updated Saturday, 21. February 2026 22:42 • 8 days ago

Zero-Downtime Schema Changes with MySQL 8.0 INSTANT DDL ^{(from Rendiment)}

Master MySQL 8.0 INSTANT DDL for zero-downtime schema changes. Learn ADD COLUMN, DROP COLUMN without table rebuilds, and use dbsafe to verify before production. [...]

Published Saturday, 21. February 2026 05:00 • 9 days ago

Is MariaDB part of the MySQL ecosystem? ^{(from MariaDB Foundation Blog)}

pWhy MariaDB is both its own database — and the natural continuation of MySQLbr Because MariaDB is at the same time a completely independent database and a fundamentally compatible extension of MySQL, the MySQL user base is not dependent upon Oracle nor upon new forks of MySQL for their future. For pragmatical reasons – … /p pContinue reading \"Is MariaDB part of the MySQL ec [...]

Published Friday, 20. February 2026 20:29 • 9 days ago

Engineering the VillageSQL Extension Framework (VEF) ^{(from VillageSQL)}

pExtending MySQL has traditionally meant a difficult choice: maintain a complex fork or accept the performance and functional limitations of the legacy UDF, plugin, or component systems. We built VillageSQL to provide a new path: a stable, versioned Application Binary Interface (ABI) for loading custom types and logic into MySQL/p [...]

Published Friday, 20. February 2026 17:23 • 9 days ago

How to Migrate Cloud PostgreSQL to On-Prem with Minimal Downtime ^{(from Severalnines Blog)}

pIn the last decade, cloud adoption has accelerated as organizations looked to scale quickly, reduce upfront capital investment, and leverage managed services. However, in recent years, a growing number of companies are choosing to migrate certain workloads back from the cloud to on-premises environments. The reasons vary; cost reduction, compliance with data sovereignty laws, improved [̷ [...]

Published Friday, 20. February 2026 08:00 • 10 days ago

TidesDB becomes Silver Sponsor of the MariaDB Foundation ^{(from MariaDB Foundation Blog)}

pWe’re excited to welcome TidesDB as a Silver Sponsor of the MariaDB Foundation.br TidesDB’s sponsorship directly supports our mission to strengthen the MariaDB ecosystem and accelerate innovation through open, community-driven collaboration. … /p pContinue reading \"TidesDB becomes Silver Sponsor of the MariaDB Foundation\"/p pThe post TidesDB becomes Silver Sponsor of the MariaD [...]

Published Friday, 20. February 2026 04:05 • 10 days ago

Your Time is All Messed Up: Time Implementations in Go ^{(from DoltHub Blog)}

We recently rewrote our implementation of `TIMESTAMPDIFF` in go-mysql-server and Dolt, and along the way, we had to make considerations for Go's implementations of time. [...]

Published Friday, 20. February 2026 00:00 • 10 days ago

FromDual Performance Monitor 2.2.1 has been released ^{(from Shinguz's Blog)}

pFromDual has the pleasure to announce the release of the new version 2.2.1 of its popular Database Performance Monitor for MariaDB, Galera Cluster, MySQL and PostgreSQL codefpmmm/code./p pThe FromDual Performance Monitor enables Database and System Administrators to monitor and understand what is going on inside their databases and on the machines where the databases reside./p pMore information yo [...]

Published Thursday, 19. February 2026 17:18 • 10 days ago

MariaDB innovation: binlog_storage_engine, small server, Insert Benchmark ^{(from Small Datum)}

pMariaDB 12.3 has a new feature enabled by the option binlog_storage_engine. When enabled it uses InnoDB instead of raw files to store the binlog. A big benefit from this is reducing the number of fsync calls per commit from 2 to 1 because it reduces the number of resource managers from 2 (binlog, InnoDB) to 1 (InnoDB).brbrMy previous post had results for sysbench with a small server. This pos [...]

Published Wednesday, 18. February 2026 04:20 • 12 days ago | Updated Thursday, 19. February 2026 17:06 • 10 days ago

What is MariaDB AI RAG and what can I do with it? ^{(from MariaDB Corporation Blog)}

I recently had the pleasure of speaking at MariaDB Day Brussels 2026, an event where MariaDB enthusiasts like myself gather, […] [...]

Published Thursday, 19. February 2026 16:56 • 10 days ago

A Guide to Accelerating Your Application with Valkey: Caching Database Queries and Sessions ^{(from Percona Database Blog)}

♦Modern applications often rely on multiple services to provide fast, reliable, and scalable responses. A common and highly effective architecture involves an application, a persistent database (like MySQL), and a high-speed cache service (like Valkey). In this guide, we’ll explore how to integrate these components effectively using Python to dramatically improve your application’s performanc [...]

Published Thursday, 19. February 2026 15:33 • 10 days ago

MariaDB Foundation Releases Alpha of the Test Automation Framework (TAF) ^{(from MariaDB Foundation Blog)}

pThe MariaDB Foundation is releasing the alpha version of the Test Automation Framework (TAF), an open-source benchmarking framework designed for clarity, repeatability, and vendor-neutral testing. TAF provides a structured way to run database benchmarks using consistent workloads, configuration, and reporting pipelines, making results easier to reproduce and discuss. … /p pContinue reading \ [...]

Published Thursday, 19. February 2026 12:38 • 10 days ago

Community push intensifies to free MySQL from Oracle’s control amid stagnation fears ^{(from InfoWorld)}

pPressure is building on Oracle to loosen its grip on MySQL, with a group of database veterans, developers, and long-time contributors urging the company to transition the open source database to an independent foundation model./p pThe call, articulated in an open letter, reflects mounting concern about MySQL’s development velocity, roadmap transparency, and role in an inc [...]

Published Thursday, 19. February 2026 09:36 • 10 days ago

Reflections on Product Quality — Rethinking the Role of the Quality Team ^{(from siddontang on Medium)}

pIn the previous articles, I discussed my basic understanding of quality, how to evaluate it, and several testing methodologies. In this article, I want to talk about something organizational, because product quality ultimately depends on how an organization executes and sustains it./ppAs usual, a few disclaimers before we begin:/pulliWhat I say here is not necessarily correct. I constantly update [...]

Published Thursday, 19. February 2026 00:06 • 11 days ago

Reflections on Product Quality — Wrong Practices in Patch Releases ^{(from siddontang on Medium)}

pIn the previous articles, I discussed my basic understanding of quality, how to evaluate it, and different testing methodologies. In this article, I want to talk about a place where we clearly dropped the ball on quality./ppWhenever we release an LTS version — such as TiDB 7.5 or 8.5 LTS — customers usually take a wait-and-see approach at first. Only after several patch releases do they gradually [...]

Published Thursday, 19. February 2026 00:04 • 11 days ago

Faster PlanetScale Postgres connections with Cloudflare Hyperdrive ^{(from PlanetScale Blog)}

Build a real-time application with PlanetScale and the Cloudflare global network. Infrastructure choices you won't need to migrate away from once you hit scale. [...]

Published Thursday, 19. February 2026 00:00 • 11 days ago

Replication Internals: Decoding the MySQL Binary Log - Part 1: Introduction and Data Types ^{(from Readyset Blog)}

A byte-level introduction to the MySQL binary log. Learn how integers, strings, and TLV fields are encoded for replication and CDC. [...]

Published Wednesday, 18. February 2026 21:08 • 11 days ago

Explaining why throughput varies for Postgres with a CPU-bound Insert Benchmark ^{(from Small Datum)}

pThroughput for the write-heavy steps of the Insert Benchmark look like a distorted sine wave with Postgres on CPU-bound workloads but not on IO-bound workloads. For the CPU-bound workloads the chart for max response time at N-second intervals for inserts is flat but for deletes it looks like the distorted sine wave. To see the chart for deletes, scroll down from here. So this looks like a pro [...]

Published Wednesday, 18. February 2026 20:38 • 11 days ago | Updated Wednesday, 18. February 2026 20:48 • 11 days ago

Raft Region Size: The Invisible Lever for Distributed Database Performance ^{(from PingCAP Blog)}

pIf you have ever tuned a distributed database, you have probably adjusted obvious knobs: CPU, memory, replication factor, concurrency limits. But there is a quieter setting, one that rarely gets headlines, that has an outsized impact on performance, reliability, and operational sanity: Raft region size. In TiDB, via TiKV, region size refers to the size […]/p pThe post Raft Region Size: The I [...]

Published Wednesday, 18. February 2026 18:00 • 11 days ago

Updated MariaDB R2DBC and Node.js Connectors now available ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of MariaDB Connector/R2DBC 1.4.0, and Connector/Node.js 3.5.1. Both are Stable (GA) releases. […] [...]

Published Wednesday, 18. February 2026 17:43 • 11 days ago

UUID to BIN: problematic & solutions, POC ^{(from lefred's blog)}

I recently tested MariaDB’s plugin architecture to add functions for UUIDs. My friend Daniël took a look at the GitHub repo and left me some insightful comments, which I addressed in issue #1. If you know me, you may know that while my daughters are practicing basketball, I’m waiting coding… As I’ve always been very […] [...]

Published Wednesday, 18. February 2026 14:10 • 11 days ago

Let’s go physical(ly separated) ^{(from The consistent voice)}

♦pIn my previous article , we discussed best practices for securing and monitoring admin access, such as role-based access controls (RBAC). It’s a good time to have a quick reminder about AAA aka “ Authentication, Authorization and Accounting” , which is a framework designed to manage access to networked resources and ensure secure, controlled interactions :/polliAuthentication : Verifies the ident [...]

Published Wednesday, 18. February 2026 09:44 • 11 days ago

A battle for MySQL’s heart – and future? ^{(from The Stack)}

Signatories of a new open letter say they don't want to go down the "hostile fork" route. [...]

Published Wednesday, 18. February 2026 09:30 • 11 days ago

MariaDB Foundation Welcomes Epsio as a Silver Sponsor ^{(from MariaDB Foundation Blog)}

pWe are delighted to announce that Epsio (www.epsio.io/) has joined the MariaDB Foundation as an official silver sponsor.br Epsio’s commitment to innovation and open technology aligns closely with the mission of the MariaDB Foundation: to support and advance the MariaDB ecosystem and strengthen the long-term viability of MariaDB as a reliable, open source database platform. … /p pContin [...]

Published Wednesday, 18. February 2026 04:31 • 12 days ago

CPU-bound Insert Benchmark vs Postgres on 24-core and 32-core servers ^{(from Small Datum)}

pThis has results for Postgres versions 12 through 18 with a CPU-bound Insert Benchmark on 24-core and 32-core servers. A report for MySQL on the same setup is here./pptl;dr/pp/pulligood news/liullithere are small improvments/liliwith the exception of get_actual_variable range I don't see new CPU overheads in Postgres 18/li/ullibad news/liullithere might be small regressions from new CPU [...]

Published Thursday, 22. January 2026 20:40 • 1 months ago | Updated Wednesday, 18. February 2026 04:11 • 12 days ago

Amazon Aurora MySQL 3.12 (compatible with MySQL 8.0.44) is now generally available ^{(from AWS What's New)}

pStarting today, Amazon Aurora MySQL - Compatible Edition 3 (with MySQL 8.0 compatibility) will support MySQL 8.0.44 through Aurora MySQL v3.12.br br In addition to many security enhancements and bug fixes, Aurora MySQL v3.12 contains several availability improvements. For more details, refer to the Aurora MySQL 3.12 and MySQL 8.0.44 release notes. To upgrade to Aurora MySQL 3.12, you can initiate [...]

Published Tuesday, 17. February 2026 20:00 • 12 days ago

Streamline Amazon RDS management with consolidation techniques – Part 1 ^{(from AWS Database Blog)}

In this first post of a two-part series, we share proven strategies for Amazon RDS database consolidation that can help you reduce operational overhead and optimize resource utilization. In the second post, we will introduce an open source tool that we developed called RDS Consolidator, which helps you visualize your current database landscape and plan consolidation scenarios. [...]

Published Tuesday, 17. February 2026 17:45 • 12 days ago

Dear Oracle, we need to talk about the future of MySQL ^{(from The Register)}

Faithful pen open letter proposing independent foundation with or without Big Red's participation pA group of influential users and developers of MySQL have invited Oracle to join their plans to create an independent foundation to guide the future development of the popular open source database, which Big Red owns.…/p p!--#include virtual='/data_centre/_whitepaper_textlinks_top.html' --/p [...]

Published Tuesday, 17. February 2026 16:49 • 12 days ago

An Open Letter to Oracle: Let’s Talk About MySQL’s Future ^{(from Percona Database Blog)}

♦What Happened at the Summits We just wrapped up two MySQL Community Summits – one in San Francisco in January, and one in Brussels right before FOSDEM. The energy in the rooms: a lot of people who care deeply about MySQL got together, exchanged ideas, and left with a clear sense that we need to […] [...]

Published Tuesday, 17. February 2026 15:07 • 12 days ago

As MySQL stagnates, its community sounds the alarm ^{(from Techzine)}

This year, Oracle has already tried to placate fears about MySQL’s development and adoption, as its apparent stagnation has meant it is ill-positioned for the short-term future. Issues abound, meaning the MySQL community has drafted a written invitation to Oracle to set course for a brighter future. The letter, now published, is seeking a thousand […] [...]

Published Tuesday, 17. February 2026 15:00 • 12 days ago

The Hidden Cost of Database Over-Provisioning ^{(from PingCAP Blog)}

pAccording to the 2025 Kubernetes Cost Benchmark Report, average CPU utilization across Kubernetes clusters is approximately 10 percent. For many teams, that raises an obvious question: why is database utilization so low? The answer is not poor engineering. It is structural. Modern cloud-native database scaling models are built around peak capacity planning. To protect availability, […]/p pTh [...]

Published Tuesday, 17. February 2026 14:36 • 12 days ago

MySQL Belgian Days and FOSDEM 2026: My Impressions ^{(from TusaCentral - MySQL Blogs)}

pFirst of all, I want to say a huge thank you to Frederic Descamps and the entire team who worked on the MySQL Belgian Days. I was thrilled to see the high number of presentations and the excellent quality across the board. We had two rooms packed with attendees, and the event was simply great. It was also incredibly productive to finally reconnect with so many people in the community face-to-face. [...]

Published Tuesday, 17. February 2026 13:49 • 12 days ago

Reflections on Product Quality — Scenario Testing ^{(from siddontang on Medium)}

pFor Quality, I once made a half-joking remark:/pblockquote“If I had infinite resources, and could write infinite test cases to cover all customer scenarios, then TiDB would almost have no bugs.”/blockquotepOf course, that is wishful thinking./ppBut from another angle, it also highlights the importance of scenario testing. I also expressed my admiration for Oracle, which has accumulated hundreds of [...]

Published Tuesday, 17. February 2026 13:02 • 12 days ago

Reflections on Product Quality — Unit Testing in TiDB ^{(from siddontang on Medium)}

pA long time ago, I noticed a potential risk in the TiDB codebase: many tests that look like unit tests (UT) are, in reality, closer to integration tests (IT). In many cases, interfaces are tested through SQL. This topic triggered extensive internal discussions at TiDB./ppEngineers who support SQL-based testing have very solid arguments. SQLite uses this approach, and such tests are relatively easy [...]

Published Tuesday, 17. February 2026 13:01 • 12 days ago

MariaDB UUID functions plugin ^{(from lefred's blog)}

At the end of my first day at MariaDB, I wanted to investigate a bit on how easy it is to extend MariaDB Server with extensions. As for MySQL, MariaDB can be extended with plugins. MariaDB has no component infrastructure, but extensibility via plugins seems easier. And indeed, it was very easy to add some […] [...]

Published Monday, 16. February 2026 19:40 • 13 days ago

MariaDB innovation: binlog_storage_engine ^{(from Small Datum)}

pMariaDB 12.3 has a new feature enabled by the option binlog_storage_engine. When enabled it uses InnoDB instead of raw files to store the binlog. A big benefit from this is reducing the number of fsync calls per commit from 2 to 1 because it reduces the number of resource managers from 2 (binlog, InnoDB) to 1 (InnoDB)./ppIn this post I have results for the performance benefit from this when using [...]

Published Monday, 16. February 2026 19:06 • 13 days ago | Updated Monday, 16. February 2026 19:22 • 13 days ago

I joined the MariaDB Foundation ^{(from lefred's blog)}

Last Friday was my last day at Oracle. Today is my first day at MariaDB.org! Of course, this move is a big surprise for many people, but not for me, and it might not be for those following the MySQL ecosystem closely. My decision to leave Oracle was made before the announcement of the new […] [...]

Published Monday, 16. February 2026 16:51 • 13 days ago

Oracle vows 'new era' for MySQL as users sharpen their forks ^{(from The Register)}

Commit drought and governance gripes push Big Red to reset pOracle has promised a "decisive new approach" to MySQL, the popular open source database it owns, following growing criticism of its approach and the prospect of a significant fork in the code.…/p [...]

Published Monday, 16. February 2026 16:48 • 13 days ago

Five MCP servers to rule the cloud ^{(from InfoWorld)}

pAnthropic’s Model Context Protocol (MCP), coined the “USB-C for AI,” has inspired the software industry to think bigger with their AI assistants. Now, armed with access to external data and APIs, as well as to internal platforms and databases, agents are getting arms and legs to conduct impressive automation./p pMCP is no longer reserved for trendy AI startups or niche so [...]

Published Monday, 16. February 2026 09:00 • 13 days ago

MySQL vs PostgreSQL Internals (Part 1) – Buffer Pool ^{(from Zhao Song's Blog)}

The debate over “MySQL vs PostgreSQL, which one is better?” has been around for a long time. As two outstanding representatives of open-source OLTP databases, I personally don’t think one overwhelmingly dominates the other. Transactional database theory has been stable for decades; both systems are practical implementations built under the same theoretical framework. [...]

Published Monday, 16. February 2026 00:00 • 14 days ago

HammerDB tproc-c on a large server, Postgres and MySQL ^{(from Small Datum)}

pThis has results for HammerDB tproc-c on a small server using MySQL and Postgres. I am new to HammerDB and still figuring out how to explain and present results so I will keep this simple and just share graphs without explaining the results.brbrThe comparison might favor Postgres for the IO-bound workloads because I used smaller buffer pools than normal to avoid OOM. I have to do this be [...]

Published Sunday, 15. February 2026 20:42 • 14 days ago | Updated Sunday, 15. February 2026 20:51 • 14 days ago

HammerDB tproc-c on a small server, Postgres and MySQL ^{(from Small Datum)}

pThis has results for HammerDB tproc-c on a small server using MySQL and Postgres. I am new to HammerDB and still figuring out how to explain and present results so I will keep this simple and just share graphs without explaining the results./pptl;dr/pp/pulliModern Postgres is faster than old Postgres/liliModern MySQL has large perf regressions relative to old MySQL, and they are worst at low [...]

Published Saturday, 14. February 2026 19:03 • 15 days ago | Updated Sunday, 15. February 2026 20:35 • 14 days ago

Introducing dbsafe: Know Before You ALTER ^{(from Rendiment)}

Analyze MySQL ALTER TABLE statements before running them. Know the algorithm, locks, and risks without testing on production. Read-only DDL safety tool. [...]

Published Saturday, 14. February 2026 05:00 • 16 days ago

^{(from Mikael Ronstrom)}

!-- Blog post for Blogger.com Title: Developing RonDB with Claude: Lessons from 30 Years of Database Engineering HOW TO PUBLISH ON BLOGGER: 1. Go to blogger.com - New Post 2. Switch to HTML view (click the pencil icon or "HTML" button) 3. Paste everything BELOW this comment block into the editor 4. Set the title to: Developing RonDB with Claude: Lessons from 30 Years of Database Engi [...]

Published Friday, 13. February 2026 19:53 • 16 days ago | Updated Friday, 13. February 2026 19:53 • 16 days ago

MariaDB 12.3.1 and 12.2.2 now available ^{(from MariaDB Foundation Blog)}

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 12.3.1, the release candidate (RC) in the new long-term support (LTS) release, and MariaDB 12.2.2, the latest stable rolling release. … /p pContinue reading \"MariaDB 12.3.1 and 12.2.2 now available\"/p pThe post MariaDB 12.3.1 and 12.2.2 now available appeared first on MariaDB.org./p [...]

Published Friday, 13. February 2026 16:15 • 16 days ago

How to Build an AI Advisor That Shows College ROI (Not Rankings) ^{(from PingCAP Blog)}

pI know too many people drowning in student debt. A friend got her Master’s in Music from an expensive private school. She’s $120k in debt and works at Starbucks. Another guy I know got a business degree from a school that costs $50k a year. He’s doing the same job he could’ve gotten without the […]/p pThe post How to Build an AI Advisor That Shows College ROI (Not Rankings) appeared first on [...]

Published Friday, 13. February 2026 15:56 • 16 days ago

Amazon RDS now supports backup configuration when restoring snapshots ^{(from AWS What's New)}

pAmazon Relational Database Service (RDS) and Amazon Aurora now offer greater flexibility for restore operations to view and modify backup retention period and preferred backup window prior to and upon restoring database snapshots. The backup retention period lets you specify how many days backups are retained, while the preferred backup window allows you to set your desired backup schedule.br br P [...]

Published Friday, 13. February 2026 13:00 • 16 days ago

ClickHouse storage architecture and optimization ^{(from Severalnines Blog)}

pIn analytical databases, storage is the dominant factor behind performance, stability, and cost. ClickHouse is designed to scan large volumes of data efficiently, but how well it performs in production depends heavily on storage layout, disk throughput, and merge behavior. For operations and support engineers, storage decisions determine whether ClickHouse is predictable and cost-efficient o [...]

Published Friday, 13. February 2026 08:00 • 17 days ago

Achieve near-zero downtime database maintenance by using blue/green deployments with AWS JDBC Driver ^{(from AWS Database Blog)}

In this post we introduce the blue/green deployment plugin for the AWS JDBC Driver, a built-in plugin that automatically handles connection routing, traffic management, and switchover detection during blue/green deployment switchovers. We show you how to configure and use the plugin to minimize downtime during database maintenance operations during blue/green deployment switchovers. [...]

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

Announcing MariaDB Community Server 12.2 GA ^{(from MariaDB Corporation Blog)}

We are excited to announce the General Availability of MariaDB Community Server 12.2. Building upon the major foundational changes introduced […] [...]

Published Thursday, 12. February 2026 19:52 • 17 days ago

Trip Report: VillageSQL at preFOSDEM MySQL Days ^{(from VillageSQL)}

pAt this year's preFOSDEM MySQL Days, Dominic Preuss and Tomas Ulin presented VillageSQL’s vision for how to solve one of the bottlenecks of upstream contributions in the MySQL ecosystem through an extension framework. This annual event brings together the MySQL community to share ideas and updates./p [...]

Published Thursday, 12. February 2026 16:06 • 17 days ago

New Era of MySQL Community Engagement ^{(from The Oracle MySQL Blog)}

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

Published Thursday, 12. February 2026 15:53 • 17 days ago

LLM Reasoning vs. Vector Search: Lessons from Building CrowdSnap’s Sentiment Analytics ^{(from PingCAP Blog)}

pCrowdSnap, a TiDB Cloud user, builds an AI analytics platform where teams upload datasets—like reviews or surveys—and pull natural language insights: sentiment trends, correlations, turning messy data into sharp decisions. In shaping their Prompt Analysis feature, the team hit a familiar AI crossroads: Lean on direct LLM calls (GPT via Azure OpenAI) for on-demand sentiment […]/p pThe post LL [...]

Published Thursday, 12. February 2026 13:11 • 17 days ago

Prompt To Production: Building Scalable AI on TiDB with Kiro ^{(from PingCAP Blog)}

pA technical deep dive into letting an AI reason directly over your database. Food waste is a quiet horror story. Every year, roughly 1.3 billion tons of food are discarded globally, often because we simply forget what’s in the back of our fridges. Half-used onions, forgotten spinach, and that single, lonely tomato—they aren’t just ingredients; […]/p pThe post Prompt To Production: Buil [...]

Published Thursday, 12. February 2026 07:18 • 18 days ago

Essential tools for monitoring and optimizing Amazon RDS for SQL Server ^{(from AWS Database Blog)}

In this post, we demonstrate how you can implement a comprehensive monitoring strategy for Amazon RDS for SQL Server by combining AWS native tools with SQL Server diagnostic utilities. We explore AWS services including AWS Trusted Advisor, Amazon CloudWatch Database Insights, Enhanced Monitoring, and Amazon RDS events, alongside native SQL Server tools such as Query Store, Dynamic Management Views [...]

Published Wednesday, 11. February 2026 21:58 • 18 days ago

Making MySQL AI-Ready: How MyVector and ProxySQL Work Together ^{(from ProxySQL Blog)}

pAs AI workloads become standard in modern applications, engineering teams face a familiar dilemma: MySQL is already the system of record, but vector search typically requires bolting on a separate database. That means two security models, two observability stacks, and inevitable data consistency headaches. A concept presented at Pre-FOSDEM 2026 by René Cannaò (ProxySQL founder) [...]/p pThe post M [...]

Published Wednesday, 11. February 2026 18:34 • 18 days ago

The Concepts of Forking ^{(from MariaDB Corporation Blog)}

Lately there has been a lot of discussion about “hard” or “soft” forks related to MySQL. As someone who has […] [...]

Published Wednesday, 11. February 2026 17:12 • 18 days ago

Amazon RDS for MariaDB now supports community MariaDB minor versions 10.6.25, 10.11.16, 11.4.10, and 11.8.6 ^{(from AWS What's New)}

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports community MariaDB minor versions 10.6.25, 10.11.16, 11.4.10, and 11.8.6. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MariaDB, and to benefit from the bug fixes, performance improvements, and new functionality added by the MariaDB community.br br You can [...]

Published Wednesday, 11. February 2026 16:23 • 18 days ago

What is the quickest way to load data into the database? ^{(from Shinguz's Blog)}

pWe had some really exciting problems to solve for the last customer! Especially because the database wasn’t exactly small./p pHere are some key data: CPU: 2 sockets x 24 cores x 2 threads = 96 vCores, 756 G RAM, 2 x 10 Tbyte PCIe SSD in RAID-10 and 7 Tbyte data, several thousand clients, rapidly growing./p pThe current throughput: 1 M codeSELECT/code/min, 56 k codeINSERT/code/min, 44 k codeU [...]

Published Wednesday, 11. February 2026 09:04 • 18 days ago

Look at me, I'm an (LLM-assisted) Emacs Lisp developer now ^{(from Laurynas Biveinis' blog)}

pClaude Code came out in February and I was hooked immediately. Luckily for me Anthropic introduced flat rate pricing plans very soon afterwards, or I'd have been bankrupted by pay-per-token prices by summer. I tried to channel all that newly-developed addiction to something productive, and decided to write, greenfield, some Emacs Lisp packages. I think such projects are perfectly-sized for working [...]

Published Monday, 01. December 2025 15:12 • 3 months ago | Updated Tuesday, 10. February 2026 12:25 • 19 days ago

The MariaDB contribution process: a step by step guide. ^{(from MariaDB Foundation Blog)}

pInspired by my VERY long presentation on the topic at FOSDEM26 I thought I’d say a couple of words on how the contribution process works. … /p pContinue reading \"The MariaDB contribution process: a step by step guide.\"/p pThe post The MariaDB contribution process: a step by step guide. appeared first on MariaDB.org./p [...]

Published Tuesday, 10. February 2026 12:18 • 19 days ago

Boring but useful: making large-scale changes on MySQL codebase with LLMs ^{(from Laurynas Biveinis' blog)}

p I used Claude Code to do a simple mass refactoring on MySQL 9.6 over two weeks, resulting in a 25K line diff that passes the testsuite. That was something I wanted to experiment with for some time now: making boring but useful large-scale changes to MySQL while spending as little human effort as possible. Claude Code with Opus 4.5 (and 4.6 for the last few days) was used for everything. /p p Why [...]

Published Tuesday, 10. February 2026 12:13 • 19 days ago | Updated Tuesday, 10. February 2026 12:13 • 19 days ago

MySQL Foreign Keys: Evolution from 5.7 to 8.0 and 8.4 LTS ^{(from Mydbops Blog)}

Lean how MySQL Foreign Keys have evolved. From the crash-prone .frm files of 5.7 to Atomic DDL in 8.0 and the stricter relational integrity rules introduced in MySQL 8.4 LTS. [...]

Published Tuesday, 10. February 2026 03:56 • 20 days ago

SQL /* comments */ can be nested ^{(from Modern SQL)}

SQL Comments, Please!pIn a program, a comment is a part of the source code that is ignored by the system. Comments are generally used for two purposes: (1) provide background information for future readers of that code, including our selves; (2) deactivate some code without deleting it yet—aka. commenting out. SQL supports comments too, of course./ppWhile SQL comments are generally ignored by the e [...]

Published Tuesday, 10. February 2026 00:00 • 20 days ago

Accelerating Innovation: MariaDB’s Journey to a 2.5x Performance Leap ^{(from MariaDB Corporation Blog)}

It is hard to believe it has already been a year since I joined MariaDB as Vice President of Engineering. […] [...]

Published Monday, 09. February 2026 19:19 • 20 days ago

MariaDB has broken the concept of dynamically configurable buffer pools! ^{(from Shinguz's Blog)}

Problem description pMySQL introduced the dynamically configurable InnoDB buffer pool with 5.7.5 in September 2014 (here and here):/p blockquote pThe innodb_buffer_pool_size configuration option can be set dynamically using a SET statement, allowing you to resize the buffer pool without restarting the server. For example:brbr mysql> SET GLOBAL innodb_buffer_pool_size=402653184;/p /blockquote pMa [...]

Published Monday, 09. February 2026 18:14 • 20 days ago

MySQL 9.6: Foreign Key Cascade Operations Finally Hit the Binary Log ^{(from Readyset Blog)}

MySQL 9.6 moves foreign key cascade enforcement to the SQL layer, making cascaded deletes visible in the binlog for replication and CDC. [...]

Published Monday, 09. February 2026 16:23 • 20 days ago

Reflections on Product Quality — The Testing Dilemma ^{(from siddontang on Medium)}

Reflections on Product Quality — The Testing DilemmapIn A Philosophy of Building High-Quality TiDB, I drew a causal loop diagram to emphasize how a high-quality product is critical to customer growth. When it comes to ensuring quality, testing naturally plays a very important role. However, this article is not about how we test TiDB./ppIn this article, I want to borrow the title of The Innovator’s [...]

Published Monday, 09. February 2026 01:05 • 21 days ago

Cursor for SQL ^{(from DoltHub Blog)}

Today, we're launching agent mode in the Dolt Workbench — a Cursor-like agentic chat interface that allows you to safely interact with Dolt, MySQL, and Postgres databases. [...]

Published Monday, 09. February 2026 00:00 • 21 days ago

The Real Operational Cost of Vacuuming in PostgreSQL ^{(from MariaDB Foundation Blog)}

pThere was a time when PostgreSQL’s own developers were far more open about the real cost of their MVCC design. Back in the 8.1 era, the documentation spelled out the resource drain, the vacuum overhead, and the “cold comfort” … /p pContinue reading \"The Real Operational Cost of Vacuuming in PostgreSQL\"/p pThe post The Real Operational Cost of Vacuuming in PostgreSQL appea [...]

Published Sunday, 08. February 2026 23:50 • 21 days ago

In 2026, Can AI Modify Database Kernel Code? ^{(from Chen Zongzhi's Medium blog)}

In 2026, Can AI Modify Database Kernel Code? Rewriting PostgreSQL with Claude Code: Full Page Write vs Doublewrite Buffer, a 3x Performance GappIt’s 2026. Can AI actually modify database kernel code? I used Claude Code to replace PostgreSQL’s Full Page Write with MySQL’s Doublewrite Buffer approach. Turns out DWB is about 3x faster./pWhy I Did ThispI’ve been bugged by this question for years: which [...]

Published Sunday, 08. February 2026 23:48 • 21 days ago

Village SQL - A MySQL Fork With Easy Extensions ^{(from Dave's MySQL Stuff)}

p I was happy to see a new MySQL fork appear. Village SQL bills itself as 'A drop-in replacement for MySQL with extensions for the agentic AI era'. Mainstream Oracle MySQL does have Plug-ins, but I have found them less easy to develop and use than other implementations, such as PostgreSQL extensions. So how does it work?/ppHead over to github.com/villagesql/villagesql-server and foll [...]

Published Sunday, 08. February 2026 19:38 • 21 days ago

Wireshark now can decode MySQL X Protocol ^{(from Daniël's Database Blog)}

pThe new protocol dissector for X Protocol in MySQL was just merged to the master branch in Wireshark. To get it build Wireshark from the master branch or wait for the next release./ppThis protocol is using Google Protobuf, which makes it much easier to work with than the regular MySQL protocol./ppSee also: dev.mysql.com/doc/dev/mysql-server/latest/page_mysqlx_protocol.html /ppIf you like what [...]

Published Sunday, 08. February 2026 17:40 • 21 days ago | Updated Sunday, 08. February 2026 17:40 • 21 days ago

Bringing GenAI to Every MySQL Instance: ProxySQL v4.0 ^{(from ProxySQL Blog)}

pThe Problem with "Just Migrate" Most organizations are sitting on MySQL deployments they can't easily change — a mix of community editions, managed cloud services, and legacy versions. Teams want RAG pipelines and natural language querying, but adding AI capabilities typically means schema migrations, new vector database infrastructure, dual-write synchronization headaches, and AI logic sprawled [ [...]

Published Sunday, 08. February 2026 16:14 • 21 days ago

How much space does NULL need? ^{(from Shinguz's Blog)}

pThe last time I consulted a customer, he came up to me beaming with joy and said that he had taken my advice and changed all the primary key columns from codeBIGINT/code (8 bytes) to codeINT/code (4 bytes) and that had made a big difference! His MySQL 8.4 database is now 750 Gbyte smaller (from 5.5 Tbyte). Nice!/p pAnd yes, I know that contradicts the recommendations of some of my PostgreSQL colle [...]

Published Sunday, 08. February 2026 15:15 • 21 days ago

Someone is deleting my shared memory segments! ^{(from Shinguz's Blog)}

pWhen we work with PostgreSQL under our myEnv, we regularly get shared memory segment errors. Example:/p precodepsql: error: connection to server on socket "/tmp/.s.PGSQL.5433" failed: FATAL: could not open shared memory segment "/PostgreSQL.4220847662": No such file or directory /code/prepor we see similar messages in the PostgreSQL error log:/p precodeERROR: could not open shared [...]

Published Sunday, 08. February 2026 05:27 • 22 days ago

Visualizing MySQL BLOB Internals Directly from MySQL Data Files (.ibd) ^{(from Zhao Song's Blog)}

In a previous post, I explored how MySQL implements partial updates and multi-versioning for BLOB columns internally. [...]

Published Sunday, 08. February 2026 00:00 • 22 days ago

FromDual Backup and Recovery Manager ^{(from Shinguz's Blog)}

pComing soon…/p pHave also a look at the Backup and Recovery Manager Documentation./p [...]

Published Saturday, 07. February 2026 19:17 • 22 days ago

Load CSV files into the database ^{(from Shinguz's Blog)}

pRecently, I wanted to display the places of residence of the members of my club on a map for a personal gimmick (IGOC members). I knew the addresses of the club members. But not the coordinates of their places of residence./p pSo I went in search of the coordinates and found what I was looking for at the Federal Office of Topography (swisstopo)./p pThe data is available there as a CSV file. Detail [...]

Published Friday, 06. February 2026 17:04 • 23 days ago

ClickHouse scaling and sharding best practices ^{(from Severalnines Blog)}

pClickHouse is a core engine for real-time analytics, powering critical functions like event ingestion, observability, customer analytics, and large-scale dashboards. However, scaling a ClickHouse cluster predictably while ensuring high availability, peak performance, and efficient resource utilization is challenging as workloads increase. Scaling involves complex planning beyond just adding nodes, [...]

Published Friday, 06. February 2026 15:39 • 23 days ago

How one space can create a nightmare for you… ^{(from SimplifieDB)}

As you know that MySQL 5.7 is going to be in its end of life this month (when I wrote this article) and many businesses are upgrading to 8 ( except few ones, believe me its true) . Many cloud vendors are providing extra support and time to their customer so that they can move … Continue reading How one space can create a nightmare for you… [...]

Published Friday, 06. February 2026 15:34 • 23 days ago

MariaDB Community Server Q1 2026 maintenance releases ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.8.6, 11.4.10, 10.11.16, and 10.6.25 maintenance releases. See […] [...]

Published Friday, 06. February 2026 15:06 • 23 days ago

And The Winners Of The Inaugural Top External Contributor To MariaDB Award are … ^{(from MariaDB Foundation Blog)}

pAnnouncing the winners of the first Top Contributor to MariaDB award/p pThe post And The Winners Of The Inaugural Top External Contributor To MariaDB Award are … appeared first on MariaDB.org./p [...]

Published Friday, 06. February 2026 13:10 • 23 days ago

MariaDB 11.8.6, 11.4.10, 10.11.16 and 10.6.25 now available ^{(from MariaDB Foundation Blog)}

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.8.6, MariaDB 11.4.10, MariaDB 10.11.16 and MariaDB 10.6.25, the latest stable releases in their respective long-term series (receiving regular maintenance and support for three years from their first stable release dates, and critical security fixes as source code releases for two additional years beyond). … /p pCon [...]

Published Friday, 06. February 2026 11:20 • 23 days ago

OpenClaw Memory Architecture: Building a Local-First RAG with SQLite ^{(from PingCAP Blog)}

pEditor’s Note: At PingCAP, we build distributed systems (TiDB), but we appreciate elegant engineering at any scale. OpenClaw demonstrates a perfect use case for local-first RAG databases: when you need zero-ops, total data privacy, and instant startup for a single user, SQLite is a highly pragmatic choice. We believe in choosing the right tool for […]/p pThe post OpenClaw Memory Architecture [...]

Published Friday, 06. February 2026 09:02 • 23 days ago

New binlog implementation in MariaDB 12.3 ^{(from MariaDB Foundation Blog)}

pI have recently completed a large project to implement a new improved binlog format for MariaDB. The result will be available shortly in the upcoming MariaDB 12.3.1 release. … /p pContinue reading \"New binlog implementation in MariaDB 12.3\"/p pThe post New binlog implementation in MariaDB 12.3 appeared first on MariaDB.org./p [...]

Published Friday, 06. February 2026 09:02 • 23 days ago

DB Fiddle – SQL Database Playground – now has MariaDB ^{(from MariaDB Foundation Blog)}

pWhen choosing a database, many times you want to play and see what it can do to see if it’s relevant. Containers are easy, but a web page is even easier. … /p pContinue reading \"DB Fiddle – SQL Database Playground – now has MariaDB\"/p pThe post DB Fiddle – SQL Database Playground – now has MariaDB appeared first on MariaDB.org./p [...]

Published Thursday, 05. February 2026 22:05 • 24 days ago

Extending MySQL 8.0 support in MySQL HeatWave ^{(from The Oracle MySQL Blog)}

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

Published Thursday, 05. February 2026 21:48 • 24 days ago

Why MySQL’s Integration with DuckDB is More Elegant Than PostgreSQL’s ^{(from Chen Zongzhi's Medium blog)}

♦pWe are currently seeing three mainstream solutions for integrating DuckDB with PostgreSQL: pg_duckdb, pg_mooncake, and pg_lake./ppHowever, I believe that MySQL, particularly with solutions like AliSQL, offers a much more elegant and effective approach./ppThe Challenges with PostgreSQL and DuckDB Integration/ppLet’s first examine the existing PostgreSQL solutions:/pp1. pg_duckdb: This is the offic [...]

Published Thursday, 05. February 2026 12:35 • 24 days ago

Introducing VillageSQL: A New Path for MySQL in the Agentic AI Era ^{(from VillageSQL)}

pMySQL is the world's most popular open-source database by many measures but a persistent innovation gap has emerged. This gap causes developers to select other databases over MySQL for new application development, particularly when AI is involved. Today, we are launching VillageSQL to close that gap and empower/p [...]

Published Thursday, 05. February 2026 05:38 • 25 days ago

Claude Code 改写 PostgreSQL 内核, Full Page Write vs Doublewrite Buffer, 性能差 3 倍 ^{(from Chen Zongzhi's GitHub blog)}

2026 年了, AI 能改数据库内核代码么? 我用 Claude Code 把 PostgreSQL 的 Full Page Write 换成了 MySQL 的 Doublewrite Buffer, 跑出来性能差了 3 倍. [...]

Published Thursday, 05. February 2026 00:00 • 25 days ago

January Product Update ^{(from Readyset Blog)}

♦pLet’s dive into our first product update of 2026!/p💬 Product UpdatespReadyset Core/pulliMySQL Replication Server UUID Support: Added the --replication-server-uuid option to set a server UUID in MySQL. This UUID is now reported in SHOW REPLICAS./liliOOM Prevention for Large Parameterized IN Predicates: Fixed potential out-of-memory/li/ul [...]

Published Wednesday, 04. February 2026 18:00 • 25 days ago

Announcing MariaDB Cloud BYOA: Fully Managed MariaDB in Your Azure Subscription ^{(from MariaDB Corporation Blog)}

The Evolution of Cloud Databases The shift to cloud databases fundamentally changed how we run production environments. By offloading the […] [...]

Published Wednesday, 04. February 2026 16:42 • 25 days ago

VillageSQL Raises $35M to Reignite Innovation in MySQL ^{(from VillageSQL)}

pToday, we are excited to launch VillageSQL to give the MySQL community a new path forward by enabling permissionless innovation via extensions. As founders with decades of experience building databases and storage infrastructure at Google and Amazon, we created VillageSQL to reignite innovation in MySQL. We have an experienced team/p [...]

Published Wednesday, 04. February 2026 16:00 • 25 days ago

Introducing Tungsten Cluster & Tungsten Replicator v7.2.1 ^{(from Continuent Blog)}

Overview of the Tungsten Cluster and Tungsten Replicator v7.2.1 release, highlighting configuration safety improvements, command-line enhancements, real-time replication performance monitoring, and important stability and security fixes.Tags: tungsten clustertungsten replicatorReleasereplication performance monitoringconfiguration management [...]

Published Wednesday, 04. February 2026 15:39 • 25 days ago

4 self-contained databases for your apps ^{(from InfoWorld)}

pFor any application that works with a lot of data, the obvious approach is to store it in some kind of database. Depending on your ambitions, that can be something as modest as SQLite, or as upscale as PostgreSQL./p pWhat often complicates things is not which database to use, but how to use it. Enterprise-scale databases like PostgreSQL give you great power but impose an [...]

Published Wednesday, 04. February 2026 09:00 • 25 days ago

为什么我认为 MySQL 比 PostgreSQL 集成 DuckDB 更加的优雅? ^{(from Chen Zongzhi's GitHub blog)}

我们看到目前有 3 个主流 PostgreSQL 集成 DuckDB 的方案在运行 pg_duckdb,pg_mooncake, pg_lake. [...]

Published Wednesday, 04. February 2026 00:00 • 26 days ago

New binlog implementation in MariaDB 12.3 ^{(from Kristian Nielsen's blog)}

I have recently completed a large project to implement a new improved binlog format for MariaDB. The result will be available shortly in the upcoming MariaDB 12.3.1 release. In this article, I will give a short overview of the new binlog implementation. For more details, check the documentation which is in the source tree as… Continue reading New binlog implementation in MariaDB 12.3 [...]

Published Tuesday, 03. February 2026 19:08 • 26 days ago

Amazon RDS now provides an enhanced console experience to connect to a database ^{(from AWS What's New)}

pAmazon RDS now provides an enhanced console experience that consolidates and provides all relevant information needed to connect to a database in one place, making it easier to connect to your RDS databases.br br The new console experience provides ready-made code snippets for Java, Python, Node.js and other programming languages as well as tools like the psql command line utility. These code snip [...]

Published Tuesday, 03. February 2026 19:06 • 26 days ago

Reading the Room: What Europe’s MySQL Community Is Really Saying ^{(from MariaDB Foundation Blog)}

pFOSDEM was exciting from a MariaDB perspective for many reasons this year. For this blog, let me concentrate on one aspect: The discussions at what was called the “Summit for MySQL Community, Europe”, hosted by Percona on Monday 2 Feb 2026 at the Marriott Grand Place in central Brussels. … /p pContinue reading \"Reading the Room: What Europe’s MySQL Community Is Really Saying\"/p [...]

Published Tuesday, 03. February 2026 18:55 • 26 days ago

/brutal-review and the new 80/20 rule ^{(from Readyset Blog)}

How we use /brutal-review: a four-perspective Claude Code command that catches bugs humans miss by spending tokens on quality. [...]

Published Tuesday, 03. February 2026 18:00 • 26 days ago

Announcing the New Tungsten University Training Sessions — Now Live ^{(from Continuent Blog)}

Explore the new Tungsten University training sessions for Tungsten Cluster, Tungsten Replicator, and Tungsten Operator. Learn from Continuent engineers through structured master classes covering MySQL HA, replication, Kubernetes, and real-world production operations.Tags: Tungsten UniversityTrainingtungsten clustertungsten replicatorTungsten Operator [...]

Published Tuesday, 03. February 2026 16:30 • 26 days ago

Teaching AI Agents to Speak “Production” SQL: Introducing TiDB Skills ^{(from PingCAP Blog)}

pAI coding agents are excellent at producing code that “works on my machine”. But as every database engineer knows, there is a massive gap between a query that runs in a local Docker container and one that survives in a high-concurrency production environment. We keep seeing the same issues arise when agents generate SQL based […]/p pThe post Teaching AI Agents to Speak “Productio [...]

Published Tuesday, 03. February 2026 13:10 • 26 days ago

How to Test ProxySQL Read/Write Split with sysbench ^{(from Rendiment)}

Configure sysbench and ProxySQL correctly to test read/write split with PXC. Why default sysbench sends all queries to writers and how to fix it. [...]

Published Tuesday, 03. February 2026 05:00 • 27 days ago

Connect Agents to your Hosted Dolt Instance using MCP ^{(from DoltHub Blog)}

You can now enable dolt mcp on your Hosted Dolt instances to connect them to your agentic workloads. [...]

Published Tuesday, 03. February 2026 00:00 • 27 days ago

Amazon RDS for MySQL now supports new minor versions 8.0.45 and 8.4.8 ^{(from AWS What's New)}

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports MySQL minor versions 8.0.45 and 8.4.8, the latest minors released by the MySQL community. We recommend upgrading to the newer minor versions to fix known security vulnerabilities in prior versions of MySQL and to benefit from bug fixes, performance improvements, and new functionality added by the MySQL community. Learn more abo [...]

Published Monday, 02. February 2026 18:47 • 27 days ago

The Fire-and-Forget Pattern: Scaling Game Analytics with TiDB Cloud and Convex ^{(from PingCAP Blog)}

pThree developers, one hackathon, and a viral meme turned into a mission. This is the story of B40 Life Simulator, a financial literacy game inspired by the real B40 experience and the financial struggles faced by Malaysian youth. It balances social impact with a clever technical strategy. By pairing Convex for real-time gameplay with TiDB […]/p pThe post The Fire-and-Forget Pattern: Scaling [...]

Published Monday, 02. February 2026 08:36 • 28 days ago

How to Build a Voice-to-Text App That Learns Your Style (Without Storing Your Words) ^{(from PingCAP Blog)}

pI’m a fast talker, but standard tools treat every platform like a dry JIRA ticket. To fix this, I dived into Chrome extension development to create Speak It: a voice-to-text app that learns your style without recording your secrets. Using privacy-first AI, the system maps a “fingerprint” of your speech—focusing on formality and sentence length—rather […]/p pThe post How to [...]

Published Friday, 30. January 2026 22:55 • 30 days ago

Oracle seeks to build bridges with MySQL developers ^{(from The Register)}

Big Red promises 'new era' as long-frustrated contributors weigh whether to believe it pOracle is taking steps to "repair" its relationship with the MySQL community, according to sources, by moving "commercial-only" features into the database application's Community Edition and prioritizing developer needs.…/p [...]

Published Friday, 30. January 2026 14:42 • 1 months ago

No More Hidden Changes: How MySQL 9.6 Transforms Foreign Key Management ^{(from The Oracle MySQL Blog)}

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

Published Friday, 30. January 2026 11:54 • 1 months ago

TiDB Partitioning ^{(from Mydbops Blog)}

Learn how TiDB partitioning handles large datasets. Explore Range, List, Hash, and Key partitioning types, global indexes, and management techniques to optimize query performance and scaling. [...]

Published Friday, 30. January 2026 11:40 • 1 months ago

What if OpenAI Used MariaDB Instead of PostgreSQL to Handle 800 Million Users? ^{(from MariaDB Corporation Blog)}

OpenAI’s journey to scale its infrastructure has provided valuable insights into the limitations and scaling challenges of traditional database systems, […] [...]

Published Thursday, 29. January 2026 19:19 • 1 months ago

Rebuilding a Replica with MyDumper ^{(from Percona Database Blog)}

♦When a replica fails due to corruption or drift, the standard solution is to rebuild it from a fresh copy of the master when pt-table-sync is not an option. Traditionally, when we need to build a new replica, we use a physical backup for speed, but there are some cases where you still need logical […] [...]

Published Thursday, 29. January 2026 14:40 • 1 months ago

The concepts of forking ^{(from Monty says)}

Lately there has been a lot of discussion about “hard” or “soft” forks related to MySQL. As someone who has done a successful fork of MySQL, I think this is both confusing and trivialising the concept of forking.brIn my previous blog, I did touch a bit on this topic, but it looks like some more clarifications are needed.brWhen we did the initial fork of MariaDB from MySQL, we tried our best t [...]

Published Thursday, 29. January 2026 09:46 • 1 months ago | Updated Thursday, 29. January 2026 09:46 • 1 months ago

TiDB Online DDL ^{(from Mydbops Blog)}

Learn how TiDB handles Online DDL without table locks. Explore the architecture, state transitions, and the Distributed Execution Framework (DXF) that enable zero-downtime schema evolution. [...]

Published Thursday, 29. January 2026 08:57 • 1 months ago

Introducing the PlanetScale MCP server ^{(from PlanetScale Blog)}

Connect Claude, Cursor, and other AI tools directly to your PlanetScale database to optimize schemas, debug queries, and monitor app performance. [...]

Published Thursday, 29. January 2026 00:00 • 1 months ago

How to Reset MySQL Root Password ^{(from RoseHosting Blog)}

pIn this blog post, we will show you how to reset the MySQL root Password on a Linux operating system. ... /p pRead More/p pThe post How to Reset MySQL Root Password appeared first on RoseHosting./p [...]

Published Wednesday, 28. January 2026 18:30 • 1 months ago

Claude + GitHub: An Experiment on Engineering Productivity ^{(from siddontang on Medium)}

pWith the arrival of AI, I’ve been repeatedly thinking about one question:/pblockquoteHas the productivity of our engineers actually improved — or do they just look busier than before?/blockquotepAt TiDB, almost all engineering work happens around GitHub:/ppwriting code, filing issues, opening PRs, doing reviews, collaborating with others./ppSo a very natural idea emerged:/pblockquoteIf we systemat [...]

Published Wednesday, 28. January 2026 02:11 • 1 months ago

Why sysbench‑tpcc results on outdated hardware should not be presented as a valid OLTP vendor comparison ^{(from MariaDB Foundation Blog)}

pBenchmark results only have meaning when the workload, hardware, and methodology are clearly defined and reproducible. When those elements are unclear or incomplete, the conclusions can easily mislead readers into assuming the results represent something they do not. … /p pContinue reading \"Why sysbench‑tpcc results on outdated hardware should not be presented as a valid OLTP vendor c [...]

Published Tuesday, 27. January 2026 21:16 • 1 months ago

Seamless TiDB Cloud Upgrades: Replicating Production Workloads with Traffic Replay ^{(from PingCAP Blog)}

pDatabase upgrades are often a source of “performance anxiety.” Even with extensive testing, the gap between a sterile staging environment and the chaotic reality of production—characterized by shifting SQL parameters, bursty concurrency, and complex execution contexts—often leads to unexpected post-upgrade regressions. Traffic Replay on TiDB Cloud, an internal-only tool currently in de [...]

Published Tuesday, 27. January 2026 19:59 • 1 months ago

Amazon RDS for PostgreSQL, MySQL and MariaDB now support r6id and r6gd database instances in additional AWS Regions ^{(from AWS What's New)}

pAWS memory optimized R6id database instances are now generally available for Amazon RDS for PostgreSQL, MySQL, and MariaDB in the Tel Aviv region. R6gd instances are now supported for Amazon RDS for PostgreSQL, MySQL, and MariaDB in Asia Pacific (Osaka), and EU (Spain, Zurich) regions.br br AWS Graviton2-based instances provide up to 40% performance improvement over R5-based instances of equ [...]

Published Tuesday, 27. January 2026 17:00 • 1 months ago

We are hiring at ProxySQL! ^{(from ProxySQL Blog)}

pProxySQL is a high-performance, highly-available protocol-aware proxy for MySQL, PostgreSQL, and wire-compatible products including RDS, RDS Aurora, Percona Server, MariaDB, ClickHouse, TimescaleDB, CockroachDB, Google Cloud SQL and Azure Database. We're growing and seeking talented people to contribute to ProxySQL's development while delivering best-in-class solutions to our subscription and supp [...]

Published Tuesday, 27. January 2026 15:37 • 1 months ago

The Hidden Complexity of Postgres Scaling Architectures ^{(from Readyset Blog)}

OpenAI recently shared how they scale Postgres with application-layer caching. This post examines the hidden complexity and a simpler solution. [...]

Published Tuesday, 27. January 2026 15:14 • 1 months ago

Automatic “Multi-Source” Async Replication Failover Using PXC Replication Manager ^{(from Percona Database Blog)}

♦The replication manager script can be particularly useful in complex PXC/Galera topologies that require Async/Multi-source replication. This will ease the auto source and replica failover to ensure all replication channels are healthy and in sync. If certain nodes shouldn’t be part of a async/multi-source replication, we can disable the replication manager script there to tightly controlled the [...]

Published Tuesday, 27. January 2026 14:04 • 1 months ago

Scoped Vector Search with the MyVector Plugin for MySQL — Part III ^{(from AskDba)}

From Concepts to Production: Real-World Patterns, Query Plans, and What’s Next In Part I, we introduced scoped vector search in MySQL using the MyVector plugin, focusing on how semantic similarity and SQL filtering work together. In Part II, we explored schema design, embedding strategies, HNSW indexing, hybrid queries, and tuning — and closed with a […] [...]

Published Tuesday, 27. January 2026 09:30 • 1 months ago

July 2025 Recap: Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pNote (January 2026): The Business-Critical service tier referenced in this blog has been rebranded to Memory Optimized. This change reflects updated naming only; the underlying performance characteristics and use cases described here continue to apply./p p /p pWe're excited to share a summary of the Azure Database for MySQL updates from the last couple of months./p pJoin us live on [...]

Published Tuesday, 27. January 2026 09:18 • 1 months ago

What is the future for MySQL? ^{(from InfoWorld)}

pIn May of 2025, MySQL celebrated its 30th anniversary. Not many technology projects go strong for three decades, let alone at the level of use that MySQL enjoys. MySQL is listed at #2 on the DB-Engines ranking, and it is listed as the most deployed relational database by technology installation tracker 6sense./p pYet for all its use, MySQL is seen as taking a back seat to [...]

Published Tuesday, 27. January 2026 09:00 • 1 months ago

Azure Database for MySQL 8.4 Now Generally Available ^{(from Azure for MySQL Blog)}

pNote (January 2026): The Business-Critical service tier referenced in this blog has been rebranded to Memory Optimized. This change reflects updated naming only; the underlying performance characteristics and use cases described here continue to apply./p pWe’re excited to announce that Azure Database for MySQL – Flexible Server now supports MySQL 8.4 in General Availability (GA). This me [...]

Published Tuesday, 27. January 2026 08:49 • 1 months ago

MySQL 8 Asynchronous Replication Failover ^{(from Mydbops Blog)}

Learn how to configure the Asynchronous Connection Failover mechanism in MySQL 8 to minimize downtime. We cover architecture, UDFs, and a step-by-step setup example. [...]

Published Tuesday, 27. January 2026 05:18 • 1 months ago

IO-bound Insert Benchmark vs MySQL on 24-core and 32-core servers ^{(from Small Datum)}

pThis has results for MySQL versions 5.6 through 9.5 with an IO-bound Insert Benchmark on 24-core and 32-core servers. The workload uses IO-bound workload. Results for a CPU-bound workload are here./ppMySQL often has large performance regressions at low concurrency from new CPU overhead while showing large improvements at high concurrency from less mutex contention. The tests here use med [...]

Published Wednesday, 21. January 2026 20:13 • 1 months ago | Updated Monday, 26. January 2026 18:38 • 1 months ago

Comparing Data When Migrating Databases With GoldenGate Veridata: Installation Guide ^{(from dbi Blog)}

pMore often than not, migrating a database is not much about moving the data but about ensuring that nothing was lost in the process. In all migration projects, a DBA will have to answer the following question: “Is my target database really identical to the source ?“ This is what Oracle GoldenGate Veridata was made […]/p pL’article Comparing Data When Migrating Databases With Gold [...]

Published Monday, 26. January 2026 07:44 • 1 months ago

tpc-c Benchmarking of MySQL 8.0.44 ^{(from SimplifieDB)}

This setup is on my local machine for mac with 8.0.44. M2 chip, memory 16G High level Results : total transaction executed in 10 min – 247298Transaction per minute – 24729Time taken on average for every case – 0-26ms ( you have to do this calculation , testing wont tell you this. I have done … Continue reading tpc-c Benchmarking of MySQL 8.0.44 [...]

Published Sunday, 25. January 2026 21:03 • 1 months ago

MariaDB is the natural replacement for MySQL ^{(from MariaDB Foundation Blog)}

pMariaDB is the natural replacement for MySQL. Why? Because it is the organic continuation of the MySQL that conquered the Internet. MySQL 8.0 is a fork of that foundation, while MariaDB stayed on track. … /p pContinue reading \"MariaDB is the natural replacement for MySQL\"/p pThe post MariaDB is the natural replacement for MySQL appeared first on MariaDB.org./p [...]

Published Sunday, 25. January 2026 20:14 • 1 months ago

joins... joins... everywhere ^{(from TusaCentral - MySQL Blogs)}

p /p p♦/p pI have a curse. My curse is curiosity. /p pHere in Percona I found one person that is very “dangerous” for me, and he and I also share the same first name, well almost, Marcos Albe. /p pMarcos is a smart guy with a lot of ideas, and he is not shy to share them. One day we were talking about sysbench, and he mentioned to me: you know it would be nice to have a test for joins in sysbench. [...]

Published Sunday, 25. January 2026 17:15 • 1 months ago

The 10 TB Scale Survival Guide for Percona Operator PXC on Kubernetes ^{(from TusaCentral - MySQL Blogs)}

p"What happens when you run a 10 TB MySQL database on Kubernetes?" /p pbrThat's the question many of our customers and users asked and honestly, we were extremely curious ourselves. ♦/p pSo, we ditched the weekend plans, rolled up our sleeves, and jumped down the rabbit hole. What we found was far more challenging (and perhaps a bit more "psychedelic") than expected. We spent days rigorously testin [...]

Published Sunday, 25. January 2026 16:06 • 1 months ago

MySQL January 2026 Performance review ^{(from TusaCentral - MySQL Blogs)}

pThis article is focused on describing the latest performance benchmarking executed on the latest releases of Community MySQL, Percona Server for MySQL and MariaDB. /p pIn this set of tests I have used the machine described here. /p Assumptions pThere are many ways to run tests, and we know that results may vary depending on how you play with many factors, like the environment or the MySQL server s [...]

Published Sunday, 25. January 2026 15:43 • 1 months ago

A POC on optimizing MySQL’s unique index insertion path ^{(from Zhao Song's Blog)}

A few months ago, I wrote a post about a possible optimization in MySQL’s unique index insertion path. As illustrated there, the idea is to reduce the current 3 B+Tree searches into 1 B+Tree search plus a scan on the leaf page (or leaf level), in order to avoid the overhead of repeatedly traversing the tree. This weekend, I implemented a quick proof-of-concept on MySQL 8.0.45 and measure the effect [...]

Published Sunday, 25. January 2026 00:00 • 1 months ago

当 MySQL 遇到 DuckDB ^{(from Chen Zongzhi's GitHub blog)}

MySQL的插件式存储引擎架构 [...]

Published Saturday, 24. January 2026 00:00 • 1 months ago

As Oracle loses interest in MySQL, devs mull future options ^{(from The Register)}

As Big Red's governance of the popular database comes into question, contributors to MySQL consider wresting control pDevelopers in the MySQL community are working together to challenge Oracle to improve transparency and commitment in its handling of the popular open source database, while considering other options, including forking the code.…/p [...]

Published Friday, 23. January 2026 13:33 • 1 months ago

MySQL January 2026 Performance Review ^{(from Percona Database Blog)}

♦This article is focused on describing the latest performance benchmarking executed on the latest releases of Community MySQL, Percona Server for MySQL and MariaDB. In this set of tests I have used the machine described here. Assumptions There are many ways to run tests, and we know that results may vary depending on how you […] [...]

Published Friday, 23. January 2026 13:31 • 1 months ago

Building and testing MySQL 8.0.45, 8.4.8, and 9.6.0 on macOS ^{(from Laurynas Biveinis' blog)}

p Oracle has just released MySQL 8.0.45, 8.4.8, and 9.6.0 and here are the results of my usual testing of building them and running the testsuite on macOS, Apple Silicon hardware. /p Build p All three versions compile with the current XCode (26.2) OK. With Homebrew-packaged LLVM, versions 14 to 17 inclusive are getting a strange CMake error that might have more to do with macOS than MySQL. LLVM 1 [...]

Published Friday, 23. January 2026 12:39 • 1 months ago | Updated Friday, 23. January 2026 12:39 • 1 months ago

Writing a Go SQL driver ^{(from DoltHub Blog)}

Take a tour of Go's SQL driver implementation and see how it works in Dolt's embedded SQL driver. [...]

Published Friday, 23. January 2026 00:00 • 1 months ago

Separating FUD and Reality: Has MySQL Really Been Abandoned? ^{(from Percona Database Blog)}

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

Published Thursday, 22. January 2026 14:34 • 1 months ago

SQL Savepoints and When to Use Them ^{(from Vettabase)}

Not many developers know about savepoints in relational databases. Even less of them know when to use them. It’s not their fault: I can’t remember seeing a good explanation of this feature. Let’s try to clarify this lesser-known functionality. In this article I’m using MariaDB syntax. But the concepts are very similar for other transactional databases. To know the exact synt [...]

Published Thursday, 22. January 2026 10:03 • 1 months ago

Native Password Legacy for 9.6 ^{(from lefred's blog)}

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

Published Thursday, 22. January 2026 09:55 • 1 months ago

Where can you find MySQL during January to April 2026 ^{(from The Oracle MySQL Blog)}

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

Published Thursday, 22. January 2026 08:15 • 1 months ago

Memory Fragmentation in Linux: What It Is, Why It Hurts, and How to Fix It ^{(from PingCAP Blog)}

pManaging memory in a high-performance database environment isn’t just about having enough RAM; it’s about how that RAM is organized. For SREs and DBAs, understanding the nuances of the Linux kernel’s memory management can be the difference between a smooth-running system and unpredictable tail latency. In this post, we’ll break down the core mechanics of […]/p pThe post Memory Fr [...]

Published Thursday, 22. January 2026 08:00 • 1 months ago

Redefining High Availability: Introducing MariaDB Advanced Cluster Technical Preview ^{(from MariaDB Corporation Blog)}

[...]

Published Wednesday, 21. January 2026 19:01 • 1 months ago

Automate the export of Amazon RDS for MySQL or Amazon Aurora MySQL audit logs to Amazon S3 with batching or near real-time processing ^{(from AWS Database Blog)}

Amazon RDS for MySQL and Amazon Aurora MySQL provide built-in audit logging capabilities, but customers might need to export and store these logs for long-term retention and analysis. Amazon S3 offers an ideal destination, providing durability, cost-effectiveness, and integration with various analytics tools. In this post, we explore two approaches for exporting MySQL audit logs to Amazon S3: eithe [...]

Published Wednesday, 21. January 2026 17:56 • 1 months ago

CPU-bound Insert Benchmark vs MySQL on 24-core and 32-core servers ^{(from Small Datum)}

pThis has results for MySQL versions 5.6 through 9.5 with a CPU-bound Insert Benchmark on 24-core and 32-core servers. The workload uses a cached database so it is often CPU-bound but on some steps does much write IO. /ppResults from a small server are here and note that MySQL often has large performance regressions at low concurrency from new CPU overhead while showing large improve [...]

Published Tuesday, 20. January 2026 19:18 • 1 months ago | Updated Wednesday, 21. January 2026 17:47 • 1 months ago

Active-Active MySQL Replication: The Pros, Cons, and Reality ^{(from Continuent Blog)}

An in-depth analysis of active-active MySQL replication, examining its benefits, operational risks, conflict scenarios, and practical guidance on when multi-primary designs make sense—and when they do not.Tags: active-activeArchitectureHigh Availability [...]

Published Wednesday, 21. January 2026 17:08 • 1 months ago

MariaDB doesn't depend on MySQL ^{(from Programming Brain)}

Thoughts on how MariaDB is incorrectly perceived merely as a fork of MySQL and how MariaDB is independent from MySQL yet highly compatible [...]

Published Wednesday, 21. January 2026 17:07 • 1 months ago

ProxySQL 3.0.5: Security hardening, protocol fixes, and smoother operations ^{(from ProxySQL Blog)}

pProxySQL 3.0.5: Security hardening, PostgreSQL protocol fixes, and smoother operations We’re excited to announce ProxySQL 3.0.5, our first release of 2026. As always, thank you to everyone who tested, reported issues, sent patches, and shared real-world feedback. ProxySQL is shaped in production, and this release is a direct result of that collaboration. ProxySQL 3.0.5 [...]/p pThe post ProxySQL 3 [...]

Published Tuesday, 20. January 2026 22:17 • 1 months ago

Amazon Aurora and RDS for PostgreSQL, MySQL and MariaDB now support r8g, r7g, and r7i database instances in additional AWS Regions ^{(from AWS What's New)}

pAWS Graviton4-based R8g database instances are now generally available for Amazon Aurora (MySQL and PostgreSQL compatibility) and Amazon RDS for PostgreSQL, MySQL, and MariaDB in additional Asia Pacific regions (Hong Kong, Osaka, and Jakarta). R8G instances are now supported for Amazon Aurora with MySQL compatibility and Amazon RDS for PostgreSQL, MySQL, and MariaDB in Asia Pacific (Seoul and Sing [...]

Published Tuesday, 20. January 2026 15:00 • 1 months ago

What Oracle Missed, We Fixed: More Performant Query Processing in Percona Server for MySQL, Part 2 ^{(from Percona Database Blog)}

♦Remember when Percona significantly improved query processing time by fixing the optimizer bug? I have described all the details in More Performant Query Processing in Percona Server for MySQL blog post. This time, we dug deeper into all the ideas from Enhanced for MySQL and based on our analysis, we proposed several new improvements. All […] [...]

Published Tuesday, 20. January 2026 13:21 • 1 months ago

Vettabase and HammerDB Partner to de-Risk Database Migrations ^{(from Vettabase)}

Vettabase and HammerDB are announcing a partnership to de-risk and assist database migrations. As vendor-independent companies that offer services for multiple database technologies, Vettabase and HammerDB intend to help organisations in the delicate move of changing their database systems. For many teams, a migration to another database is a logical option — but it comes with real concerns: Our pa [...]

Published Tuesday, 20. January 2026 09:14 • 1 months ago

Using Dolt with ORMs ^{(from DoltHub Blog)}

Object-Relational Mappers (ORMs) simplify application development by abstracting database interactions, and they pair naturally with Dolt, a MySQL-compatible, version-controlled relational database. This post explains how ORMs work with Dolt, highlighting tested integrations, useful Dolt features like schema overrides and nonlocal tables, and important considerations around branching and connection [...]

Published Tuesday, 20. January 2026 00:00 • 1 months ago

MySQL 8.4 disables AHI – Why and What you need to know ^{(from Kedar MySQL Blog)}

pMySQL 8.4 changed the InnoDB adaptive hash index (innodb_adaptive_hash_index) default from ON to OFF, a major shift after years of it being enabled by default. Note that the MySQL adaptive hash index (AHI) feature remains fully available…/p The post MySQL 8.4 disables AHI – Why and What you need to know first appeared on Change Is Inevitable. [...]

Published Monday, 19. January 2026 18:18 • 1 months ago

MySQL Alternatives at Scale: Why TiDB Beats MariaDB ^{(from PingCAP Blog)}

pDive deep into two popular MySQL alternatives and discover why TiDB is a better option for extreme scalability and real-time analytics./p pThe post MySQL Alternatives at Scale: Why TiDB Beats MariaDB appeared first on TiDB./p [...]

Published Monday, 19. January 2026 15:34 • 1 months ago

Distributed, Multi-Database Transactions Involving MariaDB and PostgreSQL ^{(from Vettabase)}

In some situations, an application needs to run a single logical transaction that involves multiple database technologies: in our example, they’ll be MariaDB and PostgreSQL. This is not an optimal scenario and I’m not recommending to design systems in this way. But it’s simply a situation that you might have to deal with in real life, for various reasons that are outside of the sc [...]

Published Monday, 19. January 2026 12:12 • 1 months ago

ClusterControl Kubernetes Database Operator Management now GA ^{(from Severalnines Blog)}

pStandardize operator-driven database ops with GitOps while keeping Kubernetes and traditional environments under one roof. Kubernetes database operators are maturing, becoming the default way to run databases in-cluster. They bring automation, self-healing patterns, and declarative lifecycle management, but they also introduce new complexity: operator-specific CRDs, dependencies, and “one-off” way [...]

Published Monday, 19. January 2026 08:00 • 1 months ago

We, Programmers, the Future? ^{(from siddontang on Medium)}

pSome time ago, I saw a Tweet from Andrej Karpathy that really stuck with me:/pblockquoteI’ve never felt this much behind as a programmer./blockquotepAt the time, I didn’t feel much anxiety./ppIf anything, I felt confident. I believed that as long as I could use AI well, I would keep iterating and improving. After all, I am still the builder of the code./ppBut recently, AI genuinely shook me for th [...]

Published Monday, 19. January 2026 01:08 • 1 months ago

Introducing Tungsten Dashboard v8.0.3 ^{(from Continuent Blog)}

Release announcement for Tungsten Dashboard v8.0.3 covering new certificate retrieval options, workflow and UI refinements, and targeted bug fixes that improve reliability in frequently changing cluster and certificate environments.Tags: tungsten dashboardupdatecertificatesusability [...]

Published Friday, 16. January 2026 15:49 • 1 months ago

Introducing MySQL Studio – Reducing the Barriers to Data Innovation ^{(from The Oracle MySQL Blog)}

MySQL Studio in Oracle Cloud Infrastructure MySQL Studio in Oracle Cloud Infrastructure (OCI) is a unified environment for working with MySQL and HeatWave features through a single, streamlined interface. It brings SQL authoring, AI-assisted chat, and Jupyter-compatible notebooks together with project-based organization to help teams get from database setup to productive analytics faster. The same [...]

Published Friday, 16. January 2026 15:49 • 1 months ago

Deploying Percona Operator for MySQL with OpenTaco for IaC Automation ^{(from Percona Database Blog)}

♦Deploying databases on Kubernetes is getting easier every year. The part that still hurts is making deployments repeatable and predictable across clusters and environments, especially from Continuous Integration(CI) perspective. This is where PR-based automation helps; you can review a plan, validate changes, and only apply after approval, before anything touches your cluster. If you’ve ever [ [...]

Published Friday, 16. January 2026 14:19 • 1 months ago

Making Featured Images: Agentic Art Direction ^{(from DoltHub Blog)}

The process of creating daily Dolt blog featured images using multiple AIs. [...]

Published Friday, 16. January 2026 00:00 • 1 months ago

Percona Operator for PostgreSQL 2025 Wrap Up and What We Are Focusing on Next ^{(from Percona Database Blog)}

♦In 2025, the Percona Operator for PostgreSQL put most of its energy into the things that matter when PostgreSQL is running inside real Kubernetes clusters: predictable upgrades, safer backup and restore, clearer observability, and fewer surprises from image and HA version drift. Backups and restores got more resilient and more controllable In March, Operator 2.6.0 […] [...]

Published Thursday, 15. January 2026 17:30 • 2 months ago

MySQL HA in Hybrid Cloud: Avoiding the Pitfalls ^{(from Continuent Blog)}

A practical guide to building MySQL high availability in hybrid cloud deployments, highlighting common failure points and proven design strategies for networking, replication, routing, and controlled failover.Tags: High Availabilityhybrid cloudArchitecturecross-site replicationfailover [...]

Published Thursday, 15. January 2026 08:34 • 2 months ago

Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

Sunday, 01. March 2026

Does Every PXC Node Need XtraBackup Installed? (from Another MySQL DBA)

Reflections on Product Quality — Quality in the AI Era (from siddontang on Medium)

Your AI Agent Forgot Everything. Here’s How We Fixed It. (from siddontang on Medium)

Saturday, 28. February 2026

ODBC Driver for MySQL: Open-Source vs Commercial (2026) (from Devart MySQL Tool Blog)

Determining the Correct innodb_buffer_pool_chunk_size (from Another Boring Tech Blog)

Foreign Keys and Schema Changes: The Constraint You Didn’t Plan For (from Rendiment)

Friday, 27. February 2026

SingleStore vs TiDB: A Guide to Choosing the Right Distributed SQL Database (from PingCAP Blog)

MariaDB Community Server 12.3 Will Include Galera Cluster (from MariaDB Corporation Blog)

SQLSTATE [HY000] [2006] Galera has gone away (from The consistent voice)

Operational guide to migrating to ClickHouse (from Severalnines Blog)

Improving Index Selection For Join Queries (from DoltHub Blog)

Video Conferencing with Postgres (from PlanetScale Blog)

Thursday, 26. February 2026

Solving the Distributed Backup Headache: How TiDB Delivers Transactional Consistency (from PingCAP Blog)

A Friendly Reset: Understanding the MariaDB Foundation’s Role (from lefred's blog)

Introducing MariaDB Enterprise Cluster on MariaDB Cloud (from MariaDB Corporation Blog)

Introducing Tungsten Cluster & Tungsten Replicator v8.0.3 (from Continuent Blog)

Wednesday, 25. February 2026

More than Flushing (also Caching) for innodb_flush_method, and Missing Release Candidate (from J-F Gagné's MySQL Blog)

What’s New At Releem - January 2026 (from Releem Blog)

Percona Operator for MongoDB 1.22.0: Automatic Storage Resizing, Vault Integration, Service Mesh Support, and More! (from Percona Database Blog)

The Rising Tide of Community Contributions to MariaDB Server (from MariaDB Foundation Blog)

The best new features in MariaDB (from InfoWorld)

ON DELETE CASCADE: The Foreign Key Change MySQL Doesn’t Log (from Rendiment)

Tuesday, 24. February 2026

Amazon RDS Snapshot Export to S3 now available in AWS GovCloud (US) Regions (from AWS What's New)

Vibe Coding a High-Performance App with Readyset QueryPilot (from Readyset Blog)

SQL history lesson with Oracle V2 (from Daniël's Database Blog)

A checklist for enterprise database success (from InfoWorld)

MariaDB innovation: vector index performance (from Small Datum)

Monday, 23. February 2026

Always Have an Exit Strategy: dbsafe Automatic Rollback Plans (from Rendiment)

How to Write a System Prompt (from DoltHub Blog)

Sunday, 22. February 2026

RAG Series – Embedding Versioning with pgvector: Why Event-Driven Architecture Is a Precondition to AI data workflows (from dbi Blog)

When MySQL Rebuilds Your Table: Understanding COPY Algorithm DDL (from Rendiment)

MySQL + Neo4j for AI Workloads: Why Relational Databases Still Matter (from Another MySQL DBA)

Saturday, 21. February 2026

MySQL 8.0 JSON Functions: Practical Examples and Indexing (from Another MySQL DBA)

Zero-Downtime Schema Changes with MySQL 8.0 INSTANT DDL (from Rendiment)

Friday, 20. February 2026

Is MariaDB part of the MySQL ecosystem? (from MariaDB Foundation Blog)

Engineering the VillageSQL Extension Framework (VEF) (from VillageSQL)

How to Migrate Cloud PostgreSQL to On-Prem with Minimal Downtime (from Severalnines Blog)

TidesDB becomes Silver Sponsor of the MariaDB Foundation (from MariaDB Foundation Blog)

Your Time is All Messed Up: Time Implementations in Go (from DoltHub Blog)

Thursday, 19. February 2026

FromDual Performance Monitor 2.2.1 has been released (from Shinguz's Blog)

MariaDB innovation: binlog_storage_engine, small server, Insert Benchmark (from Small Datum)

What is MariaDB AI RAG and ​​what can I do with it? (from MariaDB Corporation Blog)

A Guide to Accelerating Your Application with Valkey: Caching Database Queries and Sessions (from Percona Database Blog)

MariaDB Foundation Releases Alpha of the Test Automation Framework (TAF) (from MariaDB Foundation Blog)

Community push intensifies to free MySQL from Oracle’s control amid stagnation fears (from InfoWorld)

Reflections on Product Quality — Rethinking the Role of the Quality Team (from siddontang on Medium)

Reflections on Product Quality — Wrong Practices in Patch Releases (from siddontang on Medium)

Faster PlanetScale Postgres connections with Cloudflare Hyperdrive (from PlanetScale Blog)

Wednesday, 18. February 2026

Replication Internals: Decoding the MySQL Binary Log - Part 1: Introduction and Data Types (from Readyset Blog)

Explaining why throughput varies for Postgres with a CPU-bound Insert Benchmark (from Small Datum)

Raft Region Size: The Invisible Lever for Distributed Database Performance (from PingCAP Blog)

Updated MariaDB R2DBC and Node.js Connectors now available (from MariaDB Corporation Blog)

UUID to BIN: problematic & solutions, POC (from lefred's blog)

Let’s go physical(ly separated) (from The consistent voice)

A battle for MySQL’s heart – and future? (from The Stack)

MariaDB Foundation Welcomes Epsio as a Silver Sponsor (from MariaDB Foundation Blog)

CPU-bound Insert Benchmark vs Postgres on 24-core and 32-core servers (from Small Datum)

Tuesday, 17. February 2026

Amazon Aurora MySQL 3.12 (compatible with MySQL 8.0.44) is now generally available (from AWS What's New)

Streamline Amazon RDS management with consolidation techniques – Part 1 (from AWS Database Blog)

Dear Oracle, we need to talk about the future of MySQL (from The Register)

An Open Letter to Oracle: Let’s Talk About MySQL’s Future (from Percona Database Blog)

As MySQL stagnates, its community sounds the alarm (from Techzine)

The Hidden Cost of Database Over-Provisioning (from PingCAP Blog)

MySQL Belgian Days and FOSDEM 2026: My Impressions (from TusaCentral - MySQL Blogs)

Reflections on Product Quality — Scenario Testing (from siddontang on Medium)