Planet for the MySQL Community

How to automate large-scale RDS MySQL 8.0 to RDS MySQL 8.4 upgrades with Kiro and MCP ^{(from One-Time MySQL Community/Ecosystem Posts)}

When a customer has 100+ RDS MySQL 8.0 instances that need to upgrade to 8.4, they face several challenges. The RDS MySQL Upgrade Assistant is an open-source tool that provides a 19-check SQL precheck engine with a remediation playbook, automated parameter and option group migration, Blue/Green and in-place upgrade orchestration with pre-switchover guardrail checks, and an application validation fr [...]

Published Friday, 22. May 2026 18:00 • an hour ago

Write for the Percona Community ^{(from Percona Community Blog)}

You’ve fixed something gnarly in production this year. You’ve migrated a database that nobody wanted to touch. You’ve built something on top of Percona Operators, or Percona Toolkit, or Percona Monitoring and Management (PMM), and you’ve learned things along the way that aren’t written down anywhere yet. [...]

Published Friday, 22. May 2026 11:00 • 8 hours ago

MySQL 9.7.0 PGO Benchmark Analysis ^{(from Percona Database Blog)}

pOverview Servers Tested: MySQL 9.7.0 (PGO-enabled build released by Oracle) MySQL 9.7.0 Non-PGO (built without Profile-Guided Optimization — see BUILD.md) Tier Configurations: Tier 2G: 2GB InnoDB buffer pool Tier 12G: 12GB InnoDB buffer pool Tier 32G: 32GB InnoDB buffer pool View Results 📊 Interactive Reports The benchmark reports are available as interactive HTML pages … Continued/p [...]

Published Friday, 22. May 2026 07:33 • 11 hours ago

Best Practices for MySQL HeatWave Adoption for OLTP and OLAP Workloads ^{(from The Oracle MySQL Blog)}

Organizations modernizing transactional database environments are increasingly adopting MySQL HeatWave to simplify operations, improve scalability, increase availability, enhance security and enable real-time analytics without separating OLTP and OLAP systems. However, successful adoption requires more than simply provisioning a new database instance. This blog explores practical best practices for [...]

Published Friday, 22. May 2026 05:30 • 14 hours ago

Part 3 - PgBouncer to ProxySQL: Simple-Mode Benchmark ^{(from ProxySQL Blog)}

Benchmarking the PostgreSQL middle tier under SSL — PgBouncer vs ProxySQL (1/2/4 workers), same hardware, same 4KB SELECT workload. pgbench simple mode. [...]

Published Friday, 22. May 2026 00:00 • 19 hours ago

Why Move PostgreSQL to Oracle Cloud Infrastructure? A Deep Dive into OCI Database with PostgreSQL ^{(from The Oracle MySQL Blog)}

PostgreSQL has become a favorite database for modern application teams: open source, extensible, standards-friendly, and proven across transactional, analytical, geospatial, SaaS, and cloud-native workloads. But as PostgreSQL estates grow, so does the operational burden: patching, backups, monitoring, scaling, storage planning, replication, failover, disaster recovery, security hardening, and versi [...]

Published Thursday, 21. May 2026 21:33 • 21 hours ago

Amazon Aurora MySQL 8.4 is now generally available ^{(from AWS Database Blog)}

Today, we are excited to announce the general availability of Amazon Aurora MySQL 8.4, our latest major version, compatible with community MySQL 8.4.7. This release marks an important milestone for Aurora MySQL customers, introducing a simplified versioning model aligned directly with community MySQL, along with a streamlined patch version experience, and the full set of community MySQL 8.4 enhance [...]

Published Thursday, 21. May 2026 18:41 • a day ago

Knowing when new open source database engine versions release on Amazon Aurora and Amazon RDS ^{(from AWS Database Blog)}

In this post, we share the version currency timelines for Aurora and RDS open source engines. We also explain why timelines differ across engines and how you can use them to plan your upgrades. [...]

Published Thursday, 21. May 2026 18:36 • a day ago

Bintrail: MySQL Time-Travel Queries Using Indexed Binlogs ^{(from InfoQ)}

♦pBintrail is a recently introduced layer that brings point-in-time queries and row-history lookups to MySQL, the only major relational database lacking native temporal querying. Using indexed binlogs behind ProxySQL and without modifying MySQL or application code, Bintrail supports querying data as of a past timestamp and reviewing change history, primarily for recovery and audit scenarios./p By R [...]

Published Thursday, 21. May 2026 17:03 • a day ago

