Planet for the MySQL Community

A blog / news aggregator for the MySQL Community / Ecosystem

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.

Thursday, 30. April 2026

Managing Valkey Cluster in Kubernetes (from Percona Database Blog)

pOver the last several years, Percona has introduced several rock-star Kubernetes Operators for managing MySQL, Percona XtraDB Cluster, MongoDB, and PostgreSQL. For Valkey, we are actively working with the community to contribute our knowledge, and experience to help brainstorm, develop, and test the official Valkey Operator for Kubernetes. While the Valkey Operator has not yet … Continued/p [...]

How Tungsten Cluster Achieves Data Integrity With Asynchronous Replication (from Continuent Blog)

Technical overview of how Tungsten Cluster achieves data integrity with asynchronous replication, focusing on replication state management, coordinated failover, and strategies to minimize data loss in HA environments.Tags: tungsten clusterdata protectionAsynchronous Replicationfailover [...]

MySQL Tuning on OCI HeatWave: What Still Matters, What OCI Manages, and What You Should Actually Tune (from The Oracle MySQL Blog)

Once you move from self-managed MySQL to a MySQL DB System with HeatWave on OCI, the tuning story changes in an important way. On a self-managed server, you worry about two layers: MySQL and the operating system. On OCI MySQL DB Systems with HeatWave, Oracle runs your MySQL instance as a fully-managed service and explicitly […] [...]

When AI Agent Memory Outgrows SQLite: How to Tell, and What to Move to Next (from PingCAP Blog)

pCoding agents now run for hours, span multiple tools, and move between machines and sessions. However, the agent memory layer underneath them has not kept up. Most still look the way they did in the first prototype: SQLite for notes and records, local files for summaries, and embeddings bolted on later if they are needed […]/p pThe post When AI Agent Memory Outgrows SQLite: How to Tell, and [...]

Three Promises in the Agent Era, Part 2: Agents on production MySQL are fine. Until they’re not. (from dbtrail Blog)

pYou’re running agents against MySQL. So am I. It’s where we are. Sooner or later you’re going to be recovering data because of something one of them did.…/p pThe post Three Promises in the Agent Era, Part 2: Agents on production MySQL are fine. Until they’re not. appeared first on dbtrail Blog./p [...]

Continued Commitment to Percona XtraDB Cluster (from Percona Database Blog)

pAt Percona, our priority has always been to provide the open source database solutions that our users can count on for the long term. Percona XtraDB Cluster (PXC) is a core part of that promise, delivering the high availability, scalability, and data integrity that mission-critical MySQL deployments depend on. MariaDB has announced that September 30, … Continued/p pThe post Continued Commitm [...]

From Ecosystem to Architecture: Expanding How We Look at MariaDB (from MariaDB Foundation Blog)

pOver the past month, one question has been coming up with increasing frequency:br What is the MySQL / MariaDB ecosystem?br In most discussions, the answer tends to focus on contributors to the source code: engineers, committers, and core developers shaping the database itself. … /p pContinue reading \"From Ecosystem to Architecture: Expanding How We Look at MariaDB\"/p pThe post From Ecosyst [...]

Adding a New Data Type to MariaDB with Type_handler – Part 1 (from MariaDB Foundation Blog)

pThis is the first part of the series about how to add a new data type to MariaDB using the Type_handler framework. A preliminary article has already been published to start the series; … /p pContinue reading \"Adding a New Data Type to MariaDB with Type_handler – Part 1\"/p pThe post Adding a New Data Type to MariaDB with Type_handler – Part 1 appeared first on MariaDB.org./p [...]

No More Silent Foreign Key Cascades: MySQL 9.7 Lets Child Triggers Speak Up (from The Oracle MySQL Blog)

MySQL 9.7 introduces a long-requested improvement: Child table triggers are executed during SQL-layer foreign key cascades. Historically, cascades executed inside InnoDB did not invoke child table triggers, which created gaps in auditing, derived data maintenance, and observability. When a parent row change triggered cascading changes in child tables, those child table triggers were not execut [...]

RLS sounds great until it isn't (from PlanetScale Blog)

PostgreSQL's Row Level Security sounds like a clean way to enforce access control at the database layer, but the foot-guns, pooling incompatibilities, and performance traps often make it more trouble than it's worth. [...]

Announcing Vitess 24 (from Vitess)

Announcing Vitess 24 # The Vitess maintainers are happy to announce the release of version 24.0.0, along with version 2.17.0 of the Vitess Kubernetes Operator. Version 24.0.0 expands query serving capabilities for sharded keyspaces, modernizes Vitess's observability stack, and introduces faster replica provisioning through native MySQL CLONE support. The companion v2.17.0 operator release brings si [...]

Wednesday, 29. April 2026

AI Is Raising the Bar for MySQL Database Security (from The Oracle MySQL Blog)

Best practices for MySQL customers and users in an AI-accelerated security landscape: A practical guide to hardening MySQL and the environment around it Oracle recently described how AI is transforming vulnerability detection and response. The latest generation of AI is increasing the speed and scale at which vulnerabilities can be identified and remediated. Oracle is […] [...]

