Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

A description of what this website tries to achieve is in the Planet MySQL Community - Requirements RFC.

And a clarification about the MySQL Community/Ecosystem: it is not limited the users of the MySQL Database. In the current context, it also includes people interested in MySQL Variants including MariaDB Server, Percona Server, Galera, Amazon RDS and Aurora, Google Cloud SQL for MySQL, and Azure and Alibaba flavor(s) of MySQL/MariaDB/Percona Servers.

Tuesday, 09. December 2025

How Atlassian Scaled to 3M+ Tables: Multi-Tenant Control with TiDB (from PingCAP Blog)

pAtlassian is an enterprise software company that runs one of the world’s largest SaaS platforms. Best known for Jira, Confluence, Trello, and Bitbucket, the company helps teams plan, build, and run software. As tenant counts and compliance demands grew, Atlassian hit the limits of shared and siloed multi-tenancy models on a massive sharded PostgreSQL estate.  […]/p pThe post How Atlassi [...]

Design Scalable Soft Deletes and Audit Logs for MongoDB (from MinervaDB Blog)

Designing Scalable Soft Deletes, Audit Logs, and Time-Series Schemas in MongoDB Without Killing Index Performance In modern application development, data integrity, compliance, and historical tracking are non-negotiable requirements. Features like soft deletes, audit logs, and [...] [...]

BELGIAN MYSQL, MARIADB and friends COMMUNITY DINNER – FRIDAY 30 January 2026 (from FOSDEM MySQL & Friends Devroom)

FOSDEM is back in town! This year MySQL community will be present on the main event in Database Devroom. Same as the last few years the MySQL community team is once again organizing the Belgian MySQL Days. This provides us with the opportunity to bring the community together to socialize and exchange idea’s over a Belgian […] [...]

How to Turn a MySQL Unique Key Into a Primary Key (from Percona Database Blog)

♦A unique constraint specifies, one or more columns as unique it identifies. It is satisfied only when no two rows store the same non-null values at its core. A primary key constraint is a unique one that will say PRIMARY KEY in its defined way. It is satisfied only when rows unfold, and none may […] [...]

How ClusterControl Saved Christmas – Part 3 (from Severalnines Blog)

pThe Real-Time Workshop Welcome to the 3rd of a 6 part holiday series called, How ClusterControl Saved Christmas! If you missed part one, start here: Part 1 Inside Santa’s Streaming Architecture for Naughty & Nice Events After the Great Vendor Lock-In Escape, the North Pole entered a golden age of technical optimism. The snow-capped server […]/p pThe post How ClusterControl Saved Christma [...]

Monday, 08. December 2025

RocksDB performance over time on a small Arm server (from Small Datum)

pThis post has results for RocksDB on an Arm server. I previously shared results for RocksDB performance using gcc and clang. Here I share results using clang with LTO./ppRocksDB is boring, there are few performance regressions./pptl;dr/pp/pullifor cached workloads throughput with RocksDB 10.8 is as good or better than with 6.29/lilifor not-cached workloads throughput with RocksDB 10.8 is similar t [...]

November Product Update (from Readyset Blog)

Readyset holiday roundup: smarter renames, Postgres arrays, live eviction tuning, replay graph tools, MySQL CTAS, QueryPilot demos +more in Nov! [...]

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

pHow to patch your Oracle Database Appliance to 19.29/p pL’article How to patch your ODA to 19.29? est apparu en premier sur dbi Blog./p [...]

Unlocking AI-Driven Data Access: Azure Database for MySQL Support via the Azure MCP Server (from Azure for MySQL Blog)

pStep into a new era of data-driven intelligence with the fusion of Azure MCP Server and Azure Database for MySQL, where your MySQL data is no longer just stored, but instantly conversational, intelligent and action-ready. By harnessing the open-standard Model Context Protocol (MCP), your AI agents can now query, analyze and automate in natural language, accessing tables, surfacing insights and act [...]

Unlocking Secure Connections: SSL/TLS Support in Percona Toolkit (from Percona Database Blog)

♦In today’s interconnected world, data security is paramount. Protecting sensitive information transmitted between applications and databases is crucial, and SSL/TLS (Secure Sockets Layer/Transport Layer Security) plays a vital role in achieving this. Percona Toolkit, a collection of command-line tools for MySQL, MongoDB, and other databases, has long been a go-to resource for database admini [...]

RonDB development moves on (from Mikael Ronstrom)

p A few months ago we released RonDB 24.10 with 11 new features./ppDevelopment of RonDB doesn't stop there. We have continued developing RonDB 25.10, whether this release will be a LTS release or merely an intermediate release depends on the needs of our customers. RonDB 24.10 is currently being integrated into Hopsworks 4.6 and will imminently be released./ppThe work on RonDB 25.10 has taken [...]

Multimodal-Metadata-Hub for MariaDB Vector – Innovation 2nd place at MariaDB BangPypers Hackathon 2025 (from MariaDB Foundation Blog)

pWe recently announced the winners of the MariaDB Python Hackathon. We sat down with the Innovation track second place winners to learn more about the team and their submission. … /p pContinue reading \"Multimodal-Metadata-Hub for MariaDB Vector – Innovation 2nd place at MariaDB BangPypers Hackathon 2025\"/p pThe post Multimodal-Metadata-Hub for MariaDB Vector – Innovati [...]

Sunday, 07. December 2025

QUAPE Joins the MariaDB Foundation as a Silver Sponsor (from MariaDB Foundation Blog)

pWe’re pleased to welcome QUAPE as a Silver Sponsor. Their focus on high-performance infrastructure supports the Foundation’s work on the MariaDB buildbot and our commitment to open, dependable database innovation./p pThe post QUAPE Joins the MariaDB Foundation as a Silver Sponsor appeared first on MariaDB.org./p [...]

Understanding Vector Indexes in MariaDB (from MinervaDB Blog)

Understanding Vector Indexes in MariaDB: HNSW, Distance Functions, and When to Use Them MariaDB has emerged as a powerful platform for integrating vector search capabilities directly within a relational database environment, enabling efficient similarity searches [...] [...]

Mirror, Mirror on DB-Engines: The MariaDB Story (from MariaDB Foundation Blog)

pDB-Engines has become one of the most visible indicators of database popularity, capturing how the world talks about MariaDB. This post explores what the rankings truly measure and how visibility, community engagement, and education shape MariaDB’s position. It highlights recent innovations such as native vector search and explains how MariaDB’s governance model safeguards long-term openness. As u [...]

Adaptive Query Optimizer for MariaDB Vector – Innovation Winner of MariaDB Python Hackathon 2025 (from MariaDB Foundation Blog)

pWe recently announced the winners  of the MariaDB Python Hackathon. We sat down with the Innovation track first place winners to learn more about the team and their submission. … /p pContinue reading \"Adaptive Query Optimizer for MariaDB Vector – Innovation Winner of MariaDB Python Hackathon 2025\"/p pThe post Adaptive Query Optimizer for MariaDB Vector – Innovation Winner [...]

Saturday, 06. December 2025

Mitigating LWLock Contention in PostgreSQL (from MinervaDB Blog)

Mitigating LWLock Contention in PostgreSQL: Optimizing Fast-Path Locking, Partition Pruning, and Index Strategy for High-Concurrency Workloads Improving PostgreSQL performance under lock manager contention necessitates a detailed understanding of Lightweight Locks and fast-path locking behavior, followed [...] [...]

Friday, 05. December 2025

Deep Dive: High-Throughput Bulk Loading in PostgreSQL (from MinervaDB Blog)

Deep Dive: High-Throughput Bulk Loading in PostgreSQL In high-volume data environments, the standard SQL INSERT statement is an efficiency killer. When ingesting terabytes of data or migrating legacy systems, relying on row-by-row processing creates unacceptable [...] [...]

preFOSDEM MySQL Belgian Days 2026 (from FOSDEM MySQL & Friends Devroom)

We are excited to announce that the preFOSDEM MySQL Belgian Days 2026 will take place on Thursday, 29 January and Friday, 30 January 2026, in Brussels — just before FOSDEM 2026. This two-day gathering brings together the MySQL community: developers, DBAs, engineers, tool-builders, and enthusiasts — offering a fantastic opportunity for knowledge sharing, networking, and […] [...]

Effective MySQL Online DDL: Making Critical Database Schema Changes with Zero Downtime (from PingCAP Blog)

pOnline Data Definition Language (DDL) is a crucial feature for modern databases and a cornerstone of MySQL modernization strategies. It allows schema changes without significant downtime or locking that could disrupt database operations. This means these operations carry out while the database continues to be available for reads and writes, minimizing downtime and avoiding disruption […]/p p [...]

Dagster integration for MariaDB – 2nd place in MariaDB BangPypers Hackathon 2025 (from MariaDB Foundation Blog)

pWe recently announced the winners of the MariaDB Hackathon at the BangPypers meetup in Bengaluru. We are now interviewing the winner submissions, continuing with the Integration track second place winner. … /p pContinue reading \"Dagster integration for MariaDB – 2nd place in MariaDB BangPypers Hackathon 2025\"/p pThe post Dagster integration for MariaDB – 2nd place in MariaDB Ba [...]

