Planet for the MySQL Community

How TiDB X Creates Indexes at 5.5M Rows/s with Near-Zero Business Impact ^{(from PingCAP Blog)}

pAdding an index has always been a sensitive operation: The challenge is clear: How do we build indexes that are fast, stable, and minimally disruptive, even at massive scale? TiDB X, the latest version of TiDB that introduces dedicated object storage, addresses this problem through a combination of three major innovations: In this blog, we explain why […]/p pThe post How TiDB X Creates Index [...]

Published Monday, 16. March 2026 14:26 • 4 hours ago

MySQL Rockstar 2025. Q&A with Umesh Shastry ^{(from ODBMS.org)}

Q1. Umesh, congratulations on being named MySQL Rockstar 2025! Over the past decade, you’ve verified and handled over 14,000 public bug reports, acting as a crucial bridge between the MySQL community and Oracle’s development team.... [...]

Published Monday, 16. March 2026 13:07 • 5 hours ago

MySQL, from "Hello World" to High Availability ^{(from Aiven Blog - MySQL)}

Whether you’re spinning up your first relational database or running a global e-commerce platform, Aiven for MySQL provides the performance and reliability you need. [...]

Published Monday, 16. March 2026 10:00 • 8 hours ago

Where does the Community run most MariaDB in production – results from the poll ^{(from lefred's blog)}

We recently asked the MariaDB community a simple question: Where do you run MariaDB most in production? The responses give a useful snapshot of how MariaDB is deployed today across our community: The big takeaway: MariaDB remains strongly infrastructure-aware The clearest signal from this poll is that MariaDB is still most commonly run in environments […] [...]

Published Monday, 16. March 2026 07:32 • 10 hours ago

MariaDB 12.3 – Binlog Inside InnoDB ^{(from dbi Blog)}

pMariaDB has been quite active lately, the version 11.8 was already quite a step forward and apart from the changes on LTS schedule and the EOL durations, the RC 12.3 LTS is bringing some interesting changes to binlogs, pushing even further performance improvements and reliability. Instead of using the traditional flat file binlogs, they can […]/p pL’article MariaDB 12.3 – Binlog Inside [...]

Published Sunday, 15. March 2026 16:17 • a day ago

Improving MariaDB Observability with OpenSearch and Grafana ^{(from lefred's blog)}

When dealing with queries in MariaDB, there are several approaches, such as the general query log, the slow query log, and the performance_schema. The general query log is not recommended as it doesn’t contain much valuable information and can use a lot of resources when writing to the file on busy systems. The slow query […] [...]

Published Saturday, 14. March 2026 07:27 • 2 days ago

Mapping your data to file(s) in your Lakehouse table ^{(from The Oracle MySQL Blog)}

MySQL HeatWave is a fully-managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. Also included is HeatWave Lakehouse, allowing users to query data stored in object storage, MySQL databases, or a combination of both. Introduction In the 9.6.1 release of MySQL HeatWave, Lakehouse now supports the _metadata_filename column [ [...]

Published Friday, 13. March 2026 15:59 • 3 days ago

MySQL Community Early Access Builds ^{(from The Oracle MySQL Blog)}

MySQL benefits from a large and technically rigorous community—people who run MySQL at scale, test it in diverse environments, and surface issues (and ideas) that make the product better. Over the last year, we’ve been listening to community feedback and, since January 2026, sharing our updated community engagement approach (see: A New Era of MySQL Community […] [...]

Published Friday, 13. March 2026 14:44 • 3 days ago

Where does the Community run most MariaDB in production – results from the poll ^{(from MariaDB Foundation Blog)}

pWe recently asked the MariaDB community a simple question:br Where do you run MariaDB most in production?br The responses give a useful snapshot of how MariaDB is deployed today across our community:br The big takeaway: MariaDB remains strongly infrastructure-awarebr The clearest signal from this poll is that MariaDB is still most commonly run in environments where users want a high degree of cont [...]

Published Friday, 13. March 2026 07:29 • 3 days ago

Scaling Postgres connections with PgBouncer ^{(from PlanetScale Blog)}

PgBouncer is the perfect pairing for Postgres's biggest weakness: connection management. Tuning it just right is important to make this work well, and here we cover everything you need to know [...]

Published Friday, 13. March 2026 00:00 • 4 days ago

Why You Should Replace Stored Procedures with a Service Layer ^{(from PingCAP Blog)}

pIf you’ve worked with relational databases long enough, you’ve almost certainly encountered stored procedures. They made sense in an era when network latency was expensive and applications were monolithic, but the world has moved on. In this post, we’ll look at why stored procedures are holding teams back and what a modern alternative looks like. […]/p pThe post Why You Sho [...]

Published Thursday, 12. March 2026 19:35 • 4 days ago

Why Postgres® has won as the de facto database: Today and for the agentic future ^{(from InfoWorld)}

pThe AI economy is projected to reach $17 trillion by 2028, fundamentally altering how organizations architect their infrastructure. Driven by this shift, 95% of major global enterprises are on a mission-critical sprint to become their own AI and data platforms within the next two years. /p pYet only 13% of enterprises have successfully found the formula. Their secret to m [...]

Published Thursday, 12. March 2026 18:13 • 4 days ago

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

Following the strong participation in our first Public MySQL Community Roadmap Discussion (with attendees joining from around the world), we are excited to invite you to the second edition of this public community webinar series. In our latest blog post, we have published a brief recap of the first webinar—highlighting the key roadmap themes, how […] [...]

Published Thursday, 12. March 2026 17:16 • 4 days ago

Q&A with MySQL Experts, Tuesday, May 12, 2026- Web Seminar ^{(from ODBMS.org)}

Topics: MySQL Enterprise Edition Have questions about MySQL or want to share your feedback directly with the team? Join our interactive session, “Q&A with MySQL Experts,” where you get the chance to connect live... [...]

Published Thursday, 12. March 2026 13:12 • 4 days ago

Improving MariaDB Observability with OpenSearch and Grafana ^{(from MariaDB Foundation Blog)}

pWhen dealing with queries in MariaDB, there are several approaches, such as the general query log, the slow query log, and the performance_schema. … /p pContinue reading \"Improving MariaDB Observability with OpenSearch and Grafana\"/p pThe post Improving MariaDB Observability with OpenSearch and Grafana appeared first on MariaDB.org./p [...]

Published Thursday, 12. March 2026 09:33 • 4 days ago

Branch Permissions in the Hosted Dolt Workbench ^{(from DoltHub Blog)}

We recently released branch permissions for Hosted Dolt Workbench. Collaborate seamlessly with your team while having greater oversight into what makes it into your main database. [...]

Published Thursday, 12. March 2026 00:00 • 5 days ago

Building a MySQL Shell Plugin to Scan for Sensitive Data (Vibe Coding AI-assisted, ~30 minutes) ^{(from The Oracle MySQL Blog)}

Sensitive data has a way of showing up in unexpected places: an “email” column in a demo app, a forgotten “token” field in a logging table, or free-text notes that quietly become regulated data. I wanted a lightweight, repeatable way to answer a simple question on any MySQL instance: Where is sensitive data likely to […] [...]

Published Wednesday, 11. March 2026 18:48 • 5 days ago

Building a Voice-First AI Journal: What I Learned About AI Memory, Vector Search, and TiDB ^{(from PingCAP Blog)}

pI was talking to Claude the other day — not about code or some technical problem. I was venting about work, about life. And Claude responded with something so personal, so specific to my situation, that I stopped and stared at it. It referenced my daughter by name. It brought up something I’d been stressed […]/p pThe post Building a Voice-First AI Journal: What I Learned About AI Memor [...]

Published Wednesday, 11. March 2026 18:18 • 5 days ago

What’s New in MariaDB Enterprise Kubernetes Operator 26.03 ^{(from MariaDB Corporation Blog)}

Running production databases on Kubernetes means planning for the moments when things go wrong: a bad deployment, accidental data changes, […] [...]

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

Migrate Cloud SQL for MySQL to Amazon Aurora and Amazon RDS for MySQL Using AWS DMS ^{(from AWS Database Blog)}

In this post, we demonstrate how to migrate from Cloud SQL for MySQL 8+ to Amazon RDS for MySQL 8+ or Amazon Aurora MySQL–Compatible using AWS DMS over an AWS Site-to-Site VPN. We cover preparing the source and target environments, exemplifying cross-cloud connectivity, and setting up DMS tasks. [...]

Published Wednesday, 11. March 2026 16:51 • 5 days ago

When Disaster Strikes ^{(from MariaDB Corporation Blog)}

On March 1, various AWS datacenters went down, creating havoc in the Middle East. As a result various services in […] [...]

Published Wednesday, 11. March 2026 16:24 • 5 days ago

Big Vector Search Benchmark: 10 databases comparison ^{(from MariaDB Foundation Blog)}

pI have benchmarked MariaDB Vector before, but it was a while ago. Users kept asking about Milvus. New pgvector alternatives were gaining popularity. And I simply wanted to see if MariaDB got any better. … /p pContinue reading \"Big Vector Search Benchmark: 10 databases comparison\"/p pThe post Big Vector Search Benchmark: 10 databases comparison appeared first on MariaDB.org./p [...]

Published Wednesday, 11. March 2026 15:15 • 5 days ago

Is MySQL Due for a Renaissance? ^{(from One-Time MySQL Community/Ecosystem Posts)}

Back at the turn of the century, open source was experiencing widespread adoption along with the growth of the Internet. The acronym LAMP was used a lot, meaning Linux, Apache, MySQL and PHP. [...]

Published Wednesday, 11. March 2026 15:15 • 5 days ago

Replication Internals: Decoding the MySQL Binary Log Part 3: FORMAT_DESCRIPTION_EVENT — The Self-Describing Event ^{(from Readyset Blog)}

Decode the FORMAT_DESCRIPTION_EVENT, the first event in every MySQL binary log that tells parsers how to interpret everything that follows. [...]

Published Wednesday, 11. March 2026 14:00 • 5 days ago

MySQL Replication Lag – Part 2: Diagnosis and Practical Fixes ^{(from Continuent Blog)}

Operational guide to diagnosing and resolving MySQL replication lag, covering correct measurement techniques, relay log analysis, bottleneck identification, and practical strategies for reducing replication delay in production systems.Tags: replicationpracticehow toPerformance Tuning [...]

Published Wednesday, 11. March 2026 13:08 • 5 days ago

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

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

Published Wednesday, 11. March 2026 13:00 • 5 days ago

Active-Active MySQL Group Replication Best Practices ^{(from Severalnines Blog)}

pIn MySQL Group Replication (MGR) or Group Replication, an active-active configuration allows multiple group members to accept concurrent write transactions. These writes are coordinated through a consensus-based group communication system (GCS) and validated via write-set certification to preserve global transactional consistency as defined by the Group Replication protocol. active-active mode is [...]

Published Wednesday, 11. March 2026 12:54 • 5 days ago

Oracle rejects request it give up control of MySQL ^{(from InfoWorld)}

pOracle has formally refused to restructure control of the Community Edition of MySQL, following a request that it do so from a consortium of database companies providing forks of the database, and from MySQL users./p pThe decision comes after the consortium’s major players, Percona and VillageSQL, met Oracle earlier this month to discuss the changes requested in an online [...]

Published Wednesday, 11. March 2026 12:51 • 5 days 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 Wednesday, 11. March 2026 10:16 • 5 days ago

Tomas Ulin Reflects on VillageSQL: From the MySQL Core to Permissionless Innovation ^{(from VillageSQL)}

Tomas Ulin led MySQL engineering for years. He’s now at VillageSQL. We sat down with him to understand his perspective on why an extension framework is the path forward for innovating with MySQL. [...]

Published Tuesday, 10. March 2026 16:08 • 6 days ago

Oracle moves to assure MySQL community it really does care ^{(from The Register)}

Big Red waves new features including vector support, while skeptics await concrete timescales pOracle has proposed a more transparent approach to developing its open source database MySQL, including new features supporting vectors.…/p p!--#include virtual='/data_centre/_whitepaper_textlinks_top.html' --/p [...]

Published Tuesday, 10. March 2026 14:43 • 6 days ago

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

Announcing Tungsten Dashboard v8.0.4 with improved Kubernetes deployment, better hybrid SSL topology handling, enhanced connection reliability, and new interface options including compact layout and customizable cluster views.Tags: tungsten dashboardReleasekubernetessslMonitoring [...]

Published Tuesday, 10. March 2026 10:42 • 6 days ago

MariaDB taps GridGain to keep pace with AI-driven data demands ^{(from InfoWorld)}

pMariaDB, the company behind the open-source fork of MySQL, is planning to acquire in-memory computing middleware provider GridGain to bolster its platform for high-performance data and artificial intelligence (AI) workloads./p pThe database provider is planning to infuse its relational database with the California-headquartered startup’s in-memory technology, which it say [...]

Published Tuesday, 10. March 2026 09:59 • 6 days 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 • 2 months ago | Updated Tuesday, 10. March 2026 08:20 • 6 days ago

A New Era of MySQL Community Engagement: Public Community Roadmap Webinar Highlights ^{(from The Oracle MySQL Blog)}

Oracle values the MySQL community. MySQL is fundamental to our data strategy. Oracle firmly believes that MySQL’s enduring strength arises from this vibrant global community. We are excited to work with the MySQL Community on the strategy we announced in Belgium, January 29, 2026, including adding more features and functionality, accelerating innovation directly in the […] [...]

Published Tuesday, 10. March 2026 06:35 • 6 days ago

Order-Equivalence ^{(from Modern SQL)}

Order-Equivalent codeOver/code Clauses♦olli⚡Order-equivalent codeover/code clause can produce different row orders/liliApparently, the framing must be identical too to make codeover/code clauses order-equivalent/li/olpAt the heart of this article, there is a simple question: Will the following query always give the same numbering in both columns?/pprecodeSELECT ROW_NUMBER() OVER (ORDER BY x) , [...]

Published Tuesday, 10. March 2026 00:00 • 7 days ago

MySQL vs PostgreSQL Internals (Part 2) — MVCC (Multi-version Concurrency Control) ^{(from Zhao Song's Blog)}

In the previous post, I took a detailed look at how MySQL and PostgreSQL differ in their buffer pool design and implementation. In this post, I will continue with a detailed comparison of their MVCC implementations. [...]

Published Tuesday, 10. March 2026 00:00 • 7 days ago

Amazon Aurora Pricing: The many surprising costs of running an Aurora database ^{(from PlanetScale Blog)}

Amazon Aurora is pitched as a straightforward and scalable database service on AWS, but there are associated costs that you might not be aware of. [...]

Published Thursday, 15. February 2024 15:00 • over a year ago | Updated Monday, 09. March 2026 15:00 • 7 days ago

MariaDB backs down on Galera removal after community outcry ^{(from The Register)}

But questions remain over long-term commitment to clustering tech in open source pAfter a couple of years of relative calm, the relationship between MariaDB and its open source foundation was ruffled in February, leaving observers with a few unanswered questions.…/p [...]

Published Monday, 09. March 2026 14:45 • 7 days ago

MariaDB acquires GridGain for agentic AI data ^{(from Techzine)}

MariaDB acquires GridGain Systems, the creator of open source Apache Ignite. The combination of MariaDB’s relational database with GridGain’s in-memory technology is expected to deliver sub-millisecond data performance for agentic AI applications. GridGain Systems is the creator of open source Apache Ignite and focuses on in-memory computing. Apache Ignite is used for real-time applicat [...]

Published Monday, 09. March 2026 14:00 • 7 days ago

A Practical Approach to Running MySQL HeatWave AutoML in Mission-Critical Environment ^{(from The Oracle MySQL Blog)}

MySQL HeatWave AutoML is a native automated machine learning engine tightly integrated with the MySQL HeatWave database. It enables model training, inference, scoring, and explainability through SQL, executing directly on data in InnoDB tables or in external accessed via HeatWave Lakehouse from Object Storage. By operating in-database and in-memory on HeatWave nodes, AutoML eliminates data [… [...]

Published Sunday, 08. March 2026 14:49 • 8 days ago

DBeaver, a solid alternative to MySQL Workbench that works like a charm with MariaDB ^{(from lefred's blog)}

You may have noticed that MySQL Workbench has not been actively developed for a long time… You can see the number of open bugs. And the number of commits illustrates this too: In fact, Workbench has been put out of maintenance mode to add the MySQL HeatWave Migration Assistant to OCI. Not less, no more. […] [...]

Published Sunday, 08. March 2026 08:44 • 8 days ago

The Claude Code Engineer ^{(from Rendiment)}

Meet the Claude Code Engineer: a new role where QA, product thinking, and AI coordination matter more than writing code. How agentic tools reshape teams. [...]

Published Sunday, 08. March 2026 05:00 • 9 days ago

The first rule of database fight club: admit nothing ^{(from Small Datum)}

p I am fascinated by tech marketing but would be lousy at it./ppA common practice is to admit nothing -- my product, project, company, idea is perfect. And I get it because admitting something isn't perfect just provides fodder for marketing done by the other side, and that marketing is often done in bad faith.brbrBut it is harder to fix things when you don't acknowledge the problems. I wrote [...]

Published Friday, 06. March 2026 19:16 • 10 days ago | Updated Friday, 06. March 2026 23:27 • 10 days ago

TiDB Community Quarterly Roundup: The Most Popular Discussion Topics in Q4 2025 ^{(from PingCAP Blog)}

pEvery quarter, our Discord and Slack communities surface questions that reflect what teams are actually working through. These include such topics as migration blockers, cost modeling unknowns, and the everyday friction of running a distributed database in production. Between October and December 2025, we collected the most in-depth discussions and distilled them into the themes […]/p pThe p [...]

Published Friday, 06. March 2026 20:22 • 10 days ago

MariaDB Node.js Connector 3.5.2 now available ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Node.js 3.5.2 GA release. Release Notes MariaDB Connector/Node.js MariaDB […] [...]

Published Friday, 06. March 2026 19:17 • 10 days ago

February Product Update ^{(from Readyset Blog)}

♦pIt’s been a busy month with lots of updates, let’s dive into them: /pReadyset Shallow CachepThis month we introduced Readyset Shallow Cache, a new caching layer designed to expand Readyset’s query coverage. Readyset’s deep caching engine has always delivered sub-millisecond/p [...]

Published Friday, 06. March 2026 18:30 • 10 days ago

How to patch your ODA to 19.30? ^{(from dbi Blog)}

pIntroduction Patch 19.30 is now available for Oracle Database Appliance series. Let’s find out what’s new and how to apply this patch. What’s new? The real new feature is the possibility to rollback a server component patch done by an odacli update-servercomponents. Until now, in the rare cases you would need to do a rollback, […]/p pL’article How to patch your ODA to 19.30 [...]

Published Friday, 06. March 2026 15:10 • 10 days ago

Deploying MySQL Router on OpenShift with a 3-Node MySQL InnoDB Cluster on OpenShift Virtualization ^{(from Gayan Dissanayake Blog)}

Bridging containerized workloads with VM-hosted databases using OVN-Kubernetes and MySQL Router♦IntroductionpRunning stateful database workloads on Kubernetes has always been a challenge. Many organizations running OpenShift choose to host their MySQL databases inside virtual machines managed by OpenShift Virtualization (formerly KubeVirt) — benefiting from the operational familiarity of VMs while [...]

Published Friday, 06. March 2026 08:10 • 10 days ago

DBeaver, a solid alternative to MySQL Workbench that works like a charm with MariaDB ^{(from MariaDB Foundation Blog)}

pYou may have noticed that MySQL Workbench has not been actively developed for a long time… You can see the number of open bugs. … /p pContinue reading \"DBeaver, a solid alternative to MySQL Workbench that works like a charm with MariaDB\"/p pThe post DBeaver, a solid alternative to MySQL Workbench that works like a charm with MariaDB appeared first on MariaDB.org./p [...]

Published Friday, 06. March 2026 06:57 • 10 days ago

dbsafe in the Cloud: Safe Schema Changes on AWS Aurora and RDS ^{(from Rendiment)}

Run dbsafe against Aurora MySQL and RDS with TLS. Learn how Aurora's shared-storage architecture complicates gh-ost and why dbsafe auto-detects cloud topology. [...]

Published Friday, 06. March 2026 05:00 • 11 days ago

Multi-Writer Change Data Capture (CDC): Architecture, Challenges, and How TiCDC Solves Them ^{(from PingCAP Blog)}

pWhat Is Multi-Writer Change Data Capture (CDC)? Change Data Capture (CDC) is a pattern for tracking and propagating data changes in real time, powering use cases like downstream synchronization, auditing, event streaming, and real-time analytics. In a single-writer CDC system (e.g., MySQL binlog, PostgreSQL WAL replication), one node handles all writes, producing a single sequential […]/p pT [...]

Published Thursday, 05. March 2026 20:10 • 11 days ago

Scaling Your CLI Query Tool: Prioritizing Database Support for Maximum Impact ^{(from Devart MySQL Tool Blog)}

pThis guide shows how to scale a CLI query tool across multiple databases in a clear and practical way. It explains why SQL Server, MySQL, Oracle, and PostgreSQL should be your first focus, how to build reliable CLI automation, and when it makes sense to extend support to data warehouses like Redshift./p pThe post Scaling Your CLI Query Tool: Prioritizing Database Support for Maximum Impact appear [...]

Published Thursday, 05. March 2026 18:59 • 11 days ago

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 • 11 days 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 • 11 days 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 • 14 days ago | Updated Thursday, 05. March 2026 13:52 • 11 days 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 • 11 days ago | Updated Thursday, 05. March 2026 13:47 • 11 days ago

Troubleshooting MariaDB Galera Cluster Issues ^{(from Mydbops Blog)}

Learn how to troubleshoot common MariaDB Galera Cluster issues — node failures, SST errors, split brain, and replication conflicts — with real log examples and fixes. [...]

Published Thursday, 05. March 2026 10:04 • 11 days 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 • 11 days 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 • 12 days 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 • 12 days 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 • 12 days 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 • 12 days ago

Designing Continuous Availability: Active-Active HA for MySQL HeatWave Lakehouse ^{(from The Oracle MySQL Blog)}

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

Published Wednesday, 04. March 2026 14:13 • 12 days ago

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

Momentum is built one practical resource at a time. In this March edition of Monthly Product Pulse, we’re curating standout developer-facing updates across Oracle Database and Autonomous Database, APEX, Oracle Developer experiences, and MySQL community news—plus a short list of events worth putting on your radar. Use this post as a “what to read / […] [...]

Published Wednesday, 04. March 2026 11:12 • 12 days 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 • 13 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 • 13 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 • 13 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 • 13 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 • 13 days ago

Top Ways to Engage with the MySQL Community ^{(from The Oracle MySQL Blog)}

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

Published Tuesday, 03. March 2026 13:38 • 13 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 • 14 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 • 14 days ago

Drizzle joins PlanetScale ^{(from PlanetScale Blog)}

Drizzle joins PlanetScale. [...]

Published Tuesday, 03. March 2026 00:00 • 14 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 • 14 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 • 14 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 • 14 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 • 14 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 • 15 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 • 15 days ago | Updated Sunday, 01. March 2026 19:11 • 15 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 • 15 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 • 15 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 • 16 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 • 16 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 • 17 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 • 17 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 • 17 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 • 17 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 • 17 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 • 17 days ago

Checking if MySQL Tables Are Loaded in HeatWave In-Memory: A Quick Guide ^{(from The Oracle MySQL Blog)}

If you’re working with MySQL HeatWave, Oracle’s powerful in-memory query accelerator for analytics workloads, you might find yourself needing to verify whether your tables are properly loaded into that speedy in-memory columnar storage engine known as RAPID. HeatWave is all about boosting performance by offloading analytical queries from the standard MySQL row-based storage to an optimize [...]

Published Friday, 27. February 2026 02:04 • 18 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 • 18 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 • 18 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 • 18 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 • 18 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 • 18 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 • 18 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 • 19 days ago | Updated Wednesday, 25. February 2026 21:14 • 19 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 • 19 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 • 19 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 • 19 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 • 19 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 • 20 days ago

The MySQL-to-Postgres Migration That Saved $480K/Year: A Step-by-Step Guide ^{(from One-Time MySQL Community/Ecosystem Posts)}

Everything I learned migrating two massive codebases from MySQL 8 RDS to Postgres RDS, so you don’t have to figure it out alone. [...]

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

Understanding MySQL SQL Modes: A Quick Guide ^{(from The Oracle MySQL Blog)}

If you’ve ever dived into MySQL configuration, you’ve probably come across the term “SQL modes.” These are powerful settings that can change how MySQL interprets SQL queries, handles data validation, and even enforces certain standards. But with great power comes great responsibility – choosing the wrong mode can lead to unexpected behaviors, data inconsistencies, or [ [...]

Published Tuesday, 24. February 2026 21:58 • 20 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 • 20 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 • 20 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 • 20 days ago | Updated Tuesday, 24. February 2026 15:00 • 20 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 • 20 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 • 21 days ago | Updated Tuesday, 24. February 2026 00:05 • 21 days ago

Join the MySQL Community Roadmap Webinar ^{(from The Oracle MySQL Blog)}

As we shared in the MySQL Belgium Days in January, and summarized in the latest blog post , we are excited to invite you to an upcoming MySQL community webinar. This is an opportunity to connect directly with the MySQL team. Mark your calendars for Wednesday, February 25, 2026, at 10:00 am ET and join […] [...]

Published Monday, 23. February 2026 16:21 • 21 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 • 22 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 • 22 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 • 22 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 • 23 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 • 23 days ago | Updated Sunday, 22. February 2026 00:01 • 23 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 • 23 days ago | Updated Saturday, 21. February 2026 22:42 • 23 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 • 24 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 • 24 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 • 24 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 • 24 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 • 24 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 • 25 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 • 25 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 • 25 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 • 27 days ago | Updated Thursday, 19. February 2026 17:06 • 25 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 • 25 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 • 25 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 • 25 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 • 25 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 • 26 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 • 26 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 • 26 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 • 26 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 • 26 days ago | Updated Wednesday, 18. February 2026 20:48 • 26 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 • 26 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 • 26 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 • 26 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 • 26 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 • 26 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 • 27 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 • 2 months ago | Updated Wednesday, 18. February 2026 04:11 • 27 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 • 27 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 • 27 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 • 27 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 • 27 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 • 27 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 • 27 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 • 27 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 • 27 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 • 27 days ago

preFOSDEM MySQL Belgian Days 2026 Recap: Real-World Ops, New Features, and RockStar Moments ^{(from The Oracle MySQL Blog)}

Right before FOSDEM kicked off, the preFOSDEM MySQL Belgian Days returned to the usual place in Brussels for two packed days (Jan 29-30, 2026). The format stayed true to what makes this event special: a friendly, hallway-track-heavy gathering with serious technical content — this year running two parallel tracks and the grand final: the RockStars […] [...]

Published Tuesday, 17. February 2026 12:31 • 27 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 • 28 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 • 28 days ago | Updated Monday, 16. February 2026 19:22 • 28 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 • 28 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 • 28 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 • 28 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 • 29 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 • 29 days ago | Updated Sunday, 15. February 2026 20:51 • 29 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 • 30 days ago | Updated Sunday, 15. February 2026 20:35 • 29 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 • 1 months 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 • 1 months ago | Updated Friday, 13. February 2026 19:53 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months ago

Introducing MySQL Backup Export in MySQL HeatWave ^{(from The Oracle MySQL Blog)}

We are pleased to introduce the ability to export MySQL HeatWave backup data directly to an OCI Object Storage bucket in your tenancy, enabling a one-step process to create an exported backup via the Console or API. This process creates a logical dump from the backup without utilizing DB system resources, thereby minimizing the impact on the […] [...]

Published Friday, 13. February 2026 12:32 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 4 months ago | Updated Tuesday, 10. February 2026 12:25 • 1 months 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 • 1 months 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 • 1 months ago | Updated Tuesday, 10. February 2026 12:13 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months ago | Updated Sunday, 08. February 2026 17:40 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months 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 • 1 months ago

Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

Monday, 16. March 2026

How TiDB X Creates Indexes at 5.5M Rows/s with Near-Zero Business Impact (from PingCAP Blog)

MySQL Rockstar 2025. Q&A with Umesh Shastry (from ODBMS.org)

MySQL, from "Hello World" to High Availability (from Aiven Blog - MySQL)

Where does the Community run most MariaDB in production – results from the poll (from lefred's blog)

Sunday, 15. March 2026

MariaDB 12.3 – Binlog Inside InnoDB (from dbi Blog)

Saturday, 14. March 2026

Improving MariaDB Observability with OpenSearch and Grafana (from lefred's blog)

Friday, 13. March 2026

Mapping your data to file(s) in your Lakehouse table (from The Oracle MySQL Blog)

MySQL Community Early Access Builds (from The Oracle MySQL Blog)

Where does the Community run most MariaDB in production – results from the poll (from MariaDB Foundation Blog)

Scaling Postgres connections with PgBouncer (from PlanetScale Blog)

Thursday, 12. March 2026

Why You Should Replace Stored Procedures with a Service Layer (from PingCAP Blog)

Why Postgres® has won as the de facto database: Today and for the agentic future (from InfoWorld)

Join the Public MySQL Community Roadmap Discussion Webinar (Edition #2) (from The Oracle MySQL Blog)

Q&A with MySQL Experts, Tuesday, May 12, 2026- Web Seminar (from ODBMS.org)

Improving MariaDB Observability with OpenSearch and Grafana (from MariaDB Foundation Blog)

Branch Permissions in the Hosted Dolt Workbench (from DoltHub Blog)

Wednesday, 11. March 2026

Building a MySQL Shell Plugin to Scan for Sensitive Data (Vibe Coding AI-assisted, ~30 minutes) (from The Oracle MySQL Blog)

Building a Voice-First AI Journal: What I Learned About AI Memory, Vector Search, and TiDB (from PingCAP Blog)

What’s New in MariaDB Enterprise Kubernetes Operator 26.03 (from MariaDB Corporation Blog)

Migrate Cloud SQL for MySQL to Amazon Aurora and Amazon RDS for MySQL Using AWS DMS (from AWS Database Blog)

When Disaster Strikes (from MariaDB Corporation Blog)

Big Vector Search Benchmark: 10 databases comparison (from MariaDB Foundation Blog)

Is MySQL Due for a Renaissance? (from One-Time MySQL Community/Ecosystem Posts)

Replication Internals: Decoding the MySQL Binary Log Part 3: FORMAT_DESCRIPTION_EVENT — The Self-Describing Event (from Readyset Blog)

MySQL Replication Lag – Part 2: Diagnosis and Practical Fixes (from Continuent Blog)

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

Active-Active MySQL Group Replication Best Practices (from Severalnines Blog)

Oracle rejects request it give up control of MySQL (from InfoWorld)

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

Tuesday, 10. March 2026

Tomas Ulin Reflects on VillageSQL: From the MySQL Core to Permissionless Innovation (from VillageSQL)

Oracle moves to assure MySQL community it really does care (from The Register)

Introducing Tungsten Dashboard v8.0.4 (from Continuent Blog)

MariaDB taps GridGain to keep pace with AI-driven data demands (from InfoWorld)

The concepts of forking (from Monty says)

A New Era of MySQL Community Engagement: Public Community Roadmap Webinar Highlights (from The Oracle MySQL Blog)

Order-Equivalence (from Modern SQL)

MySQL vs PostgreSQL Internals (Part 2) — MVCC (Multi-version Concurrency Control) (from Zhao Song's Blog)

Monday, 09. March 2026

Amazon Aurora Pricing: The many surprising costs of running an Aurora database (from PlanetScale Blog)

MariaDB backs down on Galera removal after community outcry (from The Register)

MariaDB acquires GridGain for agentic AI data (from Techzine)

Sunday, 08. March 2026

A Practical Approach to Running MySQL HeatWave AutoML in Mission-Critical Environment (from The Oracle MySQL Blog)

DBeaver, a solid alternative to MySQL Workbench that works like a charm with MariaDB (from lefred's blog)

The Claude Code Engineer (from Rendiment)

Friday, 06. March 2026

The first rule of database fight club: admit nothing (from Small Datum)

TiDB Community Quarterly Roundup: The Most Popular Discussion Topics in Q4 2025 (from PingCAP Blog)

MariaDB Node.js Connector 3.5.2 now available (from MariaDB Corporation Blog)

February Product Update (from Readyset Blog)

How to patch your ODA to 19.30? (from dbi Blog)

Deploying MySQL Router on OpenShift with a 3-Node MySQL InnoDB Cluster on OpenShift Virtualization (from Gayan Dissanayake Blog)

DBeaver, a solid alternative to MySQL Workbench that works like a charm with MariaDB (from MariaDB Foundation Blog)

dbsafe in the Cloud: Safe Schema Changes on AWS Aurora and RDS (from Rendiment)

Thursday, 05. March 2026

Multi-Writer Change Data Capture (CDC): Architecture, Challenges, and How TiCDC Solves Them (from PingCAP Blog)

Scaling Your CLI Query Tool: Prioritizing Database Support for Maximum Impact (from Devart MySQL Tool Blog)

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)

Troubleshooting MariaDB Galera Cluster Issues (from Mydbops Blog)

MySQL Replication Lag – Part 1: Theory and Internal Mechanics (from Continuent 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)

Designing Continuous Availability: Active-Active HA for MySQL HeatWave Lakehouse (from The Oracle MySQL Blog)

Monthly Product Pulse: March 2026—Oracle Technical Resources (from Oracle ACE Program)

Tuesday, 03. March 2026