Amazon RDS for MySQL announces Innovation Release 9.6 in Amazon RDS Database Preview Environment (from AWS What's New)

pAmazon RDS for MySQL now supports community MySQL Innovation Release 9.6 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MySQL. You can deploy MySQL 9.6 in the Amazon RDS Database Preview Environment which provides the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases. [...]

XtraBackup incremental prepare phase is 2x-3x faster! (from Percona Database Blog)

pTL;DR Percona XtraBackup is a 100% open-source backup solution for Percona Server for MySQL and MySQL®. It is designed for high-availability environments, performing online, non-blocking, and highly secure backups of transactional systems without interrupting your production traffic. While full backups work for small databases, large-scale systems rely on incremental backups to save space and time [...]

TiDB Cloud Premium Public Preview: Predictable Performance, Elastic Scale, Enterprise Isolation (from PingCAP Blog)

pCloud-native databases have made it easier to ship transactional applications. Managed services, automatic failover, and elastic storage are now table stakes. The harder problems show up later: When a multi-tenant SaaS app starts hitting tail-latency spikes during compaction, when a serverless tier saturates a noisy neighbor, or when a dedicated cluster sits at 30% utilization […]/p pThe pos [...]

Orchestrator’s Next Chapter: What It Means for Percona Customers (from Percona Database Blog)

pLast week, ProxySQL announced that they are taking over the maintenance and development of Orchestrator, the MySQL high-availability and topology management tool originally authored by Shlomi Noach. You can read their announcement here: Announcing the future of Orchestrator. We want to briefly share Percona’s position on the news. We welcome this Orchestrator became the de … Continued/ [...]

Replication Internals: Decoding the MySQL Binary Log Part 9: XID_EVENT — Transaction Commit (from Readyset Blog)

The XID_EVENT is only 31 bytes, but it's what makes MySQL replication crash-safe. Part 9 of Readyset's binlog internals series decodes it field by field and explains how a single 8-byte transaction identifier ties the binary log and InnoDB redo log together for two-phase commit recovery. [...]

Introducing the Change Stream Applier (CSA): A New MySQL Replication Applier in Labs (from The Oracle MySQL Blog)

Introduction Replication performance depends on every stage in the pipeline, from the source database to transport and ultimately to commit on the replica. On the replica side, much of that performance comes down to how efficiently changes are read, scheduled, and applied under real operational pressure. In practice, that directly affects steady-state lag, backlog recovery […] [...]

Adding a New Data Type to MariaDB with Type_handler – Part 0 (from MariaDB Foundation Blog)

pWelcome to this new series about extending MariaDB. This series covers the addition of a new data type using the Type_handler.br The goal of the entire series is to create a new plugin data type MONEY to store and display amounts with currency. … /p pContinue reading \"Adding a New Data Type to MariaDB with Type_handler – Part 0\"/p pThe post Adding a New Data Type to MariaDB with Type_handl [...]

Running MySQL on Kubernetes in Regulated Environments: Security, Compliance, and Auditability (from Continuent Blog)

Learn how to run MySQL on Kubernetes in regulated environments. This guide covers security controls, compliance requirements, auditability, encryption, access management, and operational best practices for production-grade deployments.Tags: kubernetesregulationsCompliance [...]

Announcing Functional Indexes in Dolt (from DoltHub Blog)

Dolt now supports functional indexes, allowing you to index expressions and function results for faster queries on computed values. [...]

Part 2 - PgBouncer to ProxySQL: A Brief Feature Comparison (from ProxySQL Blog)

Part 2 of the PgBouncer to ProxySQL series. A direct comparison of what each tool does, focused on responsibilities PgBouncer deliberately leaves alone and that ProxySQL pulls into the proxy itself. Reflects ProxySQL 3.0.8 and PgBouncer 1.25.1 at time of writing. [...]

Tuesday, 28. April 2026

How Readyset Rewrites Your SQL: Inside the Query Transformation Pipeline (from Readyset Blog)

A deep dive into Readyset's query rewrite pipeline. How SQL is transformed into a form the dataflow engine can compile and incrementally maintain, covering decorrelation, derived table inlining, join reordering, and three-valued logic handling. [...]

MySQL with AI Inside (from VillageSQL)

Learn how to use the VillageSQL vsql-ai extension to run AI models like Claude, Gemini, ChatGPT, and local within MySQL (VillageSQL). [...]

The hypergraph optimizer is now available in MySQL 9.7 Community Edition (from Øystein on MySQL Optimizer)

I have written a new post on the MySQL blog about the hypergraph optimizer, which is now available in MySQL 9.7 Community Edition. The post gives a high-level technical overview of what is different from the classic join optimizer, why it can produce better plans for some multi-table queries, and where it is most useful to try. It also includes early benchmark results and some caveats, since the f [...]

Introducing rdst: The Client-Side SQL Performance Toolkit (from Readyset Blog)

rdst is a free CLI toolkit that audits your RDS fleet, shows you what's driving load, and tells you exactly which read replicas you can eliminate. One command. Full report in your inbox. [...]

An update on GitHub availability (from The GitHub Blog)

pHere’s what we’ve done—and what we’re still doing—to improve our availability and reliability./p pThe post An update on GitHub availability appeared first on The GitHub Blog./p [...]

Three Promises in the Agent Era, Part 1: The Frame, Reread (from dbtrail Blog)

pA few months ago I wrote that a database does three things. It executes queries. It manages relationships. It survives the physical machine it runs on. Everything else,…/p pThe post Three Promises in the Agent Era, Part 1: The Frame, Reread appeared first on dbtrail Blog./p [...]

Part 1 - PgBouncer to ProxySQL: Rethinking the PostgreSQL Middle Tier (from ProxySQL Blog)

Part 1 of the PgBouncer to ProxySQL series. Focus: architecture and operator model, not a full feature matrix. Reflects ProxySQL 3.0.7 and PgBouncer 1.25.1 at time of writing. [...]

Monday, 27. April 2026

Strengthening the MySQL Community: Highlights from Our Third Public Discussion (from The Oracle MySQL Blog)

On April 21, 2026, our third public discussion continued the conversation around transparency, participation, and the future of MySQL. Building on the momentum from earlier sessions, the discussion focused on progress and improvements to increase community transparency and practical ways for community members to get involved. At the center of the discussion was the MySQL […] [...]

The hypergraph optimizer is now available in MySQL 9.7 Community Edition (from The Oracle MySQL Blog)

MySQL 9.7 Community Edition now includes the hypergraph optimizer as an alternative to the classic join optimizer, making this capability available across all MySQL editions. This is not a cosmetic change. The hypergraph optimizer uses a new join-planning framework aimed at queries where plan shape can make a real difference, particularly for multi-table joins, workloads […] [...]

Database Trends: What is changing in the database world (besides AI) (from MariaDB Foundation Blog)

pEarlier this month, I had a half-hour chat with Kellyn Gorman, a Database and AI Advocate and Engineer at Redgate. … /p pContinue reading \"Database Trends: What is changing in the database world (besides AI)\"/p pThe post Database Trends: What is changing in the database world (besides AI) appeared first on MariaDB.org./p [...]

What an AI Agent Harness Actually Needs Beyond a Model (from PingCAP Blog)

pFor the first wave of AI applications, the model was the only architectural question that mattered. Which model reasons better. Whose code is cleaner. Whose tool calls are more reliable. Where is the context window largest. What costs less per task. That conversation still matters. It is just no longer enough. The systems attracting serious […]/p pThe post What an AI Agent Harness Actually N [...]

Lemit Trusts Readyset to Reach 100K QPS on MySQL, Without Changing a Single Line of Code (from Readyset Blog)

Lemit deployed Readyset to break past MySQL's vertical scaling ceiling, reaching 109K QPS with sub-millisecond latency and zero application code changes. [...]

Why DoltLite? (from DoltHub Blog)

DoltLite redefines what is possible for local-first software. You can now use Git-style merges instead of CRDTs in sync engines. [...]

Announcing ProxySQL 3.0.8, 3.1.8, and 4.0.8 (from ProxySQL Blog)

ProxySQL 3.0.8 introduces MySQL session-variable tracking, PostgreSQL Cluster Sync, per-server backend SSL, and mid-transaction recovery. Also announcing 3.1.8 and 4.0.8. [...]

Saturday, 25. April 2026

New Observability Tables in ProxySQL 3.0.7: stats_proxysql_global and stats_tls_certificates (from ProxySQL Blog)

ProxySQL 3.0.7 introduces two new statistics tables for TLS certificate tracking and global proxy metrics. [...]

Friday, 24. April 2026

MySQL Tuning: Is It Mostly MySQL, or Does the Operating System Matter Also? (from The Oracle MySQL Blog)

When people ask me how to tune MySQL, they usually mean, “Which variables should I change in my.cnf?” (the MySQL configuration file) That certainly is a reasonable place to start, because most day-to-day performance tuning really is driven by MySQL itself: memory allocation, redo flushing, connection handling, temporary tables, and InnoDB I/O behavior. But the […] [...]

Not enough space for using ODABR? Reduce /u01 and /opt size on your ODA (from dbi Blog)

pIntroduction The patching of an Oracle Database Appliance needs to be secured. This is because it won’t limit to patching the databases: there is plenty of other components embedded with the patch, the goal being to keep everything updated. A possible rollback may be needed. For sure, there is no possible rollback for firmwares, BIOS […]/p pL’article Not enough space for using ODABR? R [...]

Security Hardening in ProxySQL 3.0.7 (from ProxySQL Blog)

A deep dive into the protocol hardening, credential protection, and validation improvements in ProxySQL 3.0.7. [...]

C++ StringView 优化字符串比较 (from Chen Zongzhi's GitHub blog)

DuckDB / Velox / Umbra 里面常见的字符串表示方式. 和传统的 SimpleStr (ptr, len) 相比, 都是 16 字节, 但是 layout 不同. [...]

Thursday, 23. April 2026

Github And DBeaver (from Dave's MySQL Stuff)

p Hopefully, you are regularly using both DBeaver and GitHub. But did you know that you can link them together?/ppIf you are running DBeaver Community, you will have to install some software that is built into the Pro versions. /p♦brp/p1. Install Git Extension (Community Edition) ulliGo to Help -> Install New Software./liliIn the "Work with" field, en [...]

AWS Compute Optimizer supports 162 new EC2 instance types and 32 new RDS DB instance classes (from AWS What's New)

pAWS Compute Optimizer now supports the latest generation of Amazon Elastic Compute Cloud (Amazon EC2) and Amazon Relational Database Service (Amazon RDS) instance types. This expansion enables Compute Optimizer to help you take advantage of the price-to-performance improvements offered by the newest EC2 and RDS instance types./p pAWS Compute Optimizer has expanded support to include the latest ge [...]

Upcoming MySQL Events and Webinars (Updated list for April–May 2026)   (from The Oracle MySQL Blog)

As an update to our recent blog post, “Where can you find MySQL next? (Updated events list for March–May 2026)” we’d like to share the latest confirmed MySQL events and webinars, including newly added ones plus refreshed details for sessions we already announced. Since plans and agendas evolve quickly, this post is intended to provide […] [...]

Bringing External Data into MySQL with the vsql-http Extension (from VillageSQL)

Bring HTTP client functions to MySQL with vsql-http. Fetch external data, trigger slack webhooks, and process JSON directly within SQL. [...]

A Clearer Path Forward for GridGain Customers (from MariaDB Corporation Blog)

This blog was originally published on GridGain’s website. When MariaDB evaluated and acquired GridGain, we noticed something important: GridGain is […] [...]

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 5: Backup, Recovery, and Node Reconfiguration (from ReliaDB)

Configure weekly AWS Backup for the PMM EC2 instance, walk through the full recovery procedure after a failure, and reconfigure PMM client agents on x86_64 and aarch64 nodes after a PMM server IP change. [...]

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 4: Alerting with PagerDuty and CloudWatch (from ReliaDB)

Configure PMM alerting end-to-end: custom MetricsQL alert templates, PagerDuty contact points, notification policies, CloudWatch data sources via IAM role assumption, and amtool for silence management. [...]

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 3: Installing PMM Server and Registering Services (from ReliaDB)

Install PMM Server on Docker, deploy PMM clients on x86_64 and aarch64 nodes, create monitoring users, and register MySQL, ProxySQL, and MariaDB RDS services at scale. [...]

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 2: IAM Roles and Users (from ReliaDB)

Configure cross-account IAM roles for PMM CloudWatch access and IAM users for Aurora OS metrics. Includes full trust policy, permissions policy, and Terraform references. [...]

Why LLMs Write Incorrect SQL (and What That Means for Your Database) (from Readyset Blog)

LLM-generated SQL looks right, runs, and returns results. But incorrect joins, wrong aggregations, and missing filters quietly hit your database at full execution cost. Here is what teams are doing about it. [...]

Cross-Account Database Monitoring with PMM and AWS Transit Gateway — Part 1: Architecture and TGW Setup (from ReliaDB)

Set up centralized RDS monitoring across multiple AWS accounts using Percona Monitoring and Management (PMM) and AWS Transit Gateway. Full network, routing, and security group walkthrough. [...]

MySQL Community Roadmap Update and Invitation: MySQL Contributor Summit (from The Oracle MySQL Blog)

As part of our MySQL community engagement plan, which includes delivering new features into MySQL Community Edition, increasing collaboration and transparency, and expanding and growing the MySQL Ecosystem, we have created a new rhythm of public MySQL Community Discussions—starting with our first session on February 25 and continuing with our second session on March 23, […] [...]

Clustering Tradeoffs in Practice: Galera, Tungsten, and the Jepsen Findings (from Continuent Blog)

A practical comparison of MySQL clustering technologies, analyzing Galera and Tungsten using Jepsen findings to highlight trade-offs in consistency, durability, and high availability design.Tags: Galera [...]

TiDB and the Rise of the AI-Native Database (from PingCAP Blog)

pEditor’s note: This post originally appeared on The New Stack and is republished with permission. The original version is available here. When enterprises talk about artificial intelligence, the attention usually points to models: larger parameters, faster inference, cheaper tokens. But we at next-gen database maker PingCAP contend that this framing misses the most consequential change now [… [...]

Wednesday, 22. April 2026

Big O for MySQL: Why the Same Query Gets Slow at Scale (from Another Boring Tech Blog)

pBig O for MySQL, explained visually: how O(1), O(log n), O(n), O(n log n), O(n²), and O(2ⁿ) decide whether your query stays fast as your data grows./p pO post Big O for MySQL: Why the Same Query Gets Slow at Scale apareceu primeiro em Another Boring Tech Blog./p [...]

Introducing Dynamic Data Masking in MySQL: Protect Sensitive Data Without App Changes (from The Oracle MySQL Blog)

Production data is invaluable for day-to-day operations—support, troubleshooting, analytics, and development. But when that data contains sensitive fields such as SSNs, emails, phone numbers, or other identifiers, broad read access can quickly become unnecessary exposure.  Just as importantly, many organizations operate under regulatory and contractual requirements that expect strong [...]

Readyset Is Ready for MySQL 9.7 - Three Commands With rdst (from Readyset Blog)

MySQL 9.7.0 LTS is live and Readyset supports it. See how to connect, deploy, and benchmark cached reads against a real 9.7.0 upstream in three commands using rdst. [...]

Percona Live 2026 is Back in the Bay Area — Here’s Why You Don’t Want to Miss It (from Percona Database Blog)

pWe’re thrilled to welcome the open source database community back in person for Percona Live 2026, taking place May 27–29 in the Bay Area. After the energy of past events, there’s nothing like being together again — swapping war stories over coffee, sketching architectures on napkins, and learning from the people building and running databases … Continued/p pThe post Percona Live 2026 is Bac [...]

Upgrade to OpenSSL 3.5 (from The Oracle MySQL Blog)

Overview Some MySQL distribution packages, such as the generic Linux build, bundle an OpenSSL dependency within the same .tar.gz archive. With the new MySQL 8.0.46, 8.4.9 and 9.7.0 releases, we are upgrading those bundled packages from using OpenSSL 3.0 to the new OpenSSL 3.5 LTS branch. Native OS packages, such as .rpm and .deb, continue […] [...]

MySQL Performance : OpenSSL-3.5.5 Evaluation (from DimitriK's (dim) Weblog)

pThe following report is covering performance evaluation of the currently available OpenSSL releases when they are used by MySQL in CPU-intensive OLTP workloads. However, the main focus is on OpenSSL-3.5.5, which will be used by default in the next MySQL releases./p pRead more... (19 min remaining to read)/p [...]

Orchestrator for PostgreSQL: the HA brain, now first-party (from ProxySQL Blog)

How ProxySQL for PostgreSQL handles unplanned primary failure [...]

Tuesday, 21. April 2026

The Extensibility Tax: Decisions, Principles, & Lessons in Teaching MySQL New Tricks (from VillageSQL)

Why is it so hard to teach an old database new tricks? VillageSQL CTO Steve Schirripa breaks down a year of engineering hurdles, debugging nightmares, and core principles discovered while building the VillageSQL Extension Framework. [...]

MySQL 9.7.0 LTS Is Now Available: Expanded Community Capabilities and Dynamic Data Masking for Enterprise (from The Oracle MySQL Blog)

With MySQL 9.7.0 LTS, MySQL establishes its next long-term support release line, expands key capabilities in Community Edition, and introduces Dynamic Data Masking for Enterprise users. The April releases mark an important milestone for MySQL. With the GA of MySQL 9.7.0 LTS, MySQL moves from the 9.x innovation series to a new Long-Term Support release line. This begins […] [...]

Expanding board of directors – Kurt Daniel, CEO at Virtuozzo (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to welcome Kurt Daniel, five-time CEO and current CEO of Virtuozzo, to its Board—bringing in a perspective shaped at the very heart of the database industry. … /p pContinue reading \"Expanding board of directors – Kurt Daniel, CEO at Virtuozzo\"/p pThe post Expanding board of directors – Kurt Daniel, CEO at Virtuozzo appeared first on Maria [...]

Percona Operator for MySQL 1.1.0: PITR, Incremental Backups, and Compression (from Percona Database Blog)

pThe latest release of the Percona Operator for MySQL, 1.1.0, is here. It brings point-in-time recovery, incremental backups, zstd backup compression, configurable asynchronous replication retries, and a set of stability fixes. This post walks through the highlights and how they help your MySQL deployments on Kubernetes.   Percona Operator for MySQL 1.1.0 Running stateful databases … Con [...]

Approaches to tenancy in Postgres (from PlanetScale Blog)

There are many ways to slice a Postgres database for multi-tenant applications. Let's look at the three most common approaches and the trade-offs. [...]

ProxySQL for PostgreSQL — Surviving an unplanned primary failure (from ProxySQL Blog)

How ProxySQL for PostgreSQL handles unplanned primary failure [...]

Monday, 20. April 2026

Every Major OLTP Has Time Travel. Except MySQL (from dbtrail Blog)

pIf you’ve worked on Oracle, you know Flashback. Run a SELECT ... AS OF TIMESTAMP, get the row as it existed yesterday at 2pm. Find who touched it…/p pThe post Every Major OLTP Has Time Travel. Except MySQL appeared first on dbtrail Blog./p [...]

Deploying Cross-Site Replication in Percona Operator for MySQL (PXC) (from Percona Database Blog)

pHaving a separate DR cluster for production databases is a modern day requirement or necessity for tech and other related businesses that rely heavily on their database systems. Setting up such a [DC -> DR] topology for Percona XtraDB Cluster (PXC), which is a virtually- synchronous cluster, can be a bit challenging in a complex … Continued/p pThe post Deploying Cross-Site Replication in [...]

How Dolt Represents and Evaluates Queries: A Case Study (from DoltHub Blog)

We look at a recent bug fix to understand how Dolt actually represents queries internally. It turns out, database engines and compilers have a lot in common. [...]

Sunday, 19. April 2026

MySQL MCP Server v1.7.0 is out (from AskDba)

April 19, 2026 It took three release candidates and more CI tweaks than I’d like to admit, but v1.7.0 is finally tagged GA. Here’s what actually changed and why it matters. The thing I kept getting asked about: add_connection Almost every multi-database user hits the same wall: you configure your connections at startup, and that’s […] [...]

MySQL HeatWave Consulting and Managed Services (from MinervaDB Blog)

MySQL HeatWave Consulting and Managed Services: Engineering Real-Time Analytics at Scale Oracle MySQL HeatWave collapses the traditional boundary between OLTP and OLAP workloads into a single, in-database engine — eliminating the ETL pipelines, data warehouse [...] [...]

The Provider Architecture — How dbdeployer Learned to Speak PostgreSQL (from ProxySQL Blog)

A deep dive into the Provider interface that makes dbdeployer multi-database. How we abstracted MySQL, added PostgreSQL, and made it extensible for any database. [...]

Saturday, 18. April 2026

Instant Strapi Performance Without Changing Your Code (from Another Boring Tech Blog)

pHow to scale your Strapi data layer using a wire compatible caching proxy and what the results look like on 43,000 real restaurants. Strapi is an excellent tool for building content driven applications quickly. As a project grows and data becomes more interconnected, keeping the API layer snappy is a common goal for development teams. […]/p pO post Instant Strapi Performance Without Changing [...]

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

We spent March focused on expanding query optimization, building out partner integrations, continuing PostgreSQL testing, and improve the overall experience for hosting providers and teams using Releem. [...]

ProxySQL for PostgreSQL — the failover model (from ProxySQL Blog)

First blog post of a series about ProxySQL for PostgreSQL and how it handles failover [...]

Friday, 17. April 2026

Incremental backups in Percona Kubernetes Operator for MySQL (from Percona Community Blog)

Starting with version 1.1.0, the Percona Kubernetes Operator for MySQL now supports incremental backups. This feature lets you backup only the changed data since the last backup, instead of copying your entire dataset each time. The result is dramatically smaller backup sizes, faster backup windows, and lower cloud storage costs. [...]

MariaDB’s Snapshot Isolation: A Fix That Breaks More Than It Fixes (from Percona Database Blog)

pJepsen’s analysis of MySQL 8.0.34 walked through a set of concurrency and isolation anomalies in InnoDB. MariaDB, which inherits the same codebase, took the report seriously and shipped a response: a new server variable called innodb_snapshot_isolation, turned on by default starting in 11.8. The announcement claims that with the flag enabled, Repeatable Read in MariaDB … Continued/p pT [...]

Where Do Users Get MariaDB Server From? (from MariaDB Foundation Blog)

pWe recently asked the community a simple but important question:/p pWhat is the main source of the MariaDB Server you use?/p pThe answers provide a very interesting snapshot of how MariaDB is consumed in the real world today—and, perhaps more importantly, how different installation methods reflect different use cases and priorities. … /p pContinue reading \"Where Do Users Get MariaDB S [...]

ProxySQL's prepared statement cache refactor, explained (from ProxySQL Blog)

A walk-through of the PostgreSQL prepared-statement cache refactor — what was slow, why, and how the redesign turned a contended path into a contention-free one [...]

Thursday, 16. April 2026

Build resilient Kerberos authentication for Aurora Global Database without joining Active Directory domain (from AWS Database Blog)

In this post, we show you how to build a multi-Region Kerberos authentication system that matches your Aurora Global Database’s resilience using AWS Directory Service for Microsoft Active Directory (AWS Managed Microsoft AD) with multi-Region replication and a one-way forest trust to your on-premises Active Directory, so your Linux clients can authenticate without joining the AD domain. [...]

How GitHub uses eBPF to improve deployment safety (from The GitHub Blog)

pLearn how Github uses eBPF to detect and prevent circular dependencies in its deployment tooling. /p pThe post How GitHub uses eBPF to improve deployment safety appeared first on The GitHub Blog./p [...]

Introducing MySQL GTID Support and Zero-Downtime Failover in Readyset (from Readyset Blog)

Readyset now fully supports MySQL GTIDs, enabling zero-downtime failover without restarting or losing your cache. Learn how GTID replication works in Readyset and how to script failover into your existing MySQL high availability setup. [...]

Inside MySQL: 20 Years of Source Code, Open Source Contributions, and What Comes Next. A Conversation with Marcelo Altmann (from ODBMS.org)

Q1. Marcelo, congratulations on being named MySQL Rockstar 2025! You’ve spent nearly 20 years working with MySQL — from the LAMP stack era when InnoDB was “the new kid” to today’s cloud-native, multi-terabyte production environments.... [...]

zstd Compression Support in ProxySQL 3.0.7 (from ProxySQL Blog)

ProxySQL 3.0.7 adds native zstd compression for the MySQL protocol, offering better compression ratios and lower CPU overhead compared to zlib. [...]

Dissecting the MySQL 8.0 Performance Regression on oltp_update_non_index (from Zhao Song's Blog)

The performance regression in MySQL 8.0 is well known, but it is still not fully understood. That is because it is not a regression caused by one obvious bottleneck. MySQL 8.0 introduced many new designs and refactored major subsystems, so the gap comes from a combination of configuration defaults, architectural trade-offs, and many small overheads spread across different layers. [...]

Wednesday, 15. April 2026

What Happens to a Database When the User is an AI agent (from PingCAP Blog)

pEditor’s note: This post originally appeared on The New Stack and is republished with permission. The original version is available here. In the past, we judged enterprise databases by how useful they were to people like us. We rated them on how well they helped architects create schemas, DBAs plan capacity, and analysts build queries.  We […]/p pThe post What Happens to a Database When [...]

Symlinks are Unsafe since MySQL 8.0.39 (and maybe even before) (from J-F Gagné's MySQL Blog)

You read this right, symbolic links (symlinks) are unsafe in MySQL since at least 8.0.39.  As always, it is a little more complicated than that, but if you are using symbolic links and in certain conditions, you risk a crash.  I think it is important to raise awareness on this, hence this post. My attention was brought to this via the now private Bug #120156: MySQL 8.0.39/8.0.42 [...]

Monitoring MySQL data locks, or the tip of the iceberg (from The Oracle MySQL Blog)

Monitoring MySQL data locks, or the tip of the iceberg This story is about recent (*) performance improvements implemented in MySQL, related to monitoring of data locks. (*) Originally written in Feb 2025. Refresher What is a data lock? When a user session connects to the MySQL database, it executes SQL queries. The query runs; […] [...]

Tutorial: Building AI Agents That Talk to Your Azure Database for MySQL (from Azure for MySQL Blog)

pWhat if you could ask your database a question in plain English and get the answer instantly, without writing a single line of SQL?/p pIn this tutorial, you'll build a Python-based AI agent that connects to Azure Database for MySQL server and uses OpenAI's function calling to translate natural language questions into SQL queries, execute them, and return human-readable answers. The agent can explo [...]

What changed between MySQL 9.7.0-er and 9.7.0-er2 (from Laurynas Biveinis' blog)

p Oracle has published the second MySQL 9.7.0 early access release! /p p Previously I wrote about building and testing the first one under macOS. This time I won't do that, because I cannot, because of a showstopper bug #120246 (XCode 26.4 fails to build 9.7.0-er2). Using a different compiler does not help this time because some of the errors appear libc-related. /p p So, this time I'll be lookin [...]

Replication Internals: Decoding the MySQL Binary Log - Part 8: Row Events — WRITE_ROWS, UPDATE_ROWS, and DELETE_ROWS (from Readyset Blog)

Part 8 of Readyset's MySQL binary log internals series decodes WRITE_ROWS, UPDATE_ROWS, and DELETE_ROWS events, covering row images, column bitmaps, null bitmaps, and how MySQL stores INSERT, UPDATE, and DELETE operations byte by byte. [...]

Multi-Region MySQL on Kubernetes: Architecture Patterns for Global Scale (from Continuent Blog)

A deep dive into multi-region MySQL deployment patterns on Kubernetes, exploring replication models, failover strategies, and the operational trade-offs required to achieve global scale and resilience.Tags: kubernetesArchitecture [...]

Ask Claude what happened to your MySQL (from dbtrail Blog)

pMost teams running MySQL in production don’t have a DBA. They have a developer who set up RDS two years ago, automated snapshots they’ve never tested a restore…/p pThe post Ask Claude what happened to your MySQL appeared first on dbtrail Blog./p [...]

Tuesday, 14. April 2026

Improving storage with additional storage volumes in Amazon RDS for SQL Server (from AWS Database Blog)

As SQL Server workloads grow on Amazon Relational Database Service (Amazon RDS) for Db2, the 64 TiB storage limit can force architectural issues that constrain business growth and create performance bottlenecks when transaction logs compete with data for I/O resources. The additional storage volumes feature in Amazon RDS for SQL Server solves these challenges. You can use Amazon RDS for SQL Server [...]

Accelerate database migration to Amazon Aurora DSQL with Kiro and Amazon Bedrock AgentCore (from AWS Database Blog)

In this post, we walk through the steps to set up the custom migration assistant agent and migrate a PostgreSQL database to Aurora DSQL. We demonstrate how to use natural language prompts to analyze database schemas, generate compatibility reports, apply converted schemas, and manage data replication through AWS DMS. As of this writing, AWS DMS does not support Aurora DSQL as target endpoint. To ad [...]

Village News: MySQL/Database News (14 April 2026) (from VillageSQL)

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

What Our Survey Says About MariaDB Preview Releases (from lefred's blog)

Preview releases are among the clearest ways an open-source community can shape the future of a database before it becomes a production reality. They give users early access to new features, a chance to validate upgrade paths, and an opportunity to catch issues while the change is still inexpensive. In our recent survey, we asked […] [...]

Monday, 13. April 2026

Auditing Login Attempts in MySQL and MariaDB (from Percona Database Blog)

pMy colleague Miguel wrote about ways to audit login attempts in MySQL over 13 years ago, and this is still a relevant subject. I decided to refresh this topic to include some important changes since then. Very often, it is important to track login attempts to our databases due to security reasons as well as … Continued/p pThe post Auditing Login Attempts in MySQL and MariaDB appeared first o [...]

Google Cloud introduces QueryData to help AI agents create reliable database queries (from InfoWorld)

pA new tool from Google Cloud aims to improve the accuracy of AI agents querying databases in multi-agent systems or applications./p pQueryData, which translates natural language into database queries with what the company claims is “near 100% accuracy,” is being pitched as an alternative to direct generation of queries by large language models (LLMs), which Google says ca [...]

Options for changing AWS KMS encryption key for Amazon RDS databases (from AWS Database Blog)

In this post, we review the options for changing the AWS KMS key on your Amazon RDS database instances and on your Amazon RDS and Aurora clusters. We start with the most common approach, which is the snapshot method, and then we include additional options to consider when performing this change on production instances and clusters that can mitigate downtime. Each of the approaches mentioned in this [...]

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

Following the strong participation in the first two editions of our Public MySQL Community Discussion webinar series, we’re excited to invite you to Edition #3. These sessions are part of our ongoing commitment to increase transparency, strengthen collaboration, and make it easier for the community to provide input that helps shape the evolution of MySQL’s. […] [...]

Sunday, 12. April 2026

MariaDB Foundation releases the BETA of the Test Automation Framework (TAF) 2.5 (from MariaDB Foundation Blog)

pThe MariaDB Foundation is releasing the BETA version of the Test Automation Framework (TAF) 2.5. This release represents a significant architectural upgrade, strengthening the framework’s lifecycle model, profiling capabilities, extraction and install pipeline, and reporting consistency. … /p pContinue reading \"MariaDB Foundation releases the BETA of the Test Automation Framework (TAF [...]

How a MySQL UPDATE Actually Works: InnoDB Internals Animated (from ReliaDB)

Step-by-step animation of what happens inside MySQL when you run an UPDATE. From client packet to redo log fsync — every layer of InnoDB explained with interactive visualization. [...]

Saturday, 11. April 2026

Writing My Own Extension For Village SQL Part II (from Dave's MySQL Stuff)

p Writing my own extension for Village SQL has been a learning experience. Extensions are a big part of the PostgreSQL ecosystem, and the idea of bringing them to the MySQL ecosystem is a source of hope for the 'most popular database'.  /ppbr/pThe Good NewspI was able to build my extension, vsql_cube, and get it into the server! Yeah!     /pmysql> select * from [...]

MySQL EXPLAIN Output Explained: The Complete Guide (2026) (from ReliaDB)

Every column of MySQL EXPLAIN output decoded with real examples from a 680K-row production database. Learn what each access type means, when to worry, and how to fix the slow ones. [...]

Friday, 10. April 2026

Navigating Business Challenges: Insights from Sailing (from AskDba)

Some experiences can be simulated. Sailing cannot, and it ever changes. At first glance, a sailboat feels like leisure, wind, sea, and escape from reality. But the moment you take responsibility on board, that illusion disappears. A sailboat is not an escape from life. It is a lifestyle full of responsibilities. As we enter the […] [...]

MySQL 9.7.0 vs sysbench on a small server (from Small Datum)

pThis has results from sysbench on a small server with MySQL 9.7.0 and 8.4.8. Sysbench is run with low concurrency (1 thread) and a cached database. The purpose is to search for changes in performance, often from new CPU overheads.brbrI tested MySQL 9.7.0 with and without the hypergraph optimizer enabled. I don't expect it to help much because the queries run here are simple. I hope to learn it doe [...]

What Our Survey Says About MariaDB Preview Releases (from MariaDB Foundation Blog)

pPreview releases are among the clearest ways an open-source community can shape the future of a database before it becomes a production reality. They give users early access to new features, a chance to validate upgrade paths, and an opportunity to catch issues while the change is still inexpensive. … /p pContinue reading \"What Our Survey Says About MariaDB Preview Releases\"/p pThe post Wh [...]

Keeping a Postgres queue healthy (from PlanetScale Blog)

Dead tuples from high-churn job queues can silently degrade your Postgres database when vacuum falls behind—especially alongside competing workloads. Traffic Control keeps cleanup on track. [...]

Thursday, 09. April 2026

Sysbench vs MySQL on a small server: another way to view the regressions (from Small Datum)

pThis post provides another way to see the performance regressions in MySQL from versions 5.6 to 9.7. It complements what I shared in a recent post. The workload here is cached by InnoDB and my focus is on regressions from new CPU overheads. /ppThe good news is that there are few regressions after 8.0. The bad news is that there were many prior to that and these are unlikely to be undone. [...]

S3 is the New Network: Rethinking Data Architecture for AI Agents (from PingCAP Blog)

pEditor’s note: This post originally appeared on The New Stack and is republished with permission. The original version is available here. For decades, database designers have built distributed databases around the assumption that storage must live close to compute. The farther data travels over the network, the reasoning goes, the greater the potential for delay. Local […]/p pThe post S3 is [...]

Amazon RDS Blue/Green Deployments now supports Amazon RDS Proxy (from AWS What's New)

pAmazon RDS Blue/Green Deployments now supports Amazon RDS Proxy, enabling faster application recovery during switchover by eliminating DNS propagation delays. Blue/Green Deployments create a fully managed staging environment (Green) that allows you to deploy and test production changes, keeping your current production database (Blue) safe. When ready, you can switchover to the new production envir [...]

Amazon RDS Blue/Green Deployments now supports Amazon RDS Proxy (from AWS What's New)

pAmazon RDS Blue/Green Deployments now supports Amazon RDS Proxy, enabling faster application recovery during switchover by eliminating DNS propagation delays. Blue/Green Deployments create a fully managed staging environment (Green) that allows you to deploy and test production changes, keeping your current production database (Blue) safe. When ready, you can switchover to the new production envir [...]

When “Committed” Doesn’t Mean Durable: What Jepsen Found in Galera Cluster (from Continuent Blog)

Jepsen found write loss, stale reads, and lost updates in MariaDB Galera Cluster. This article examines what commit actually guarantees and why ordering impacts durability and consistency. [...]

We Built a Free MySQL EXPLAIN Analyzer — Here's What It Catches That You're Missing (from ReliaDB)

Free MySQL & MariaDB EXPLAIN ANALYZE visualizer with 49 detection rules, smart index recommendations, and impact simulation. Tested against AI analysis on 50 unseen queries. 100% client-side. [...]

Bringing databases and Kubernetes together (from InfoWorld)

pRunning databases on Kubernetes is popular. For cloud-native organizations, Kubernetes is the de facto standard approach to running databases. According to Datadog, databases are the most popular workload to deploy in containers, with 45 percent of container-using organizations using this approach. The Data on Kubernetes Community found that production deployments were now c [...]

MariaDB Vector: How it works. Part IV (from MariaDB Foundation Blog)

pThis is the last post in the “MariaDB Vector: How it works” series. The first three were about storage, in-memory representation, HNSW modifications. … /p pContinue reading \"MariaDB Vector: How it works. Part IV\"/p pThe post MariaDB Vector: How it works. Part IV appeared first on MariaDB.org./p [...]

Announcing the future of Orchestrator: ProxySQL takes takes the helm (from ProxySQL Blog)

ProxySQL officially takes over the maintenance and development of Orchestrator, ensuring a bright future for the industry-standard database topology management tool. [...]

Wednesday, 08. April 2026

The Insert Benchmark vs MariaDB 10.2 to 13.0 on a 32-core server (from Small Datum)

pThis has results for MariaDB versions 10.2 through 13.0 vs the Insert Benchmark on a 32-core server. The goal is to see how performance changes over time to find regressions or highlight improvements. My previous post has results from a 24-core server.  Differences between these servers include:br/pulliRAM - 32-core server has 128G, 24-core server has 64G/lilifsync latency - 32-core [...]

The Insert Benchmark vs MariaDB 10.2 to 13.0 on a 24-core server (from Small Datum)

pThis has results for MariaDB versions 10.2 through 13.0 vs the Insert Benchmark on a 24-core server. The goal is to see how performance changes over time to find regressions or highlight improvements./ppMariaDB 13.0.0 is faster than 10.2.30 on most benchmark steps and otherwise as fast as 10.2.30. This is a great result./pptl;dr/pp/pullifor a CPU-bound workload/liullithe write-heavy step [...]

Village News: MySQL/Database News (8 April 2026) (from VillageSQL)

MySQL news: 8.0 EOL options, ProxySQL updates, Azure Fabric Mirroring, and Anthropic AI security alerts. Plus, 2026 database event schedules. [...]

Replication Internals: Decoding the MySQL Binary Log Part 7: TABLE_MAP_EVENT – Table Metadata for Row-Based Replication (from Readyset Blog)

Learn how MySQL's TABLE_MAP_EVENT maps table IDs to database names and column layouts before row-based replication events. Includes a full byte-level breakdown of column types, null bitmaps, and optional metadata. [...]

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 5: Execution, Validation, Cutover, and Cleanup (from ReliaDB)

Run the AWS DMS migration task, enable data validation, perform the cutover from MariaDB to Aurora MySQL, recreate indexes, and clean up all temporary AWS resources. [...]

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 4: DMS Endpoints, Task Configuration, and Assessments (from ReliaDB)

Configure AWS DMS source and target endpoints, set up DMS users, create the migration task with correct LOB and table mapping settings, and run pre-migration assessments. [...]

Celebrating 30 Years of MySQL: Free Training & Certification Results  (from The Oracle MySQL Blog)

In 2025, MySQL celebrated its 30th anniversary—and to mark the milestone, Oracle University (together with the MySQL Community team) offered free MySQL training and free certification exams from April 20 through July 31, 2025.  The goal was simple: make it easy for developers, DBAs, architects, and newcomers to build practical skills and validate them with […] [...]

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 3: Schema and User Migration (from ReliaDB)

Migrate schema and users from MariaDB 10.6 to Aurora MySQL 8.0. Covers mysqldump compatibility pipeline, incompatible object cleanup, index strategy for DMS, and user export with pt-show-grants. [...]

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 2: AWS DMS Infrastructure Setup (from ReliaDB)

Set up AWS DMS for MariaDB to Aurora MySQL migration. Step-by-step guide to IAM roles, replication instance sizing, VPC configuration, and security group rules. [...]

MariaDB 10.6 to MySQL Aurora 8.0 Migration Guide — Part 1: Pre-Migration Requirements (from ReliaDB)

Pre-migration checklist for migrating from MariaDB 10.6 to Amazon Aurora MySQL 8.0 via AWS DMS. Covers timeout settings, binlog configuration, and target validation. [...]

Tuesday, 07. April 2026

Thanks AWS Open Source (from J-F Gagné's MySQL Blog)

I would like to thank AWS Open Source for their support. For some time, I am maintaining Planet for the MySQL Community, a blog / news aggregator for the MySQL Community/Ecosystem.  I am also maintaining a similar aggregator for the Valkey Community. Maintaining blog / news aggregators is not free.  It incurs hosting, domain registration, and other costs (in addition to time, [...]

Monitor custom database metrics in Amazon RDS for SQL Server using Amazon CloudWatch (from AWS Database Blog)

In this post, we demonstrate how to create custom Amazon RDS for SQL Server CloudWatch metrics. You accomplish this by using SQL Server Agent jobs and CloudWatch Logs integration. We walk through an example of monitoring table size within a SQL Server database however, this approach works for various other metrics. You can adapt this approach to track row counts, database size, job counts, user ses [...]

The AWS Lambda ‘Kiss of Death’ (from Shattered Silicon OSDB Blog)

pOur story begins as most database issues start: with hands on foreheads, internally or externally, saying ‘WTF is going on?’. We observed a series of database freezes on our production environment. It was quite severe. Connections spiked, writes were stalled and at some point, a large database freeze and they cleared. Being a Galera environment, […]/p pThe post The AWS Lambda ‘Kiss of [...]

Writing My Own Extension for Village SQL Part I (from Dave's MySQL Stuff)

pSince my previous post on Village SQL, life has been filled with too many other things. But finally I was able this past weekend to circle back and try to write my own extension./ppThe Village SQL TL;DR -> MySQL with PostgreSQL like extensions.  /ppThe  documentation on writing new extensions seems complete, but I have run into issues that are probably caused by me, and not the d [...]

Reducing P999 Latency in Distributed Databases with TiDB 8.5 (from PingCAP Blog)

pReducing P999 latency in distributed databases is one of the hardest challenges in modern OLTP systems. A handful of slow requests can cascade across services, break SLOs, and directly impact business outcomes, especially in latency-sensitive environments like trading platforms and real-time applications. This is the challenge of tail latency. As systems scale, variability compounds: queueing [ [...]

What enterprise devops teams should learn from SaaS (from InfoWorld)

pMany enterprise devops teams struggle to deploy frequently, increase test automation, and ensure reliable releases. What can they learn from SaaS companies, where developing and deploying software for thousands of customers is core to their revenue and business operations?/p pSaaS companies must have robust testing, observability, deployment, and monitoring capabilities. [...]

Announcing ProxySQL 3.0.7, 3.1.7, and 4.0.7 (from ProxySQL Blog)

ProxySQL 3.0.7 brings protocol hardening, zstd compression, TLS certificate tracking, and new security improvements. Also announcing 3.1.7 and 4.0.7. [...]

Monday, 06. April 2026

Starting from PostgreSQL’s fsync Failure (from Chen Zongzhi's Medium blog)

♦IntroductionpIn 2018, the PostgreSQL community discovered a severe problem that had existed for 20 years: when fsync() fails, PostgreSQL's handling could lead to silent data loss. This incident, known as "fsyncgate", not only revealed an architectural flaw in PostgreSQL itself, but also exposed a deep conflict between the Linux kernel, file systems, and databases regarding I/O error [...]

Tournament of Databases: The Winner! (from VillageSQL)

MySQL beats PostgreSQL to win our Tournament of Databases. See how multi-threaded architecture and replication carried MySQL to the championship. [...]

Optimize full-text search in Amazon RDS for MySQL and Amazon Aurora MySQL (from AWS Database Blog)

In this post, we show you how to optimize full-text search (FTS) performance in Amazon RDS for MySQL and Amazon Aurora MySQL-Compatible Edition through proper maintenance and monitoring. We discuss why FTS indexes require regular maintenance, common issues that can arise, and best practices for keeping your FTS-enabled databases running smoothly. [...]

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 5: Change Management, Troubleshooting, and Complete Checklist (from ReliaDB)

Complete MySQL 8.4 upgrade checklist with 41 items, 8 common troubleshooting scenarios, project timeline estimates, and change management templates for production upgrades. [...]

MySQL Tools for Performance Tuning and Test Data Generation (from Kedar MySQL Blog)

pAs a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to…/p The post MySQL Tools for Performance Tuning and Test Data Generation first appeared on Change Is Inevitable. [...]

Your MySQL Backups Won’t Pass a Compliance Audit Alone (from dbtrail Blog)

pEvery compliance framework that touches data recovery says some version of the same thing: you need to be able to restore data, prove that you can, and show…/p pThe post Your MySQL Backups Won’t Pass a Compliance Audit Alone appeared first on dbtrail Blog./p [...]

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 4: Rollback Strategy and Post-Upgrade Validation (from ReliaDB)

Plan your MySQL 8.4 rollback strategy before you start. Plus the complete post-upgrade validation checklist — version checks, replication health, optimizer stats, and monitoring. [...]

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 3: Upgrade Execution (from ReliaDB)

Three MySQL upgrade approaches compared — replication-based, in-place, and rolling replica. Step-by-step commands, configuration templates, and time estimates for each method. [...]

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 2: Upgrade Testing (from ReliaDB)

Learn how to test your MySQL 8.0 to 8.4 upgrade using pt-upgrade, dry-run procedures, application compatibility checks, and canary testing before touching production. [...]

MySQL 8.0 to 8.4 LTS Upgrade Guide — Part 1: Pre-Upgrade Preparation (from ReliaDB)

MySQL 8.0 reached EOL on April 6, 2026. This guide covers every pre-upgrade step — backups, upgrade checker, removed parameters, authentication migration, and schema fixes. [...]

Sysbench vs MariaDB on a small server: using the same charset for all versions (from Small Datum)

pThis has results for sysbench vs MariaDB on a small server. I repeated tests using the same charset (latin1) for all versions as explained here. In previous results I used a multi-byte charset for modern MariaDB (probably 11.4+) by mistake and that adds a 5% CPU overhead for many tests./pptl;dr/pp/pulliMariaDB has done much better than MySQL at avoid regressions from code bloat./liliThere are seve [...]

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

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

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

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

Sunday, 05. April 2026

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

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

What's Coming to dbdeployer (from ProxySQL Blog)

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

Saturday, 04. April 2026

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

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

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

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

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

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

Friday, 03. April 2026

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

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

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

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

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

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

Percona Bug Report: March 2026 (from Percona Community Blog)

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

Vibe-Coded Agents for Vibe-Coded Issues (from DoltHub Blog)

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

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

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

Thursday, 02. April 2026

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

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

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

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

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

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

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

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

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

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

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

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

Patterns for Postgres Traffic Control (from PlanetScale Blog)

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

Wednesday, 01. April 2026

MariaDB Java Connector 3.5.8 now available (from MariaDB Corporation Blog)

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

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

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

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

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

March Product Update (from Readyset Blog)

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

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

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

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

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

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

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

Tuesday, 31. March 2026

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PostgreSQL Internals for the MySQL DBA (from Rendiment)

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

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

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

Graceful degradation in Postgres (from PlanetScale Blog)

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

Monday, 30. March 2026

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

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

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

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

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

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

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

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

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

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

Sunday, 29. March 2026

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

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

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

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

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

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

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

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

Saturday, 28. March 2026

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

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

Friday, 27. March 2026

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

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

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

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

Tournament of Databases: Round 2 (from VillageSQL)

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

Thursday, 26. March 2026

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

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