How ClusterControl Saved Christmas – Part 2 (from Severalnines Blog)

pFreedom Isn’t Free When You’re Stuck in Someone Else’s Cloud Welcome to the second of a 6 part holiday series called, How ClusterControl Saved Christmas! If you missed part one, start here: Part 1 A Familiar Chain in the Code By February, the snow outside the North-Pole data center had melted just enough for the […]/p pThe post How ClusterControl Saved Christmas – Part 2 appeared first [...]

Thursday, 04. December 2025

Apache Airflow integration for MariaDB – winner of MariaDB BangPypers Hackathon 2025 (from MariaDB Foundation Blog)

pWe recently announced the winners of the MariaDB Hackathon at the BangPypers meetup in Bengaluru. We sat down with the Integration track first place winner to learn more about the team and their submission.  … /p pContinue reading \"Apache Airflow integration for MariaDB – winner of MariaDB BangPypers Hackathon 2025\"/p pThe post Apache Airflow integration for MariaDB – winn [...]

Cloud-Native MySQL High Availability: Understanding Virtually SYNC and ASYNC Replication (from Percona Database Blog)

♦When we run databases in Kubernetes, we quickly learn one important truth: things will fail, and we need to be prepared for this. Pods are ephemeral; nodes can come and go, storage is abstracted behind PersistentVolumes and can be either local to a node or backed by network storage, and Kubernetes moves workloads as needed […] [...]

Installing a MariaDB Galera Cluster on Ubuntu 24.04 | MariaDB Galera pt 1 (from Vettabase)

At Vettabase, we’re starting a new blog series on High Availability (HA) with focus on MariaDB Galera Cluster. This series will be a collection of hands-on guides, each tackling one practical topic: from installation, configuration, and adding or removing nodes, to backups, upgrades, and schema changes. Our goal is simple: create a complete, practical reference that anyone can follow to deplo [...]

Redgate joins MariaDB Foundation as Silver Sponsor (from MariaDB Foundation Blog)

pWe’re delighted to welcome Redgate as a new Silver Sponsor of the MariaDB Foundation.br Redgate is well known across the database world for software solutions which reliably solve the challenges of database management – … /p pContinue reading \"Redgate joins MariaDB Foundation as Silver Sponsor\"/p pThe post Redgate joins MariaDB Foundation as Silver Sponsor appeared first on Mar [...]

(from DoltHub Blog)

![CDATA[ After 5 years, Dolt performs just as well as MySQL on Sysbench ]] [...]

Wednesday, 03. December 2025

Trust but Verify: A Playbook for Database Consistency Checks (from Continuent Blog)

Technical walkthrough of database consistency verification using Tungsten Replicator, including checksum-based table scans, targeted row validation with limits, operational risks, and performance best practices.Tags: tungsten replicatorvalidationdatabase consistency [...]

Azure Database for MySQL triggers for Azure Functions (Public Preview) (from Azure for MySQL Blog)

pDevelopers can now accelerate development time and focus only on the core business logic of their applications, for developing event-driven applications with Azure Database for MySQL as the backend data store./p p /p pWe are excited to announce that you can now invoke an Azure Function based on changes to an Azure Database for MySQL table. This new capability is made possible through the  [...]

Ignite 2025: Advancing Azure Database for MySQL with Powerful New Capabilities (from Azure for MySQL Blog)

pAt Ignite 2025, we’re introducing a wave of powerful new capabilities for Azure Database for MySQL, designed to help organizations modernize, scale, and innovate faster than ever before. From enhanced high availability and seamless serverless integrations to AI-powered insights and greater flexibility for developers, these advancements reflect our commitment to delivering a resilient, intelligent [...]

MySQL Replication Best Practices: How to Keep Your Replicas Sane (and Your Nights Quiet) (from Percona Community Blog)

pMySQL replication has been around forever, and yet… people still manage to set it up in ways that break at the worst possible moment. Even in 2025, you can get burned by tiny schema differences, missing primary keys, or one forgotten config flag. I’ve seen replicas drift so far out of sync they might as well live in a different universe./p pThis guide covers the practical best practices—the stuff [...]

(from DoltHub Blog)

![CDATA[ As of version 1.78.0, we have a new value for zero time. What does this mean and why did we make this change? ]] [...]

Tuesday, 02. December 2025

Open Source AI Models Building a Development Team (from Another MySQL DBA)

pThe Question We're Finally Asking/ppFor years we've debated: Can AI replace software engineers? The question was always a bit theatrical. The real question—the one that actually matters—is a different one entirely: Can AI augment the engineering process in ways that make better code happen faster?/ppI think we're closer to a practical answer than we realize./ppThere's a concept that's been brewing [...]

Advanced Query Plan Management in Aurora PostgreSQL (from MinervaDB Blog)

Advanced Query Plan Management in Aurora PostgreSQL: Stabilizing Performance Across Version Upgrades When upgrading Amazon Aurora PostgreSQL to a new major version, database administrators must not only plan for compatibility and downtime but also guard [...] [...]

How ClusterControl Saved Christmas – Part 1 (from Severalnines Blog)

pRepatriation, Control, and the Start of Santa’s Database Modernization Journey Welcome to the first of a 6 part holiday series called, How ClusterControl Saved Christmas! Releasing twice a week, each part will take a look at issues and solutions around operational control and continuity for modern data workloads from what we hope is a fun […]/p pThe post How ClusterControl Saved Christmas &# [...]

Benefits of Importing Data with MariaDB CONNECT and PostgreSQL Data Wrappers (from Vettabase)

There are many ways to import data from external sources into a database. MariaDB and PostgreSQL offer native solutions: the MariaDB CONNECT storage engine and PostgreSQL Foreign Data Wrappers. Unfortunately, these options are often overlooked, in favour of more expensive, more fragile and slower solutions. Let’s see what CONNECT and FDWs are, and why they are often the best choice for import [...]

Using db_bench to measure RocksDB performance with gcc and clang (from Small Datum)

pThis has results for db_bench, a benchmark for RocksDB, when compiling it with gcc and clang. On one of my servers I saw a regression on one of the tests (fillseq) when compiling with gcc. The result on that server didn't match what I measured on two other servers. So I repeated tests after compiling with clang to see if I could reproduce it./pptl;dr/pp/pullia common outcome is/liulli~10% more QPS [...]

How We Optimize RocksDB in TiKV — SST Compaction Guard (from siddontang on Medium)

How We Optimize RocksDB in TiKV — SST Compaction GuardpCompaction is one of the most expensive operations inside RocksDB, and for TiKV — a distributed, region-based key–value store — compaction inefficiency can translate directly into wasted I/O, higher write amplification, and slower read operations./ppIn this article, I’ll explain a fundamental problem in TiKV’s compaction workflow, why RocksDB’s [...]

Monday, 01. December 2025

Upgrade Now: Announcing MySQL Galera Cluster In-Place Migration to MariaDB Galera Cluster (from MariaDB Corporation Blog)

We have two important announcements for the MySQL Galera Cluster community. First, we are excited to announce a new, seamless […] [...]

On High-dimensional computational geometry and databases. Q&A with Vissarion Fisikopoulos (from ODBMS.org)

Q1.   MySQL’s spatial query optimizer must handle complex geometric predicates efficiently. Can you walk us through the key challenges in optimizing spatial queries—particularly for operations like spatial joins and nearest-neighbor searches? How do computational geometry... [...]

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

How to Build an AI Agent that Builds Full-Stack Apps (from PingCAP Blog)

pAn open-source starter kit for building a “Lovable.dev”-style AI agent More and more, we’re seeing AI agents build entire applications from a single prompt. Platforms like Lovable.dev and Manus are pioneering this space. Many of them are using TiDB Cloud to power their data layer. So, we decided to build one too, as a public, […]/p pThe post How to Build an AI Agent that Bu [...]

How much will openness matter to AI? (from InfoWorld)

pSometimes in tech we misunderstand our history. For example, because Linux eventually commoditized the Unix wars, and because Apache and Kubernetes became the standard plumbing of the web, we assume that “openness” is an inevitable force of nature. The narrative is comforting; it’s also mostly wrong./p pAt least, it’s not completely correct in the ways advocates sometimes [...]

Keeping the ride safe: Lessons from Seattle group bike rides (from Jeremy Cole)

So you want to run a group ride? Group bike rides are one of the most fun ways to explore a city with your friends, or just to spend a few hours or a day out. Joining organized group rides such as Critical Mass in your city is a great way to meet like-minded people […] [...]

(from DoltHub Blog)

![CDATA[ Dolt supports a new configuration option, `listener.require_client_cert`, that forces all clients to send a certificate when they connect, otherwise the connect is refused. You can use this option to globally require all clients to present a certificate so that both ends of the connection are verified. ]] [...]

