Planet for the MySQL Community

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 • 3 hours 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 • 11 hours 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 • a day 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 • a day 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 • a day 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 • a day 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 • 4 days ago | Updated Monday, 25. May 2026 00:55 • a day 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 • 3 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 • 3 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 • 4 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 • 4 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 • 4 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 • 4 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 • 5 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 • 5 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 • 5 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 • 5 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 • 5 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 • 5 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 • 5 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 • 5 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 • 5 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 • 5 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 • 6 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 • 6 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 • 6 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 • 6 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 • 6 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 • 6 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 • 7 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 • 7 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 • 7 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 • 7 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 • 8 days ago | Updated Tuesday, 19. May 2026 04:19 • 8 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 • 8 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 • 8 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 • 8 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 • 10 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 • 11 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 • 11 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 • 11 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 • 12 days ago | Updated Friday, 15. May 2026 10:31 • 11 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 • 12 days ago | Updated Friday, 15. May 2026 10:26 • 11 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 • 12 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 • 12 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 • 12 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 • 12 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 • 12 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 • 12 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 • 12 days ago | Updated Thursday, 14. May 2026 12:45 • 12 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 • 12 days ago | Updated Thursday, 14. May 2026 12:34 • 12 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 • 12 days ago | Updated Thursday, 14. May 2026 10:59 • 12 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 • 12 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 • 13 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 • 13 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 • 13 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 • 13 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 • 13 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 • 14 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 • 14 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 • 14 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 • 14 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 • 15 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 • 15 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 • 15 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 • 15 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. [...]