Planet for the MySQL Community

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