Amazon Aurora MySQL 8.4 is now generally available ^{(from AWS What's New)}

pAmazon Aurora MySQL-Compatible Edition now supports MySQL 8.4, a community MySQL Long Term Support (LTS) major version. Aurora MySQL 8.4 launches with compatibility for community MySQL 8.4.7 and introduces aligned version numbering, so the version number you run on Aurora matches the community MySQL version it is compatible with. Aurora also manages the underlying patch on your behalf, simplifying [...]

Published Thursday, 21. May 2026 16:00 • a day ago

From parser combinators to hand-written TDOP: On adopting sqlparser-rs at Readyset ^{(from Readyset Blog)}

Readyset replaced its homegrown SQL parser with sqlparser and saw 4x throughput improvement and 44% lower tail latency. Here's why we switched and how we did it safely. [...]

Published Thursday, 21. May 2026 13:43 • a day ago

AI-Assisted Production Database Ops with ClusterControl MCP and CCX MCP ^{(from Severalnines Blog)}

pIn December, we introduced how Model Context Protocol could make ClusterControl easier to work with from AI assistants. Since then, Severalnines has expanded that MCP direction across its database operations platforms with ClusterControl MCP and CCX MCP. The latest ClusterControl MCP is the major update, providing a more robust implementation with 69 tools and 20 […]/p pThe post AI-Assisted [...]

Published Thursday, 21. May 2026 10:22 • a day ago

Vibe-coding an Audit Plugin in Under 3 Minutes ^{(from MariaDB Foundation Blog)}

pWho says developing MariaDB plugins is hard? I was able to produce one in under 3 minutes!br I of course did it by asking Grok nicely:br The produced result is actually very decent:br It even produced a Makefile:br And compilation instructions:br While I had Grok’s attention I’ve given it a follow up task:br Note the “please” … /p pContinue reading \"Vibe-coding an Au [...]

Published Thursday, 21. May 2026 09:06 • a day ago

A Practical Guide for MySQL HeatWave Capacity Planning ^{(from The Oracle MySQL Blog)}

As organizations modernize their data platforms, MySQL HeatWave has emerged as a powerful solution for running online transactional processing (OLTP) and real-time online analytics processing (OLAP) together without ETL complexity. However, achieving optimal performance and cost efficiency requires thoughtful capacity planning. This blog explains how to monitor and estimate MySQL HeatWave capacity [...]

Published Thursday, 21. May 2026 08:00 • a day ago

Designing Resilient APIs with MySQL HeatWave High Availability and Read Replicas ^{(from The Oracle MySQL Blog)}

Modern cloud applications are expected to remain available even during infrastructure interruptions, replication failovers, maintenance events, and transient network failures. In distributed database environments, it requires applications to treat transient failures as a normal part of production operations. This blog discusses practical API reliability designs for applications using MySQL HeatWave [...]

Published Thursday, 21. May 2026 01:57 • a day ago

Stop Writing Dialect-Specific SQL: A Unified Query Builder for Node.js ^{(from DZone)}

The Problem Most Backend Developers Face pYou're building a SaaS application that needs to support multiple databases. Or maybe you're migrating from MySQL to PostgreSQL. Or you have different clients using different database engines./p pWhatever the reason, you've likely encountered this nightmare:/p [...]

Published Wednesday, 20. May 2026 17:00 • 2 days ago

Stop Paying for Air: Most Cloud Database Spend Is Wasted ^{(from MariaDB Corporation Blog)}

This blog was originally published on SkySQL’s website. The Hidden Cost of Idle Cloud Databases Structured databases are amongst the biggest […] [...]

Published Wednesday, 20. May 2026 15:58 • 2 days ago

CVE-2026-8053: “We don’t use time-series” is not a mitigation ^{(from Percona Database Blog)}

pTL;DR: A bug in MongoDB’s time-series collection code allows a user with the standard readWrite role to corrupt memory within the mongod process. Best case: your database crashes, and you spend the night writing a postmortem. Worst case: an attacker is running their code as mongod, with the same access to your data that the … Continued/p pThe post CVE-2026-8053: “We don’t u [...]

Published Wednesday, 20. May 2026 15:13 • 2 days ago

Where to Find VillageSQL Next Week ^{(from VillageSQL)}

Catch VillageSQL in the Bay Area next week! We're speaking and sponsoring at Percona Live, South Bay Systems, and the Oracle MySQL Summit. [...]

Published Wednesday, 20. May 2026 14:00 • 2 days ago

TLS Certificate Pinning and Best Practices in Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pTransport Layer Security (TLS) encrypts data in transit between client applications and the server and authenticates the service endpoint in client-server authentication. /p pAzure Database for MySQL server certificates are issued by well-known trusted public Certificate Authorities (CAs), including Microsoft-issu [...]

Published Wednesday, 20. May 2026 13:00 • 2 days ago

TiDB SCaiLE Europe 2026: Why Engineers Building Agentic AI Should Be in Stockholm on 4 June ^{(from PingCAP Blog)}

pMost teams shipping AI agents in 2026 hit the same wall around the same time. The prototype works. Ten users or even a thousand users mostly work. But then one user action triggers thousands of agent instances, context has to branch per agent in milliseconds, and vector lookups stack on top of transactional reads. The […]/p pThe post TiDB SCaiLE Europe 2026: Why Engineers Building Agentic AI [...]

Published Tuesday, 19. May 2026 17:24 • 3 days ago

Not All Open Source Is Equal: Choosing a PostgreSQL Operator for Kubernetes in 2026 ^{(from Percona Database Blog)}

pChoosing an open source PostgreSQL operator for Kubernetes used to be a question about features and community size. In 2026, it has become a question about licensing posture, image distribution, and whether the project you pick today will still be operationally open in three years. This is part 1 of a 3-part series on running … Continued/p pThe post Not All Open Source Is Equal: Choosing a P [...]

Published Tuesday, 19. May 2026 17:12 • 3 days ago

Ready for your busiest day: How we scale ^{(from Intercom Blog)}

Every system has limits. Competence is knowing where they are, measuring them, and moving them before customers reach them. Here's how we do this at Fin. [...]

Published Tuesday, 19. May 2026 15:31 • 3 days ago

MySQL Data at Rest: Architecture & Best Practices ^{(from Mydbops Blog)}

Learn how MySQL data-at-rest encryption protects your database files, including its architecture, key management, and differences between MySQL 8.0 and 8.4. [...]

Published Tuesday, 19. May 2026 08:28 • 3 days ago

Implementing MySQL Data-at-Rest Encryption: Step-by-Step Guide ^{(from Mydbops Blog)}

Learn how to implement MySQL data-at-rest encryption using the MySQL 8.4 component-based keyring. Secure tablespaces, logs, and backups effectively. [...]

Published Tuesday, 19. May 2026 04:07 • 4 days ago

PostgreSQL Buffer Access 5 Rules ^{(from Chen Zongzhi's GitHub blog)}

src/backend/storage/buffer/README 是 PG 社区维护 buffer manager 的官方设计文档. 它在开头列了 5 条 buffer access rules, 提 patch / review 时直接引用. 这 5 条规则合起来定义了 PG 的 Pin 协议, 也是 PG 和 InnoDB buffer manager 设计上真正分叉的地方. [...]

Published Tuesday, 19. May 2026 00:00 • 4 days ago

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

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.8.7, 11.4.11, 10.11.17, and 10.6.26 maintenance releases. See […] [...]

Published Monday, 18. May 2026 21:10 • 4 days ago

How ProxySQL 3.0.8 improves MySQL session-variable tracking ^{(from ProxySQL Blog)}

ProxySQL 3.0.8 extends session-variable tracking beyond parsed SET statements by consuming MySQL session-state notifications from backend OK packets. [...]

Published Sunday, 17. May 2026 00:00 • 6 days ago

Observability in Spring Boot 4 ^{(from DZone)}

pIn microservices, you’ve likely broken a cold sweat more than once when a request suddenly 'vanishes' the moment it hits a Database or a Message Broker. It is a true operational nightmare. However, with the release of Spring Boot 4 in early 2026, building a comprehensive Observability system has become easier than ever, thanks to the 'all-in' support from micrometer tracing./p The Problem: "Anonym [...]

Published Friday, 15. May 2026 17:00 • 7 days ago

Introducing Our First MariaDB Server Solution Stack: A Privacy-First Stack with Nextcloud, Passbolt, and MariaDB ^{(from MariaDB Foundation Blog)}

pMariaDB Foundation is pleased to announce the publication of our first MariaDB Server Solution Stack in the MariaDB Server Ecosystem Hub:br Privacy-First Stack: Nextcloud, Passbolt, and MariaDB Serverbr This stack brings together three open-source technologies with a shared purpose: helping organizations build collaboration infrastructure around privacy, control, and long-term digital sovereignty. [...]

Published Friday, 15. May 2026 14:27 • 7 days ago

One Agent, One Sandbox, One Database: Inside the Kimi K2.6 Architecture ^{(from PingCAP Blog)}

pA few months back I wrote two pieces about what infrastructure agents actually need: One on the database trends shaping 2026, another on why agents are the new database users. The arguments stayed mostly theoretical. What was missing was a large-scale, practical example. As of this quarter, I can finally point to one. TiDB Cloud […]/p pThe post One Agent, One Sandbox, One Database: Inside th [...]

Published Thursday, 14. May 2026 19:35 • 8 days ago

MariaDB Community Server 10.6 Is Reaching End of Life – Here’s What to Do Next ^{(from MariaDB Corporation Blog)}

If you’re running MariaDB Community Server 10.6, mark your calendar: July 6, 2026 is the official End of Life (EOL) […] [...]

Published Thursday, 14. May 2026 17:21 • 8 days ago

Building an AI Vision Search Engine with MySQL HeatWave GenAI ^{(from MySQL expert Diary)}

pModern AI systems increasingly rely on multimodal data: text, images, documents, audio, and video. Among these modalities, image understanding has become one of the most important capabilities for AI-powered applications.br Traditionally, implementing these capabilities required specialized computer vision infrastructure, external vector databases, custom ML pipelines, and multiple frameworks.br W [...]

Published Thursday, 14. May 2026 16:54 • 8 days ago

Why the World's Most Popular Database Is at a Crossroads ^{(from VillageSQL)}

As PostgreSQL gains mindshare, MySQL faces a crossroads. Learn why VillageSQL believes a shift from hard forks to extensibility will define the future of the world's most popular database. [...]

Published Thursday, 14. May 2026 16:34 • 8 days ago

Upgrade strategies for Amazon RDS for MySQL 8.0 to 8.4 ^{(from AWS Database Blog)}

This post is part of a two-part series on upgrading RDS for MySQL 8.0 to 8.4. Here, we cover the end of standard support timeline, extended support costs, upgrade methods, and key best practices. For a step-by-step implementation guide, see Best practices for upgrading RDS for MySQL 8.0 to 8.4 with prechecks, Blue/Green, and rollback. [...]

Published Thursday, 14. May 2026 15:57 • 8 days ago

Best practices for upgrading Amazon RDS for MySQL 8.0 to 8.4 with prechecks, Blue/Green, and rollback ^{(from AWS Database Blog)}

In this post, you learn how to build a complete upgrade workflow for RDS for MySQL 8.0 to 8.4, covering pre-upgrade compatibility checks, Amazon RDS Blue/Green Deployments for minimal downtime, and a rollback strategy for added protection. [...]

Published Thursday, 14. May 2026 15:57 • 8 days ago

A better way to work with SQL Server ^{(from InfoWorld)}

pMicrosoft recently ended support for Azure Data Studio, its development tool for the SQL Server and Azure SQL databases. Part of a range of tools designed to work with Microsoft’s on-premises and in-cloud SQL databases, Azure Data Studio focused on building and testing queries rather than database administration. In other words, it was a developer-focused, lighter-weight alt [...]

Published Thursday, 14. May 2026 09:00 • 8 days ago

How TPC-C Works ^{(from DoltHub Blog)}

A detailed description of Dolt's TPC-C benchmarking. [...]

Published Thursday, 14. May 2026 00:00 • 9 days ago

ORDER BY Has Come a Long Way ^{(from Modern SQL)}

codeOrder by/code Has Come a Long Way♦olliLimited support in codeunion/code, codeexcept/code and codeintersect/code legs/liliExpressions must not contain selected columns/li/olpThe codeorder by/code clause is surely one of the best-known SQL clauses. Yet there are a number of common misunderstandings that are worth clearing up. For that, I’ll walk you through the evolution of the codeorder by/code [...]

Published Thursday, 14. May 2026 00:00 • 9 days ago

Egress problems and where to find them ^{(from PlanetScale Blog)}

Reducing the size and frequency of requests to your database has the double benefit of making your applications faster and cheaper. [...]

Published Thursday, 14. May 2026 00:00 • 9 days ago

Village News: MySQL/Database News + Events (13 May 2026) ^{(from VillageSQL)}

Stay updated with the MySQL community! Discover the latest news from Meta, Azure, and MariaDB, plus a curated list of upcoming global database events for 2026. [...]

Published Wednesday, 13. May 2026 15:27 • 9 days ago

Replication Internals: Decoding the MySQL Binary Log Part 11: GTID_TAGGED_LOG_EVENT — Tagged GTIDs and MySQL's New Serialization Framework ^{(from Readyset Blog)}

Part 11 of Readyset's MySQL binary log series decodes the GTID_TAGGED_LOG_EVENT, introduced in MySQL 8.4 to support user-defined GTID tags. Learn how MySQL's new mysql::serialization TLV framework encodes it, how to read variable-length integers byte by byte, and how the tagged format compares to the classic GTID_LOG_EVENT. [...]

Published Wednesday, 13. May 2026 13:18 • 9 days ago

Why Kimi K2.6 Chose TiDB: The Story Behind Millions of AI Agent Databases ^{(from siddontang on Medium)}

p1. Why I Wanted to Write This/ppContinue reading on Medium »/p [...]

Published Wednesday, 13. May 2026 02:41 • 10 days ago

TiDB SCaiLE Europe 2026: Speaker Lineup and Session Preview ^{(from PingCAP Blog)}

pAgentic AI changes the database problem. A single user action can trigger many agent steps. However, each agent needs state, memory, transactions, analytics, and retrieval to stay consistent under real production load. That pressure exposes the weak points in stacks built from separate OLTP databases, vector stores, warehouses, and sync pipelines. TiDB SCaiLE Europe 2026 […]/p pThe post TiDB [...]

Published Tuesday, 12. May 2026 18:05 • 10 days ago

Migrating Data Ingestion Systems at Meta Scale ^{(from Engineering at Meta)}

pMeta’s data ingestion system, which our engineering teams leverage for up-to-date snapshots of the social graph, has recently undergone a significant revamp to enhance its reliability at scale. Moving from our legacy system to our new architecture required a large-scale migration of our entire data ingestion system. We’re sharing the solutions and strategies that enabled [...]/p pRead More.../p [...]

Published Tuesday, 12. May 2026 16:00 • 10 days ago

MySQL Community Update: Public Discussion #4, Design Proposals, and Contributor Summit ^{(from The Oracle MySQL Blog)}

Following the strong engagement across the first three editions of our Public MySQL Community Discussion series, we’re pleased to invite you to Edition #4. We will focus on the upcoming contribution process changes and our Contributor Summit later in May. This ongoing series is part of our commitment to increase transparency, strengthen collaboration, and provide […] [...]

Published Tuesday, 12. May 2026 15:20 • 10 days ago

From Preview to Production: TiDB Cloud Dedicated on Microsoft Azure is Now Generally Available ^{(from PingCAP Blog)}

pFor teams standardized on Azure, distributed SQL has been a tradeoff. Stay on managed SQL Server or Azure Database for MySQL and live with single-instance scale ceilings. Step outside Azure to get horizontal scale. Today, TiDB Cloud Dedicated on Microsoft Azure is Generally Available (GA), which removes that tradeoff. After nearly a year of public […]/p pThe post From Preview to Produc [...]

Published Monday, 11. May 2026 19:08 • 11 days ago

What’s New in dbForge 2026.1: Greater Convenience, Enhanced Code Completion, and a Big Update of dbForge Studio for PostgreSQL ^{(from Devart MySQL Tool Blog)}

pThe time has come to announce the release of dbForge 2026.1, a grand update that brings a variety of new features and long-anticipated enhancements to the entire dbForge ecosystem./p pThe post What’s New in dbForge 2026.1: Greater Convenience, Enhanced Code Completion, and a Big Update of dbForge Studio for PostgreSQL appeared first on Devart Blog./p [...]

Published Monday, 11. May 2026 17:46 • 11 days ago

Documented: The MariaDB Server (Community) Contribution Process ^{(from MariaDB Foundation Blog)}

pIf you ever considered contributing code to the MariaDB server, you should know that this is an intricate process involving multiple steps and multiple actors. To help you see your contributions successfully merged into the MariaDB Server codebase I’ve compiled a comprehensive description of the contribution process itself, the roles involved into it, the sequence of actions and conditions f [...]

Published Monday, 11. May 2026 14:13 • 11 days ago

Now in Public Preview: Custom Port Support in Azure Database for MySQL – Flexible Server ^{(from Azure for MySQL Blog)}

blockquote pℹ️ Note: Custom port support for Azure Database for MySQL is now generally available. Read the full GA announcement here./p /blockquote p /p pWe’re thrilled to announce the public preview of Custom Port Support for Azure Database for MySQL – Flexible Server! This feature gives you more control over how your MySQL servers integrate with your applications and network environment [...]

Published Monday, 11. May 2026 12:43 • 11 days ago

ProxySQL in Front of AWS RDS & Aurora MySQL — Part 1: Why and Where to Place It ^{(from ReliaDB)}

Why put ProxySQL in front of RDS or Aurora MySQL? Placement trade-offs, alternatives comparison, and the lab topology that carries through this 5-part series. [...]