Planet for the MySQL Community

How Atomic DDL Works in MySQL 8.0 ^{(from Libing Song's Blog)}

Before MySQL 8.0, DDL was not crash-safe. There were three main problems: The metadata in the server layer and the metadata/data in InnoDB could become inconsistent. The server-layer metadata was stored in files — for example, table definitions were kept in .frm files — while InnoDB kept its own copy of the metadata in its tables. A crash could leave... [...]

Published Tuesday, 22. September 2026 02:00 • 19 hours ago | Updated Tuesday, 22. September 2026 16:06 • 4 hours ago

PeakAIO contributes support of 8k API nodes to RonDB 26.02.11 ^{(from Mikael Ronstrom)}

pPeakAIO develops pNFS Lattice, a new parallel file system using RonDB as a metadata server. To support larger clusters they needed more API nodes. RonDB 25.10 added support for 2039 API nodes, now 26.02.11 when released will support 8191 API nodes./p pSince originally RonDB supported 255 API nodes, changing to 8191 API nodes caused a number of memory segments to grow significantly. So part of the [...]

Published Tuesday, 22. September 2026 13:48 • 7 hours ago

AI Agent State Explained ^{(from PingCAP Blog)}

pKey Takeaways An agent that forgets everything between calls can’t finish a multi-step task, can’t recover from a mid-workflow crash, and can’t show you what it actually did. That’s the practical cost of statelessness, and it’s the problem AI agent state exists to solve. AI agent state is the durable record of memory, task progress, […]/p pThe post AI Agent Stat [...]

Published Monday, 21. September 2026 21:35 • 23 hours ago

Village News: MySQL News + Events (21 September 2026) ^{(from VillageSQL)}

pWelcome back. This issue covers five weeks rather than the usual one — the gap since the August issue took in Percona Live Amsterdam, the launch of the OurSQL Foundation, and the run-up to the MySQL Galera Cluster end of life on 30 September./ppIf you want to get/p [...]

Published Monday, 21. September 2026 16:58 • a day ago

Ensuring High Availability for Resilient Cloud Databases with MariaDB ^{(from DBTA)}

High availability and disaster recovery are critical for cloud databases, but not all HA architectures deliver the same level of resilience when failures occur. DBTA recently held a webinar, Beyond Hyperscaler HA: Building Resilient Cloud Databases, with MariaDB experts who looked at the limitations of traditional hyperscaler DBaaS HA approaches and explained how modern database architectures can m [...]

Published Monday, 21. September 2026 15:00 • a day ago

Why is Naomi Cannon bashing MariaDB? ^{(from Shinguz's Blog)}

p10 days ago, an article by Naomi Cannon on Reddit caught my attention; it included a link to the full article on Medium./p pAs I read through the article, I didn’t notice any major errors or false statements. What surprised me a bit was the detailed, technical knowledge in this article, which is unusual for a typical tech blogger./p pWhat bothered me about this article was that she mainly bashed M [...]

Published Monday, 21. September 2026 13:25 • a day ago

DISTANCE() and VECTOR_DISTANCE(): Vector Similarity in Percona Server for MySQL 9.7 ^{(from Percona Database Blog)}

pTL;DR Percona Server for MySQL 9.7.2-2 now supports DISTANCE() for vector similarity scoring directly in SQL (COSINE, EUCLIDEAN, MANHATTAN, DOT metrics). This is the compute primitive you need to rank or filter embeddings by similarity directly in SQL. ANN indexing (e.g. HNSW, IVF) is the next milestone for fast large-scale similarity search; and this function provides … Continued/p pThe pos [...]

Published Monday, 21. September 2026 09:57 • a day ago

Getting VECTOR capabilities in MySQL 8.4 using VillageSQL ^{(from Ronald Bradford Blog)}

For this quick verification of the 0.0.7 development branch of VillageSQL with the new vsql-vector plugin. Recreate the VillageSQL Percona Live presentation using MySQL version 8.4 and SVECTOR. Demonstrate a more detailed example using SVECTOR(1024) string embedded data. [...]

Published Sunday, 20. September 2026 00:00 • 3 days ago

MariaDB 13 Expands Oracle Compatibility and Improves Developer Experience and Observability ^{(from InfoQ)}

♦pMariaDB Community Server 13.0 has reached General Availability (GA) and is now officially stable. This release introduces a range of new features, deprecations, and performance improvements, including expanded support for procedural SQL, new DML capabilities, and more./p By Sergio De Simone [...]

Published Friday, 18. September 2026 19:00 • 4 days ago

MySQL Community Engagement in Brazil and Europe ^{(from The Oracle MySQL Blog)}

This September and October, Heather VanCura will meet with MySQL users, contributors, developers, DBAs, customers, and community leaders across Brazil and Europe. With more than 30 years of innovation behind it, the MySQL community is entering an important new phase. The focus is on expanding engagement, collaboration, and contributions while increasing and driving innovati [...]

Published Friday, 18. September 2026 17:13 • 4 days ago

“Verify, Measure, and Get Your Hands Dirty”: Two Decades of Database Support with Sveta Smirnova ^{(from MariaDB Foundation Blog)}

pAt Percona Live Amsterdam I caught up with Sveta Smirnova, a world-renowned MySQL expert, author of “MySQL Troubleshooting” and “MySQL Cookbook, 4th Edition”, and a frequent speaker at events from Oracle OpenWorld and FOSDEM to HighLoad. … /p pContinue reading \"“Verify, Measure, and Get Your Hands Dirty”: Two Decades of Database Support with Sveta Smirnov [...]

Published Friday, 18. September 2026 15:44 • 4 days ago

The ideal database for AI agents doesn't exist yet, says Percona CEO ^{(from The Register)}

Iterative workloads caught vendors off guard, but requirements for a clean-slate solution remain unclear [...]

Published Friday, 18. September 2026 12:34 • 4 days ago

MONyog vs Percona PMM ^{(from Webyog Blog)}

pPercona Monitoring and Management is open source. MONyog is not. But when you add up engineering hours, infrastructure overhead and ongoing maintenance, the math changes fast. Percona PMM is genuinely […]/p pThe post MONyog vs Percona PMM appeared first on Webyog./p [...]

Published Friday, 18. September 2026 12:09 • 4 days ago

The architecture of Neki ^{(from PlanetScale Blog)}

Sharded Postgres, from the team behind Vitess [...]

Published Friday, 18. September 2026 00:00 • 5 days ago

Galera Cluster Remains An Integral Part of MariaDB Server ^{(from MariaDB Corporation Blog)}

As we reach the final release of the MySQL version of Galera Cluster, we want to provide clarity around the […] [...]

Published Thursday, 17. September 2026 19:32 • 5 days ago

Why Your AI Agent Doesn’t Actually Remember Anything ^{(from PingCAP Blog)}

pEditor’s note: This post originally appeared on The New Stack and is republished with permission. The original version is available here. A few months ago, I was reviewing a customer support agent who had a strange failure pattern. A user would chat with it on Monday about a billing issue, get partway through the resolution, and […]/p pThe post Why Your AI Agent Doesn’t Actually Remember Any [...]

Published Thursday, 17. September 2026 16:14 • 5 days ago

The database world grew up — notes from Percona Live Amsterdam ^{(from MariaDB Foundation Blog)}

pLast week I spent a few days in Amsterdam at Percona Live. It was the first Percona Live in Europe since before the pandemic, and you could feel it in the room: a slightly disbelieving happiness at simply being together again. … /p pContinue reading \"The database world grew up — notes from Percona Live Amsterdam\"/p pThe database world grew up — notes from Percona Live Amsterdam appeared fi [...]

Published Thursday, 17. September 2026 13:09 • 5 days ago

Using DuckDB inside MySQL ^{(from VillageSQL)}

A duck, a dolphin, and a pelican walk into a bar... [...]

Published Thursday, 17. September 2026 13:00 • 5 days ago

Evaluating LLM models for DBA tasks ^{(from Percona Database Blog)}

p Evaluating LLM Models for DBA Tasks Large language models are increasingly capable of performing practical systems-administration tasks. I wanted to understand how well they could handle something more specialized: database administration. To explore this, I developed a harness for evaluating the ability of different LLMs to execute real DBA tasks on remote systems. My … Continued/p p [...]

Published Thursday, 17. September 2026 11:50 • 5 days ago

Group Replication Beyond a Single Cluster: DC-DR with Percona (PS MySQL) Operator ^{(from Percona Database Blog)}

pA while ago, we discussed the cross-site replication feature of the Percona PXC operator. Recently, a similar cross-site replication feature was introduced in the Percona (PS MySQL) operator v1.2.0, a topology based on Group Replication/InnoDB Cluster. In this blog post, we will explore how to add a DR Cluster to an existing DC Cluster to … Continued/p pThe post Group Replication Beyond a Si [...]

Published Thursday, 17. September 2026 06:43 • 6 days ago

MariaDB 13.0 Is Now Stable ^{(from MariaDB Foundation Blog)}

pMariaDB Server 13.0 is now Stable!br The 13.0 series started its journey in March 2026 with the Preview. It then progressed through the Release Candidate phase and is now ready for general use as MariaDB’s latest Stable rolling release. … /p pContinue reading \"MariaDB 13.0 Is Now Stable\"/p pMariaDB 13.0 Is Now Stable appeared first on MariaDB.org/p [...]

Published Thursday, 17. September 2026 06:30 • 6 days ago

Too many GCache Page Files in MySQL Data Directory ^{(from Percona Database Blog)}

pLearn why PXC accumulates thousands of gcache.page.* files, how frozen GCache purging causes disk growth, and how to safely recover and rejoin using IST./p pThe post Too many GCache Page Files in MySQL Data Directory appeared first on Percona./p [...]

Published Thursday, 17. September 2026 05:29 • 6 days ago

On JSONPath in MariaDB and MySQL ^{(from Sergei Petrunia's blog)}

JSONPath is a part of SQL Standard. MySQL and MariaDB support a subset of it: “lax mode” only, no support for predicates, etc. But even the lax mode implementation has behavior different from the standard: MDEV-40746: JSON Path computation doesn’t do lax mode unboxing. The same non-standard behavior can be observed in MariaDB, MySQL, and […] [...]

Published Wednesday, 16. September 2026 16:06 • 6 days ago

Trying DuckDB for Magento Analytics: An Experiment with One Million Orders ^{(from MariaDB Foundation Blog)}

pMagento normally uses InnoDB for orders, order items, invoices, and other transactional data. However, analytical reports have another workload. I wanted to check whether DuckDB can improve a real Magento report without replacing the operational database. … /p pContinue reading \"Trying DuckDB for Magento Analytics: An Experiment with One Million Orders\"/p pTrying DuckDB for Magento Analyti [...]

Published Wednesday, 16. September 2026 16:00 • 6 days ago

1,000 MCP servers, zero schema bloat? Lessons from Uber's attack on AI costs ^{(from The Stack)}

Tool access architecture is a sweet cost lever, even before you think about model choices... [...]

Published Wednesday, 16. September 2026 13:07 • 6 days ago

MariaDB adoption is growing, and the way people get it is changing – Adoption Index 2026-09 ^{(from MariaDB Foundation Blog)}

pThe MariaDB Adoption Index is up 126% in a year. More people are downloading MariaDB, more people are contributing to it, and more projects are building on it than at any point since we started measuring. … /p pContinue reading \"MariaDB adoption is growing, and the way people get it is changing – Adoption Index 2026-09\"/p pMariaDB adoption is growing, and the way people get it is changing [...]

Published Wednesday, 16. September 2026 11:47 • 6 days ago

Node.js and MySQL Tutorial: Connect, Query, and Pool with mysql2 ^{(from Code For Geek)}

Install the mysql package, point it at MySQL 8, and the handshake dies with ER_NOT_SUPPORTED_AUTH_MODE. I reproduced that against MySQL 8.4.11 and MySQL 9.7.2 before a single query reached either server. mysql2 speaks the same protocol, adds a promise API and prepared statements, and authenticates through caching_sha2_password, the plugin MySQL has used by default since […] [...]

Published Wednesday, 16. September 2026 10:57 • 6 days ago

Vibe Coding a Database Lab: How I Built DBCanvas to Stop Rebuilding the Same Test Environment ^{(from Percona Community Blog)}

Percona gives us room to work on our own AI-assisted projects, and I used mine to fix a problem I kept running into. Every time I wanted to try a new database feature, debug something tricky, or reproduce a customer issue, I ended up rebuilding much of the same infrastructure: DNS, TLS, Docker networking, database topologies, users and test data. Over the years, I wrote scripts to automate this but [...]

Published Wednesday, 16. September 2026 10:31 • 6 days ago

NodeJS MySQL Select Unique ^{(from Code For Geek)}

I ran SELECT UNIQUE age FROM users on a table with a duplicated age. It returned 22, 17 and 15, the same rows SELECT DISTINCT returns. On MySQL 8 that statement stops before the table is read, because UNIQUE never entered the server’s select grammar, and DISTINCT is the modifier both servers accept. Which unique […] [...]

Published Wednesday, 16. September 2026 10:12 • 6 days ago

Implementing GitOps from Infrastructure to DB Operators to Unify Ops for Kubernetes Databases ^{(from Severalnines Blog)}

pMost platform teams already use GitOps for their Kubernetes apps. The config lives in Git, Argo CD applies it, and deployments are predictable. But look one layer down and things get messy. Infrastructure setup is often still done by hand, running Terraform locally or through scattered scripts. Database operations, especially for databases running through Kubernetes […]/p pThe post Implement [...]

Published Wednesday, 16. September 2026 08:57 • 6 days ago

What We Learned From the First MySQL Ecosystem Spotlight ^{(from OurSQL Foundation Blog)}

pQuick test: name five tools in the MySQL ecosystem that are not MySQL itself. Most people stop at two./p pThat’s the real problem. MySQL is everywhere, but a lot of what’s built around it stays inside small circles. You know about it if you’re in the right Slack channel. Nobody else does./p pThat’s why, for our first conference booth, we did something a bit different: we ga [...]

Published Wednesday, 16. September 2026 00:00 • 7 days ago

Announcing MariaDB Community Server 13.0 GA ^{(from MariaDB Corporation Blog)}

MariaDB Community Server 13.0 GA deepens Oracle PL/SQL compatibility with REF CURSORs and RECORD types, gives developers UPDATE…RETURNING, expands manageability […] [...]

Published Tuesday, 15. September 2026 22:43 • 7 days ago

Vector search in MySQL: an early look at HNSW and custom indexes in VillageSQL ^{(from VillageSQL)}

An early look at custom indexes and vector search in MySQL (VillageSQL): HNSW index, 20x faster than a full scan, with recall measured. [...]

Published Tuesday, 15. September 2026 17:20 • 7 days ago

MariaDB Enterprise Server 12.3 Beta: Conflict-Aware Replication, Raft-Based Cluster, and Passwordless TLS Authentication ^{(from MariaDB Corporation Blog)}

MariaDB Enterprise Server 12.3.3-0 ES BETA is now available for testing, the first beta build of the upcoming MariaDB Enterprise […] [...]

Published Tuesday, 15. September 2026 17:03 • 7 days ago

Node.js MySQL Insert Record ^{(from Code For Geek)}

I pointed a Node script at a MySQL table and the connection succeeded. The INSERT failed on a name containing an apostrophe. Pasting values into the SQL string holds until real data arrives, then a name like O’Brien ends the run with a syntax error. Placeholders are the fix, and the driver escapes every value […] [...]

Published Tuesday, 15. September 2026 16:07 • 7 days ago

NodeJS MySQL Select Record ^{(from Code For Geek)}

RowDataPacket is the name MySQL hands back to Node.js, and it is the line most readers get stuck on. This is the select step end to end, from a running MySQL server to a callback whose rows you can read. What you need to run MySQL SELECT queries in NodeJS Three things, in dependency order. […] [...]

Published Tuesday, 15. September 2026 16:02 • 7 days ago

Performance improvements in Percona Server 8.4.11-11 ^{(from Percona Database Blog)}

pFocusing on Percona Server 8.4.11-11 My previous post (Performance Progression of Percona Server for MySQL 8.4) did a brief review of the performance changes in Percona Server for MySQL 8.4 released in 2026. I recommend reading it first to better understand the material in this post. Version 8.4.11-11 includes patches that deliver significant improvements in … Continued/p pThe post Performan [...]

Published Tuesday, 15. September 2026 11:52 • 7 days ago

Home and Pricing Page Redesign ^{(from DoltHub Blog)}

DoltHub is the version-controlled database company, and our new homepage and pricing page reflect that shift. [...]

Published Tuesday, 15. September 2026 00:00 • 8 days ago

Percona and HexaCluster: Faster, Safer Oracle Migration ^{(from Percona Database Blog)}

pPercona and HexaCluster have partnered to remove the hardest part of an open source database migration: getting off Oracle, SQL Server, DB2 or Sybase ASE with confidence, on a predictable timeline, without a multi-year consulting program. Percona brings open source expertise, its own distributions, operators and enterprise support. HexaCluster brings the assessment and migration engineering … [...]

Published Monday, 14. September 2026 22:19 • 8 days ago

AWS renews Diamond sponsorship of MariaDB Foundation for a fourth consecutive year ^{(from MariaDB Foundation Blog)}

pMariaDB Foundation is pleased to announce that Amazon Web Services (AWS) has renewed its Diamond sponsorship for a fourth consecutive year. … /p pContinue reading \"AWS renews Diamond sponsorship of MariaDB Foundation for a fourth consecutive year\"/p pAWS renews Diamond sponsorship of MariaDB Foundation for a fourth consecutive year appeared first on MariaDB.org/p [...]

Published Monday, 14. September 2026 16:35 • 8 days ago

AI Coding Agent Files Explained: How Persistent Workspaces Survive Resets ^{(from PingCAP Blog)}

pAn agent clones a repo, installs dependencies, reproduces a failing test, and gets three-quarters of the way through a fix. The sandbox hits its duration limit. The next run starts in an empty directory with the same task, the same prompt, and none of the evidence. Nothing crashed and nothing errored. The work was never […]/p pThe post AI Coding Agent Files Explained: How Persistent Workspac [...]

Published Monday, 14. September 2026 14:57 • 8 days ago

MySQL INSTANT DDL breaks EXCHANGE PARTITION ^{(from Kedar MySQL Blog)}

pMySQL ERROR 1731 'Non matching attribute INSTANT COLUMN(s)' breaks EXCHANGE PARTITION after ALGORITHM=INSTANT. This blog offers reasoning and fixtures./p The post MySQL INSTANT DDL breaks EXCHANGE PARTITION first appeared on Change Is Inevitable. [...]

Published Monday, 14. September 2026 13:36 • 8 days ago

Diagnosing MySQL Memory Problems with Jemalloc ^{(from Libing Song's Blog)}

This article is also available in Chinese: 中文版. Browse all English articles. Memory leaks and high memory usage are common problems in MySQL, and diagnosing them depends heavily on good memory-monitoring data. MySQL’s Performance Schema provides memory monitoring, but the granularity of PFS’s memory statistics is coarse, which makes it hard to pinpoint the exact code responsible. The figure above.. [...]

Published Wednesday, 08. April 2026 02:00 • 6 months ago | Updated Monday, 14. September 2026 11:24 • 8 days ago

Percona releases Galera Cluster Version 9.7 ^{(from Shinguz's Blog)}

pFinally, some good news again!/p What has happened so far pAfter MariaDB Corp. acquired Codership OY—and with it, Galera Cluster for MySQL—in May 2025 [ 1 ], then announced the discontinuation of support for Galera Cluster for MySQL 8.4 at the end of September 2026 [ 2 ], and subsequently stated that it would no longer support Galera Cluster (for MariaDB!) in the Community Edition [ 3 ], there was [...]

Published Monday, 14. September 2026 09:33 • 8 days ago

Optimising Multi-Range Queries with Logical Charts ^{(from Vettabase)}

Regular database indexes cannot be used for queries that contain conditions based on two or more ranges. But there are unconventional ways to solve this problem and make queries faster. In this post we’ll explore a conceptually simple way: logical charts. The Problem Suppose we need to find the customers in a certain age band who made a certain number of orders in the last 12 months. We have [...]

Published Monday, 14. September 2026 09:12 • 8 days ago

Continuing the ProxySQL.Cloud Conversation After Percona Live Amsterdam ^{(from ProxySQL Blog)}

Thank you to everyone who explored ProxySQL.Cloud with us in Amsterdam. Here is a closer look at the operational problems the platform is designed to solve and how to stay involved. [...]

Published Monday, 14. September 2026 00:00 • 9 days ago

NodeJS MySQL Drop Table ^{(from Code For Geek)}

DROP TABLE crashed my Node process when I re-ran it without a guard, and the fix turns that crash into a warning. I built every code path below on Node 26.7.0 with mysql 2.18.1 and mysql2 3.24.4 against MariaDB 10.11.14. I captured the terminal output as images so what you run matches what I saw. […] [...]

Published Sunday, 13. September 2026 14:07 • 9 days ago

NodeJS MySQL Create Table ^{(from Code For Geek)}

I ran node app.js once and the users table appeared, then I ran it again and MySQL returned Table users already exists. If you copy the Node.js MySQL create table snippet from an older tutorial you expect it to be safe to rerun because the code looks like any other setup script, so the duplicate […] [...]

Published Sunday, 13. September 2026 11:10 • 9 days ago

NodeJS MySQL Create Database ^{(from Code For Geek)}

Node.js can create a MySQL database with one query, but the connection that runs it has to be set up without naming a database first. I hit ER_DB_CREATE_EXISTS on the next run because my first draft skipped IF NOT EXISTS, which means the same script blows up the moment you re-run it. The safe path […] [...]

Published Sunday, 13. September 2026 10:08 • 9 days ago

Thank You for Connecting with ProxySQL at Percona Live Amsterdam 2026 ^{(from ProxySQL Blog)}

Thank you to everyone who met the ProxySQL team in Amsterdam. Continue the conversation with resources for ProxySQL.Cloud, MySQL, PostgreSQL, high availability, routing, and observability. [...]

Published Sunday, 13. September 2026 00:00 • 10 days ago

MySQL Workbench 26.7で試してほしい5つのこと ^{(from The Oracle MySQL Blog)}

本記事は、Five Things to Try in MySQL Workbench 26.7の日本語訳です。 MySQL Workbench 26.7では、最新のテクノロジーとMySQL Shellを基盤として構築した、新世代のMySQL Workbenchを導入しました。 Alfredo Kojimaによるブログ「MySQL Workbench 26のご紹介」では、新しいアーキテクチャと今回のリリースで利用できる機能について分かりやすく紹介しています。ここではその内容を繰り返すのではなく、Workbench 26.7をインストールしたら、ぜひ試していただきたい機能をいくつか紹介します。すぐに確認できるものもあれば、新しいインターフェースを使い込んでいくうちに初めて気付くような機能もあります。 1. Notebookを使う、またはSQL Scriptを使い続ける SQL Notebook [...]

Published Saturday, 12. September 2026 17:40 • 10 days ago

Runtime: Orchid Security wants to kill your agents ^{(from The Stack)}

+ Jira gets loopy, OpenAI's new data tool, and Qodo unleashes VAR for code. [...]

Published Saturday, 12. September 2026 15:00 • 10 days ago

NodeJS MySQL Create Connection ^{(from Code For Geek)}

I rebuilt this MySQL connection from scratch on Node 26 with mysql2 3.24.4 because the old page still taught the unmaintained mysql package. It left every error to a throw that crashes your process. I ran each snippet below against a local MariaDB 10.11 on 3306, so every ER_ACCESS_DENIED_ERROR you see came from a run […] [...]

Published Saturday, 12. September 2026 14:05 • 10 days ago

Node.js and MySQL Connection Pool Example ^{(from Code For Geek)}

I threw a per-request MySQL connection into a small Node API and watched it limp under concurrent load, so I rebuilt it with a mysql2 pool and kept the receipts. I created the pool with createPool on Node v26.7.0 and mysql2 3.24.4, ran pool.query and pool.getConnection against a local host, and got ER_ACCESS_DENIED_NO_PASSWORD_ERROR back because […] [...]

Published Saturday, 12. September 2026 11:06 • 10 days ago

Dynamic Data Masking in Percona Server for MySQL: Setup & Best Practices ^{(from Mydbops Blog)}

Learn how to implement Dynamic Data Masking in Percona Server for MySQL using masking components, secure views, and in-memory dictionary caching in 8.4.4. [...]

Published Friday, 11. September 2026 18:16 • 11 days ago

Five Things to Try in MySQL Workbench 26.7 ^{(from The Oracle MySQL Blog)}

With MySQL Workbench 26.7, we introduced a new generation of MySQL Workbench, built on updated technology and on the MySQL Shell foundation. Alfredo Kojima’s post, Introducing MySQL Workbench 26, provides a great overview of the new architecture and the capabilities available in this release. Rather than repeat that overview, I wanted to share a few things […] [...]

Published Friday, 11. September 2026 17:40 • 11 days ago

Synchronize MySQL and IndexedDB in an Offline-First App ^{(from Code For Geek)}

When you build an offline-first app, the question is what happens to a change while there is no network. The answer is a queue that writes to IndexedDB first, pushes to MySQL, and clears the local copy only after the server confirms. The library versions behind that run are Express 5.2.1 and mysql2 3.24.4, both […] [...]

Published Friday, 11. September 2026 11:20 • 11 days ago

Ajax in Node.js: How to Build a Live Search Feature ^{(from Code For Geek)}

Adding live search to a Node.js and MySQL app takes a query, an endpoint, and a little front-end code. The last step is a search box that filters the table as you type. Express 5.2.1, mysql2 3.24.4 and MariaDB 10.11 served that run, and the row counts come from EXPLAIN rather than a stopwatch. Load […] [...]

Published Friday, 11. September 2026 11:20 • 11 days ago

MySQL Community Meetups Fall 2026 ^{(from The Oracle MySQL Blog)}

In our recent Where can you find MySQL from August through October 2026?, we shared a broad view of MySQL conferences, community activities, and user group meetups. Since then, community gatherings in Denver, Taipei, and Nashville have brought MySQL users, developers, and contributors together for technical discussion and local connection. We are continuing that momentum […] [...]

Published Friday, 11. September 2026 10:22 • 11 days ago

Postgres follows the SQL standard for UPDATE statements, unlike MySQL ^{(from DoltHub Blog)}

Learn how Dolt and Doltgres support different SQL behavior on a shared engine using a new engine extension point [...]

Published Friday, 11. September 2026 00:00 • 12 days ago

1 month, 5 outages: Databases are under massive strain at GitHub ^{(from The Stack)}

Peak cache CPU utilisation for GitHub Actions trimmed, temporarily, from a worrying 98% to 80%, MySQL DBs moving to Azure... [...]

Published Thursday, 10. September 2026 15:56 • 12 days ago

MySQL & Friends: Distributed Databases@SCaLE ^{(from Dave's MySQL Stuff)}

pThe 24th Annual Southern California Linux Expo – SCaLE 24x – to be held April 1-4, 2027 at the Pasadena Convention Center in Pasadena, California, near Los Angeles./ppWe invite you to share your work on FOSS programs and open hardware projects with the rest of the community and to exchange ideas with leading experts in these fields./ppThis year, the traditional MySQL track is expanding to include [...]

Published Thursday, 10. September 2026 13:27 • 12 days ago

MONyog vs SolarWinds ^{(from Webyog Blog)}

pThe MySQL monitoring tool built for DBAs — not multi-database budgets. SolarWinds treats MySQL as one entry on a menu of eight databases. MONyog exists for one reason: keeping MySQL […]/p pThe post MONyog vs SolarWinds appeared first on Webyog./p [...]

Published Thursday, 10. September 2026 12:16 • 12 days ago

The Perfect Serve: What Tennis Taught Me About Reading PMM Like a Coach Instead of Guessing ^{(from Percona Community Blog)}

When I started learning tennis as an adult, I realized that what made tennis difficult was not learning the tennis strokes, instead it was learning to realize the value of the feedback loop: racket vibrations, tennis ball sounds, and the way my balance shifted before I even realized it. None of this information is obvious on the court. However, without it I would continue to make the same significa [...]

Published Thursday, 10. September 2026 12:00 • 12 days ago

Introducing Neki ^{(from PlanetScale Blog)}

Neki, sharded Postgres by PlanetScale, is now available in platform preview. [...]

Published Thursday, 10. September 2026 12:00 • 12 days ago

Introducing MySQL Workbench 26 ^{(from The Oracle MySQL Blog)}

The MySQL team at Oracle is excited to announce MySQL Workbench 26.7, the first of a new generation of the GUI administration and development tool for MySQL. A New Workbench MySQL Workbench 8 has served the community well, but it’s now old and has reached end of life. Its architecture, built on C++ and platform […] [...]

Published Thursday, 10. September 2026 10:20 • 12 days ago

How to setup and use Percona Binlog Server (PBS) ^{(from Kedar MySQL Blog)}

pEarlier last week I was working with Percona Binlog Server, Percona’s tool for archiving the MySQL binary log (binlog) outside of a traditional replica and exploring what it can do.…/p The post How to setup and use Percona Binlog Server (PBS) first appeared on Change Is Inevitable. [...]

Published Thursday, 10. September 2026 08:14 • 13 days ago

GitHub availability report: August 2026 ^{(from The GitHub Blog)}

pIn August, we experienced five incidents that resulted in degraded performance across GitHub services./p pThe post GitHub availability report: August 2026 appeared first on The GitHub Blog./p [...]

Published Thursday, 10. September 2026 02:05 • 13 days ago

Enabling TLS in PXC without Downtime ^{(from Percona Database Blog)}

pStarting with Percona XtraDB Cluster (PXC) 8.0, replication traffic encryption is enabled by default. That said, it’s common to find clusters running without TLS that suddenly need it: a new compliance requirement, an audit finding, a network segment that is no longer considered trusted. PXC has a variable for exactly that case, pxc-encrypt-cluster-traffic, which handles … Continued/p [...]

Published Wednesday, 09. September 2026 23:32 • 13 days ago

Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging ^{(from Percona Database Blog)}

pPercona Operator for PostgreSQL 3.1.0 takes on three things that decide whether a PostgreSQL platform passes review: is the data encrypted at rest, can it serve reads without straining the primary, and are the logs there when you need them. This release answers all three inside the custom resource, so none of them is a … Continued/p pThe post Percona Operator for PostgreSQL 3.1.0: Transparen [...]

Published Wednesday, 09. September 2026 16:08 • 13 days ago

Meet pgstef: Why Stefan Fercot Joined Percona, and Why You Should Find Him at Percona Live Amsterdam ^{(from Percona Database Blog)}

pIf you have spent any time in the Postgres community, you already know the name pgstef. Stefan Fercot has spent years as one of the most visible advocates for pgBackRest, a familiar face at European Postgres conferences, and countless hallway conversations about backups, high availability, and everything in between. Now he is doing that work … Continued/p pThe post Meet pgstef: Why Stefan Fe [...]

Published Wednesday, 09. September 2026 15:55 • 13 days ago

HTML5 Push Notification System Using Nodejs MySQL Socket.io ^{(from Code For Geek)}

Post a comment in one browser and watch it appear in a second browser in the same second, with a desktop notification on top. That is the whole project. You build it with Express, a MySQL database, and Socket.IO broadcast, and every sample below ran on current releases before publication. I ran the rebuilt stack […] [...]

Published Wednesday, 09. September 2026 09:18 • 13 days ago

Best Practices for AI-Assisted App Development: Reviewing AI-Generated Code for Production ^{(from PingCAP Blog)}

pThis article shows how to efficiently develop high-quality applications with TiDB, an open-source NewSQL database that supports Hybrid Transactional and Analytical Processing (HTAP) workloads and can serve as a scale-out MySQL database without manual sharding./p pThe post Best Practices for AI-Assisted App Development: Reviewing AI-Generated Code for Production appeared first on TiDB./p [...]

Published Wednesday, 09. September 2026 07:00 • 14 days ago

Enabling OCI Log Analytics for MySQL HeatWave – Now available for MySQL 8.4 ^{(from The Oracle MySQL Blog)}

MySQL HeatWave telemetry is the built-in capability for exporting selected MySQL server logs to an observability destination. When telemetry is configured with OCI Log Analytics, it export MySQL log natively for search and analysis – supporting security investigations, database and operational errors troubleshooting, identification of costly SQL and performance bottlenecks, and centralized au [...]

Published Tuesday, 08. September 2026 20:09 • 14 days ago

Amazon RDS for MariaDB now supports community MariaDB minor versions 10.6.28, 10.11.19, 11.4.13, 11.8.9, and 12.3.3 ^{(from AWS What's New)}

pStarting today, Amazon Relational Database Service (Amazon RDS) for MariaDB now supports MariaDB minor versions 10.6.28, 10.11.19, 11.4.13, 11.8.9, and 12.3.3, the latest minors released by community MariaDB. In addition to operational improvements, these minor versions introduce support for post-quantum TLS (PQ-TLS) key exchange, providing you with post-quantum cryptography options for encry [...]

Published Tuesday, 08. September 2026 16:00 • 14 days ago

Automating MySQL HeatWave Maintenance with the OCI Command Line Interface (CLI) ^{(from The Oracle MySQL Blog)}

Manage recurring maintenance windows, defer disruptive maintenance, and audit maintenance activity with a reusable Bash utility. MySQL HeatWave on Oracle Cloud Infrastructure gives administrators control over when scheduled maintenance can occur and, with maintenance-disabled windows, the ability to temporarily defer non-critical maintenance that would cause downtime. That flexibility is useful whe [...]

Published Tuesday, 08. September 2026 15:26 • 14 days ago

RavenDB brings AI agents to existing SQL databases with Quill ^{(from Techzine)}

RavenDB introduces Quill, a context layer that sits on top of existing PostgreSQL, SQL Server, and MySQL databases. This lets organizations deploy AI agents in production without migrating their system of record or building a complete AI stack. RavenDB, a NoSQL document database, aims to address a problem many IT departments now face with Quill. […] [...]

Published Tuesday, 08. September 2026 13:00 • 14 days ago

Advanced Cryptography in MySQL with vsql-crypto ^{(from VillageSQL)}

Advanced cryptography for MySQL (VillageSQL): salted password hashing, HMAC signatures, AES encryption with random IVs, and secure random IDs. [...]

Published Tuesday, 08. September 2026 11:48 • 14 days ago

MariaDB’s Database Survey 2026 ^{(from ODBMS.org)}

How are developers and organisations really using databases — and MariaDB? Take our survey and help shape this year’s public report. The survey is anonymous and should take 8 minutes or less to finish. Results will... [...]

Published Tuesday, 08. September 2026 09:27 • 14 days ago

MariaDB Enterprise Server Maintenance Releases ^{(from MariaDB Corporation Blog)}

New security maintenance releases for MariaDB Enterprise Server: 11.8.9-6, 11.4.13-10, and 10.6.28-24 are now available. While these releases were originally […] [...]

Published Monday, 07. September 2026 17:50 • 15 days ago

DB Trail World Tour – Sept 2026 ^{(from dbtrail Blog)}

pAmsterdam, The Netherlands: perconalive.com/2026-amsterdam/talks/mysql-time-travel-practical-row-level-recovery-with-open-source-tools Montevideo, Uruguay: percona.university/event/percona-university-montevideo-uruguay/ Buenos Aires, Argentina: nerdearla.com/en/argentina/schedule/poor-mans-lakehouse-analytics-historicas-y-recovery-sobre-mysql-con-duckdb-parquet/ Sao Paulo, Brasil: mysqlbrconf.com. [...]

Published Monday, 07. September 2026 12:09 • 15 days ago

Dealing with caching_sha2_password in MariaDB Server – Part 2: Migrating Users from MySQL with pt-show-grants ^{(from lefred's blog)}

In the first part of this article, I explained how MariaDB Server can authenticate users using caching_sha2_password, and more importantly, how it is possible to migrate an existing MySQL user to MariaDB while keeping the same password. The solution works, but there is one obvious problem: it is mostly a manual process. For one user, […] [...]

Published Monday, 07. September 2026 11:16 • 15 days ago

ProxySQL HA with BGP ECMP Anycast ^{(from Percona Community Blog)}

When setting up a new database for an application, high availability (HA) is one of the main priorities. Let’s assume for this example that you chose to use a Percona XtraDB (PXC) cluster to host your database. But how does the application know which PXC node is healthy and can receive application traffic? Introducing a cluster of ProxySQLs can solve this problem, as ProxySQL will healthcheck the d [...]

Published Monday, 07. September 2026 11:00 • 15 days ago

Rethinking PAM ^{(from MariaDB Foundation Blog)}

pPAM, Pluggable Authentication Modules, originated in Solaris and became common place in all Linux, BSDs, and AIX, HP-UX and macOS. MariaDB has had PAM support as an option since MariaDB 5.2.10 becoming stable in 10.0.11. … /p pContinue reading \"Rethinking PAM\"/p pRethinking PAM appeared first on MariaDB.org/p [...]

Published Monday, 07. September 2026 06:59 • 16 days ago

Something restarts my MySQL every morning. It isn’t MySQL. ^{(from Another Boring Tech Blog)}

pThe alert fires at 06:37 and by the time anyone opens a laptop the database is back. The application log holds a wall of Lost connection to MySQL server during query, uptime says 41 days, and the error log records a clean shutdown: no crash, no signal, no out-of-memory kill. The next morning it happens at 06:12, and […]/p pO post Something restarts my MySQL every morning. It isn’t MySQ [...]

Published Sunday, 06. September 2026 21:32 • 16 days ago

Meet ProxySQL at Percona Live 2026 Amsterdam ^{(from ProxySQL Blog)}

ProxySQL is sponsoring Percona Live 2026 Amsterdam. Visit our booth September 9–11 to meet the team, preview ProxySQL.Cloud, and talk MySQL and PostgreSQL operations. [...]

Published Sunday, 06. September 2026 00:00 • 17 days ago

From a Chocolate Wrapper to Concurrent InnoDB Page Splits ^{(from MariaDB Foundation Blog)}

pThis work started from a conversation with Monty Widenius at Meet Magento Czech in August. We discussed possible ways to improve the scalability of the InnoDB B+Tree, especially its insert path and page splits. … /p pContinue reading \"From a Chocolate Wrapper to Concurrent InnoDB Page Splits\"/p pFrom a Chocolate Wrapper to Concurrent InnoDB Page Splits appeared first on MariaDB.org/p [...]

Published Saturday, 05. September 2026 20:24 • 17 days ago

Database branching explained: How it works and when to use it ^{(from Devart MySQL Tool Blog)}

pYour application code branches in seconds. Your database still gets copied, shared, and fought over. Here is how database branching closes that gap, where it breaks down, and what has to sit around it before it makes releases safer./p pThe post Database branching explained: How it works and when to use it appeared first on Devart Blog./p [...]

Published Saturday, 05. September 2026 16:56 • 17 days ago

Announcing ProxySQL 3.0.11, 3.1.11, and 4.0.11 ^{(from ProxySQL Blog)}

ProxySQL 3.0.11, 3.1.11, and 4.0.11 improve multiplexing, causal reads, modern authentication, FFTO and TSDB reliability, and MCP/GenAI operations. [...]

Published Saturday, 05. September 2026 00:00 • 18 days ago

MySQL 26.7 and the Power of Community Contribution ^{(from The Oracle MySQL Blog)}

As we have discussed through the new MySQL Community Engagement initiative, we are sharing metrics that highlight how the community contributes to MySQL. These measures help us understand the growth of community participation, recognize the people helping improve the product, and identify where we can continue to strengthen the contributor experience. The MySQL community delivered […] [...]

Published Friday, 04. September 2026 16:43 • 18 days ago

Launching MariaDB’s Database Survey 2026 ^{(from MariaDB Foundation Blog)}

pWe want to know how you’re really using MariaDB — and databases in general. Not the marketing version or the one-off case study. The real story: what you’re building, how you are using it, what’s working, and what’s frustrating. … /p pContinue reading \"Launching MariaDB’s Database Survey 2026\"/p pLaunching MariaDB’s Database Survey 2026 appeared fi [...]

Published Friday, 04. September 2026 10:03 • 18 days ago

MariaDB Plugins Beyond C++: What the Community Told Us ^{(from MariaDB Foundation Blog)}

pA few weeks ago, we asked a simple question:br Which language would you use to write MariaDB plugins?br The question related to MDEV-40189 (Support plugins written in various languages), an idea we introduced earlier this summer to lower the barrier to MariaDB plugin development by supporting languages other than C and C++. … /p pContinue reading \"MariaDB Plugins Beyond C++: What the Commun [...]

Published Friday, 04. September 2026 09:56 • 18 days ago

Serverless MySQL for AI Agents: Store Memory, Tool Outputs, and Searchable State in One Backend ^{(from PingCAP Blog)}

pMySQL AI, in the sense that matters most to application teams, means MySQL-compatible infrastructure that holds agent memory, tool outputs, embeddings, and persistent application state in one backend, with vector search and SQL available in the same query. Serverless MySQL for AI agents is that backend delivered as an auto-scaling service rather than a cluster […]/p pThe post Serverless MySQ [...]

Published Thursday, 03. September 2026 21:05 • 19 days ago

OAuth2 and JWT Logins for MySQL ^{(from VillageSQL)}

MySQL logins without passwords: vsql-oauth2 lets accounts authenticate with OAuth2/OIDC JWTs and map their roles onto database roles. [...]

Published Thursday, 03. September 2026 17:37 • 19 days ago

Troubleshoot AWS Advanced JDBC Wrapper configuration for Aurora Global Database write forwarding ^{(from AWS Database Blog)}

Configuring the AWS Advanced JDBC Wrapper for Amazon Aurora Global Database with write forwarding requires Region-specific settings, and misconfiguration causes latency spikes and connection failures. This post walks through the correct dialect, plugins, host patterns, and write forwarding settings for the primary and secondary Regions. [...]

Published Thursday, 03. September 2026 16:26 • 19 days ago

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

pStarting today, Amazon Aurora MySQL-Compatible Edition 8.4 will support MySQL 8.4.8. In addition to several security enhancements and bug fixes, Aurora MySQL 8.4.8 includes several improvements, such as support for post-quantum TLS (PQ-TLS) key exchange, transaction timeout, multi-source replication, and delayed replication. PQ-TLS provides you with post-quantum cryptography options for encrypting [...]

Published Thursday, 03. September 2026 16:01 • 19 days ago

Amazon Aurora MySQL now supports multi-source replication and delayed replication ^{(from AWS What's New)}

pStarting today, Amazon Aurora MySQL supports two new replication capabilities: multi-source replication and delayed replication. Multi-source replication lets a single Aurora MySQL cluster replicate from multiple source databases at the same time, making it easier to consolidate data from separate MySQL databases. This enables critical use-cases, such as merging shards or aggregating data from sep [...]

Published Thursday, 03. September 2026 16:00 • 19 days ago

MariaDB R2DBC Connector 1.4.2 now available ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/R2DBC 1.4.2 GA release. Download Now Release Notes MariaDB […] [...]

Published Thursday, 03. September 2026 14:06 • 19 days ago

MariaDB Connector/C Compatibility: An Update on CONC-821 ^{(from MariaDB Foundation Blog)}

pAs a DBA, there are some surprises I enjoy. Discovering a useful feature is one of them. Discovering that an application behaves differently after a maintenance update is considerably further down the list. … /p pContinue reading \"MariaDB Connector/C Compatibility: An Update on CONC-821\"/p pMariaDB Connector/C Compatibility: An Update on CONC-821 appeared first on MariaDB.org/p [...]

Published Thursday, 03. September 2026 12:02 • 19 days ago

Improving container security in your CI/CD pipeline ^{(from Ronald Bradford Blog)}

At PyCon AU 2026 , the presentation Your Python container is 90% stuff you didn’t ask for by Scott Norris at Chainguard really exposed the impact of being lazy in container management for security purposes. [...]

Published Thursday, 03. September 2026 00:00 • 20 days ago

MySQL 26.7 and 9.7 LTS: 7 Powerful Features for Performance, Scalability and High Availability ^{(from MinervaDB Blog)}

MySQL 26.7 is the first release Oracle has shipped under calendar versioning, and it landed on 28 July 2026 together with MySQL 9.7.2 LTS and MySQL 8.4.11 LTS. Most of the coverage so far has [...] [...]

Published Wednesday, 02. September 2026 19:07 • 20 days ago

[In development] Private Preview: Reader Endpoint for Azure Database for MySQL ^{(from Azure Updates)}

We’re happy to announce the public preview of reader endpoint support to simplify connection management when using multiple replicas in Azure Database for MySQL - Flexible Server. A reader endpoint enables automatic load balancing of read-only connection [...]

Published Wednesday, 02. September 2026 16:59 • 20 days ago

On how MySQL implements JSON ARRAY indexing ^{(from Sergei Petrunia's blog)}

Me and Yuchen Pei have been studying how JSON ARRAY indexing is done in MySQL. The details are posted here: MDEV-40822. Yuchen has discovered cases where using ARRAY index for reads causes different query results from the same query not using the index. Looks like a bug (or maybe two). Sometimes one has to choose […] [...]

Published Wednesday, 02. September 2026 11:04 • 20 days ago

OpenID Connect Authentication for MySQL, Now Fully Open Source ^{(from Percona Database Blog)}

pPercona Server for MySQL now ships with a fully open source OpenID Connect (OIDC) authentication plugin, available starting with Percona Server for MySQL 8.4.11-11 and 9.7.2-2 (not yet released as of this writing). It allows a MySQL account to authenticate against any standards-compliant Identity Provider (IdP) instead of relying on a locally stored password, closing … Continued/p pThe post [...]

Published Wednesday, 02. September 2026 08:56 • 20 days ago

MariaDB/MySQL Environment MyEnv 3.0.1 has been released ^{(from Shinguz's Blog)}

pFromDual has the pleasure to announce the release of the new version 3.0.1 of its popular MariaDB, MySQL and PostgreSQL multi-instance environment MyEnv./p pThe new MyEnv can be downloaded here. How to install MyEnv is described in the MyEnv Installation Guide./p pIn the inconceivable case that you find a bug in the MyEnv please report it to our public repository on Codeberg./p pAny feedback, stat [...]

Published Wednesday, 02. September 2026 07:51 • 21 days ago

Introducing the OurSQL Foundation ^{(from OurSQL Foundation Blog)}

pEarlier this year, we held two MySQL Summits where we discussed concerns that the MySQL ecosystem has stalled and that MySQL is no longer the automatic first choice for new projects./p pDespite these concerns, we recognize that MySQL remains widely deployed in production and is still an excellent database for building a business./p pWe believe this slow growth stems from the lack of a neutral part [...]

Published Wednesday, 02. September 2026 00:00 • 21 days ago

What is a Serverless Database and Why It Matters for Modern AI Apps ^{(from PingCAP Blog)}

pA serverless database is a cloud database that decouples compute from storage, scales capacity automatically as demand changes, and bills for what a workload actually consumes. Servers still exist. The difference is that you never size them, patch them, or pay for idle ones, and capacity planning stops being a launch-day decision. That difference matters […]/p pThe post What is a Serverless [...]

Published Tuesday, 01. September 2026 20:10 • 21 days ago

MariaDB 12.3 InnoDB-Accelerated Binary Logging: Delivering 1.50x Higher Throughput ^{(from MariaDB Corporation Blog)}

What Is the MariaDB Binary Log Bottleneck and How Does InnoDB-Based Logging Solve It? In modern high-performance database infrastructure, the […] [...]

Published Tuesday, 01. September 2026 18:12 • 21 days ago

VMware Explore: Broadcom touts faster "metal to model”, partnerships, hardened container images ^{(from The Stack)}

Bare metal provisioning for multiple vendors, done via VCF in minutes? [...]

Published Tuesday, 01. September 2026 14:30 • 21 days ago

MariaDB Foundation Newsletter – September 2026 ^{(from MariaDB Foundation Blog)}

pAugust belonged to transparency: MariaDB published its governance framework, and the first contribution statistics report in over a year put numbers on who actually builds the server. … /p pContinue reading \"MariaDB Foundation Newsletter – September 2026\"/p pMariaDB Foundation Newsletter – September 2026 appeared first on MariaDB.org/p [...]

Published Tuesday, 01. September 2026 11:30 • 21 days ago

Guide to replica_allow_higher_version_source in MySQL ^{(from Mydbops Blog)}

Prevent silent replication breakage during MySQL upgrades using the replica_allow_higher_version_source system variable. [...]

Published Tuesday, 01. September 2026 11:24 • 21 days ago

Remote DBA Services for Online Gaming Platforms 2026 ^{(from Mydbops Blog)}

Compare remote DBA services for online gaming platforms in 2026: MySQL InnoDB Cluster, MongoDB, PostgreSQL and TiDB, with PCI-DSS and 24/7 coverage checks. [...]

Published Tuesday, 01. September 2026 10:09 • 21 days ago

Java and MySQL Connectivity Using JDBC ^{(from Code For Geek)}

Java Database Connectivity (JDBC) gives a Java program a standard API for opening a MySQL connection, sending SQL, and reading rows. The work starts with a compatible MySQL driver, a complete JDBC URL, and an account that can reach only the database your program needs. I compiled the example below with Maven resolving MySQL Connector/J […] [...]

Published Tuesday, 01. September 2026 08:19 • 22 days ago

Recovering PostgreSQL Data When Blocks Are Corrupted ^{(from Shinguz's Blog)}

pAs part of our work on “PostgreSQL for Dolphins and Sea Lions,” I also enjoy reading the PostgreSQL mailing lists to see what kinds of problems come up and how they’re solved./p pOne email in particular caught my attention:/p blockquote pI’m unable to access one of the tables. Even a simple codeSELECT/code statement fails with the error below./p precodeprod=# SELECT count(*) FROM schema.tabl [...]

Published Tuesday, 01. September 2026 08:12 • 22 days ago

Announcing ProxySQL.Cloud ^{(from ProxySQL Blog)}

A new SaaS platform to manage and monitor your MySQL and PostgreSQL environments from one control plane. Previewing at Percona Live 2026 Amsterdam. [...]

Published Tuesday, 01. September 2026 00:00 • 22 days ago

Managed Database Services for SaaS Startups: 2026 Guide ^{(from Mydbops Blog)}

Compare managed database services for SaaS startups across MySQL, PostgreSQL, MongoDB, MariaDB and TiDB, with 24/7 DBA coverage and compliance checks. [...]

Published Monday, 31. August 2026 17:37 • 22 days ago

How I Built a SQL Diagnostic Tool That Works Without Touching Your Database ^{(from DZone)}

pMost developers I've worked with write SQL every day. Very few of them are DBAs. According to the 2024 Stack Overflow Developer Survey — 65,000 developers across 185 countries — database administrators make up just 0.3% of the developer population. The tools built for SQL performance were designed for that 0.3%. I built QueryTuner for everyone else./p pI've spent 13 years as an application archite [...]

Published Monday, 31. August 2026 15:00 • 22 days ago

MariaDB at Percona Live Amsterdam 2026: Ecosystem, Plugins, Security, and Community ^{(from MariaDB Foundation Blog)}

pMariaDB is heading to Percona Live Amsterdam 2026! Join us for sessions on server plugins, protocol security and ecosystem building, hear independent MariaDB experiences, meet Percona\'s new General Manager for MariaDB, and visit the MariaDB booth for demos and discussions with our engineers./p pMariaDB at Percona Live Amsterdam 2026: Ecosystem, Plugins, Security, and Community appeared first on M [...]

Published Monday, 31. August 2026 10:21 • 22 days ago

MariaDB Server – See What Changed Between Versions ^{(from lefred's blog)}

As a DBA, comparing Database Server versions is an important part of preparing an upgrade. You need to know which server options were added or removed, which defaults changed, and what else is different between the versions you are running and the versions you plan to deploy. When I worked with MySQL, I used a […] [...]

Published Monday, 31. August 2026 07:30 • 23 days ago

Install MySQL on macOS with Homebrew ^{(from Code For Geek)}

Homebrew gives you the shortest path to a local MySQL server on macOS, but an install command alone does not prove that the server is running or that the client can connect. I checked the Homebrew mysql formula and built this sequence around the package, service, security, and connection checks it documents. Use this route […] [...]

Published Monday, 31. August 2026 04:33 • 23 days ago

How one connection kills a database ^{(from PlanetScale Blog)}

Unblock stuck connections with live connection management in the PlanetScale CLI and dashboard [...]

Published Monday, 31. August 2026 00:00 • 23 days ago

My take on PyCon Australia 2026 ^{(from Ronald Bradford Blog)}

PyCon AU 2026 held in Brisbane this week was a five day event for the Python community. With specialized tracks and dedicated tutorial and engineering days there was a wide variety of content available. [...]

Published Sunday, 30. August 2026 00:00 • 24 days ago

Connect Deno to MySQL with mysql2 ^{(from Code For Geek)}

Deno can use the mysql2 driver through its npm compatibility layer, so a Deno app can open a MySQL connection without reviving an older URL import. The working path is small: give the app a limited database account, read its connection values from environment variables, execute a parameterized query, then close the pool. I ran […] [...]

Published Saturday, 29. August 2026 09:12 • 24 days ago

MySQL Release Models: LTS, Innovation, and Single Release ^{(from The Oracle MySQL Blog)}

What LTS, Innovation, and “latest supported” mean across MySQL Server, Shell, Router, Connectors, and Operator MySQL has two different release models, and understanding which products follow which model makes choosing versions much simpler. MySQL Server and MySQL NDB Cluster offer Long-Term Support (LTS) and Innovation releases. MySQL Shell, MySQL Router, MySQL Connectors, [...]

Published Friday, 28. August 2026 18:03 • 25 days ago

Prisma ORM with TiDB: The Serverless Setup Guide for AI Apps ^{(from PingCAP Blog)}

pKey Takeaways Introduction Prisma is the ORM (Object-Relational Mapper) most teams use for a TypeScript project, and it connects to TiDB through the standard MySQL provider, so a schema written for MySQL works unchanged. The connection is where the work is. Serverless functions and edge runtimes open and discard connections on every invocation, which is […]/p pThe post Prisma ORM with TiDB: [...]

Published Friday, 28. August 2026 16:44 • 25 days ago

Amazon Aurora MySQL 3.13 (compatible with MySQL 8.0.45) is generally available ^{(from AWS What's New)}

pStarting today, Amazon Aurora MySQL-Compatible Edition 3 (compatible with MySQL 8.0) supports MySQL 8.0.45, which includes community MySQL fixes and Aurora-specific improvements. For detailed information on this release, refer to Aurora MySQL 3 and MySQL 8.0.45 release notes.br br You can upgrade your databases during scheduled maintenance windows using automatic minor version upgrades. To simplif [...]

Published Friday, 28. August 2026 16:00 • 25 days ago

DBeaver as a MySQL Workbench Replacement : Performance Queries ^{(from Dave's MySQL Stuff)}

p "Hey, Dave! "Is there any way to get the old MySQL Workbench performance information from DBeaver?" An old acquaintance asked me this question this morning. The queries running without an index and the high-cost SQL statement information were what was wanted. /ppYup. The good news is that all that information on the instance's performance is all SQL. And that SQL is pretty s [...]

Published Friday, 28. August 2026 14:56 • 25 days ago

MONyog vs Datadog ^{(from Webyog Blog)}

pA world-class observability platform. But do you need a whole platform just to monitor MySQL? Datadog is one of the best full-stack observability products on the market. It’s also metered […]/p pThe post MONyog vs Datadog appeared first on Webyog./p [...]

Published Friday, 28. August 2026 13:58 • 25 days ago

Build a Deno API Server with MySQL ^{(from Code For Geek)}

Build a Deno API server with MySQL by keeping HTTP handling separate from database work. The handler below rejects an empty name, creates a user, and lists users, while MySQL2 owns parameterized SQL. Install Deno and prepare MySQL Install Deno with the current Deno installation instructions. Deno can import npm packages, including MySQL2, through its […] [...]

Published Friday, 28. August 2026 09:14 • 25 days ago

Implementing Type Contracts via Mutually Referencing Type Parameters ^{(from DoltHub Blog)}

It's not obvious how to properly write generic code that operates on recursive or mutually-recursive types. Here's how to do it right. [...]

Published Friday, 28. August 2026 00:00 • 26 days ago

MySQL 26.7 – Thank you for your contributions! ^{(from The Oracle MySQL Blog)}

The MySQL team would like to thank everyone in the community who contributed bug reports, patches, pull requests, and continued feedback that became part of the MySQL 26.7 release. As always, community contributions help make MySQL better for everyone. In this release, we received contributions across the MySQL Server Optimizer, Parser, Prepared Statements, Performance Schema, […] [...]

Published Thursday, 27. August 2026 17:42 • 26 days ago

IPv6-ready applications with MySQL HeatWave on OCI ^{(from The Oracle MySQL Blog)}

Users can now provision a DB system with an IPv6 address when the selected subnet supports IPv6. Applications can then reach the DB system through its IPv6 primary endpoint. IPv6 connectivity, familiar MySQL Modern cloud applications increasingly use IPv6 to expand address capacity, simplify large network estates, and support long-term infrastructure modernization. Yet a single […] [...]

Published Thursday, 27. August 2026 15:24 • 26 days ago

Performance Progression of Percona Server for MySQL 8.4 ^{(from Percona Database Blog)}

p1. Purpose and scope This performance investigation aims to look into the read/write performance of Percona Server for MySQL 8.4 and how it changed between versions released in 2026: 8.4.8-8 released on 12 March 2026 8.4.10-10 released on 30 June 2026 8.4.11-11 released on 20 August 2026 We want to see if there are improvements … Continued/p pThe post Performance Progression of Percona Serve [...]

Published Thursday, 27. August 2026 13:07 • 26 days ago

Will AI agents replace database IDEs? The future of database development ^{(from Devart MySQL Tool Blog)}

pAI agents can already write SQL, inspect schemas, and work through multi-step database tasks. But what happens when they start acting inside the database itself. Read the full article to see where that shift leads, what still needs human control, and how database IDEs fit into the picture./p pThe post Will AI agents replace database IDEs? The future of database development appeared first on Devar [...]

Published Thursday, 27. August 2026 11:15 • 26 days ago

MySQL CPU and CSPU Versioning for More Frequent Security Updates ^{(from The Oracle MySQL Blog)}

Oracle plans to move MySQL security updates toward a monthly cadence, supplementing the current quarterly Critical Patch Update (CPU) schedule. These monthly Critical Security Patch Update (CSPU) releases will be issued only when needed to address critical security or stability issues; they are not a fixed monthly release commitment. These CSPU releases will focus on […] [...]

Published Wednesday, 26. August 2026 18:50 • 27 days ago

Managed Database Services for Martech Platforms (2026) ^{(from Mydbops Blog)}

Managed database services for martech platforms: replica lag in send windows, PCI-DSS and GDPR gaps, and polyglot MySQL, MongoDB and Cassandra scaling. [...]

Published Wednesday, 26. August 2026 15:58 • 27 days ago

Announcing VillageSQL Server 0.0.6 ^{(from VillageSQL)}

VillageSQL Server 0.0.6 is now available. This release advances the mainline to MySQL Server 8.4.11 and adds support for MySQL Server 9.7.2 and Percona Server 8.4.10. [...]

Published Wednesday, 26. August 2026 12:00 • 27 days ago

DuckDB Speed on MySQL with dbtrail, Without a New Storage Engine ^{(from Percona Community Blog)}

Two recent posts on the Percona blog caught my attention. In Replicating from InnoDB into a DuckDB storage engine and The DuckDB MySQL engine at 500 GB, Evgeniy Patlan wired DuckDB into mysqld as a storage engine, pointed row-based replication at it, and measured it at TPC-H scale factor 500. The numbers are striking: loads 25 times faster than InnoDB, one fifth of the disk, and the full 22-query T [...]

Published Wednesday, 26. August 2026 11:00 • 27 days ago

Postgres + ClickHouse Architectural Patterns ^{(from Severalnines Blog)}

pThe role of databases has shifted significantly as modern applications must deliver real-time analytics, dashboards, and machine learning alongside low-latency transaction processing. Handling these diverse demands with a single relational database has become unsustainable under growing data volumes. Consequently, organizations are adopting specialized database architectures where multiple engines [...]

Published Wednesday, 26. August 2026 08:08 • 28 days ago

Where can you find MySQL from August through October 2026? ^{(from The Oracle MySQL Blog)}

The MySQL Community team will continue to be active across conferences, user group meetups, open source events, and regional community activities throughout August, September, and October 2026. While some of our August events were featured in our previous event update, we’ve included them here again with the latest information. Whether you’re interested [...]

Published Tuesday, 25. August 2026 14:19 • 28 days ago

MariaDB Server 12.3, 11.8, 11.4 and 10.11 – Q3 2026 Maintenance Releases, and Goodbye 10.6 ^{(from MariaDB Foundation Blog)}

pMariaDB Server maintenance releases are here!br On August 24, we released updates for our four currently maintained Long Term Support series:br As usual, these maintenance releases include bug fixes, stability improvements, and ongoing work across MariaDB Server. … /p pContinue reading \"MariaDB Server 12.3, 11.8, 11.4 and 10.11 – Q3 2026 Maintenance Releases, and Goodbye 10.6\"/p pMariaDB S [...]

Published Tuesday, 25. August 2026 12:14 • 28 days ago

MariaDB Contribution Statistics, January-June 2026 ^{(from MariaDB Foundation Blog)}

pAfter a long break, I will be taking over reporting on the contributions. FYI, the last one was done in Jan 2025.br Just like last time, I’m going to start with a breakdown of all the organizations who have contributed to MariaDB Server during the above period. … /p pContinue reading \"MariaDB Contribution Statistics, January-June 2026\"/p pMariaDB Contribution Statistics, January-June [...]

Published Tuesday, 25. August 2026 08:28 • 29 days ago

MySQL Galera Cluster EOL: Your Practical Paths Forward ^{(from Continuent Blog)}

MySQL Galera Cluster reaches end of life on September 30, 2026. This guide compares five practical paths forward - MariaDB Galera Cluster, Percona XtraDB Cluster, self-managed MySQL, managed cloud MySQL and Tungsten Cluster - with the trade-offs, migration effort and long-term risks of each. [...]

Published Tuesday, 25. August 2026 07:18 • 29 days ago

Problems with large tables in Postgres ^{(from PlanetScale Blog)}

Postgres presents pretty predictable performance problems when dealing with large tables. Sharding solves this. [...]

Published Tuesday, 25. August 2026 00:00 • 29 days ago

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

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 12.3.3, 11.8.9, 11.4.13, and 10.11.19 maintenance releases. See […] [...]

Published Monday, 24. August 2026 23:40 • 29 days ago

Open Weight Models Are Chapter One. The Data Layer Is the Rest of the Book. ^{(from PingCAP Blog)}

pOn July 24, Jensen Huang made the first post of his life on X. It wasn’t a product launch or a victory lap. It was a policy letter signed by 25 companies, doubling to 50 within a day, asking Washington not to restrict open weight AI models. Microsoft, Meta, IBM, a16z, and Hugging Face. The […]/p pThe post Open Weight Models Are Chapter One. The Data Layer Is the Rest of the Book. appeared fi [...]

Published Monday, 24. August 2026 20:29 • 29 days ago

Amazon RDS for MySQL now supports new minor version 8.4.11 ^{(from AWS What's New)}

pStarting today, Amazon Relational Database Service (Amazon RDS) for MySQL supports MySQL minor version 8.4.11, the latest minor released by community MySQL. In addition to operational improvements, MySQL 8.4.11 introduces support for post-quantum TLS (PQ-TLS) key exchange, providing you with post-quantum cryptography options for encrypting your data in-transit. We recommend upgrading to the newer [...]

Published Monday, 24. August 2026 08:41 • 29 days ago

The history of Postgres sharding ^{(from PlanetScale Blog)}

Why has it taken so long to get good Postgres sharding? The last 20 years are the answer. [...]

Published Monday, 24. August 2026 00:00 • 30 days ago

MySQL 26.7 Moves the Thread Pool Plugin to Community Edition ^{(from MinervaDB Blog)}

MySQL 26.7 moved the Thread Pool plugin to Community edition. As of the 26.7.0 Innovation release (GA 2026-07-31), the MySQL Thread Pool — the connection-handling model Oracle reserved for MySQL Enterprise Edition for roughly fifteen [...] [...]

Published Saturday, 22. August 2026 08:43 • 1 months ago

MySQL Galera Cluster EOL: Your Decision Runway and What It Costs to Wait ^{(from Continuent Blog)}

MySQL Galera Cluster maintenance ends September 30, 2026, while MySQL 8.0 has already reached end of life. Learn what these overlapping lifecycle changes mean, what risks increase after support ends, and what teams should decide before the Galera EOL deadline. [...]

Published Friday, 21. August 2026 07:55 • 1 months ago

August 2026 MySQL Contributor Summit and Inaugural MySQL Steering Committee Members ^{(from The Oracle MySQL Blog)}

The MySQL community gathered once again for the second MySQL Contributor Summit of 2026, held August 5–6 as a hybrid event from Broomfield, Colorado. Building on the momentum of the inaugural summit in May, MySQL contributors from across the MySQL ecosystem came together to share ideas, review technical proposals, and collaborate on the future of MySQL. Over two […] [...]

Published Thursday, 20. August 2026 15:37 • 1 months ago

MySQL Connection Pooling: What It Is and Why Your Application Needs It ^{(from Webyog Blog)}

pFew MySQL errors are as disruptive as this one: ERROR 1040 (HY000): Too many connections Your database is running. Your server has RAM to spare. Yet MySQL is refusing new […]/p pThe post MySQL Connection Pooling: What It Is and Why Your Application Needs It appeared first on Webyog./p [...]

Published Thursday, 20. August 2026 10:13 • 1 months ago

13 best practices for database development in Visual Studio 2026 ^{(from Devart MySQL Tool Blog)}

pVisual Studio 2026 ships SQL projects through SSDT, and only the original project format. Here is how to configure, validate, version, deploy, and drift-check a database project without discovering the gaps during a release./p pThe post 13 best practices for database development in Visual Studio 2026 appeared first on Devart Blog./p [...]

Published Thursday, 20. August 2026 06:55 • 1 months ago

The curious case of timezone inconsistencies between PgBouncer and Patroni Cluster ^{(from Percona Community Blog)}

I would like to introduce here the curious case that I had on a Patroni Cluster in production, after a migration from Oracle, with timezone differences between what was written from an application log and what was set in PostgreSQL. [...]

Published Thursday, 20. August 2026 00:00 • 1 months ago

Introducing the Hosted Dolt REST API ^{(from DoltHub Blog)}

Hosted Dolt now has an official, versioned REST API for creating and managing deployments. It's built on the same OpenAPI contract we used for the DoltHub API v2, so both APIs return the same envelope, the same errors, and the same auth. Here's how to use it. [...]

Published Thursday, 20. August 2026 00:00 • 1 months ago

My Journey from Traditional Monolithic Architecture to Distributed SQL ^{(from PingCAP Blog)}

pAs a database veteran, I found traditional monolithic databases (such as Oracle) to have bottlenecks for mission critical applications in the cloud, which called for a next generation cloud native database to solve these challenges. This is what excited me about joining the PingCAP team, where we took the core concept of Distributed SQL’s multi-node auto-sharding architecture and extended it to al [...]

Published Wednesday, 19. August 2026 18:57 • 1 months ago

Aligning MySQL Extensions with Existing Component Services ^{(from VillageSQL)}

The VillageSQL Extension Framework now lets developers directly consume MySQL component services within their extensions. [...]

Published Wednesday, 19. August 2026 17:37 • 1 months ago

Security Advisory: Privileged ClickHouse access through the Grafana data source in PMM ^{(from Percona Database Blog)}

pDate of release: 19 August 2026 Severity: High Affected product: PMM Impacted versions: 3.9.0 and below Summary Percona has recently been made aware of a security vulnerability affecting PMM. We take the security of our products and the protection of our customers’ data with the utmost seriousness. This advisory describes the vulnerability, the immediate steps … Continued/p pThe post S [...]

Published Wednesday, 19. August 2026 13:07 • 1 months ago

Postgres pioneer credits Oracle with helping his database take over the world ^{(from The Register)}

Big Red's acquisition of MySQL sent users running toward the open source alternative, says Michael Stonebraker [...]

Published Wednesday, 19. August 2026 12:37 • 1 months ago

Stop guessing at gcache: inspect Galera/PXC write sets with gcache-inspector ^{(from Percona Database Blog)}

pThe common practice is to size the Galera Cache based on write volume measured during peak load, but often it is more of a guesswork. The writeset cache capacity planning is crucial to shorten the maintenance time and avoid long state transfers while the cluster runs with reduced compute power. Now, if you could understand … Continued/p pThe post Stop guessing at gcache: inspect Galera/PXC w [...]

Published Wednesday, 19. August 2026 08:23 • 1 months ago

“If GitHub was stable, these alternatives would not be as interesting”: Cursor launches Origin as GitHub goes dark ^{(from The New Stack)}

♦pCursor has officially thrown its hat into the code-hosting ring with Origin, a Git-compatible platform built for a world where/p pThe post “If GitHub was stable, these alternatives would not be as interesting”: Cursor launches Origin as GitHub goes dark appeared first on The New Stack./p [...]

Published Tuesday, 18. August 2026 19:47 • 1 months ago

DuckDB 2.0 coming this fall with client/server mode ^{(from InfoWorld)}

pDuckDB, the analytics database with high-end features in a single easily deployed binary, is due to release a major update, version 2.0, this fall./p pIn a blog post on the DuckDB site, the project’s maintainers outlined several key features that motivated a major version bump. The single biggest is a client/server mode, allowing DuckDB to function both as a compact, in-p [...]

Published Tuesday, 18. August 2026 18:35 • 1 months ago

What a careful MySQL to MariaDB migration still misses ^{(from MariaDB Corporation Blog)}

The MariaDB Migrator announcement post introduced the MySQL-to-MariaDB migration tool and walked through its four modes. This post is about […] [...]

Published Tuesday, 18. August 2026 16:58 • 1 months ago

Help Test the MySQL Upgrade Advisor: A Community Upgrade-Planning Wizard for MySQL Shell ^{(from The Oracle MySQL Blog)}

Choosing how to upgrade a MySQL database is rarely just a question of source and target versions. The best approach can depend on database size, storage engines, replication topology, available infrastructure, acceptable downtime, backup readiness, application compatibility, and rollback requirements. A small standalone database with a long maintenance window may be a good candidate for […] [...]

Published Tuesday, 18. August 2026 14:44 • 1 months ago

Seravo becomes a Silver Sponsor of MariaDB Foundation ^{(from MariaDB Foundation Blog)}

pMariaDB Foundation is delighted to welcome Seravo as a Silver Sponsor, turning a long-standing relationship in the open-source ecosystem into formal support for the future of MariaDB. … /p pContinue reading \"Seravo becomes a Silver Sponsor of MariaDB Foundation\"/p pSeravo becomes a Silver Sponsor of MariaDB Foundation appeared first on MariaDB.org/p [...]

Published Tuesday, 18. August 2026 13:35 • 1 months ago

Village News: MySQL News + Events (18 August 2026) ^{(from VillageSQL)}

A curated roundup of August 2026's top MySQL and open-source database news, featuring MySQL 9.7 updates, Postgres, and upcoming global events. [...]

Published Tuesday, 18. August 2026 12:00 • 1 months ago

MariaDB 12.3 LTS Webinar: Performance, Scalability, High Availability & the AI-Native Database ^{(from MinervaDB Blog)}

Our MariaDB 12.3 LTS webinar is now available as a free PDF download. Over 60 minutes, Shiv Iyer — Founder & CEO of MinervaDB and a database engineer who has spent three decades inside MySQL, [...] [...]

Published Tuesday, 18. August 2026 10:45 • 1 months ago

MySQL Community Edition Vulnerability Advisory: August 2026 ^{(from One-Time MySQL Community/Ecosystem Posts)}

This page provides a view of the vulnerabilities addressed in MySQL Community Edition in the August 2026 Oracle MySQL Critical Security Patch Update. For this page, “MySQL Community Edition” means Community-distributed MySQL products. Only rows that map to Community-distributed components are included here. [...]

Published Tuesday, 18. August 2026 00:00 • 1 months ago

Fixing Old Software Bugs Without Thinking ^{(from Ronald Bradford Blog)}

I previously came across an issue in my benchmarking work where I relied on the Latency Histogram section of sysbench output. On Linux it worked fine — I generally ran my workload there, so it never mattered. [...]

Published Tuesday, 18. August 2026 00:00 • 1 months ago

Percona University Comes to Uruguay ^{(from Percona Database Blog)}

pPercona University is coming to Montevideo. On September 23rd, 2026, we’re getting together for a full day of technical talks on open source software, and you are invited! If you work or study with open source software in Uruguay, this one is for you. It’s a whole day of learning, with the people who build … Continued/p pThe post Percona University Comes to Uruguay appeared first [...]

Published Monday, 17. August 2026 16:34 • 1 months ago

MariaDB High Availability: Maximum Availability Solutions in MariaDB 12.3 LTS ^{(from MinervaDB Blog)}

MariaDB high availability reached a new baseline with MariaDB Server 12.3 LTS, GA on 2026-05-29 as version 12.3.2. For the first time, a MariaDB LTS release ships parallel replication between Galera Clusters (MDEV-20065), closing the [...] [...]

Published Monday, 17. August 2026 11:03 • 1 months ago

What is a data topology? ^{(from PlanetScale Blog)}

A data topology describes the sharding scheme a Neki router uses to map logical PostgreSQL tables to physical shards and route queries. [...]

Published Monday, 17. August 2026 00:00 • 1 months ago

Curating DuckDB Datasets Leveraging AI ^{(from Ronald Bradford Blog)}

In Curated MySQL Data Sets for Realistic Testing I described datasets assembled the manual way — download, schema, load, validate, document — over hours or days per source. This post is the follow-up I promised: what changes when AI assists the same workflow, using DuckDB as the target engine and GeoNames as the first example. [...]

Published Monday, 17. August 2026 00:00 • 1 months ago

Extending MariaDB with Native Aggregate Plugins: Laying the Groundwork for HyperLogLog ^{(from MariaDB Foundation Blog)}

pMariaDB already allows developers to add new Pluggable Data Types and scalar Plugin Functions. One missing piece has been Pluggable Aggregate Functions operating on PDTs. That matters for functionality such as HyperLogLog, where an extension needs to aggregate values into a custom statistical sketch while preserving its native SQL type. … /p pContinue reading \"Extending MariaDB with Native [...]

Published Sunday, 16. August 2026 16:00 • 1 months ago

Why INSERT IGNORE should not be used ^{(from Ronald Bradford Blog)}

Let’s say you’re building a reference table from source data, e.g. a silver medallion table from a primary source. In this example I am using a file of random locations on the globe extracted from OpenStreetMap (OSM) as my primary source. [...]

Published Sunday, 16. August 2026 00:00 • 1 months ago

What Constitutes Clean Data? ^{(from Ronald Bradford Blog)}

Clean data is one of those terms everyone uses and few define precisely. Row counts match? No nulls in key columns? Values within expected ranges? All useful checks — and all insufficient once you move from a table view to a visualization view. [...]

Published Saturday, 15. August 2026 00:00 • 1 months ago

MariaDB InnoDB Disk Space & Fragmentation ^{(from lefred's blog)}

As a DBA, disk space has always worried me. In fact, the biggest problem for a MySQL/MariaDB DBA is the large, fragmented InnoDB Tablespaces. It was even more problematic when a single tablespace handled everything. But even with a tablespace per table (innodb_file_per_table=ON) fragmentation on large tables can still be an issue and waste disk […] [...]

Published Friday, 14. August 2026 22:07 • 1 months ago

MariaDB Foundation Advances TAF with HammerDB 6.0 and xt_reservoir Integration ^{(from MariaDB Foundation Blog)}

pOverviewbr While validating MariaDB RSS stability under stored procedure workloads, I ran into unexpected memory growth. The goal was straightforward: confirm that MariaDB was not leaking memory when running TPROC-C stored procedure workloads. … /p pContinue reading \"MariaDB Foundation Advances TAF with HammerDB 6.0 and xt_reservoir Integration\"/p pMariaDB Foundation Advances TAF with Hamm [...]

Published Friday, 14. August 2026 15:48 • 1 months ago

More Control, More Visibility: Deferred Maintenance & Events in MySQL HeatWave ^{(from The Oracle MySQL Blog)}

MySQL HeatWave now offers more control and transparency around maintenance. With Deferred Maintenance and Maintenance Events, customers can better align database maintenance with their business schedules and operational processes to reduce disruption. Customers can now temporarily disable disruptive maintenance which requires system reboots. To ensure the ongoing security of customer environments, [...]

Published Friday, 14. August 2026 15:05 • 1 months ago

With performance_schema off, MySQL metrics are absent not zero ^{(from LibreDB Studio)}

Cache hit ratio, queries per second and buffer-pool usage are omitted rather than defaulted, and two more figures mean less than their names suggest. [...]

Published Friday, 14. August 2026 09:00 • 1 months ago

What's New With Golang Generics ^{(from DoltHub Blog)}

Go is conservative with adding new features, but it does happen. Generics were new once. Here's some ways that generics have evolved in recent versions, and how Dolt incorporates them. [...]

Published Friday, 14. August 2026 00:00 • 1 months ago

Curated MySQL Data Sets for Realistic Testing ^{(from Ronald Bradford Blog)}

Synthetic benchmarks have their place, but I have always preferred working with real data. Not client production data — that stays private — but publicly available datasets that reflect the messy shapes, skewed distributions, and indexing challenges you encounter in the wild. [...]

Published Friday, 14. August 2026 00:00 • 1 months ago

MariaDB Community Server 10.6.28 now available ^{(from MariaDB Corporation Blog)}

MariaDB is pleased to announce the immediate availability of the MariaDB Community Server 10.6.28 maintenance release. This is the final […] [...]

Published Thursday, 13. August 2026 20:30 • 1 months ago

More to Explore: What’s New on Planet MySQL ^{(from The Oracle MySQL Blog)}

Planet MySQL has always been about discovering what’s happening across the MySQL community. Now, there’s even more to explore. We’ve added new ways to discover the projects and products that make up the broader MySQL ecosystem, find upcoming MySQL events, and search the wealth of content shared by the community. At the center of these […] [...]

Published Thursday, 13. August 2026 18:17 • 1 months ago

Replicating from InnoDB into a DuckDB storage engine ^{(from Percona Database Blog)}

pOur first post showed MySQL 9.7 with one change: mark a table ENGINE=DuckDB and its analytical queries run in DuckDB instead of InnoDB. The question we kept getting after that was about replication. Can you keep a normal InnoDB primary for the writes, and run a replica where the big tables are ENGINE=DuckDB? Then the … Continued/p pThe post Replicating from InnoDB into a DuckDB storage engin [...]

Published Thursday, 13. August 2026 17:23 • 1 months ago

MySQL Database Security: A 12-PointChecklist for 2026 ^{(from Webyog Blog)}

pDatabase misconfigurations are among the most common causes of data breaches — and most of them are preventable. The majority of MySQL security improvements are straightforward, do not require specialized […]/p pThe post MySQL Database Security: A 12-PointChecklist for 2026 appeared first on Webyog./p [...]

Published Thursday, 13. August 2026 12:40 • 1 months ago

MariaDB 13.1 Feature in Focus: JSON Operators and JSON_TABLE Improvements ^{(from lefred's blog)}

MariaDB 13.1 introduces the long-awaited `-` and `-` JSON operators, together with `FORMAT JSON` support in `JSON_TABLE()`. Discover how these improvements simplify JSON queries, preserve nested objects and arrays, and improve compatibility with MySQL applications. [...]

Published Thursday, 13. August 2026 09:50 • 1 months ago

MariaDB 13.1 Feature in Focus: JSON Operators and JSON_TABLE Improvements ^{(from MariaDB Foundation Blog)}

pJSON support in MariaDB has improved significantly over the years.br We have functions to create JSON documents, extract values, modify objects, inspect arrays, compare documents, and even transform JSON into relational rows using JSON_TABLE(). … /p pContinue reading \"MariaDB 13.1 Feature in Focus: JSON Operators and JSON_TABLE Improvements\"/p pMariaDB 13.1 Feature in Focus: JSON Operators [...]

Published Thursday, 13. August 2026 09:45 • 1 months ago

Doltgres is as Fast as MySQL is Slow ^{(from DoltHub Blog)}

Overview of recent performance optimizations to Doltgres that brought it on par with MySQL [...]

Published Thursday, 13. August 2026 00:00 • 1 months ago

How to set up change data capture for real-time database pipelines ^{(from Mydbops Blog)}

Positions a 2026 step-by-step CDC guide covering Debezium, Kafka Connect, MySQL binlogs, and PostgreSQL WAL. [...]

Published Wednesday, 12. August 2026 12:08 • 1 months ago

How to reduce slow query incidents in high-traffic MySQL apps ^{(from Mydbops Blog)}

Promises an eight-step MySQL slow-query process covering logs, EXPLAIN, indexes, pooling, timeouts, and alerting. [...]

Published Wednesday, 12. August 2026 10:55 • 1 months ago

COSCUP 2026: Planning your upgrade to MySQL 9.7 ^{(from Ronald Bradford Blog)}

I recently had the pleasure of presenting Planning your upgrade to MySQL 9.7 at COSCUP 2026 in Taipei, Taiwan. COSCUP (Conference for Open Source Coders, Users and Promoters) is one of the largest open source conferences in Asia, and the community there is always engaged and technically sharp. [...]

Published Wednesday, 12. August 2026 00:00 • 1 months ago

Migrate RDS and Aurora logs to CloudWatch Infrequent Access ^{(from AWS Database Blog)}

Organizations running Amazon RDS and Amazon Aurora often pay full CloudWatch Logs ingestion rates for database logs they rarely access. This post shows how to build an automated, tag-driven solution that migrates RDS and Aurora CloudWatch log groups from the Standard to the Infrequent Access log class and cuts log ingestion costs by about 50%. [...]

Published Tuesday, 11. August 2026 16:19 • 1 months ago

From Replication to Resilience: Miguel Araújo on Building the Operational Layer of MySQL High Availability ^{(from ODBMS.org)}

Q1. As the tech lead for AdminAPI, you’ve spent years helping shape how MySQL users deploy and manage InnoDB Cluster, ReplicaSet, and ClusterSet environments. From your experience, what are some of the most important... [...]

Published Tuesday, 11. August 2026 13:28 • 1 months ago

MySQL Replication: How to Set It Up and Monitor It Effectively ^{(from Webyog Blog)}

pMySQL replication is one of the most relied-upon features in production MySQL environments. It powers read scaling, disaster recovery, analytics offloading, and geographic redundancy. It is also one of the […]/p pThe post MySQL Replication: How to Set It Up and Monitor It Effectively appeared first on Webyog./p [...]

Published Tuesday, 11. August 2026 12:16 • 1 months ago

Percona for MongoDB: RHEL 10, Its Derivatives, and Debian 13 – On Both x86_64 and ARM ^{(from Percona Database Blog)}

pWe’re happy to announce that Percona Server for MongoDB (PSMDB) 8.0.28-12 extends platform support to RHEL 10 and its derivatives (Oracle Linux 10, Rocky Linux 10, AlmaLinux 10, and other RHEL-compatible distributions) for both x86_64 and ARM (aarch64) architectures. This release also adds support for Debian 13 “Trixie” on x86_64 and ARM64. We’ll continue to … Continu [...]

Published Tuesday, 11. August 2026 12:15 • 1 months ago

Amazon RDS for MariaDB now supports MariaDB 12.3 ^{(from AWS What's New)}

pStarting today, Amazon RDS for MariaDB supports MariaDB major version 12.3, the latest Long-Term Support release from the MariaDB community. This release supports MariaDB 12.3.2 minor version. br br MariaDB 12.3 includes Oracle TO_DATE() function compatibility, reducing the code changes needed when migrating applications from Oracle to MariaDB. It adds an IS JSON predicate, so you can valida [...]

Published Tuesday, 11. August 2026 08:54 • 1 months ago

How to set up automated database failover testing ^{(from Mydbops Blog)}

Covers 2026 failover testing for MySQL, PostgreSQL, and MongoDB-RTO targets, health checks, trigger scripts, and troubleshooting. [...]

Published Tuesday, 11. August 2026 08:05 • 1 months ago

Making the PostgreSQL Documentation Even Better ^{(from Shinguz's Blog)}

pWhile working on our project “PostgreSQL for Dolphins and Sea Lions,” I pored over the PostgreSQL documentation on replication./p pSince I’m not quite up to speed on this topic yet, I like to look up certain terms (parameters, functions, etc.) every now and then to see exactly what they mean or how they work (RTFM!). That’s exactly why links were originally invented—the very thing that first made [...]

Published Tuesday, 11. August 2026 06:40 • 1 months ago

MariaDB Foundation is pleased to welcome Auree as a Silver Sponsor. ^{(from MariaDB Foundation Blog)}

pAuree is building a cloud-independent platform for deploying and operating highly available open source databases, including MariaDB, inside customers’ own cloud accounts. Its Bring Your Own Cloud model allows organisations to choose their cloud provider, region, infrastructure size, and security environment while Auree automates database provisioning, monitoring, backups, clustering, and fa [...]

Published Monday, 10. August 2026 15:34 • 1 months ago

Planet for the MySQL Community

A blog / news aggregator (Planet) for the MySQL Community / Ecosystem

Tuesday, 22. September 2026

How Atomic DDL Works in MySQL 8.0 (from Libing Song's Blog)

PeakAIO contributes support of 8k API nodes to RonDB 26.02.11 (from Mikael Ronstrom)

Monday, 21. September 2026

AI Agent State Explained (from PingCAP Blog)

Village News: MySQL News + Events (21 September 2026) (from VillageSQL)

Ensuring High Availability for Resilient Cloud Databases with MariaDB (from DBTA)

Why is Naomi Cannon bashing MariaDB? (from Shinguz's Blog)

DISTANCE() and VECTOR_DISTANCE(): Vector Similarity in Percona Server for MySQL 9.7 (from Percona Database Blog)

Sunday, 20. September 2026

Getting VECTOR capabilities in MySQL 8.4 using VillageSQL (from Ronald Bradford Blog)

Friday, 18. September 2026

MariaDB 13 Expands Oracle Compatibility and Improves Developer Experience and Observability (from InfoQ)

MySQL Community Engagement in Brazil and Europe (from The Oracle MySQL Blog)

“Verify, Measure, and Get Your Hands Dirty”: Two Decades of Database Support with Sveta Smirnova (from MariaDB Foundation Blog)

The ideal database for AI agents doesn't exist yet, says Percona CEO (from The Register)

MONyog vs Percona PMM (from Webyog Blog)

The architecture of Neki (from PlanetScale Blog)

Thursday, 17. September 2026

Galera Cluster Remains An Integral Part of MariaDB Server (from MariaDB Corporation Blog)

Why Your AI Agent Doesn’t Actually Remember Anything (from PingCAP Blog)

The database world grew up — notes from Percona Live Amsterdam (from MariaDB Foundation Blog)

Using DuckDB inside MySQL (from VillageSQL)

Evaluating LLM models for DBA tasks (from Percona Database Blog)

Group Replication Beyond a Single Cluster: DC-DR with Percona (PS MySQL) Operator (from Percona Database Blog)

MariaDB 13.0 Is Now Stable (from MariaDB Foundation Blog)

Too many GCache Page Files in MySQL Data Directory (from Percona Database Blog)

Wednesday, 16. September 2026

On JSONPath in MariaDB and MySQL (from Sergei Petrunia's blog)

Trying DuckDB for Magento Analytics: An Experiment with One Million Orders (from MariaDB Foundation Blog)

1,000 MCP servers, zero schema bloat? Lessons from Uber's attack on AI costs (from The Stack)

MariaDB adoption is growing, and the way people get it is changing – Adoption Index 2026-09 (from MariaDB Foundation Blog)

Node.js and MySQL Tutorial: Connect, Query, and Pool with mysql2 (from Code For Geek)

Vibe Coding a Database Lab: How I Built DBCanvas to Stop Rebuilding the Same Test Environment (from Percona Community Blog)

NodeJS MySQL Select Unique (from Code For Geek)

Implementing GitOps from Infrastructure to DB Operators to Unify Ops for Kubernetes Databases (from Severalnines Blog)

What We Learned From the First MySQL Ecosystem Spotlight (from OurSQL Foundation Blog)

Tuesday, 15. September 2026

Announcing MariaDB Community Server 13.0 GA (from MariaDB Corporation Blog)

Vector search in MySQL: an early look at HNSW and custom indexes in VillageSQL (from VillageSQL)

MariaDB Enterprise Server 12.3 Beta: Conflict-Aware Replication, Raft-Based Cluster, and Passwordless TLS Authentication (from MariaDB Corporation Blog)

Node.js MySQL Insert Record (from Code For Geek)

NodeJS MySQL Select Record (from Code For Geek)

Performance improvements in Percona Server 8.4.11-11 (from Percona Database Blog)

Home and Pricing Page Redesign (from DoltHub Blog)

Monday, 14. September 2026

Percona and HexaCluster: Faster, Safer Oracle Migration (from Percona Database Blog)

AWS renews Diamond sponsorship of MariaDB Foundation for a fourth consecutive year (from MariaDB Foundation Blog)

AI Coding Agent Files Explained: How Persistent Workspaces Survive Resets (from PingCAP Blog)

MySQL INSTANT DDL breaks EXCHANGE PARTITION (from Kedar MySQL Blog)

Diagnosing MySQL Memory Problems with Jemalloc (from Libing Song's Blog)

Percona releases Galera Cluster Version 9.7 (from Shinguz's Blog)

Optimising Multi-Range Queries with Logical Charts (from Vettabase)

Continuing the ProxySQL.Cloud Conversation After Percona Live Amsterdam (from ProxySQL Blog)

Sunday, 13. September 2026

NodeJS MySQL Drop Table (from Code For Geek)

NodeJS MySQL Create Table (from Code For Geek)

NodeJS MySQL Create Database (from Code For Geek)

Thank You for Connecting with ProxySQL at Percona Live Amsterdam 2026 (from ProxySQL Blog)

Saturday, 12. September 2026

MySQL Workbench 26.7で試してほしい5つのこと (from The Oracle MySQL Blog)

Runtime: Orchid Security wants to kill your agents (from The Stack)

NodeJS MySQL Create Connection (from Code For Geek)

Node.js and MySQL Connection Pool Example (from Code For Geek)

Friday, 11. September 2026

Dynamic Data Masking in Percona Server for MySQL: Setup & Best Practices (from Mydbops Blog)

Five Things to Try in MySQL Workbench 26.7 (from The Oracle MySQL Blog)

Synchronize MySQL and IndexedDB in an Offline-First App (from Code For Geek)

Ajax in Node.js: How to Build a Live Search Feature (from Code For Geek)

MySQL Community Meetups Fall 2026 (from The Oracle MySQL Blog)

Postgres follows the SQL standard for UPDATE statements, unlike MySQL (from DoltHub Blog)

Thursday, 10. September 2026

1 month, 5 outages: Databases are under massive strain at GitHub (from The Stack)

MySQL & Friends: Distributed Databases@SCaLE (from Dave's MySQL Stuff)

MONyog vs SolarWinds (from Webyog Blog)

The Perfect Serve: What Tennis Taught Me About Reading PMM Like a Coach Instead of Guessing (from Percona Community Blog)

Introducing Neki (from PlanetScale Blog)

Introducing MySQL Workbench 26 (from The Oracle MySQL Blog)