Planet for the MySQL Community

Threadpool Performance Assessment - MySQL vs Mariadb ^{(from mysql tips)}

Why this assessment of mysql vs mariadb threadpoolThreadpool is a commercial feature in MySQL whereas it's opensource in Mariadb and some variation is there so, I thought of assessing to know real gain of threadpool in terms of performance. This performance assessment, I did on on my 6 core ubuntu 24 laptop for read-only, read-write and tpcc cached workloads. Here, a cached/memory [...]

Published Wednesday, 03. June 2026 17:31 • 23 hours ago | Updated Thursday, 04. June 2026 16:05 • 15 minutes ago

Understanding how backups work in Amazon Aurora ^{(from AWS Database Blog)}

In this post, we dive deep into the Aurora backup architecture, how it differs from Amazon RDS backups, and the Amazon CloudWatch metrics available to monitor your backup storage usage. Through detailed scenarios and visualizations, we demonstrate how workload patterns and retention periods impact backup costs. We also explore cross-Region backup options and share recommended practices to optimize [...]

Published Thursday, 04. June 2026 15:37 • 44 minutes ago

Inserting in Two Tables in a Single Round-Trip with JSON Duality Views in MySQL 9.7 ^{(from J-F Gagné's MySQL Blog)}

A few months ago, I was asking myself how to insert in two tables in a single round-trip to the database. I wanted to do that to optimize a process. My optimization involved splitting a table in two, which would need inserting in two tables atomically. The downside was changing an auto-commit INSERT to a transaction with two inserts, which was changing the shape of the workload [...]

Published Thursday, 04. June 2026 14:17 • 2 hours ago

How to Reduce Database TCO by 30% Without Sacrificing Performance | Mydbops ^{(from Mydbops Blog)}

Learn how the 30% Rule helps organizations reduce database TCO through architectural modernization, storage efficiency, and performance tuning for MySQL and TiDB. [...]

Published Thursday, 04. June 2026 12:14 • 4 hours ago

The Power Of The Community! ^{(from MariaDB Foundation Blog)}

pA proper comparison of the distinct committers to MariaDB and MySQL repositories since Q1 2025./p pThe post The Power Of The Community! appeared first on MariaDB.org./p [...]

Published Thursday, 04. June 2026 11:42 • 5 hours ago

Distributed SQL vs. MySQL: Scaling IoT and Chat Apps | Mydbops ^{(from Mydbops Blog)}

This technical review compares TiDB and MySQL for IoT and chat platforms, demonstrating how distributed SQL resolves metadata scaling and write ingestion limits while cutting storage costs by 50%. [...]

Published Thursday, 04. June 2026 11:22 • 5 hours ago

MariaDB Hidden Gem: Create Aggregate Function ^{(from lefred's blog)}

Have you ever written a query where the GROUP BY was easy, but the aggregate was the problem? You know how to group the rows.You know what result you want for each group.But none of the built-in aggregate functions really match your logic. So you end up with a long expression using SUM(), CASE, IF(), […] [...]

Published Thursday, 04. June 2026 10:41 • 6 hours ago

MariaDB Hidden Gem: Create Aggregate Function ^{(from MariaDB Foundation Blog)}

pHave you ever written a query where the GROUP BY was easy, but the aggregate was the problem?br You know how to group the rows.You know what result you want for each group.But none of the built-in aggregate functions really match your logic. … /p pContinue reading \"MariaDB Hidden Gem: Create Aggregate Function\"/p pThe post MariaDB Hidden Gem: Create Aggregate Function appeared first on Mar [...]

Published Thursday, 04. June 2026 10:35 • 6 hours ago

Happy Path, Escape Hatch, and the Space Between ^{(from VillageSQL)}

Learn how VillageSQL balances ease and power in API design using the Happy Path, the Escape Hatch, and the deliberate patience in between. [...]

Published Wednesday, 03. June 2026 17:21 • 23 hours ago

VillageSQL Features… déjà vu? ^{(from lefred's blog)}

At events with the MySQL community, when we were enough “veterans,” we had a little ritual: we played Cards Against the MySQL Community. A politically incorrect (but still lighthearted) game that followed the same rules as “Cards Against Humanity.“ Those were some really fun, unforgettable evenings! One of the most popular black cards, which always […] [...]

Published Wednesday, 03. June 2026 14:53 • a day ago

Zero-Downtime MySQL to AWS RDS/Aurora Migration Playbook | Mydbops ^{(from Mydbops Blog)}

Learn how to migrate from self-hosted MySQL to AWS RDS or Aurora with zero-downtime. A comprehensive playbook covering strategy, AWS DMS, and cutover best practices by Mydbops experts. [...]

Published Wednesday, 03. June 2026 10:10 • a day ago

Celebrating the MariaDB Foundation Sea Lions Champions Nominees ^{(from MariaDB Foundation Blog)}

pThe MariaDB Foundation Sea Lions Champions recognize individuals and organizations that strengthen the MariaDB ecosystem through technical excellence, community leadership, open-source stewardship, ecosystem impact, and real-world adoption. … /p pContinue reading \"Celebrating the MariaDB Foundation Sea Lions Champions Nominees\"/p pThe post Celebrating the MariaDB Foundation Sea Lions Champ [...]

Published Wednesday, 03. June 2026 08:47 • a day ago

From Question to Insight with MySQL Studio ^{(from The Oracle MySQL Blog)}

When we introduced MySQL Studio, the goal was to bring the common parts of database development and analysis into one OCI workspace: SQL authoring, schema exploration, results visualization, and Ask Studio. The next step is making that workspace more useful during the everyday flow of MySQL work. For many MySQL developers, DBAs, and application teams, […] [...]

Published Wednesday, 03. June 2026 08:05 • a day ago

From 100 TPS to 10,000 TPS: A Systematic Tuning Path for MySQL ^{(from Mydbops Blog)}

A stage-by-stage MySQL performance tuning guide, InnoDB internals, connection pooling with ProxySQL, read replica scaling, and sharding strategy. [...]

Published Wednesday, 03. June 2026 07:12 • a day ago

MariaDB Foundation: Bringing TPC-B Back To Life ^{(from MariaDB Foundation Blog)}

pWhen I joined Pervasive PSQL, one of the first performance test cases I was introduced to was TPC-B. It was already implemented inside Pervasive PSQL and it quickly became one of the most important tools in my daily work. … /p pContinue reading \"MariaDB Foundation: Bringing TPC-B Back To Life\"/p pThe post MariaDB Foundation: Bringing TPC-B Back To Life appeared first on MariaDB.org./p [...]

Published Wednesday, 03. June 2026 01:10 • a day ago

Rate Limiting (Throttle) for MySQL with ProxySQL and Bintrail ^{(from dbtrail Blog)}

pBack in 2020 I wrote about rate limiting writes to MySQL with ProxySQL. The main idea is still valid, but two things changed enough to write it again.…/p pThe post Rate Limiting (Throttle) for MySQL with ProxySQL and Bintrail appeared first on dbtrail Blog./p [...]

Published Tuesday, 02. June 2026 20:55 • 2 days ago

I got swarmed by a replication issue ^{(from The consistent voice)}

pI recently worked with a client who runs a mature CI/CD pipeline on GitLab. Docker Swarm as the orchestrator, config files versioned and pulled at deploy time, the whole nine yards. They had been deploying standalone MariaDB instances this way for a while, without a hitch./ppThen came the ask : stand up an async replication cluster. One primary, two replicas, one MaxScale instance sitting in front [...]

Published Tuesday, 02. June 2026 20:18 • 2 days ago

MariaDB Community Server Corrective Releases ^{(from MariaDB Foundation Blog)}

pMariaDB Community Server corrective releases are now available for the currently maintained long-term series. These releases address critical CVEs, and we strongly recommend that all users review the security advisories and upgrade as soon as possible. … /p pContinue reading \"MariaDB Community Server Corrective Releases\"/p pThe post MariaDB Community Server Corrective Releases appeared fir [...]

Published Tuesday, 02. June 2026 19:20 • 2 days ago

[Launched] Generally Available: Azure Database for MySQL now available in new regions and expanded availability zones ^{(from Azure Updates)}

Azure Database for MySQL Flexible Server continues to expand its global footprint with new regional availability and enhanced availability zone support. You can now deploy Azure Database for MySQL Flexible Server in the Denmark East, Austria East, and Bel [...]

Published Tuesday, 02. June 2026 19:00 • 2 days ago

[Launched] Generally Available: Azure Database for MySQL Flexible Server self-service quota management experience ^{(from Azure Updates)}

Managing your quota is now faster, simpler, and more transparent. Azure Database for MySQL Flexible Server supports self-service quota management through the Azure Quotas blade in the Azure portal. You can view your current quota usage and limits, request [...]

Published Tuesday, 02. June 2026 19:00 • 2 days ago

MariaDB Enterprise Server Q1 2026 Corrective Releases ^{(from MariaDB Corporation Blog)}

New corrective maintenance releases for MariaDB Enterprise Server 11.8.6-4, 11.4.10-8, and 10.6.25-22 are now available. Download Now Notable Release Updates […] [...]

Published Tuesday, 02. June 2026 18:38 • 2 days ago

Snowflake’s Horizon Context aims to give AI agents a common understanding of the business ^{(from InfoWorld)}

pAs enterprises move from AI experimentation to production deployments, one challenge is becoming increasingly apparent: AI systems are only as reliable as the business context they operate in./p pSnowflake is attempting to address that problem with Horizon Context, a new set of semantic and metadata-management capabilities, currently in preview, that it unveiled Tuesday a [...]

Published Tuesday, 02. June 2026 18:06 • 2 days ago

How GitHub plans to win developers back ^{(from The New Stack)}

♦pFor much of the past year, GitHub has not been the stable utility developers had long gotten used to. Outages,/p pThe post How GitHub plans to win developers back appeared first on The New Stack./p [...]

Published Tuesday, 02. June 2026 17:56 • 2 days ago

May Product Update ^{(from Readyset Blog)}

Readyset now ships MCP support, PostgreSQL group commit, the UNTIL WRITE caching policy, and more. Plus a new case study hitting 100K QPS on MySQL. [...]

Published Tuesday, 02. June 2026 17:30 • 2 days ago

Extend MySQL Using Rust ^{(from VillageSQL)}

Discover how the VillageSQL Rust SDK brings native, memory-safe Rust extension development to MySQL, bypassing C++ entirely. [...]

Published Tuesday, 02. June 2026 15:59 • 2 days ago

Where can you find MySQL during June–August 2026? ^{(from ODBMS.org)}

June 1, 2026 4 minute read Lenka Kasparova MySQL Community Manager The MySQL Community team will be active across conferences, user group meetups, open source events, and regional community activities during the summer months. Whether... [...]

Published Tuesday, 02. June 2026 14:54 • 2 days ago

MySQL Schema Design Patterns That Enable Linear Scalability ^{(from MinervaDB Blog)}

Most MySQL performance problems do not start in the query optimizer or the connection pool. They start at the whiteboard, months or years earlier, in the moment someone sketched the first version of a schema [...] [...]

Published Tuesday, 02. June 2026 11:18 • 2 days ago

The Percona Community Slack is open — come hang out ^{(from Percona Community Blog)}

The Percona Community Slack is open — come hang out There’s a new place for the people behind the databases to actually talk to each other. [...]

Published Tuesday, 02. June 2026 11:00 • 2 days ago

Introducing Tungsten Cluster & Tungsten Replicator v8.0.4 ^{(from Continuent Blog)}

Tungsten Cluster and Tungsten Replicator v8.0.4 is a maintenance release focused on security hardening, updated dependencies, stronger diagnostics, improved replication visibility, safer failover behavior, and reliability fixes across core components.Tags: tungsten clustertungsten replicatordatabase failoverreplication monitoringdatabase securityupdate [...]

Published Tuesday, 02. June 2026 07:53 • 2 days ago

Announcing Dumbo Garbage Collection ^{(from DoltHub Blog)}

MongoDB and Git had a baby, and it's named Dumbo. The latest release has garbage collection! [...]

Published Tuesday, 02. June 2026 00:00 • 3 days ago

MySQL Resource Quotas, Throttling, and Fair-Share Scheduling: A Practical Guide ^{(from MinervaDB Blog)}

A practical, production-focused guide to MySQL resource quotas, throttling, and fair-share scheduling — using Resource Groups, MAX_USER_CONNECTIONS, MAX_EXECUTION_TIME, and ProxySQL to protect performance under noisy-neighbor and multi-tenant workloads. [...] [...]

Published Tuesday, 02. June 2026 00:00 • 3 days ago

Tuning MariaDB for Cloud and Containerized Environments ^{(from MinervaDB Blog)}

A practical guide to tuning MariaDB for cloud and containerized environments — right-sizing the InnoDB buffer pool, handling cgroup limits in Docker and Kubernetes, taming ephemeral storage and network latency, and building stateful, observable database workloads. [...] [...]

Published Tuesday, 02. June 2026 00:00 • 3 days ago

A New Pull Request Processing Time Record ^{(from MariaDB Foundation Blog)}

pWe have a new record average time to process a pull request: 21 days!br Part of my job is following (and trying to improve of course) some key metrics about MariaDB Server pull request processing. … /p pContinue reading \"A New Pull Request Processing Time Record\"/p pThe post A New Pull Request Processing Time Record appeared first on MariaDB.org./p [...]

Published Monday, 01. June 2026 14:25 • 3 days ago

Where can you find MySQL during June–August 2026? ^{(from The Oracle MySQL Blog)}

The MySQL Community team will be active across conferences, user group meetups, open source events, and regional community activities during the summer months. Whether you would like to hear about the latest MySQL 9.7 updates, meet the MySQL team, join a user group meetup, or connect with the broader open source and developer community, here […] [...]

Published Monday, 01. June 2026 14:22 • 3 days ago

Agent-led devs need serverless OpenSearch, Amazon claims ^{(from The Register)}

System relies on a proprietary storage layer as AWS moves to separate storage and compute to fit mega AI demands [...]

Published Monday, 01. June 2026 12:45 • 3 days ago

How Meta Rebuilt Data Ingestion for Petabyte-Scale Reliability ^{(from InfoQ)}

♦pThe engineering team at Meta recently outlined how the company migrated a data ingestion platform that transfers several petabytes of MySQL social graph data daily to improve reliability and operational efficiency. The team used techniques like reverse shadowing and continuous checksum monitoring to ensure zero downtime during the transition./p By Renato Losio [...]

Published Saturday, 30. May 2026 06:01 • 5 days ago

MySQL performance with Kubernetes: bare metal vs K8 with docker vs K8 with container ^{(from mysql tips)}

Why database performance assessment with KubernetespNow a days, Kubernetes is being used to manage databases like MySQL/Mariadb for reasons like manageability etc. However, the real question is whether we are aware of the performance overhead costs. So, the objective of my assessment is to find out actual overhead with different runtime like docker or container./pA [...]

Published Thursday, 28. May 2026 05:39 • 7 days ago | Updated Saturday, 30. May 2026 05:34 • 5 days ago

Why using production workloads over simulated workloads is critical ^{(from Ronald Bradford Blog)}

AI-Assisted SQL Tuning Last week in his keynote speech at Percona Live Bay Area 2026 , Andy Pavlo presented Databases: The Final Boss of Agents and provided some useful insights into query optimization of simulated workloads leveraging AI. [...]

Published Saturday, 30. May 2026 00:00 • 6 days ago

JSON Duality Views in MySQL 9.7 — What you need to know ^{(from Marcelo Altmann)}

♦pMySQL 9.7 was released as the new LTS, and one of the features that caught my attention is JSON Duality Views. I have written about a few other 9.7 changes already, so this time I wanted to learn about Duality Views and share what I’ve learned./ppThe idea behind a JSON Duality View is simple to state but powerful in practice: the same data is exposed both as normalized relational tables (Your usu [...]

Published Friday, 29. May 2026 23:29 • 6 days ago

MariaDB Server 12.3 LTS Released ^{(from MariaDB Foundation Blog)}

pThe MariaDB Foundation is pleased to announce the availability of MariaDB Server 12.3 LTS, the latest Long Term Support release of MariaDB Server. The first GA of the 12.3 series is 12.3.2. … /p pContinue reading \"MariaDB Server 12.3 LTS Released\"/p pThe post MariaDB Server 12.3 LTS Released appeared first on MariaDB.org./p [...]

Published Friday, 29. May 2026 16:47 • 6 days ago

Percona Live 2026: AI Won’t ‘Kill’ DBAs, New Open Database Champions Will Rise ^{(from Techstrong.IT)}

pPercona Live 2026 returned to Mountain View, California this month, bringing together database professionals, open source advocates, and practitioners for what the company describes as a no-nonsense, hands-on event. Held at the Computer History Museum (nice people, great museum, so-so conference center top section), the conference was initially anchored by a keynote from new Percona [...]/p pThe [...]

Published Friday, 29. May 2026 13:51 • 6 days ago

Building Smart Semantic Search using PostgreSQL and pgvector. Case Study - Part 1 - Introduction ^{(from Percona Community Blog)}

Type “zero downtime database migration” into the site’s search bar and you’ll get articles and talks about database migration with minimal downtime, even if those words aren’t in the titles or content. This is semantic search on PostgreSQL and pgvector, without paid embedding APIs or a separate vector database. In this series I’ll cover how it works and why I chose this stack. [...]

Published Friday, 29. May 2026 11:00 • 6 days ago

PostgreSQL HeapTable + Pin vs MySQL InnoDB IOT + Persistent Cursor ^{(from Chen Zongzhi's Medium blog)}

♦pIn an earlier post I went through the Pin mechanism from PostgreSQL’s Buffer Access 5 Rules. HeapTable + Pin leads to a few more differences from InnoDB, and that’s what this post is about./pWhy InnoDB has a persistent cursorpInnoDB’s persistent cursor exists to preserve the position of an index tree cursor while a query walks the B-tree./ppWhy is that needed? Take a large query. Once you’ve read [...]

Published Friday, 29. May 2026 07:27 • 6 days ago

MySQL HeatWave Document Store for Modern Applications ^{(from The Oracle MySQL Blog)}

Modern applications generate and consume enormous amounts of semi-structured data. User profiles, product catalogs, IoT telemetry, application events, AI prompts, and content metadata rarely fit neatly into rigid relational schemas anymore. At the same time, enterprises still need the reliability, security, analytics, and operational maturity of a traditional database platform. This is where MySQL [...]

Published Friday, 29. May 2026 02:22 • 7 days ago

Evolving with Beads ^{(from DoltHub Blog)}

A guide to evolving your Beads setup from classic single-agent mode to server and shared-server modes for multi-agent workflows, with a bonus look at the global Beads database. [...]

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

MariaDB Community Server 12.3 LTS: How It Scales AI Workloads and Delivers 4x Write Performance ^{(from MariaDB Corporation Blog)}

We are thrilled to announce that MariaDB Community Server 12.3 has reached Generally Available (GA) status. As our latest Long […] [...]

Published Thursday, 28. May 2026 19:27 • 7 days ago

Percona celebrates 20th birthday with new foundation — and a goat cake ^{(from The New Stack)}

♦pPercona, which makes a popular open-source database-as-a-service (DBaaS), celebrated its 20th birthday this week with a rebrand, a new supporting/p pThe post Percona celebrates 20th birthday with new foundation — and a goat cake appeared first on The New Stack./p [...]

Published Thursday, 28. May 2026 17:14 • 7 days ago

Porting PostgreSQL Extensions to MySQL using Agent Skills ^{(from VillageSQL)}

Discover how to build and port PostgreSQL extensions to MySQL using VillageSQL's Extension Framework and our new automated CLI agent skill. [...]

Published Thursday, 28. May 2026 14:56 • 7 days ago

OurSQL Foundation launches to support MySQL users, developers, and companies ^{(from One-Time MySQL Community/Ecosystem Posts)}

Today marks the launch of The OurSQL Foundation, an open organisation that will support the community of users, developers, and companies that are invested in the success of MySQL. The new Foundation will provide a venue for those involved in the MySQL community using, building and deploying applications that use MySQL or the broad range of compatible software to share with their peers, to access k [...]

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

Percona Operator for PostgreSQL 3.0.0: Hard Fork, OLM Scoping, Major Upgrades ^{(from Percona Database Blog)}

pThe Percona Operator for PostgreSQL 3.0.0 is here. This is the release that completes the hard fork of the operator from the Crunchy Data PostgreSQL Operator into a fully independent project, with a dedicated upstream.pgv2.percona.com API group for the inherited CRDs, an automatic CRD-rename rollout for existing 2.x installs on upgrade, and a public roadmap … Continued/p pThe post Percona Op [...]

Published Thursday, 28. May 2026 13:29 • 7 days ago

MariaDB Foundation at Oracle’s MySQL Contributor Summit: Ecosystems, Forks and Constructive Coexistence ^{(from MariaDB Foundation Blog)}

pLast week, Oracle invited MariaDB Foundation to give a presentation at Oracle’s MySQL Contributor Summit 2026. I had the opportunity to participate remotely and speak about MariaDB’s role within the broader MySQL ecosystem. … /p pContinue reading \"MariaDB Foundation at Oracle’s MySQL Contributor Summit: Ecosystems, Forks and Constructive Coexistence\"/p pThe post MariaDB Foundat [...]

Published Thursday, 28. May 2026 12:33 • 7 days ago

A new vendor-neutral foundation to stop MySQL slipping? ^{(from The Stack)}

OurSQL is so vendor-neutral that it does not include MySQL's owner, but its board features folks from AliSQL. [...]

Published Thursday, 28. May 2026 09:01 • 7 days ago

General Availability of the MySQL Flexible Server Quota Management Self-Service Experience ^{(from Azure for MySQL Blog)}

What’s New? pThe updated experience introduces a dedicated Azure Database for MySQL Flexible Server Quotas blade in the Azure portal, offering a streamlined and intuitive interface to: /p ul liView current usage and limits across the various SKU families and regions /li liRequest quota increases tailored to your MySQL Flexible Server deployment needs /li /ul pThi [...]

Published Thursday, 28. May 2026 05:58 • 7 days ago

Guide your Amazon Aurora MySQL migration with Kiro powers ^{(from AWS Database Blog)}

Today, we announce the Amazon Aurora MySQL power for Kiro. The power connects Kiro’s AI agent to Aurora MySQL and pairs live database access with curated best-practice guidance. You describe what you need in natural language. The agent generates the API calls, SQL, and configuration for you to review and run. In this post, we walk through how the power guides a production migration from Amazon Rela [...]

Published Thursday, 28. May 2026 00:15 • 8 days ago

PostgreSQL HeapTable + Pin vs MySQL InnoDB IOT + Persist cursor ^{(from Chen Zongzhi's GitHub blog)}

前面介绍过 PostgreSQL Buffer Access 5 Rules 里面的 Pin 机制, 其实 HeapTable + Pin 机制还带来了其他和 InnoDB 的区别. [...]

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

Connection Pooling Best Practices for MySQL at Scale ^{(from MinervaDB Blog)}

A principal database architect's guide to MySQL connection pooling at scale: right-sizing application pools, ProxySQL multiplexing, tuning max_connections and timeouts, avoiding connection storms, and the metrics that actually matter. [...] [...]

Published Wednesday, 27. May 2026 20:01 • 8 days ago

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

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.8.8, 11.4.12, 10.11.18, and 10.6.27 corrective releases. See […] [...]

Published Wednesday, 27. May 2026 19:09 • 8 days ago

Optimize costs in Amazon Aurora ^{(from AWS Database Blog)}

By implementing modern optimization techniques for Aurora, you can achieve additional cost reduction beyond traditional methods alone. This isn’t only about spending less—it’s about building a more efficient, scalable, and resilient database environment. In this post, we show you a structured approach to optimizing Amazon Aurora database costs. It outlines specific strategies, implementation steps, [...]

Published Wednesday, 27. May 2026 18:15 • 8 days ago

Amazon Aurora MySQL now supports integration with Kiro Powers ^{(from AWS What's New)}

pToday, AWS announces that Amazon Aurora MySQL-Compatible Edition now supports integration with Kiro Powers, enabling developers to build Aurora MySQL-backed applications faster with AI agent assistance. Kiro Powers is a repository of curated and pre-packaged Model Context Protocol (MCP) servers, steering files, and hooks that have been validated by Kiro partners to accelerate specialized software [...]

Published Wednesday, 27. May 2026 15:00 • 8 days ago

Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Backup-Restore and PV Reuse ^{(from Percona Database Blog)}

pA Percona PostgreSQL operator pgBackRest restore is the simplest way to move off the Crunchy Data PostgreSQL Operator: take a full Crunchy backup, point the new Percona cluster’s dataSource at the existing pgBackRest archive, and the cluster bootstraps from it before its first start. This post covers that path, plus a second option, persistent-volume reuse, for cases … Continued/p pThe [...]

Published Wednesday, 27. May 2026 12:02 • 8 days ago

MySQL community establishes independent foundation ^{(from Techzine)}

A group of companies and developers from the MySQL ecosystem has established the OurSQL Foundation. The new organization aims to better align the future of the open-source database with the community while also collaborating more closely with Oracle, the owner of MySQL. The initiators argue that MySQL users and developers need greater transparency regarding the […] [...]

Published Wednesday, 27. May 2026 11:03 • 8 days ago

Virtuozzo Renews Sponsorship of MariaDB Foundation ^{(from MariaDB Foundation Blog)}

pWe are delighted to announce that Virtuozzo has renewed its sponsorship of MariaDB Foundation.br Virtuozzo has been a long-standing supporter of open infrastructure, service providers, and cloud platforms, and we are very pleased to continue strengthening our collaboration. … /p pContinue reading \"Virtuozzo Renews Sponsorship of MariaDB Foundation\"/p pThe post Virtuozzo Renews Sponsorship [...]

Published Wednesday, 27. May 2026 10:48 • 8 days ago

MySQL Execution Plans Explained: Reading and Tuning for Faster Queries ^{(from MinervaDB Blog)}

A Principal Database Architect's practical guide to reading MySQL execution plans with EXPLAIN and EXPLAIN ANALYZE, decoding the type and Extra columns, and applying proven indexing and query-rewrite techniques to make slow queries fast. [...] [...]

Published Wednesday, 27. May 2026 04:30 • 8 days ago

How MariaDB Cloud Optimizes Database Resilience and Cost: A Deep Dive into High Availability ^{(from MariaDB Corporation Blog)}

MariaDB has long been the backbone of mission-critical applications, valued for its rich feature set, developer-friendly SQL dialect and a […] [...]

Published Tuesday, 26. May 2026 17:49 • 9 days ago

MySQL faithful launch OurSQL Foundation to keep Oracle honest ^{(from The Register)}

Community group wants transparency, collaboration, and a clearer roadmap for the open source database [...]

Published Tuesday, 26. May 2026 17:30 • 9 days ago

How Procurement Leaders Realize ROI from Open Source Databases ^{(from Percona Database Blog)}

pDatabase purchases are often considered just another IT expense. The primary concerns are limited to license fees and sign support contracts. But this mindset ignores hidden costs like downtime, excess capacity, rising renewal fees, and data transfer charges. The financial sector particularly suffers, as proprietary databases hinder system updates for compliance and real-time AI, impose … Co [...]

Published Tuesday, 26. May 2026 15:20 • 9 days ago

Announcing VillageSQL Server 0.0.4 ^{(from VillageSQL)}

Explore VillageSQL Server 0.0.4: now featuring VEF v3, custom aggregates, parameter inference, and preview capabilities like background threads. [...]

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

ProxySQL joins MariaDB Foundation as Silver Sponsor ^{(from MariaDB Foundation Blog)}

pWe are very pleased to welcome ProxySQL as a Silver Sponsor of the MariaDB Foundation.br ProxySQL is the leading proxy for MySQL and has recently focused on supporting more and more of MariaDB, both with the Proxy and with other open-source projects ProxySQL is stewarding, like dbdeployer and orchestrator. … /p pContinue reading \"ProxySQL joins MariaDB Foundation as Silver Sponsor\"/p pThe [...]

Published Tuesday, 26. May 2026 06:10 • 9 days ago

Part 4 - PgBouncer to ProxySQL: Extended and Prepared Protocols ^{(from ProxySQL Blog)}

Part 4 of the PgBouncer to ProxySQL series. Benchmarks ProxySQL and PgBouncer under PostgreSQL's extended and prepared query protocols. ProxySQL keeps the lead and widens it as worker threads increase. [...]

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

MySQL Time-Travel with near-ZERO overhead: How bintrail skips the write load ^{(from dbtrail Blog)}

pA reader asked four operations-grade questions about Time Travel SQL. Here is how bintrail handles multi-TB tables, retention, monitoring, and partitioning - and how it differs from MariaDB system-versioned tables./p pThe post MySQL Time-Travel with near-ZERO overhead: How bintrail skips the write load appeared first on dbtrail Blog./p [...]

Published Monday, 25. May 2026 16:05 • 10 days ago

Drupal recommends MariaDB ^{(from MariaDB Foundation Blog)}

pMariaDB is now clearly listed as the recommended database in Drupal’s official documentation. Following community discussion on Drupal.org, the Database server requirements now lists MariaDB first, and identifies it as the recommended database for Drupal 10, 11, and 12. … /p pContinue reading \"Drupal recommends MariaDB\"/p pThe post Drupal recommends MariaDB appeared first on MariaDB. [...]

Published Monday, 25. May 2026 11:29 • 10 days ago

Running TidesDB as a MySQL 9.7 storage engine ^{(from Percona Database Blog)}

ptidesdb-mysql is an experimental build that was developed to verify how TidesDB, the LSM-tree key/value engine, can work with MySQL 9.7 as a storage engine. The current build is v0.2.4, and it’s an experiment, not a finished product. So you can use it in your tests if you also want to try TidesDB with MySQL … Continued/p pThe post Running TidesDB as a MySQL 9.7 storage engine appeared [...]

Published Monday, 25. May 2026 10:51 • 10 days ago

Migrate from Crunchy Data PostgreSQL Operator to Percona PostgreSQL Operator: Standby Cluster Method ^{(from Percona Database Blog)}

pA Crunchy to Percona PostgreSQL migration is more straightforward than most cross-operator moves on Kubernetes, because the Percona PostgreSQL Operator is a hard fork of the Crunchy Data PostgreSQL Operator. Same Patroni HA, same pgBackRest backups, same overall CRD shape. This post walks through the safest of the three migration paths: a standby cluster method … Continued/p pThe post Migrat [...]

Published Monday, 25. May 2026 07:49 • 10 days ago

Mariadb Performance : Openssl and wolfssl ^{(from mysql tips)}

pWhy this SSL performance assessment of Mariadb ?/ppMy first objective was to assess new openssl 3.5 or 3.6 and see whether it's improving for Mariadb or not and second , I could not find any comparative analysis of ssl for Mariabd in public space./ppEarlier in MySQL, I had done exhaustive assessment of wolfssl and openssl's different version so thought of doing some against Mariadb whi [...]

Published Friday, 22. May 2026 09:02 • 13 days ago | Updated Monday, 25. May 2026 00:55 • 11 days ago

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

psrc/backend/storage/buffer/README 是 PG 社区维护 buffer manager 的官方设计文档. 它在开头列了 5 条 buffer access rules, 提 patch / review 时直接引用. 这 5 条规则合起来定义了 PG 的 Pin 协议, 也是 PG 和 InnoDB buffer manager 设计上真正分叉的地方./p同步原语先看清楚pPG 的 buffer 上有两个独立的同步原语:/pulliPin — atomic refcount, 防止 slot 被 evict 换成别的 page. 持有时间可长可短, 甚至跨函数 / 跨节点传递都行./liliContent Lock — LWLock, share / exclusive 两种模式, 保护 page 字节内容的并发访问. 持有时间应当尽量短./li/ulpPG [...]

Published Saturday, 23. May 2026 21:36 • 12 days ago

Why Modern Finance Runs on Open Source ^{(from Percona Database Blog)}

pFor decades, financial institutions have relied on proprietary databases to power everything from customer transactions to real-time risk engines. But the pressures facing banks, fintechs, and payment providers have changed. Even minutes of downtime can trigger customer loss. 91% of enterprises report costs over $300,000 per hour, with 44% saying it can exceed $1 million. … Continued/p pThe [...]

Published Saturday, 23. May 2026 10:59 • 12 days ago

MySQL HeatWave Database Housekeeping Best Practices ^{(from The Oracle MySQL Blog)}

As MySQL HeatWave environments continue to grow, many organizations prioritize scaling compute and storage resources while overlooking a critical area: database housekeeping. Inadequate maintenance practices can result in excessive storage consumption, longer backup and recovery times, replication lag, degraded query performance, and increased operational costs. This blog highlights key database hy [...]

Published Saturday, 23. May 2026 06:21 • 12 days ago

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 • 13 days 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 • 13 days 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 • 13 days 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 • 13 days 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 • 14 days ago

Catching and fixing regressions in the MySQL Ecosystem ^{(from Nyrkiö Blog)}

Guest blog by Amrendra Kumar, former MySQL Performance Engineer I worked the past 14 years in the MySQL Performance & QA team in Oracle. Like many others I was recently laid off. I thought of sharing my experience of how we use continuous benchmarking to prevent performance regressions in MySQL releases. In my opinion the […] [...]

Published Thursday, 21. May 2026 21:18 • 14 days 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 • 14 days 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 • 14 days 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 • 14 days 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 • 14 days 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 • 14 days 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 • 14 days 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 • 14 days 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 • 14 days 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 • 15 days 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 • 15 days ago

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

The Hidden Cost of Idle Cloud Databases Structured databases are amongst the biggest line items in enterprise IT infrastructure – […] [...]

Published Wednesday, 20. May 2026 15:58 • 15 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 • 15 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 • 15 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 • 15 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 • 16 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 • 16 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 • 16 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 • 16 days ago

MySQL- Crash Recovery Performance Assessment ^{(from mysql tips)}

pWhy we need to assess the performance of crash recovery in MySQ and here is my explanation:/pp It’s not just WLs or bug fixes — any change in redo format or code changes around it, flushing behavior, or recovery concurrency can silently slow things down and if you have huge volume of data to recover than it could be painful./ppbr/ppMySQL errorlog is the best place to look into det [...]

Published Tuesday, 19. May 2026 03:32 • 17 days ago | Updated Tuesday, 19. May 2026 04:19 • 17 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 • 17 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 • 17 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 • 17 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 • 19 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 • 20 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 • 20 days ago

mysql tips ^{(from mysql tips)}

While testing of mysql using sysbench I wanted to ensure that sysbench client is using SSL connection. For this performance_schema came handy.br br mysql> SELECT CONNECTION_TYPE from performance_schema.threads where processlist_command='Query';br +-----------------+br | CONNECTION_TYPE |br +-----------------+br | SSL/TLS |br +-----------------+br br br mys [...]

Published Wednesday, 15. November 2017 07:24 • over a year ago | Updated Friday, 15. May 2026 10:36 • 20 days ago

WAL impact - MySQL 9.7.0 preview 2 times slower than Mariadb 12.3 preview ^{(from mysql tips)}

p mysql 9.7.0 preview looks like 2.3 times slower wrt mariadb with default binlog which is very surprising/pp/p♦brbrp/p [...]

Published Thursday, 14. May 2026 12:49 • 21 days ago | Updated Friday, 15. May 2026 10:31 • 20 days ago

PGO in MySQL community 9.7 ^{(from mysql tips)}

p PGO (Profile-guided optimization) in mysql community edition of 9.7.0/pp--------------------------------------------------------------------------------------------------------------------------/ppStraightforward , 30% gain we have seen in eneterprise edition of mysql in read only sysbench test like point-select ( memory bound) . /ppI am curious to know whethe [...]

Published Thursday, 14. May 2026 12:57 • 21 days ago | Updated Friday, 15. May 2026 10:26 • 20 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 • 21 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 • 21 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 • 21 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 • 21 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 • 21 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 • 21 days ago

TAF automation framework to test MariaDB innodb-based-binary-log ^{(from mysql tips)}

p This is first time, I am trying MariaDB and I mostly used MySQL. I thought of trying TAF against different version of maridb with hammerdb' tpcc. I must admit that I have mostly used sysench's tpcc or dbt2 ( old implementation of tpcc)/ppTAF , I pulled from github.com/MariaDB/TAF and I got community linux build of mariadb on my ubuntu 22.04 LTS , 16 cpu ./ppSince, InnoDB-Based Binary Log is [...]

Published Thursday, 14. May 2026 12:45 • 21 days ago | Updated Thursday, 14. May 2026 12:45 • 21 days ago

Performance QA practice in MySQL followed ^{(from mysql tips)}

olliContinous performance regression testing using automated tool - Scalabilty and single threaded test/lili Release Performance for server - On platform Linux and Windows /liliPre-push performance testing for Woklog/POC for major feature. Triage and find out whether non-functional test is required or not./liliBenchmarking like MySQL Heatwave (standalone or HA) vs RDS vs Aurora etc ./lili [...]

Published Thursday, 14. May 2026 12:32 • 21 days ago | Updated Thursday, 14. May 2026 12:34 • 21 days ago

Regression Analysis and hunting of ps-covered-id in mariadb 10.5.29 as reported by MarC in his blogpost ^{(from mysql tips)}

Reference: smalldatum.blogspot.com/2026/04/cpu-bound-sysbench-on-large-server.html Issue: ps-covered-pk - select id from sbtest where id in ( 100 random ids) , regressed between 10.5.29 release to 10.4.34 release Conclusion: "Remove multiple InnoDB buffer pool instances (MDEV-15058)" commit: 1a6f708ec594ac0ae2dd30db926ab07b100fa24b , did cause regression in ps-ps-covered-pk Investigation: Two [...]

Published Thursday, 14. May 2026 10:59 • 21 days ago | Updated Thursday, 14. May 2026 10:59 • 21 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 • 21 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 • 22 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 • 22 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 • 22 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 • 22 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 • 22 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 • 23 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 • 23 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 • 23 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 • 23 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 • 24 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 • 24 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 • 24 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 • 24 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. [...]