MySQL BLOB Internals - Partial Update Implementation and Multi-Versioning (from Zhao Song's Blog)

In this blog, I would like to introduce the implementation of BLOB and BLOB partial update in MySQL, and explain how the current design works together with the MVCC module to support multi-version control for BLOB columns. [...]

Sunday, 30. November 2025

Upgrade Now: Announcing MySQL Galera Cluster In-Place Migration to MariaDB Galera Cluster (from Galera Blog)

We have two important announcements for the MySQL Galera Cluster community. First, we are excited to announce a new, seamless In-Place Migration path to MariaDB Galera Cluster. This migration process has been rigorously tested and confirmed to be straightforward and, in the vast majority of scenarios, achieves minimal operational interruption. Second, with this fully supported […] [...]

DEP-18: A proposal for Git-based collaboration in Debian (from Optimized by Otto)

♦pI am a huge fan of Git, as I have witnessed how it has made software development so much more productive compared to the pre-2010s era. I wish all Debian source code were in Git to reap the full benefits./p pGit is not perfect, as it requires significant effort to learn properly, and the ecosystem is complex with even more things to learn ranging from cryptographic signatures and commit hooks to [...]

Saturday, 29. November 2025

Using sysbench to measure how Postgres performance changes over time, November 2025 edition (from Small Datum)

pThis has results for the sysbench benchmark on a small and big server for Postgres versions 12 through 18. Once again, Postgres is boring because I search for perf regressions and can't find any here. Results from MySQL are here and MySQL is not boring./ppWhile I don't show the results here, I don't see regressions when comparing the latest point releases with their predecessors -- 13.22 [...]

Using sysbench to measure how MySQL performance changes over time, November 2025 edition (from Small Datum)

pThis has results for the sysbench benchmark on a small and big server for MySQL versions 5.6 through 9.5. The good news is that the arrival rate of performance regressions has mostly stopped as of 8.0.43. The bad news is that there were large regressions from 5.6 through 8.0./pptl;dr for low-concurrency tests/pp/pullifor point queries/liulliMySQL 5.7.44 gets about 10% less QPS than 5.6.51/liliMySQ [...]

Friday, 28. November 2025

Attribute promotion and demotion in the MariaDB Galera Cluster (from Shinguz's Blog)

pIn MariaDB master/slave replication there is a feature called attribute promotion/demotion./p pSimply put, it is about how the slave behaves or should behave if the master and slave have different column definitions or even a different number of columns or a different sequence of columns./p Use case of the customer pThis week we discussed with a customer the case of how he could perform a roll [...]

Object Storage Is Rewriting the Database Playbook (from siddontang on Medium)

pRecently I re-watched an interesting talk — Stanford CS 153: Infra @ Scale — Cursor CTO & Co-Founder Sualeh Asif, where he walked through how Cursor scaled their infrastructure and what broke along the way./ppUnderneath the war stories is a very clear message:/pblockquoteObject storage isn’t just for analytics anymore — it’s quietly reshaping how we should build OLTP databases./blockquotepAnd [...]

Thursday, 27. November 2025

How Manus 1.5 Uses TiDB X to Let Agents Ship Full-Stack Apps at Scale (from PingCAP Blog)

pSoftware is shifting from developer-driven to agent-driven. With Manus 1.5, AI agents don’t just “help you code”; they spin up full-stack applications end-to-end. Ideas move from prompt to deployed app in minutes. It’s a glimpse of what’s next: rapid iteration, parallel exploration, and continuous change without human bottlenecks. That speed creates a new reality for […]/p pThe post How Manu [...]

Wednesday, 26. November 2025

Tombstone Storms in Apache Cassandra (from MinervaDB Blog)

Understanding and Mitigating Tombstone Storms in Apache Cassandra Apache Cassandra is a highly scalable, distributed NoSQL database designed for high availability and performance across commodity hardware. However, one of the most insidious performance issues that [...] [...]

Let’s Rebuild the MySQL Community Together (from Percona Database Blog)

♦Where We Are We can all agree that the MySQL ecosystem isn’t in great shape right now. Take a look at Julia’s blog post [Analyzing the Heartbeat of the MySQL Server: A Look at Repository Statistics], which confirms what many of us have felt: Oracle isn’t as committed to MySQL and its ecosystem as it […] [...]

Guardrails for Tungsten Maintenance: Using Ansible Like a Pro for Safe Changes (from Continuent Blog)

Practical guide to using Ansible safely with Tungsten Clustering, including outage analysis, maintenance mode usage, rolling database operations, and automation guardrails to prevent cascading failures in production MySQL clusters.Tags: MaintenanceAnsiblerolling restartbest practices [...]

Tuesday, 25. November 2025

Simplify data integration using zero-ETL from self-managed databases to Amazon Redshift (from AWS Database Blog)

In this post, we demonstrate how to set up a zero-ETL integration between self-managed databases such as MySQL, PostgreSQL, SQL Server, and Oracle to Amazon Redshift. The transactional data from the source gets replicated in near real time on the destination, which processes analytical queries. [...]

Announcing AWS Glue zero-ETL for self-managed Database Sources (from AWS What's New)

pAWS Glue now supports zero-ETL for self-managed database sources. Using Glue zero-ETL, you can now setup an integration to replicate data from Oracle, SQL Server, MySQL or PostgreSQL databases which are located on-premises or on AWS EC2 to Redshift with a simple experience that eliminates configuration complexity.br br AWS zero-ETL for self-managed database sources will automatically create an int [...]

Slack is a Suboptimal Feed Reader (RSS / Atom) (from J-F Gagné's MySQL Blog)

This is a MySQL Blog, why am I posting about Slack, Feed Readers, RSS and Atom ?  Because blog aggregators, which are usually consumed on their RSS or Atom interface via a Feed Reader, are an important knowledge sharing tool in the MySQL Community (and in other communities, see Valkey below).  I know some people are using Slack as their Feed Reader, and I recently realized Slack is [...]

Building the Future of MySQL: Announcing Plans for MySQL Vector Support and a MySQL Binlog Server (from Percona Database Blog)

♦At Percona, our mission has always been to help you succeed with open source databases. We do that by listening to the community, understanding the challenges you face, and building the solutions you need. Now, after a comprehensive review of market trends and direct feedback from our customers and the MySQL community, we are excited […] [...]

Snowflake to acquire Select Star to enhance its Horizon Catalog (from InfoWorld)

pSnowflake has signed a definitive agreement to acquire San Francisco-based startup Select Star’s team and context metadata platform to enhance its Horizon Catalog offering, the company said in a statement./p pHorizon Catalog is a unified data discovery, management, and governance suite inside the cloud-based data warehouse provider’s Data Cloud offering./p pData and go [...]

Monday, 24. November 2025

Analyzing the Heartbeat of the MySQL Server: A Look at Repository Statistics (from Percona Database Blog)

♦The MySQL database server is a foundational component of the open-source world. While its impact is undeniable, looking at the raw statistics of its core source code repository reveals a dynamic and sometimes surprising development history. By analyzing the total lines of code inserted, the number of commits over the years, and unique contributors, we […] [...]

The Right Tool for the Job (from Percona Community Blog)

pWhen I first got into woodworking, my mentor shared a piece of advice that has stuck with me ever since: “Use the right tool for the job.” You wouldn’t reach for a belt sander to flatten a board when a planer can accomplish the task faster, cleaner, and with far better results./p pThe same principle applies in the world of database engineering. When working with MySQL or Percona Server, choosing t [...]

(from DoltHub Blog)

![CDATA[ ]] [...]

Saturday, 22. November 2025

Challenges compiling old C++ code on modern Linux (from Small Datum)

pI often compile old versions of MySQL, MariaDB, Postgres and RocksDB in my search for performance regressions. Compiling is easy with Postgres as they do a great job at avoiding compilation warnings and I never encounter broken builds. Certainly the community gets the credit for this, but I suspect their task is easier because they use C.  This started as a LinkedIn post.brbrI expect people t [...]

How We Optimize RocksDB in TiKV — MVCC GC Optimization (from siddontang on Medium)

How We Optimize RocksDB in TiKV — MVCC GC OptimizationpTiKV implements distributed transactions based on Google’s Percolator model./ppEvery data may have multiple versions, and TiKV assigns timestamps using a centralized timestamp oracle (TSO) that generates globally unique, monotonically increasing timestamps. These timestamps serve as the version identifiers for MVCC reads and writes across the e [...]

Friday, 21. November 2025

MariaDB Connector/C 3.4.8, and 3.3.18 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C 3.4.8, and 3.3.18. Release Notes and Changelogs MariaDB Connector/C […] [...]

Troubleshooting MySQL Group Replication Performance (from MinervaDB Blog)

Troubleshooting MySQL Group Replication Performance Bottlenecks: A Technical Deep Dive MySQL Group Replication (GR) provides native high availability and fault tolerance through synchronous multi-master or single-primary replication. However, its distributed nature introduces unique performance challenges. [...] [...]

How PostgreSQL and MySQL Handle No-Op Updates (from MinervaDB Blog)

How PostgreSQL and MySQL Handle No-Op Updates: A Performance Deep Dive Introduction No-op updates in SQL—where an UPDATE statement sets columns to their existing values—are rare in well-designed applications. Yet legacy code, third-party plugins, or [...] [...]

AWS Organizations now supports upgrade rollout policy for Amazon Aurora and Amazon RDS (from AWS What's New)

pToday, AWS Organizations announces support for upgrade rollout policy, a new capability that helps customers stagger automatic upgrades across their Amazon Aurora (MySQL-Compatible Edition and PostgreSQL-Compatible Edition) and Amazon Relational Database Service (Amazon RDS) including RDS for MySQL, RDS for PostgreSQL, RDS for MariaDB, RDS for SQL Server, RDS for Oracle, and RDS for Db2 databases. [...]

Learning Structured Query Language (SQL) with open-source software : SQLite and DBeaver (from PHP With MySQL)

pStructured Query Language, or SQL is one of the top-rated computer languages, year after year. But learning its quirky syntax and how to control its power can be a challenge. /pWhy?pFirst, you need a database. In most cases, that means setting up a relational database. You need to install the software, get it running, create accounts, and somehow load data before you can use it. This is like [...]

MariaDB 12.2.1 Release Candidate now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 12.2.1, the latest release candidate (RC) rolling release.br MariaDB 12.2.1 features deeper MySQL and Oracle compatibility, removal of the depth limit from JSON functions, and additional Information Schema tables and columns. … /p pContinue reading \"MariaDB 12.2.1 Release Candidate now available\"/p pThe post MariaDB [...]

Zencoder becomes Silver Sponsor of MariaDB Foundation (from MariaDB Foundation Blog)

pMariaDB Foundation is pleased to announce that Zencoder has joined as a Silver Sponsor.br Zencoder describes itself as “a universal AI platform focused on integrating generative coding workflows into existing developer tools and infrastructure. … /p pContinue reading \"Zencoder becomes Silver Sponsor of MariaDB Foundation\"/p pThe post Zencoder becomes Silver Sponsor of MariaDB Foundat [...]

AI-Powered Postgres index suggestions (from PlanetScale Blog)

Introducing AI-powered index suggestions for PostgreSQL [...]

Thursday, 20. November 2025

MySQL 8.4 Memory Limits: tmp_table_size vs. temptable_max_ram (from Another Boring Tech Blog)

pI recently got into a bit of a debate about standardizing MySQL 8.4’s internal temporary table configuration. We wanted to cap memory usage efficiently, but relying on “rules of thumb” isn’t enough when production stability is at stake. The main confusion was about how per-query limits fight with global limits. So, rather than guessing, I.../p pO post MySQL 8.4 Memory Limits: tmp [...]

Azure HorizonDB: Microsoft goes big with PostgreSQL (from InfoWorld)

pEnterprises need data, and data needs to be stored, with a flexible, portable environment that scales from developers’ laptops to global clouds. That storage also needs to be able to run on any OS and any cloud without breaking the bank./p pThere aren’t many options. You might be able to use MySQL or any of its forks for most purposes, but it struggles to support large da [...]

(from DoltHub Blog)

![CDATA[ Dolt's SQL server now supports mutual TLS authentication. You can configure user accounts to require a client to present a valid certificate that is chained from the servers CA cert. You can also place additional constraints on the SSL cipher, certificate subject, and certificate issuer. ]] [...]

Wednesday, 19. November 2025

Comparing MySQL Operators on Kubernetes: Which One Fits Your Workloads? (from Continuent Blog)

Compare leading MySQL Operators for Kubernetes, including Oracle, Percona, KubeDB, and Tungsten Operator. Learn how they differ in replication, failover, backups, zero-downtime operations, and which operator best fits your MySQL workloads.Tags: kubernetesTungsten OperatorHigh Availability [...]

Deploying on OCI with the starter kit – part 3 (applications) (from lefred's blog)

We saw in part 1 how to deploy our starter kit in OCI, and in part 2 how to connect to the compute instance. We will now check which development languages are available on the compute instance acting as the application server. After that, we will see how easy it is to install a new […] [...]

Percona Operator for MySQL Is Now GA, More MySQL Options for the Community on Kubernetes (from Percona Community Blog)

pWe’re excited to share that the new Percona Operator for MySQL (based on Percona Server for MySQL) is officially in General Availability (GA)!/p pThis release introduces native MySQL Group Replication support for Kubernetes, providing our community with another open-source option for running reliable, consistent MySQL clusters at scale./p pThis is about more choices for the community. Each MySQL r [...]

MariaDB 12.1.2 rolling release now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 12.1.2, the latest stable rolling release.br MariaDB 12.1.2 features performance enhancements, deeper MySQL and Oracle compatibility, and other general improvements. … /p pContinue reading \"MariaDB 12.1.2 rolling release now available\"/p pThe post MariaDB 12.1.2 rolling release now available appeared first on MariaDB [...]

Common Schema Design Patterns for SaaS — and How TiDB Helps (from siddontang on Medium)

Common Schema Design Patterns for SaaS — and How TiDB HelpspWhen you’re building a SaaS app, the first big question about your database usually isn’t SQL or NoSQL, it’s —/pblockquote“Where should I put all my tenants’ data?”/blockquotepAnd that simple question opens a deep rabbit hole of schema design choices, trade-offs, and a few “oh no” moments you’ll only discover at scale./ppI’ve been there. H [...]

(from DoltHub Blog)

![CDATA[ Dolt makes it possible to implement a Cursor-like user interface for any database backed application, complete with diff and rollback. This article explains how. ]] [...]

Tuesday, 18. November 2025

What’s New in MariaDB 12: Full Release Guide  (from Devart MySQL Tool Blog)

pLearn what’s new in MariaDB 12. Release notes, features, breaking changes, benchmarks, and upgrade tips. Try dbForge Studio for MySQL free today./p pThe post What’s New in MariaDB 12: Full Release Guide  appeared first on Devart Blog./p [...]

Announcing MariaDB Community Server 12.1 GA (from MariaDB Corporation Blog)

[...]

Introducing the GA Release of the New Percona Operator for MySQL: More Replication Options on Kubernetes (from Percona Database Blog)

♦The Percona Cloud Native team is happy to announce the general availability of the Percona Operator for MySQL, based on Percona Server for MySQL. This release introduces an additional Kubernetes-native approach to deploying and managing MySQL clusters with synchronous Group Replication, delivering the consistency required for organizations with business continuity needs. With this release, Percona [...]

Amazon RDS for MariaDB now supports community MariaDB minor versions 10.6.24, 10.11.15, and 11.4.9 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports community MariaDB minor versions 10.6.24, 10.11.15, and 11.4.9. 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 leverage [...]

Monday, 17. November 2025

Accelerate database modernization using AI with the Database Modernizer Workshop (from AWS Database Blog)

In this post, we show how you can use the Database Modernizer workshop to accelerate your database modernization journey from MySQL to Amazon DynamoDB. Traditional approaches to migrating from relational databases to NoSQL solutions like DynamoDB can take several months, requiring extensive expertise in data modeling, application refactoring, and migration strategies. The Database Modernizer worksh [...]

BangPypers x MariaDB Python Hackathon – Winners Announced! (from MariaDB Foundation Blog)

pLast Saturday marked an exciting milestone: the announcement of the winners in our first large-scale MariaDB Python Hackathon, organised in collaboration with BangPypers, HackerEarth, and MariaDB plc. … /p pContinue reading \"BangPypers x MariaDB Python Hackathon – Winners Announced!\"/p pThe post BangPypers x MariaDB Python Hackathon – Winners Announced! appeared first on MariaDB.org./p [...]

Deploying on OCI with the starter kit – part 2 (from lefred's blog)

In part 1, we saw how to deploy several resources to OCI, including a compute instance that will act as an application server and a MySQL HeatWave instance as a database. In this article, we will see how to SSH into the deployed compute instance. Getting the key To connect to the deployed compute instance, […] [...]

TiDB AgentX Hackathon 2025 Recap: Double the Submissions, Real-World AI on Display (from PingCAP Blog)

pThe results are in, and they are spectacular. When we challenged the community to move beyond simple RAG demos, we never imagined the sheer ingenuity we’d see. With 219 incredible submissions, the AgentX Hackathon 2025 proved one thing: the era of sophisticated, multi-step AI agents is here. A New Chapter for TiDB Hackathons Last year’s […]/p pThe post TiDB AgentX Hackathon 2025 [...]

MariaDB 11.8.5 critical bugfix release now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation announces the availability of MariaDB 11.8.5.br Users of MariaDB 11.8.4 are strongly recommended to upgrade to the new release.br MariaDB 11.8.4 is affected by an issue resulting in only partial deletion of data on MyISAM or Aria tables under specific conditions. … /p pContinue reading \"MariaDB 11.8.5 critical bugfix release now available\"/p pThe post MariaDB 11.8.5 [...]

Amazon Aurora MySQL 3.11 (compatible with MySQL 8.0.43) 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.43 through Aurora MySQL v3.11.br br In addition to several security enhancements and bug fixes, MySQL 8.0.43 contains additional errors for group replication and introduces the mysql client “commands” option, which enables or disables most mysql client commands. For more details, refer [...]

Amazon RDS for MySQL now supports new minor versions 8.0.44 and 8.4.7 (from AWS What's New)

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

Saturday, 15. November 2025

(from DoltHub Blog)

![CDATA[ This guide will help you set up Dolt (a version-controlled SQL database) with Claude Code, enabling you to use AI to make database changes that you can track, review, and manage through the Dolt Workbench. ]] [...]

Friday, 14. November 2025

Introducing fully managed Blue/Green deployments for Amazon Aurora Global Database (from AWS Database Blog)

Today, we're introducing Amazon RDS Blue/Green support for Aurora Global Database, enabling database upgrades and modifications with minimal downtime. With just a few steps, you can create a blue/green deployment that establishes a fully managed staging (green) environment mirroring the existing production (blue) environment, including the primary and its associated secondary regions of the Global [...]

Speak About MySQL At SCaLE 23x (from Dave's MySQL Stuff)

pI help facilitate the MySQL track at SCaLE. I am seeking first-time presenters who can discuss MySQL.  I am also looking for old-timers who haven't spoken in a while at a conference and those who have forgotten to submit a talk. /ppThe MySQL Community is at a crossroads, and the MySQL track will cap off a day with a panel on the past, present, and future of MySQL. /ppThe 2 [...]

MariaDB Community Server 11.8.5 Corrective Release (from MariaDB Corporation Blog)

MariaDB informs users of the immediate availability of MariaDB Community Server 11.8.5, a crucial corrective release for the 11.8 series. […] [...]

Deploying on OCI with the starter kit – part 1 (from lefred's blog)

If you want to create a new application, test it, and deploy it on the cloud, Oracle Cloud Infrastructure provides an always-free tier for compute instances and MySQL HeatWave instances (and more). If you are a developer, it can also be complicated to start deploying to the cloud, as you need to figure out the […] [...]

A Tale of Two Databases: No-Op Updates in PostgreSQL and MySQL (from Percona Database Blog)

♦I’m lazy when I’m speakin’ I’m lazy when I walk I’m lazy when I’m dancin’ I’m lazy when I talk   X-Press 2 Feat. David Byrne – Lazy While preparing a blog post to compare how PostgreSQL and MySQL handle locks, as part of a series covering the different approaches to MVCC for these databases, […] [...]

$5 PlanetScale is live (from PlanetScale Blog)

You can now create single node Postgres databases on PlanetScale starting at just $5. [...]

Thursday, 13. November 2025

CSV File Load Error - Data Too Long or Value Too Long (from Dave's MySQL Stuff)

p  You are trying to load a CSV file into a database, and almost inevitably, you run into an ERROR: value too long for type character varying 64 if you are using PostgreSQL.  Or SQL Error [1406] [22001]: Data truncation: Data too long for column 'Name' at row 1 if you are using MariaDB or MySQL./ppIt doesn't matter if you are using the DBeaver application or [...]

Building brighter futures: How YES tackles youth unemployment with Azure Database for MySQL (from Azure for MySQL Blog)

pThis article was co-authored by Malcolm MacDonald, CIO at YES, and Saurabh Kirtani, Senior Product Manager at Microsoft/p pbrYouth unemployment is one of South Africa’s most persistent challenges with more than half of young people struggling to secure their first job. At the same time, employers hesitate to hire people without experience, and youth cannot gain experience without employment. Solvi [...]

Zero-Downtime Upgrades: How TiDB Powers Always-On Databases (from PingCAP Blog)

pIn the vast landscape of databases, ensuring zero-downtime upgrades and operation continuity remains a challenge. Due to inherent design limitations, traditional databases often introduce significant downtime during upgrades – a challenge that can spell operational chaos for businesses reliant on real-time data access.  Enter TiDB, a cutting-edge distributed SQL database that offers a s [...]

How we optimize RocksDB in TiKV (Part 1) — The Battle Against the DB Mutex (from siddontang on Medium)

How we optimize RocksDB in TiKV — The Battle Against the DB MutexpWhen we started building TiKV nine years ago, we chose RocksDB as our storage engine. And for good reasons — it’s a highly efficient, battle-tested key-value store with a flexible LSM-tree design that’s proven at scale. It gave us a great foundation to build a distributed transactional key-value database on./ppBut as our users’ data [...]

Wednesday, 12. November 2025

Why successful people should be mentored? (from AskDba)

Not knowing whether you need a mentor or not at the beginning. People often assume that mentorship is something you outgrow. They imagine it as a ladder. It’s something you climb early in your career. Once you reach a certain level of success, you step off and stand on your own. In reality, the opposite […] [...]

Real-World SaaS Multi-Region MySQL: Tungsten Cluster Implementation Guide (from Continuent Blog)

Comprehensive guide to implementing a real-world multi-region MySQL SaaS deployment with Tungsten Cluster, covering architecture design, automation, monitoring, and operational best practices.Tags: SaaSmulti-region databasereplicationHigh Availabilityzero downtime [...]

Tuesday, 11. November 2025

MariaDB 12 Triggers (from SQL And Its Sequels (Ocelot Blog))

There’s new SQL syntax in MariaDB 12. MariaDB’s manual doesn’t document it all, so I will try. First in this series is: the Oracle-style CREATE TRIGGER … event with OR, and the standard-style table information_schema.triggered_update_columns. event with OR CREATE TRIGGER trigger_name BEFORE|AFTER INSERT|UPDATE [OF column-list]|DELETE [OR INSERT|UPDATE [OF [...]

Extending Flexibility in MySQL HeatWave Maintenance: Introducing Configurable Maintenance (from The Oracle MySQL Blog)

Align upgrades with your business schedules, minimize disruption, and plan version transitions with confidence, all while maintaining the reliability and compliance you expect from MySQL HeatWave. We are also extending Innovation release available cycle from 3 months to 5 months, this enables customers to stay on the same innovation release version for longer period of time. [...]

MySQL Memory Usage: A Guide to Optimization (from Percona Community Blog)

pStruggling with MySQL memory spikes? Knowing how and where memory is allocated can make all the difference in maintaining a fast, reliable database. From global buffers to session-specific allocations, understanding the details of MySQL’s memory management can help you optimize performance and avoid slowdowns. Let’s explore the core elements of MySQL memory usage with best practices for trimming e [...]

(from DoltHub Blog)

![CDATA[ How we build Dolt from source on Windows using Git Bash, MSYS2, and pacman. ]] [...]

Monday, 10. November 2025

MariaDB Enterprise Manager: The Native Way to Manage All Your MariaDB Environments (from MariaDB Corporation Blog)

[...]

What’s New At Releem - October 2025 (from Releem Blog)

Another month in the books – and it’s been a great one. Highlights include support for GCP Cloud SQL, enhanced servers overview for multi-server management, and a round of Agent improvements focused on stability and lighter performance impact. [...]

A thread through my 2025 Postgres events (from Percona Community Blog)

pI recently got back from PostgreSQL Conference Europe in Riga, marking the end of my conference activities for 2025. The speakers were great. The audience, for the Extensions Showcase on Community Day on Tuesday and my Kubernetes from the database out talk, were great. The event team was great. The singing at karaoke was terrible, but it’s supposed to be./p pAfter attending a good few events this [...]

(from DoltHub Blog)

![CDATA[ In this post, I talk about the strategies used to improve agentic data importing using idempotent goal based planning and execution. ]] [...]

Sunday, 09. November 2025

Can an OLTP Database Compete in Analytics Benchmarks? The TiDB Story (from siddontang on Medium)

pTiDB was born as an OLTP database — designed from day one to solve the scalability limits that traditional transactional databases like MySQL, MariaDB or Aurora often hit./ppIts mission was clear: scale transactional workloads seamlessly without sacrificing MySQL compatibility or operational simplicity./ppHowever, TiDB’s story doesn’t stop there./ppThanks to its TiFlash component — a columnar, MPP [...]

Friday, 07. November 2025

Supercharging Real-Time Applications with TiDB and DragonflyDB (from PingCAP Blog)

pData-intensive applications demand scalability, low latency, and resilience. However, traditional databases often struggle to handle both transactional consistency and fast in-memory caching at scale. But that’s where TiDB and DragonflyDB shine together: In this tutorial, we’ll walk through setting up a TiDB + Dragonfly stack, show how they complement each other, and build a hands-on […]/p p [...]

AI makes JavaScript programming fun again (from InfoWorld)

pI feel some responsibility to sound a cautionary note amid all the AI fervor, and this report has seen a share of that. But, on the occasion of this November 2025 report, I’d like to instead celebrate AI-driven programming for all it’s worth./p pAt its best, AI brings back a feeling of excitement and fun to programming. It lifts some of the heavy grunt work off developers, [...]

More Django developers turning to AI – report (from InfoWorld)

pAI is becoming an important learning resource for users of Django, the well-established Python web framework. The recently published State of Django 2025 report notes that 38% of Django Developers Survey respondents said they were using AI tools to educate themselves on Django./p pFor Django development, 69% reported using ChatGPT, while 34% said they were using GitHub Co [...]

MariaDB 11.8.4, 11.4.9, 10.11.15 and 10.6.24 now available (from MariaDB Foundation Blog)

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

AWS Advanced .NET Data Provider Driver is Generally Available (from AWS What's New)

pThe Amazon Web Services (AWS) Advanced .NET Data Provider Driver is now generally available for Amazon RDS and Amazon Aurora PostgreSQL and MySQL-compatible databases. This advanced database driver reduces RDS Blue/Green switchover and database failover times, improving application availability. Additionally, it supports multiple authentication mechanisms for your database, including Federated Aut [...]

Thursday, 06. November 2025

MariaDB Unlocks Your Data for Secure, Enterprise-Grade Agentic with MariaDB AI RAG and MariaDB Enterprise MCP Server (from MariaDB Corporation Blog)

[...]

Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages) (from J-F Gagné's MySQL Blog)

While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug (Bug #111353 : 3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE).  There has been recent activity on this bug, showing an easy workaround.  This, even if it is known since 16 July 2024, has not been talked about much, so this deserves a blog post. [...]

MariaDB Community Server Q4 2025 maintenance releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.8.4, 11.4.9, 10.11.15, and 10.6.24 maintenance releases. See […] [...]

How to Scale TiDB Locally with Online DDL (from PingCAP Blog)

pData-intensive applications outgrow single-node MySQL long before product-market fit is “done.” Hot partitions, schema change windows, and manual sharding slow teams down. But TiDB solves this with a MySQL-compatible, distributed SQL architecture that scales storage and compute independently and keeps applications online during change. In this quick tutorial, we’ll spin up TiDB locally with [...]

MySQL Basics: Don’t Lose It—Backing Up and Restoring Your Database (from The Oracle MySQL Blog)

Learn how to safeguard your MySQL database with simple, reliable backup and restore techniques! This final post in the beginner series uses fun library analogies and clear MySQL Shell examples to ensure your data stays safe—no matter what surprises come your way. [...]

(from DoltHub Blog)

![CDATA[ FastAPI is a popular Python framework for building APIs. In this article, we'll build a sample application using FastAPI and Dolt. ]] [...]

Wednesday, 05. November 2025

Surprise with innodb_doublewrite_pages in MySQL 8.0.20+ (from Percona Database Blog)

♦In a recent post, The Quirks of Index Maintenance in Open Source Databases, I compared the IO load generated by open source databases while inserting rows in a table with many secondary indexes. Because of its change buffer, InnoDB was the most efficient solution. However, that’s not the end of the story. Evolution of the […] [...]

Enhanced Operational Databases (from Shattered Silicon OSDB Blog)

pThe post Enhanced Operational Databases appeared first on Shattered Silicon./p [...]

Simplified: Upgrade Non-SSL-enabled Tungsten v6 to SSL-enabled Tungsten v8 (from Continuent Blog)

Step-by-step guide to upgrading Tungsten Clustering and Replicator from version 6 (non-SSL) to version 8 (SSL-enabled). Learn how to enable SSL for MySQL, Tungsten Connectors, and REST APIs with minimal downtime and maximum data security.Tags: sslupgradeHigh Availability [...]

Tuesday, 04. November 2025

October Product Update (from Readyset Blog)

♦pAs traffic spikes approach for the holiday season, we’ve rolled out new improvements to help you keep database performance fast and predictable. Here’s what’s new:/p💬 Product UpdatespReadyset Core/pulliSmarter Time-Series Aggregations: We introduced codeBucket(timestamptz, interval)/code, a Readyset-specific SQL function that groups/li/ul [...]

Sysadmin’s Inconceivable Tales – Squeezing More Performance out of tar (from Shattered Silicon OSDB Blog)

pHow we squeezed 33% moreperformance out of tar on x86-64 Linux./p pThe post Sysadmin’s Inconceivable Tales – Squeezing More Performance out of tar appeared first on Shattered Silicon./p [...]

How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4 (from Kedar MySQL Blog)

pDuring a MySQL upgrade process the RDS replication between MySQL 8.0 and 8.4 was configured. I wanted to ensure the data was consistent for any random reason. This post is…/p The post How to checksum on AWS RDS for MySQL Replication 8.0 8.4 first appeared on Change Is Inevitable. [...]

MySQL Basics: Safe and Sound—User Management and Database Security (from The Oracle MySQL Blog)

Keep your MySQL database protected with beginner-friendly advice on user management and security! Learn how to create users, grant and revoke privileges, and safeguard your data using library-themed examples and practical tips. Essential reading for every data explorer eager to lock up their digital collection. [...]

GROUP BY ALL (from Modern SQL)

codeGroup by All/code: Generate codegroup by/code from codeselect/code♦olliCannot mix aggregates with non-aggregated columns: codea + count(*)/code/liliRemoves the codegroup by all/code clause if it leads to an error that does not happen without codegroup by/code clause/li/olpSome Systems allow the special codegroup by all/code syntax as a shorthand for grouping on all codeselect/code items that do [...]

Announcing Vitess 23 (from PlanetScale Blog)

Vitess 23 is now generally available [...]

Announcing Vitess 23.0.0 (from Vitess)

Announcing Vitess 23.0.0 # We’re excited to release Vitess 23.0.0 — the latest major version of Vitess — bringing new defaults, better operational tooling, and refined metrics. This release builds on the strong foundation of version 22 and is designed to make deployment and observability smoother, while continuing to scale MySQL workloads horizontally with confidence. ✅ Why This Release Matters # F [...]

Monday, 03. November 2025

Scoped Vector Search with the MyVector Plugin for MySQL – Part II (from AskDba)

Subtitle: Schema design, embedding workflows, hybrid search, and performance tradeoffs explained. Quick Recap from Part 1 In Part 1, we introduced the MyVector plugin — a native extension that brings vector embeddings and HNSW-based approximate nearest neighbor (ANN) search into MySQL. We covered how MyVector supports scoped queries (e.g., WHERE user_id = X) to ensure […] [...]

MariaDB vs PostgreSQL: Understanding the Architectural Differences That Matter (from MariaDB Foundation Blog)

pThis blog post is based on the YouTube presentation “MariaDB vs PostgreSQL: Technical Deep Dive | Architecture, Performance & Design Trade-offs” by Manoj Vakeel, part of MariaDB Foundation’s ongoing series exploring core database design choices and how they impact modern workloads. … /p pContinue reading \"MariaDB vs PostgreSQL: Understanding the Architectural Diff [...]

$50 PlanetScale Metal (from PlanetScale Blog)

Introducing $50 PlanetScale Metal [...]

Report on our investigation of the 2025-10-20 incident in AWS us-east-1 (from PlanetScale Blog)

On 2025-10-20, there was an incident that affected PlanetScale, initially caused by DNS misconfiguration in one of PlanetScale’s service providers, followed by several hours of capacity constraints and network instability. [...]

Sunday, 02. November 2025

Checking Your MySQL Server Before an Upgrade with MySQL Shell (from Another Boring Tech Blog)

pUpgrading MySQL is often seen as straightforward — install the new binaries, restart, done. In reality, it’s more like upgrading a production jet engine mid-flight. Small changes in defaults, deprecated settings, or old privileges can lead to surprises you don’t want at 2:00 AM on maintenance night. Or even worse, see your performance deteriorating during.../p pO post Checking Your MySQL Server Be [...]

Saturday, 01. November 2025

Migrating From MySQL To PostgreSQL in Five Simple Steps (from Dave's MySQL Stuff)

pThere are many reasons you may want to migrate from MySQL to PostgreSQL, which we will skip over for brevity.  I see many questions about moving tables and data, and sadly, the answers range from sloppy to incredibly complicated.  Each database migration is unique, as issues range from heavily relying on a vendor's feature to extremely complex schemas that require attention to minute det [...]

When Every AI Agent Needs Its Own Database: Why TiDB Cloud Is the Answer (from siddontang on Medium)

pImagine you’re building an AI startup./ppYour mission?/pblockquoteEmpower every customer to use an AI agent to build their own website — simply by chatting./blockquotepSounds magical — and it is. Products like Manus, Lovable, and others are already doing this. But under the hood, one question quickly becomes a nightmare for engineers:/ppWhere does each AI agent store its data?/ppEvery agent needs [...]

Friday, 31. October 2025

Troubleshooting MariaDB Performance (from MinervaDB Blog)

Troubleshooting MariaDB Performance: A Complete Guide MariaDB performance issues can significantly impact application responsiveness and user experience. Whether you’re experiencing slow queries, high CPU usage, or connection bottlenecks, understanding how to diagnose and resolve these [...] [...]

MariaDB 2025 High Availability Best Practices (from MinervaDB Blog)

MariaDB 2025 High Availability Best Practices High availability (HA) has become a critical requirement for modern database infrastructure. As organizations increasingly rely on MariaDB for mission-critical applications, implementing robust HA strategies ensures continuous service delivery [...] [...]

How Distributed ACID Transactions Work in TiDB (from PingCAP Blog)

pTransactions—especially distributed ACID transactions—are ubiquitous. Protocols around transactions are equally ubiquitous, even if we don’t immediately realize it. Take, for example, a common marriage ceremony. It’s essentially a two-phase commit (2PC) protocol. The officiant is the transaction coordinator (TC), and the couple getting married are the active participants. In the first phase, the T [...]

How to Configure pgBackRest Backups and Restores in PostgreSQL (Local/k8s) Using a MinIO Object Store (from Percona Database Blog)

♦This blog post explains how to configure and use MinIO as S3-compatible storage for managing PostgreSQL backups, and how to perform data restoration and recovery in both standalone (local) and Kubernetes environments. [...]

The clock's ticking for MySQL 8.0 as end of life looms (from The Register)

Percona says more than half of installs remain on version set to lose support in 2026 pUsers have six months to migrate from MySQL 8.0 if they are to stay on a supported version of the open source database, or face security and reliability risks.…/p [...]

Thursday, 30. October 2025

Encryption support in PMM Dump (from Percona Community Blog)

pThe codepmm-dump/code client utility performs a logical backup of the performance metrics collected by the PMM Server and imports them into a different PMM Server instance. PMM Dump allows you to share monitoring data collected by your PMM server with the Percona Support team securely./p pUp until now dumps, created by the tool, were not encrypted. It was possible to encrypt them after they are do [...]

$5 PlanetScale (from PlanetScale Blog)

Introducing the $5 PlanetScale plan. [...]

Last Call: State of MariaDB 2025 Survey (+ New Preview Insights) (from MariaDB Foundation Blog)

pThere are a couple days left until the survey closes – take this as a gentle nudge to participate if you’ve been meaning to 🙂 br Take the survey now! … /p pContinue reading \"Last Call: State of MariaDB 2025 Survey (+ New Preview Insights)\"/p pThe post Last Call: State of MariaDB 2025 Survey (+ New Preview Insights) appeared first on MariaDB.org./p [...]

MySQL Basics: Trust the Process—Mastering Transactions Step by Step (from The Oracle MySQL Blog)

Discover how to use transactions in MySQL to keep your data safe and organized—just like a diligent librarian! This beginner-friendly post explains what transactions are, why they matter, and how to use them with easy library metaphors, clear SQL examples, and essential tips for database reliability. [...]

Wednesday, 29. October 2025

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

Managing stateful, mission-critical databases on Kubernetes demands automation, reliability and a predictable lifecycle. We’re excited to announce the general availability […] [...]

Zero-Downtime MySQL Certificate Rotation (from Continuent Blog)

Learn how to rotate MySQL SSL/TLS certificates with zero downtime using Tungsten Clustering 7.2.0/8.0.1 and the tpm cert tool, including generating certs, dual-alias rollout, safe node-by-node restarts, SELinux fixes, and cleanup to retire old aliases without interrupting production.Tags: zero-downtime MySQLcertificate rotationtungsten clusterMySQL TLS [...]

No, you probably dont need Kubernetes (from The consistent voice)

pEt ouais, vous ne rêvez pas, je l’affirme en toute confiance. Haut et fort. Sur Linkedin le paradis de la hype et des buzzwords./ppComme le souligne fort justement Nicolas Martinez dans son excellent post, K8s ajoute une couche de complexité souvent inutile :/ppMaintenance lourde, coûts cachés, temps perdu, obligation d’avoir une équipe DevOps/SRE : le jeu en vaut-il la chandelle ?/ppConcernant Ma [...]

How deep can a bug be? (from MariaDB Foundation Blog)

pLast year I filed a bug report MDEV-33603 on what a looked like a benign problem with an optimizer taking a different code path in a particular trivial looking test. … /p pContinue reading \"How deep can a bug be?\"/p pThe post How deep can a bug be? appeared first on MariaDB.org./p [...]

(from DoltHub Blog)

![CDATA[ Modularization is critical for large codebases. If it feels like it's creating barriers, it's actually telling you something important about your code. ]] [...]

Tuesday, 28. October 2025

Performance Engineered: MariaDB Enterprise Server 11.8 Accelerates OLTP Workloads by 2.5x (from MariaDB Corporation Blog)

MariaDB 11.8 delivers up to 2.5x higher OLTP throughput on Dell PowerEdge R7715 servers powered by AMD EPYC™ processors MariaDB […] [...]

Keyword vs. semantic search with AI (from Programming Brain)

How to build keyword and semantic search in MariaDB using Python, LangChain, and AI embeddings. [...]

Practical Data Masking in Percona Server for MySQL 8.4 (from Percona Database Blog)

♦Data masking lets you hide sensitive fields (emails, credit-card numbers, job titles, etc.) while keeping data realistic for reporting, support, or testing. It is particularly useful when you collaborate with external entities and need to share your data for development reasons. You also need to protect your data and keep your customers’ privacy safe. Last […] [...]

Building and testing MySQL 8.0.44 / 8.4.7 / 9.5.0 releases on macOS (from Laurynas Biveinis' blog)

p Oracle MySQL 8.0.44 / 8.4.7 / 9.5.0 are out and it's time for me to build and run their tests on macOS, Apple Silicon hardware. I have skipped the review of the previous set of releases this summer due to personal reasons, so this covers the delta from 8.0.42 / 8.4.5 / 9.3.0, out in spring. /p Build p No need to use any of the bundled 3rd party libraries, and the current XCode (26.0.1) compile [...]

MySQL 9.5 – Thank you for your contributions! (from The Oracle MySQL Blog)

MySQL 9.5 has been released, here is a list of the contributions we included in it. Thank you to all contributors! [...]

MySQL 9.5 – Thank you for your contributions! (from lefred's blog)

On October 10th, 2025, we released MySQL 9.5, the latest Innovation Release. As usual, we released bug fixes for 8.0 and 8.4 LTS, but this post focuses on the newest release. In this release, we can see contributions related to Connector J and Connector Net, as well as to different server categories. Connector / J […] [...]

High Availability with MariaDB Galera Cluster Guide (from Mydbops Blog)

Ensure zero downtime and data consistency with our guide to setting up a MariaDB Galera Cluster, covering installation, configuration, and monitoring. [...]

MySQL Basics: The Inside Track—Speeding Up Searches with Indexes (from The Oracle MySQL Blog)

Unlock the secret to faster data searches with indexes! This post introduces beginners to the power of indexes in MySQL, using friendly library metaphors and simple SQL examples. Learn how—and why—to create indexes, understand their impact, and keep your growing database running at page-turning speed. [...]

Monday, 27. October 2025

Optimize and troubleshoot database performance in Amazon Aurora PostgreSQL by analyzing execution plans using CloudWatch Database Insights (from AWS Database Blog)

In this post, we demonstrate how you can use Amazon CloudWatch Database Insights to analyze your SQL execution plan to troubleshoot and optimize your SQL query performance in an Aurora PostgreSQL cluster. [...]

Effortless Document AI with MySQL HeatWave GenAI (from The Oracle MySQL Blog)

This post demonstrates how you can use HeatWave GenAI to transform an unstructured PDF of a purchase order into a structured, queryable format directly within your database. We'll walk through the process of loading a PO from an object store and then asking natural language questions to retrieve key details like order dates, item costs, and supplier information. [...]

Rethinking Scale: TiDB’s Evolution Into an AI Agent Database (from PingCAP Blog)

pRecently, I’ve been meeting customers across industries including AIaaS, Web3, and FinTech. No matter where I go, the conversation always turns to one thing: AI. Everyone’s asking the same question: “How will AI transform our business, and how does TiDB embrace this change?” So, I started sharing what had been on my mind lately. “The era […]/p pThe post Rethinking Scale: TiD [...]

ClusterControl 2.3.4 Adds MySQL Group Replication, Streamlined Air-Gapped Installation, and Controller Pooling for Scalable Management (from Severalnines Blog)

pWe’re happy to announce the release of ClusterControl v2.3.4, delivering powerful updates that strengthen high availability, secure deployment options, and scalability for enterprise-scale database management.  As with every release, we’ve focused on tackling real-world challenges our users face. Below, we’ll dive into the key features that define this release, followed by additional improvem [...]

How to Replicate TiDB to a Mirrored Database in Microsoft Fabric with TiCDC (from PingCAP Blog)

pTiDB is an open-source distributed SQL database built for cloud-native, data-intensive, and AI-driven applications. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability. By leveraging a TiCDC replication solution for Open Mirroring, TiDB seamlessly integrates with Microsoft Fabric. This unlocks continuous, real-time data synchronization from any TiD [...]

MariaDB Cloud – kicking the tires with openflights data (from MariaDB Foundation Blog)

pMariaDB plc recently acquired SkySQL and rebranded it MariaDB Cloud that offers serverless MariaDB as a service. Kaj Arnö interviewed the technical father, and now it is time for a practical, technical kick-the-tires look at MariaDB Cloud. … /p pContinue reading \"MariaDB Cloud – kicking the tires with openflights data\"/p pThe post MariaDB Cloud – kicking the tires wit [...]

Sunday, 26. October 2025

RAG Series – Agentic RAG (from dbi Blog)

pIntroduction In earlier parts, we moved from Naive RAG (vector search) to Hybrid RAG (dense + sparse) to Adaptive RAG (query classification and dynamic weighting). Each step improved what we retrieve. Agentic RAG goes further: the LLM decides if and when to retrieve at all and can take multiple steps (retrieve → inspect → refine […]/p pL’article RAG Series – Agentic RAG est apparu en premier [...]

Alfresco – When a JDBC driver breaks after years of stability (from dbi Blog)

pA customer recently contacted us regarding an issue with an old Alfresco Enterprise 4.2.2 environment. The system had been running stably for years, with a nightly restart of the Tomcat/Alfresco service to help recycle the memory and fix long-standing issues in this version. Earlier this week, one of these nightly restarts suddenly failed and since […]/p pL’article Alfresco – When a JDBC dri [...]

Do We Really Need RPO = 0 for Regional Disaster Recovery for database services? (from siddontang on Medium)

pA few years ago, if someone told me an entire AWS region could go down, I might have smiled politely and said, “Maybe in theory.” But then it actually happened./pWhen the Unthinkable Became RealitypDuring the world-shaking AWS DynamoDB outage in US-EAST-1, countless engineers across the globe were suddenly thrown into chaos./ppEveryone was frantically refreshing AWS status pages, hoping for one up [...]

Friday, 24. October 2025

How efficient is RocksDB for IO-bound, point-query workloads? (from Small Datum)

pHow efficient is RocksDB for workloads that are IO-bound and read-only? One way to answer this is to measure the CPU overhead from RocksDB as this is extra overhead beyond what libc and the kernel require to perform an IO. Here my focus is on KV pairs that are smaller than the typical RocksDB block size that I use -- 8kb.brbrBy IO efficiency I mean: br    (storage read IOPs from RocksDB [...]

Accelerate Similarity Search with Automatic HeatWave Vector Index (from The Oracle MySQL Blog)

Accelerate Similarity Search with Automatic HeatWave Vector Index [...]

Enhance Your Data Processing with HeatWave Temporary Tables (from The Oracle MySQL Blog)

Enhance Your Data Processing with HeatWave Temporary Tables [...]

Simplify Real-Time Analytics with MySQL HeatWave Auto-Refresh Materialized Views (from The Oracle MySQL Blog)

Simplify Real-Time Analytics with MySQL HeatWave Auto-Refresh Materialized Views [...]

MariaDB Cloud: A Semi-Technical Introduction (from MariaDB Foundation Blog)

pWhen co-founding MariaDB plc under the name SkySQL Corporation fifteen years ago (before MariaDB Foundation existed), we picked the name SkySQL with a bit of a reference to the cloud. … /p pContinue reading \"MariaDB Cloud: A Semi-Technical Introduction\"/p pThe post MariaDB Cloud: A Semi-Technical Introduction appeared first on MariaDB.org./p [...]

(from DoltHub Blog)

![CDATA[ Switch statements in Go have unique features that make it easy to write complex flow controls. Read this blog to see what makes them so special. ]] [...]

Thursday, 23. October 2025

Where can you find MySQL during November 2025 - January 2026! (from The Oracle MySQL Blog)

MySQL events in Nov-Jan 2026 [...]

MySQL Basics: Count Me In—Aggregating and Grouping Your Data (from The Oracle MySQL Blog)

Discover how to use aggregate functions and GROUP BY in MySQL to answer big questions about your data! This post guides beginners through counting, averaging, and categorizing records with friendly library metaphors, clear examples, and humor. A great way to level up your SQL skills and get your data stories told. [...]

Wednesday, 22. October 2025

Schema Changes Made Easy with MySQL Cluster/J 9.4 (from The Oracle MySQL Blog)

Introducing new APIs in Cluster/J to help applications handle schema changes [...]

Introducing MySQL Cluster/J 9.4 (from The Oracle MySQL Blog)

The first of two parts describing new features in Cluster/J, the NoSQL Java development environment for MySQL NDB Cluster. [...]

Introducing MariaDB Exa: 1,000x Faster Analytics on Live Data (from MariaDB Corporation Blog)

The Challenge: Grappling with Growing Datasets We are excited to announce our partnership with Exasol, a collaboration set to revolutionize […] [...]

UUIDv7 and Time-Based Partitioning in PostgreSQL 18 (from MinervaDB Blog)

UUIDv7 and Time-Based Partitioning in PostgreSQL 18: A Complete Guide Introduction: The UUID Evolution That Changes Everything PostgreSQL 18 introduces native support for UUIDv7, a game-changing identifier format that solves one of the database world’s [...] [...]

Faster Recommendations with User & Item Features: MySQL HeatWave's Two Tower Model (from The Oracle MySQL Blog)

We are excited to share how MySQL HeatWave brings powerful recommendation capabilities directly into your database with the integration of the TwoTower model, a deep learning architecture that's become the gold standard for large-scale recommender systems [...]

FromDual Backup and Recovery Manager for MariaDB and MySQL 2.3.2 has been released (from Shinguz's Blog)

pFromDual has the pleasure to announce the release of the new version 2.3.2 of its popular Backup and Recovery Manager for MariaDB and MySQL (codebrman/code)./p pThe new FromDual Backup and Recovery Manager can be downloaded from here. The FromDual Repositories were updated. How to install and use the Backup and Recovery Manager is described in FromDual Backup and Recovery Manager (codebrman/code) [...]

Announcing the Release of MariaDB Enterprise Platform 2026 (from MariaDB Corporation Blog)

We are thrilled to announce the launch of MariaDB Enterprise Platform 2026, establishing MariaDB as the definitive database platform for […] [...]

What the AWS Outage Showed Us: Resilience is Built Across Clouds (from Continuent Blog)

An analysis of the AWS outage and how cross-cloud continuity ensures uptime across cloud providers using solutions like Tungsten Cluster.Tags: cloud resiliencecross-cloud continuityHigh Availabilitymulti-cloud strategy [...]

Tuesday, 21. October 2025

Monitoring multithreaded replication in Amazon RDS for MySQL, Amazon RDS for MariaDB, and Aurora MySQL (from AWS Database Blog)

In this post, we discuss methods to effectively monitor parallel replication performance and tune its related parameters for Amazon Aurora MySQL and Amazon Relational Database Service for MySQL and MariaDB. [...]

Overview and best practices of multithreaded replication in Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon Aurora MySQL (from AWS Database Blog)

In this first post, we dive into the world of MySQL replication, with a special focus on parallel replication techniques. We start with a quick overview of how MySQL replication works, then explore the intricacies of multithreaded replication. We discuss key configuration options and best practices for optimization. [...]

Advanced Database Performance Tuning for MariaDB (from MinervaDB Blog)

Advanced Database Performance Tuning for MariaDB Introduction MariaDB performance tuning is a multi-layered discipline that requires deep understanding of database internals, storage mechanisms, query execution paths, and system-level interactions. Effective optimization can yield performance improvements [...] [...]

Does Your Black Friday Database Scaling Strategy Involve Duct Tape and Prayers? (from Readyset Blog)

Scale MySQL for Black Friday traffic without read replicas. Readyset QueryPilot automates query caching to boost MySQL performance and stability. [...]

How to Stream Data from Kafka to TiDB (from PingCAP Blog)

pModern applications generate enormous amounts of event data with user actions, transactions, logs, and metrics all happening in real time. To handle this scale, many teams rely on Apache Kafka, a distributed messaging system that decouples applications from their data pipelines and ensures reliable, high-throughput data delivery. On the storage side, TiDB provides a distributed SQL [...]

MySQL Basics: Join the Party—Bringing Tables Together with JOINs (from The Oracle MySQL Blog)

Discover how to combine information from multiple tables using JOINs in MySQL! This beginner-friendly guide explains INNER JOINs (and friends) with fun library metaphors, approachable SQL examples, and practical tips to help you unlock the true power of your relational database. [...]

What’s New At Releem - September 2025 (from Releem Blog)

September was a month of momentum. We focused on problems that frustrate every DBA: deadlocks, incomplete visibility, and cloud deployment quirks. We’ve shipped real-time deadlock monitoring, expanded the weekly reports, and fixed key issues with Releem Agent for RDS. [...]

Monday, 20. October 2025

Determine how much concurrency to use on a benchmark for small, medium and large servers (from Small Datum)

pWhat I describe here works for me given my goal, which is to find performance regressions. A benchmark run at low concurrency is used to find regressions from CPU overhead. A benchmark run at high concurrency is used to find regressions from mutex contention. A benchmark run at medium concurrency might help find both./ppMy informal way for classifying servers by size is:/pp/pullismall - has less t [...]

How to Succeed in the MariaDB Python Hackathon, Bangalore (from MariaDB Foundation Blog)

pLast Friday, we hosted an Ask Me Anything session with HackerEarth – and we promised to share the same insights here in written form. So here it is: your guide to success in the MariaDB Python Hackathon! … /p pContinue reading \"How to Succeed in the MariaDB Python Hackathon, Bangalore\"/p pThe post How to Succeed in the MariaDB Python Hackathon, Bangalore appeared first on MariaDB.org [...]