Planet for the MySQL Community

Best of Both Worlds: Introducing Readyset Shallow Cache ^{(from Readyset Blog)}

Introduce Readyset Shallow Cache: near-100% query coverage, TTL-based refresh, herd protection, and 1000x faster reads without code changes. [...]

Published Thursday, 05. March 2026 16:29 • 5 hours ago

Guide to Upgrade Azure Database for MySQL from 8.0 to 8.4 ^{(from Azure for MySQL Blog)}

pThis guide merges Azure official documentation and best practices from real-world upgrades. Always refer to the latest Azure documentation and portal/CLI for any updates or discrepancies./p 1. Background pWhy Upgrade?/p ul liMySQL 5.7 reached end of community support in October 2023, and will enter extended support in August 2026./li liMySQL 8.0 will reach end of community support in April 2026 an [...]

Published Thursday, 05. March 2026 14:00 • 7 hours ago

Mind the InnoDB Purge on Queue / Row Deletion Job (else slow queries) ^{(from J-F Gagné's MySQL Blog)}

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

Published Monday, 02. March 2026 19:47 • 3 days ago | Updated Thursday, 05. March 2026 13:52 • 7 hours ago

Row Deletion Jobs Done Right ^{(from J-F Gagné's MySQL Blog)}

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

Published Thursday, 05. March 2026 13:39 • 7 hours ago | Updated Thursday, 05. March 2026 13:47 • 7 hours ago

MySQL Replication Lag – Part 1: Theory and Internal Mechanics ^{(from Continuent Blog)}

A deep technical explanation of MySQL replication lag mechanics, covering the replication pipeline, network and apply-stage bottlenecks, throughput imbalance, and the impact of different replication models on latency and availability.Tags: replicationtheoryPerformance Tuning [...]

Published Thursday, 05. March 2026 09:18 • 12 hours ago

Announcing Extended Support for Azure Database for MySQL ^{(from Azure for MySQL Blog)}

blockquote pℹ️ Important Note (March 2026): Based on customer feedback requesting additional time to complete major version upgrades, we have extended the grace period before extended support billing begins for Azure Database for MySQL: /p ul liMySQL 5.7: Extended support billing start date moved from April 1, 2026 to August 1, 2026. /li /ul ul liMy [...]

Published Thursday, 05. March 2026 07:45 • 13 hours ago

How to Build an AI App That Simulates Life Decisions ^{(from PingCAP Blog)}

pFor most of 2025, I found myself trapped in an exhausting loop. Every few days, I’d open ChatGPT, Claude, or Gemini and ask the same question in slightly different ways: “Should I buy a house or keep renting?” The numbers seemed simple on the surface. My rent was $2,000 monthly. The mortgage would run around […]/p pThe post How to Build an AI App That Simulates Life Decisio [...]

Published Wednesday, 04. March 2026 20:42 • a day ago

Supercharge Your PostgreSQL with ProxySQL ^{(from ProxySQL Blog)}

pNext week, you can find several members of the ProxySQL team in Bengaluru at PG Conf India 2026. ProxySQL is a gold sponsor and will deliver a 3-hour tutorial titled "Supercharge Your PostgreSQL: A Hands-On Guide to High Availability and Connection Pooling with ProxySQL". Be sure to come by the booth and talk to us [...]/p pThe post Supercharge Your PostgreSQL with ProxySQL appeared first on Prox [...]

Published Wednesday, 04. March 2026 19:40 • a day ago

Replication Internals: Decoding the MySQL Binary Log Part 2: File Header and Common Event Header ^{(from Readyset Blog)}

Learn how to decode the MySQL binary log file header and 19-byte event header, including timestamps, event types, and replication metadata. [...]

Published Wednesday, 04. March 2026 15:00 • a day ago

The Queen of Naboo and Many Systems: MariaDB Server Ecosystem Hub ^{(from MariaDB Foundation Blog)}

pIn the royal court of Naboo, Queen Amidala received delegations from many worlds.br Some arrived as long-standing allies. Others were travelers whose routes simply crossed the planet’s orbit. … /p pContinue reading \"The Queen of Naboo and Many Systems: MariaDB Server Ecosystem Hub\"/p pThe post The Queen of Naboo and Many Systems: MariaDB Server Ecosystem Hub appeared first on MariaDB [...]

Published Wednesday, 04. March 2026 14:45 • a day ago

TiDB Performance Troubleshooting ^{(from MinervaDB Blog)}

TiDB Performance Troubleshooting: A Systematic Guide to Diagnosing Slow Queries, Hot Regions, and TiKV Bottlenecks TiDB’s distributed architecture offers exceptional scalability and high availability, but with complexity comes unique performance challenges. Whether you’re dealing with [...] [...]

Published Tuesday, 03. March 2026 19:55 • 2 days ago

What Exactly Is the MySQL Ecosystem? ^{(from Percona Database Blog)}

♦As we set out to help the MySQL ecosystem assert greater independence from Oracle by establishing a vendor-neutral industry association, we had to confront a deceptively simple question: What exactly is the MySQL ecosystem? There are many views on this question. Some argue it should revolve strictly around the MySQL brand—meaning MariaDB would be excluded. […] [...]

Published Tuesday, 03. March 2026 14:39 • 2 days ago

What the MariaDB Community Wants Next: A Look at Our MySQL-Compatibility Poll ^{(from lefred's blog)}

This post was originally published on MariaDB.org. We recently asked the community: “Which MySQL-compatibility feature would you most like to see in the next MariaDB release?” A big thank you to everyone who voted. We received 506 votes, and the results give us a helpful snapshot of which compatibility gaps feel most important to users […] [...]

Published Tuesday, 03. March 2026 14:20 • 2 days ago

The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite ^{(from Programming Brain)}

Features and performance are important when choosing databases, but so it is the “bus factor” risk [...]

Published Tuesday, 03. March 2026 14:01 • 2 days ago

What the MariaDB Community Wants Next: A Look at Our MySQL-Compatibility Poll ^{(from MariaDB Foundation Blog)}

pWe recently asked the community:br “Which MySQL-compatibility feature would you most like to see in the next MariaDB release?”br A big thank you to everyone who voted. … /p pContinue reading \"What the MariaDB Community Wants Next: A Look at Our MySQL-Compatibility Poll\"/p pThe post What the MariaDB Community Wants Next: A Look at Our MySQL-Compatibility Poll appeared first on M [...]

Published Tuesday, 03. March 2026 13:39 • 2 days ago

Before the Index, Before the Schema: MySQL Makes Three Promises ^{(from Rendiment)}

What is a database actually supposed to do? A framework of three core promises that applies whether you're a DBA, developer, or ops engineer. [...]

Published Tuesday, 03. March 2026 05:00 • 3 days ago

Saying goodbye to the LD1 storage format ^{(from DoltHub Blog)}

Dolt rewrote its storage layer in 2022. 4 years later, we're finally dropping support for the pre-1.0 storage format. This blog describes how they're different and what the work of deletion entailed. [...]

Published Tuesday, 03. March 2026 00:00 • 3 days ago

Drizzle joins PlanetScale ^{(from PlanetScale Blog)}

Drizzle joins PlanetScale. [...]

Published Tuesday, 03. March 2026 00:00 • 3 days ago

Galera, continuity, and responsibility: how the Foundation and MariaDB plc move forward ^{(from MariaDB Foundation Blog)}

pIntroductionbr Over the past weeks, questions around Galera, high availability, and continuity have generated understandable concern within parts of the MariaDB community.br Clarity matters in moments like this.That is also why this response was unfortunately not immediate. … /p pContinue reading \"Galera, continuity, and responsibility: how the Foundation and MariaDB plc move forward\"/p pT [...]

Published Monday, 02. March 2026 21:23 • 3 days ago

Mastering Cross-Database Date Manipulation: Subtracting Days in MySQL and H2 ^{(from Devart MySQL Tool Blog)}

pThis guide explains how to subtract days from dates across MySQL, H2, and other databases with different SQL dialects. Learn how to standardize behavior using compatibility modes, wrapper functions, and unified tooling so the same logic works reliably even when multiple database engines run side by side./p pThe post Mastering Cross-Database Date Manipulation: Subtracting Days in MySQL and H2 appe [...]

Published Monday, 02. March 2026 18:52 • 3 days ago

Set up and troubleshoot IAM database authentication in AWS DMS ^{(from AWS Database Blog)}

In this post, we demonstrate how to configure IAM database authentication in AWS Database Migration Service (AWS DMS). You’ll also learn the structured troubleshooting approach you follow to address the errors when configuring IAM database authentication with AWS DMS [...]

Published Monday, 02. March 2026 17:54 • 3 days ago

The Aiven Free Tier Competition: Build, Share, and Win $1,000! ^{(from Aiven Blog - MySQL)}

Build with Aiven’s free tier services like Kafka and PostgreSQL, share your story using #AivenFreeTier, and compete for a $1,000 grand prize. Ends March 31! [...]

Published Monday, 02. March 2026 10:41 • 3 days ago

Hardening MySQL: Practical Security Strategies for DBAs ^{(from Percona Community Blog)}

MySQL Security Best Practices: A Practical Guide for Locking Down Your Database Introduction MySQL runs just about everywhere. I’ve seen it behind small personal projects, internal tools, SaaS platforms, and large enterprise systems handling serious transaction volume. When your database sits at the center of everything, it becomes part of your security perimeter whether you planned it that way or [...]

Published Monday, 02. March 2026 00:00 • 4 days ago

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 • 4 days ago | Updated Sunday, 01. March 2026 19:11 • 4 days 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 • 5 days 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 • 5 days 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 • 5 days 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 • 5 days 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 • 6 days 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 • 6 days ago

Village News: MySQL/Database News (February 27, 2026) ^{(from VillageSQL)}

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

Published Friday, 27. February 2026 18:28 • 6 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 • 6 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 • 6 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 • 7 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 • 7 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 • 7 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 • 7 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 • 7 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 • 7 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 • 7 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 • 8 days ago | Updated Wednesday, 25. February 2026 21:14 • 8 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 • 8 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 • 8 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 • 8 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 • 9 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 • 9 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 • 9 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 • 9 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 • 9 days ago | Updated Tuesday, 24. February 2026 15:00 • 9 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 • 10 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 • 10 days ago | Updated Tuesday, 24. February 2026 00:05 • 10 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 • 11 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 • 11 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 • 11 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 • 12 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 • 12 days ago | Updated Sunday, 22. February 2026 00:01 • 12 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 • 12 days ago | Updated Saturday, 21. February 2026 22:42 • 12 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 • 13 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 • 13 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 • 13 days ago

How We Brought a Dead MySQL InnoDB Cluster Back to Life ^{(from Gayan Dissanayake Blog)}

A war story: complete outage, GTID chaos, duplicate UUIDs, and the steps that finally workedpThere’s a particular kind of dread that comes with staring at a database cluster where every node shows OFFLINE./ppNo reads. No writes. Just silence where your production data used to be./ppThat’s exactly where we found ourselves with a MySQL InnoDB Cluster — three nodes, all down, all stubbornly refusing t [...]

Published Friday, 20. February 2026 10:25 • 13 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 • 14 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 • 14 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 • 14 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 • 14 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 • 16 days ago | Updated Thursday, 19. February 2026 17:06 • 14 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 • 14 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 • 14 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 • 14 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 • 14 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 • 15 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 • 15 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 • 15 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 • 15 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 • 15 days ago | Updated Wednesday, 18. February 2026 20:48 • 15 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 • 15 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 • 15 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 • 15 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 • 15 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 • 15 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 • 16 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 • 16 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 • 16 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 • 16 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 • 16 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 • 16 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 • 16 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 • 16 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 • 16 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 • 16 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 • 16 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 • 17 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 • 17 days ago | Updated Monday, 16. February 2026 19:22 • 17 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 • 17 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 • 17 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 • 18 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 • 18 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 • 18 days ago | Updated Sunday, 15. February 2026 20:51 • 18 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 • 19 days ago | Updated Sunday, 15. February 2026 20:35 • 18 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 • 20 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 • 20 days ago | Updated Friday, 13. February 2026 19:53 • 20 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 • 20 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 • 20 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 • 20 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 • 21 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 • 21 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 • 21 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 • 21 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 • 21 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 • 21 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 • 22 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 • 22 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 • 22 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 • 22 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 • 22 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 • 22 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 • 23 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 • 23 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 • 23 days ago | Updated Tuesday, 10. February 2026 12:13 • 23 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 • 24 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 • 24 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 • 24 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 • 24 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 • 24 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 • 25 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 • 25 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 • 25 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 • 25 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 • 25 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 • 25 days ago | Updated Sunday, 08. February 2026 17:40 • 25 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 • 25 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 • 25 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 • 26 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 • 26 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 • 26 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 • 27 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 • 27 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 • 27 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 • 27 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 • 27 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 • 27 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 • 27 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 • 27 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 • 28 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 • 28 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 • 28 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 • 29 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 • 29 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 • 29 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 • 29 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 • 29 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 • 29 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 • 30 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 • 30 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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

MySQL Query Optimization Guide ^{(from Nipuna Perera Blog)}

A practical guide to MySQL query optimization using cardinality and index strategies. [...]

Published Friday, 23. January 2026 12:10 • 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

Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

Thursday, 05. March 2026

Best of Both Worlds: Introducing Readyset Shallow Cache (from Readyset Blog)

Guide to Upgrade Azure Database for MySQL from 8.0 to 8.4 (from Azure for MySQL Blog)

Mind the InnoDB Purge on Queue / Row Deletion Job (else slow queries) (from J-F Gagné's MySQL Blog)

Row Deletion Jobs Done Right (from J-F Gagné's MySQL Blog)

MySQL Replication Lag – Part 1: Theory and Internal Mechanics (from Continuent Blog)

Announcing Extended Support for Azure Database for MySQL (from Azure for MySQL Blog)

Wednesday, 04. March 2026

How to Build an AI App That Simulates Life Decisions (from PingCAP Blog)

Supercharge Your PostgreSQL with ProxySQL (from ProxySQL Blog)

Replication Internals: Decoding the MySQL Binary Log Part 2: File Header and Common Event Header (from Readyset Blog)

The Queen of Naboo and Many Systems: MariaDB Server Ecosystem Hub (from MariaDB Foundation Blog)

Tuesday, 03. March 2026

TiDB Performance Troubleshooting (from MinervaDB Blog)

What Exactly Is the MySQL Ecosystem? (from Percona Database Blog)

What the MariaDB Community Wants Next: A Look at Our MySQL-Compatibility Poll (from lefred's blog)

The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite (from Programming Brain)

What the MariaDB Community Wants Next: A Look at Our MySQL-Compatibility Poll (from MariaDB Foundation Blog)

Before the Index, Before the Schema: MySQL Makes Three Promises (from Rendiment)

Saying goodbye to the LD1 storage format (from DoltHub Blog)

Drizzle joins PlanetScale (from PlanetScale Blog)

Monday, 02. March 2026

Galera, continuity, and responsibility: how the Foundation and MariaDB plc move forward (from MariaDB Foundation Blog)

Mastering Cross-Database Date Manipulation: Subtracting Days in MySQL and H2 (from Devart MySQL Tool Blog)

Set up and troubleshoot IAM database authentication in AWS DMS (from AWS Database Blog)

The Aiven Free Tier Competition: Build, Share, and Win $1,000! (from Aiven Blog - MySQL)

Hardening MySQL: Practical Security Strategies for DBAs (from Percona Community Blog)

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)

Village News: MySQL/Database News (February 27, 2026) (from VillageSQL)

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 We Brought a Dead MySQL InnoDB Cluster Back to Life (from Gayan Dissanayake Blog)

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)