Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

A description of what this website tries to achieve is in the Planet MySQL Community - Requirements RFC.

And a clarification about the MySQL Community/Ecosystem: it is not limited the users of the MySQL Database. In the current context, it also includes people interested in MySQL Variants including MariaDB Server, Percona Server, Galera, Amazon RDS and Aurora, Google Cloud SQL for MySQL, and Azure and Alibaba flavor(s) of MySQL/MariaDB/Percona Servers.

Wednesday, 19. November 2025

Deploying on OCI with the starter kit – part 3 (applications) (from lefred's blog)

We saw in part 1 how to deploy our starter kit in OCI, and in part 2 how to connect to the compute instance. We will now check which development languages are available on the compute instance acting as the application server. After that, we will see how easy it is to install a new […] [...]

Percona Operator for MySQL Is Now GA, More MySQL Options for the Community on Kubernetes (from Percona Community Blog)

pWe’re excited to share that the new Percona Operator for MySQL (based on Percona Server for MySQL) is officially in General Availability (GA)!/p pThis release introduces native MySQL Group Replication support for Kubernetes, providing our community with another open-source option for running reliable, consistent MySQL clusters at scale./p pThis is about more choices for the community. Each MySQL r [...]

MariaDB 12.1.2 rolling release now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 12.1.2, the latest stable rolling release.br MariaDB 12.1.2 features performance enhancements, deeper MySQL and Oracle compatibility, and other general improvements. … /p pContinue reading \"MariaDB 12.1.2 rolling release now available\"/p pThe post MariaDB 12.1.2 rolling release now available appeared first on MariaDB [...]

Common Schema Design Patterns for SaaS — and How TiDB Helps (from siddontang on Medium)

Common Schema Design Patterns for SaaS — and How TiDB HelpspWhen you’re building a SaaS app, the first big question about your database usually isn’t SQL or NoSQL, it’s —/pblockquote“Where should I put all my tenants’ data?”/blockquotepAnd that simple question opens a deep rabbit hole of schema design choices, trade-offs, and a few “oh no” moments you’ll only discover at scale./ppI’ve been there. H [...]

Tuesday, 18. November 2025

What’s New in MariaDB 12: Full Release Guide  (from Devart MySQL Tool Blog)

pLearn what’s new in MariaDB 12. Release notes, features, breaking changes, benchmarks, and upgrade tips. Try dbForge Studio for MySQL free today./p pThe post What’s New in MariaDB 12: Full Release Guide  appeared first on Devart Blog./p [...]

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

[...]

Ignite 2025: Advancing Azure Database for MySQL with Powerful New Capabilities (from Azure for MySQL Blog)

pAt Ignite 2025, we’re introducing a wave of powerful new capabilities for Azure Database for MySQL, designed to help organizations modernize, scale, and innovate faster than ever before. From enhanced high availability and seamless serverless integrations to AI-powered insights and greater flexibility for developers, these advancements reflect our commitment to delivering a resilient, intelligent [...]

Introducing the GA Release of the New Percona Operator for MySQL: More Replication Options on Kubernetes (from Percona Database Blog)

♦The Percona Cloud Native team is happy to announce the general availability of the Percona Operator for MySQL, based on Percona Server for MySQL. This release introduces an additional Kubernetes-native approach to deploying and managing MySQL clusters with synchronous Group Replication, delivering the consistency required for organizations with business continuity needs. With this release, Percona [...]

Amazon RDS for MariaDB now supports community MariaDB minor versions 10.6.24, 10.11.15, and 11.4.9 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports community MariaDB minor versions 10.6.24, 10.11.15, and 11.4.9. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MariaDB, and to benefit from the bug fixes, performance improvements, and new functionality added by the MariaDB community.br br You can leverage [...]

Monday, 17. November 2025

Accelerate database modernization using AI with the Database Modernizer Workshop (from AWS Database Blog)

In this post, we show how you can use the Database Modernizer workshop to accelerate your database modernization journey from MySQL to Amazon DynamoDB. Traditional approaches to migrating from relational databases to NoSQL solutions like DynamoDB can take several months, requiring extensive expertise in data modeling, application refactoring, and migration strategies. The Database Modernizer worksh [...]

BangPypers x MariaDB Python Hackathon – Winners Announced! (from MariaDB Foundation Blog)

pLast Saturday marked an exciting milestone: the announcement of the winners in our first large-scale MariaDB Python Hackathon, organised in collaboration with BangPypers, HackerEarth, and MariaDB plc. … /p pContinue reading \"BangPypers x MariaDB Python Hackathon – Winners Announced!\"/p pThe post BangPypers x MariaDB Python Hackathon – Winners Announced! appeared first on MariaDB.org./p [...]

Deploying on OCI with the starter kit – part 2 (from lefred's blog)

In part 1, we saw how to deploy several resources to OCI, including a compute instance that will act as an application server and a MySQL HeatWave instance as a database. In this article, we will see how to SSH into the deployed compute instance. Getting the key To connect to the deployed compute instance, […] [...]

TiDB AgentX Hackathon 2025 Recap: Double the Submissions, Real-World AI on Display (from PingCAP Blog)

pThe results are in, and they are spectacular. When we challenged the community to move beyond simple RAG demos, we never imagined the sheer ingenuity we’d see. With 219 incredible submissions, the AgentX Hackathon 2025 proved one thing: the era of sophisticated, multi-step AI agents is here. A New Chapter for TiDB Hackathons Last year’s […]/p pThe post TiDB AgentX Hackathon 2025 [...]

MariaDB 11.8.5 critical bugfix release now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation announces the availability of MariaDB 11.8.5.br Users of MariaDB 11.8.4 are strongly recommended to upgrade to the new release.br MariaDB 11.8.4 is affected by an issue resulting in only partial deletion of data on MyISAM or Aria tables under specific conditions. … /p pContinue reading \"MariaDB 11.8.5 critical bugfix release now available\"/p pThe post MariaDB 11.8.5 [...]

Amazon Aurora MySQL 3.11 (compatible with MySQL 8.0.43) is now generally available (from AWS What's New)

pStarting today, Amazon Aurora MySQL - Compatible Edition 3 (with MySQL 8.0 compatibility) will support MySQL 8.0.43 through Aurora MySQL v3.11.br br In addition to several security enhancements and bug fixes, MySQL 8.0.43 contains additional errors for group replication and introduces the mysql client “commands” option, which enables or disables most mysql client commands. For more details, refer [...]

Amazon RDS for MySQL now supports new minor versions 8.0.44 and 8.4.7 (from AWS What's New)

pAmazon Relational Database Service (Amazon RDS) for MySQL now supports MySQL minor versions 8.0.44 and 8.4.7, the latest minors released by the MySQL community. We recommend upgrading to the newer minor versions to fix known security vulnerabilities in prior versions of MySQL and to benefit from bug fixes, performance improvements, and new functionality added by the MySQL community. Learn more abo [...]

Saturday, 15. November 2025

(from DoltHub Blog)

![CDATA[ This guide will help you set up Dolt (a version-controlled SQL database) with Claude Code, enabling you to use AI to make database changes that you can track, review, and manage through the Dolt Workbench. ]] [...]

Friday, 14. November 2025

Introducing fully managed Blue/Green deployments for Amazon Aurora Global Database (from AWS Database Blog)

Today, we're introducing Amazon RDS Blue/Green support for Aurora Global Database, enabling database upgrades and modifications with minimal downtime. With just a few steps, you can create a blue/green deployment that establishes a fully managed staging (green) environment mirroring the existing production (blue) environment, including the primary and its associated secondary regions of the Global [...]

Speak About MySQL At SCaLE 23x (from Dave's MySQL Stuff)

pI help facilitate the MySQL track at SCaLE. I am seeking first-time presenters who can discuss MySQL.  I am also looking for old-timers who haven't spoken in a while at a conference and those who have forgotten to submit a talk. /ppThe MySQL Community is at a crossroads, and the MySQL track will cap off a day with a panel on the past, present, and future of MySQL. /ppThe 2 [...]

MariaDB Community Server 11.8.5 Corrective Release (from MariaDB Corporation Blog)

MariaDB informs users of the immediate availability of MariaDB Community Server 11.8.5, a crucial corrective release for the 11.8 series. […] [...]

Deploying on OCI with the starter kit – part 1 (from lefred's blog)

If you want to create a new application, test it, and deploy it on the cloud, Oracle Cloud Infrastructure provides an always-free tier for compute instances and MySQL HeatWave instances (and more). If you are a developer, it can also be complicated to start deploying to the cloud, as you need to figure out the […] [...]

A Tale of Two Databases: No-Op Updates in PostgreSQL and MySQL (from Percona Database Blog)

♦I’m lazy when I’m speakin’ I’m lazy when I walk I’m lazy when I’m dancin’ I’m lazy when I talk   X-Press 2 Feat. David Byrne – Lazy While preparing a blog post to compare how PostgreSQL and MySQL handle locks, as part of a series covering the different approaches to MVCC for these databases, […] [...]

$5 PlanetScale is live (from PlanetScale Blog)

You can now create single node Postgres databases on PlanetScale starting at just $5. [...]

Thursday, 13. November 2025

CSV File Load Error - Data Too Long or Value Too Long (from Dave's MySQL Stuff)

p  You are trying to load a CSV file into a database, and almost inevitably, you run into an ERROR: value too long for type character varying 64 if you are using PostgreSQL.  Or SQL Error [1406] [22001]: Data truncation: Data too long for column 'Name' at row 1 if you are using MariaDB or MySQL./ppIt doesn't matter if you are using the DBeaver application or [...]

Building brighter futures: How YES tackles youth unemployment with Azure Database for MySQL (from Azure for MySQL Blog)

pThis article was co-authored by Malcolm MacDonald, CIO at YES, and Saurabh Kirtani, Senior Product Manager at Microsoft/p pbrYouth unemployment is one of South Africa’s most persistent challenges with more than half of young people struggling to secure their first job. At the same time, employers hesitate to hire people without experience, and youth cannot gain experience without employment. Solvi [...]

Zero-Downtime Upgrades: How TiDB Powers Always-On Databases (from PingCAP Blog)

pIn the vast landscape of databases, ensuring zero-downtime upgrades and operation continuity remains a challenge. Due to inherent design limitations, traditional databases often introduce significant downtime during upgrades – a challenge that can spell operational chaos for businesses reliant on real-time data access.  Enter TiDB, a cutting-edge distributed SQL database that offers a s [...]

How we optimize RocksDB in TiKV (Part 1) — The Battle Against the DB Mutex (from siddontang on Medium)

How we optimize RocksDB in TiKV — The Battle Against the DB MutexpWhen we started building TiKV nine years ago, we chose RocksDB as our storage engine. And for good reasons — it’s a highly efficient, battle-tested key-value store with a flexible LSM-tree design that’s proven at scale. It gave us a great foundation to build a distributed transactional key-value database on./ppBut as our users’ data [...]

Wednesday, 12. November 2025

Why successful people should be mentored? (from AskDba)

Not knowing whether you need a mentor or not at the beginning. People often assume that mentorship is something you outgrow. They imagine it as a ladder. It’s something you climb early in your career. Once you reach a certain level of success, you step off and stand on your own. In reality, the opposite […] [...]

Real-World SaaS Multi-Region MySQL: Tungsten Cluster Implementation Guide (from Continuent Blog)

Comprehensive guide to implementing a real-world multi-region MySQL SaaS deployment with Tungsten Cluster, covering architecture design, automation, monitoring, and operational best practices.Tags: SaaSmulti-region databasereplicationHigh Availabilityzero downtime [...]

Tuesday, 11. November 2025

MariaDB 12 Triggers (from SQL And Its Sequels (Ocelot Blog))

There’s new SQL syntax in MariaDB 12. MariaDB’s manual doesn’t document it all, so I will try. First in this series is: the Oracle-style CREATE TRIGGER … event with OR, and the standard-style table information_schema.triggered_update_columns. event with OR CREATE TRIGGER trigger_name BEFORE|AFTER INSERT|UPDATE [OF column-list]|DELETE [OR INSERT|UPDATE [OF [...]

Extending Flexibility in MySQL HeatWave Maintenance: Introducing Configurable Maintenance (from The Oracle MySQL Blog)

Align upgrades with your business schedules, minimize disruption, and plan version transitions with confidence, all while maintaining the reliability and compliance you expect from MySQL HeatWave. We are also extending Innovation release available cycle from 3 months to 5 months, this enables customers to stay on the same innovation release version for longer period of time. [...]

MySQL Memory Usage: A Guide to Optimization (from Percona Community Blog)

pStruggling with MySQL memory spikes? Knowing how and where memory is allocated can make all the difference in maintaining a fast, reliable database. From global buffers to session-specific allocations, understanding the details of MySQL’s memory management can help you optimize performance and avoid slowdowns. Let’s explore the core elements of MySQL memory usage with best practices for trimming e [...]

(from DoltHub Blog)

![CDATA[ How we build Dolt from source on Windows using Git Bash, MSYS2, and pacman. ]] [...]

Monday, 10. November 2025

MariaDB Enterprise Manager: The Native Way to Manage All Your MariaDB Environments (from MariaDB Corporation Blog)

[...]

What’s New At Releem - October 2025 (from Releem Blog)

Another month in the books – and it’s been a great one. Highlights include support for GCP Cloud SQL, enhanced servers overview for multi-server management, and a round of Agent improvements focused on stability and lighter performance impact. [...]

A thread through my 2025 Postgres events (from Percona Community Blog)

pI recently got back from PostgreSQL Conference Europe in Riga, marking the end of my conference activities for 2025. The speakers were great. The audience, for the Extensions Showcase on Community Day on Tuesday and my Kubernetes from the database out talk, were great. The event team was great. The singing at karaoke was terrible, but it’s supposed to be./p pAfter attending a good few events this [...]

(from DoltHub Blog)

![CDATA[ In this post, I talk about the strategies used to improve agentic data importing using idempotent goal based planning and execution. ]] [...]

Sunday, 09. November 2025

Can an OLTP Database Compete in Analytics Benchmarks? The TiDB Story (from siddontang on Medium)

pTiDB was born as an OLTP database — designed from day one to solve the scalability limits that traditional transactional databases like MySQL, MariaDB or Aurora often hit./ppIts mission was clear: scale transactional workloads seamlessly without sacrificing MySQL compatibility or operational simplicity./ppHowever, TiDB’s story doesn’t stop there./ppThanks to its TiFlash component — a columnar, MPP [...]

Friday, 07. November 2025

Supercharging Real-Time Applications with TiDB and DragonflyDB (from PingCAP Blog)

pData-intensive applications demand scalability, low latency, and resilience. However, traditional databases often struggle to handle both transactional consistency and fast in-memory caching at scale. But that’s where TiDB and DragonflyDB shine together: In this tutorial, we’ll walk through setting up a TiDB + Dragonfly stack, show how they complement each other, and build a hands-on […]/p p [...]

AI makes JavaScript programming fun again (from InfoWorld)

pI feel some responsibility to sound a cautionary note amid all the AI fervor, and this report has seen a share of that. But, on the occasion of this November 2025 report, I’d like to instead celebrate AI-driven programming for all it’s worth./p pAt its best, AI brings back a feeling of excitement and fun to programming. It lifts some of the heavy grunt work off developers, [...]

More Django developers turning to AI – report (from InfoWorld)

pAI is becoming an important learning resource for users of Django, the well-established Python web framework. The recently published State of Django 2025 report notes that 38% of Django Developers Survey respondents said they were using AI tools to educate themselves on Django./p pFor Django development, 69% reported using ChatGPT, while 34% said they were using GitHub Co [...]

MariaDB 11.8.4, 11.4.9, 10.11.15 and 10.6.24 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.8.4, MariaDB 11.4.9, MariaDB 10.11.5 and MariaDB 10.6.24, the latest stable releases in their respective long-term series (receiving regular maintenance and support for three years from their first stable release dates, and critical security fixes as source code releases for two additional years beyond). … /p pConti [...]

AWS Advanced .NET Data Provider Driver is Generally Available (from AWS What's New)

pThe Amazon Web Services (AWS) Advanced .NET Data Provider Driver is now generally available for Amazon RDS and Amazon Aurora PostgreSQL and MySQL-compatible databases. This advanced database driver reduces RDS Blue/Green switchover and database failover times, improving application availability. Additionally, it supports multiple authentication mechanisms for your database, including Federated Aut [...]

Thursday, 06. November 2025

MariaDB Unlocks Your Data for Secure, Enterprise-Grade Agentic with MariaDB AI RAG and MariaDB Enterprise MCP Server (from MariaDB Corporation Blog)

[...]

Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages) (from J-F Gagné's MySQL Blog)

While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug (Bug #111353 : 3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE).  There has been recent activity on this bug, showing an easy workaround.  This, even if it is known since 16 July 2024, has not been talked about much, so this deserves a blog post. [...]

MariaDB Community Server Q4 2025 maintenance releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.8.4, 11.4.9, 10.11.15, and 10.6.24 maintenance releases. See […] [...]

How to Scale TiDB Locally with Online DDL (from PingCAP Blog)

pData-intensive applications outgrow single-node MySQL long before product-market fit is “done.” Hot partitions, schema change windows, and manual sharding slow teams down. But TiDB solves this with a MySQL-compatible, distributed SQL architecture that scales storage and compute independently and keeps applications online during change. In this quick tutorial, we’ll spin up TiDB locally with [...]

MySQL Basics: Don’t Lose It—Backing Up and Restoring Your Database (from The Oracle MySQL Blog)

Learn how to safeguard your MySQL database with simple, reliable backup and restore techniques! This final post in the beginner series uses fun library analogies and clear MySQL Shell examples to ensure your data stays safe—no matter what surprises come your way. [...]

(from DoltHub Blog)

![CDATA[ FastAPI is a popular Python framework for building APIs. In this article, we'll build a sample application using FastAPI and Dolt. ]] [...]

Wednesday, 05. November 2025

Surprise with innodb_doublewrite_pages in MySQL 8.0.20+ (from Percona Database Blog)

♦In a recent post, The Quirks of Index Maintenance in Open Source Databases, I compared the IO load generated by open source databases while inserting rows in a table with many secondary indexes. Because of its change buffer, InnoDB was the most efficient solution. However, that’s not the end of the story. Evolution of the […] [...]

Enhanced Operational Databases (from Shattered Silicon OSDB Blog)

pThe post Enhanced Operational Databases appeared first on Shattered Silicon./p [...]

Simplified: Upgrade Non-SSL-enabled Tungsten v6 to SSL-enabled Tungsten v8 (from Continuent Blog)

Step-by-step guide to upgrading Tungsten Clustering and Replicator from version 6 (non-SSL) to version 8 (SSL-enabled). Learn how to enable SSL for MySQL, Tungsten Connectors, and REST APIs with minimal downtime and maximum data security.Tags: sslupgradeHigh Availability [...]

Tuesday, 04. November 2025

October Product Update (from Readyset Blog)

♦pAs traffic spikes approach for the holiday season, we’ve rolled out new improvements to help you keep database performance fast and predictable. Here’s what’s new:/p💬 Product UpdatespReadyset Core/pulliSmarter Time-Series Aggregations: We introduced codeBucket(timestamptz, interval)/code, a Readyset-specific SQL function that groups/li/ul [...]

Sysadmin’s Inconceivable Tales – Squeezing More Performance out of tar (from Shattered Silicon OSDB Blog)

pHow we squeezed 33% moreperformance out of tar on x86-64 Linux./p pThe post Sysadmin’s Inconceivable Tales – Squeezing More Performance out of tar appeared first on Shattered Silicon./p [...]

How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4 (from Kedar MySQL Blog)

pDuring a MySQL upgrade process the RDS replication between MySQL 8.0 and 8.4 was configured. I wanted to ensure the data was consistent for any random reason. This post is…/p The post How to checksum on AWS RDS for MySQL Replication 8.0 8.4 first appeared on Change Is Inevitable. [...]

MySQL Basics: Safe and Sound—User Management and Database Security (from The Oracle MySQL Blog)

Keep your MySQL database protected with beginner-friendly advice on user management and security! Learn how to create users, grant and revoke privileges, and safeguard your data using library-themed examples and practical tips. Essential reading for every data explorer eager to lock up their digital collection. [...]

GROUP BY ALL (from Modern SQL)

codeGroup by All/code: Generate codegroup by/code from codeselect/code♦olliRemoves the codegroup by all/code clause if it leads to an error that does not happen without codegroup by/code clause/li/olpSome Systems allow the special codegroup by all/code syntax as a shorthand for grouping on all codeselect/code items that do not have an aggregate function./pprecodeSELECT customers.id, customers.name, [...]

Announcing Vitess 23 (from PlanetScale Blog)

Vitess 23 is now generally available [...]

Announcing Vitess 23.0.0 (from Vitess)

Announcing Vitess 23.0.0 # We’re excited to release Vitess 23.0.0 — the latest major version of Vitess — bringing new defaults, better operational tooling, and refined metrics. This release builds on the strong foundation of version 22 and is designed to make deployment and observability smoother, while continuing to scale MySQL workloads horizontally with confidence. ✅ Why This Release Matters # F [...]

Monday, 03. November 2025

Scoped Vector Search with the MyVector Plugin for MySQL – Part II (from AskDba)

Subtitle: Schema design, embedding workflows, hybrid search, and performance tradeoffs explained. Quick Recap from Part 1 In Part 1, we introduced the MyVector plugin — a native extension that brings vector embeddings and HNSW-based approximate nearest neighbor (ANN) search into MySQL. We covered how MyVector supports scoped queries (e.g., WHERE user_id = X) to ensure […] [...]

MariaDB vs PostgreSQL: Understanding the Architectural Differences That Matter (from MariaDB Foundation Blog)

pThis blog post is based on the YouTube presentation “MariaDB vs PostgreSQL: Technical Deep Dive | Architecture, Performance & Design Trade-offs” by Manoj Vakeel, part of MariaDB Foundation’s ongoing series exploring core database design choices and how they impact modern workloads. … /p pContinue reading \"MariaDB vs PostgreSQL: Understanding the Architectural Diff [...]

$50 PlanetScale Metal (from PlanetScale Blog)

Introducing $50 PlanetScale Metal [...]

Report on our investigation of the 2025-10-20 incident in AWS us-east-1 (from PlanetScale Blog)

On 2025-10-20, there was an incident that affected PlanetScale, initially caused by DNS misconfiguration in one of PlanetScale’s service providers, followed by several hours of capacity constraints and network instability. [...]

Sunday, 02. November 2025

Checking Your MySQL Server Before an Upgrade with MySQL Shell (from Another Boring Tech Blog)

pUpgrading MySQL is often seen as straightforward — install the new binaries, restart, done. In reality, it’s more like upgrading a production jet engine mid-flight. Small changes in defaults, deprecated settings, or old privileges can lead to surprises you don’t want at 2:00 AM on maintenance night. Or even worse, see your performance deteriorating during.../p pO post Checking Your MySQL Server Be [...]

Saturday, 01. November 2025

Migrating From MySQL To PostgreSQL in Five Simple Steps (from Dave's MySQL Stuff)

pThere are many reasons you may want to migrate from MySQL to PostgreSQL, which we will skip over for brevity.  I see many questions about moving tables and data, and sadly, the answers range from sloppy to incredibly complicated.  Each database migration is unique, as issues range from heavily relying on a vendor's feature to extremely complex schemas that require attention to minute det [...]

When Every AI Agent Needs Its Own Database: Why TiDB Cloud Is the Answer (from siddontang on Medium)

pImagine you’re building an AI startup./ppYour mission?/pblockquoteEmpower every customer to use an AI agent to build their own website — simply by chatting./blockquotepSounds magical — and it is. Products like Manus, Lovable, and others are already doing this. But under the hood, one question quickly becomes a nightmare for engineers:/ppWhere does each AI agent store its data?/ppEvery agent needs [...]

Friday, 31. October 2025

Troubleshooting MariaDB Performance (from MinervaDB Blog)

Troubleshooting MariaDB Performance: A Complete Guide MariaDB performance issues can significantly impact application responsiveness and user experience. Whether you’re experiencing slow queries, high CPU usage, or connection bottlenecks, understanding how to diagnose and resolve these [...] [...]

MariaDB 2025 High Availability Best Practices (from MinervaDB Blog)

MariaDB 2025 High Availability Best Practices High availability (HA) has become a critical requirement for modern database infrastructure. As organizations increasingly rely on MariaDB for mission-critical applications, implementing robust HA strategies ensures continuous service delivery [...] [...]

How Distributed ACID Transactions Work in TiDB (from PingCAP Blog)

pTransactions—especially distributed ACID transactions—are ubiquitous. Protocols around transactions are equally ubiquitous, even if we don’t immediately realize it. Take, for example, a common marriage ceremony. It’s essentially a two-phase commit (2PC) protocol. The officiant is the transaction coordinator (TC), and the couple getting married are the active participants. In the first phase, the T [...]

How to Configure pgBackRest Backups and Restores in PostgreSQL (Local/k8s) Using a MinIO Object Store (from Percona Database Blog)

♦This blog post explains how to configure and use MinIO as S3-compatible storage for managing PostgreSQL backups, and how to perform data restoration and recovery in both standalone (local) and Kubernetes environments. [...]

The clock's ticking for MySQL 8.0 as end of life looms (from The Register)

Percona says more than half of installs remain on version set to lose support in 2026 pUsers have six months to migrate from MySQL 8.0 if they are to stay on a supported version of the open source database, or face security and reliability risks.…/p [...]

Thursday, 30. October 2025

Encryption support in PMM Dump (from Percona Community Blog)

pThe codepmm-dump/code client utility performs a logical backup of the performance metrics collected by the PMM Server and imports them into a different PMM Server instance. PMM Dump allows you to share monitoring data collected by your PMM server with the Percona Support team securely./p pUp until now dumps, created by the tool, were not encrypted. It was possible to encrypt them after they are do [...]

$5 PlanetScale (from PlanetScale Blog)

Introducing the $5 PlanetScale plan. [...]

Last Call: State of MariaDB 2025 Survey (+ New Preview Insights) (from MariaDB Foundation Blog)

pThere are a couple days left until the survey closes – take this as a gentle nudge to participate if you’ve been meaning to 🙂 br Take the survey now! … /p pContinue reading \"Last Call: State of MariaDB 2025 Survey (+ New Preview Insights)\"/p pThe post Last Call: State of MariaDB 2025 Survey (+ New Preview Insights) appeared first on MariaDB.org./p [...]

MySQL Basics: Trust the Process—Mastering Transactions Step by Step (from The Oracle MySQL Blog)

Discover how to use transactions in MySQL to keep your data safe and organized—just like a diligent librarian! This beginner-friendly post explains what transactions are, why they matter, and how to use them with easy library metaphors, clear SQL examples, and essential tips for database reliability. [...]

Wednesday, 29. October 2025

What’s New in MariaDB Enterprise Kubernetes Operator 25.10 (from MariaDB Corporation Blog)

Managing stateful, mission-critical databases on Kubernetes demands automation, reliability and a predictable lifecycle. We’re excited to announce the general availability […] [...]

Zero-Downtime MySQL Certificate Rotation (from Continuent Blog)

Learn how to rotate MySQL SSL/TLS certificates with zero downtime using Tungsten Clustering 7.2.0/8.0.1 and the tpm cert tool, including generating certs, dual-alias rollout, safe node-by-node restarts, SELinux fixes, and cleanup to retire old aliases without interrupting production.Tags: zero-downtime MySQLcertificate rotationtungsten clusterMySQL TLS [...]

No, you probably dont need Kubernetes (from The consistent voice)

pEt ouais, vous ne rêvez pas, je l’affirme en toute confiance. Haut et fort. Sur Linkedin le paradis de la hype et des buzzwords./ppComme le souligne fort justement Nicolas Martinez dans son excellent post, K8s ajoute une couche de complexité souvent inutile :/ppMaintenance lourde, coûts cachés, temps perdu, obligation d’avoir une équipe DevOps/SRE : le jeu en vaut-il la chandelle ?/ppConcernant Ma [...]

How deep can a bug be? (from MariaDB Foundation Blog)

pLast year I filed a bug report MDEV-33603 on what a looked like a benign problem with an optimizer taking a different code path in a particular trivial looking test. … /p pContinue reading \"How deep can a bug be?\"/p pThe post How deep can a bug be? appeared first on MariaDB.org./p [...]

(from DoltHub Blog)

![CDATA[ Modularization is critical for large codebases. If it feels like it's creating barriers, it's actually telling you something important about your code. ]] [...]

Tuesday, 28. October 2025

Performance Engineered: MariaDB Enterprise Server 11.8 Accelerates OLTP Workloads by 2.5x (from MariaDB Corporation Blog)

MariaDB 11.8 delivers up to 2.5x higher OLTP throughput on Dell PowerEdge R7715 servers powered by AMD EPYC™ processors MariaDB […] [...]

Keyword vs. semantic search with AI (from Programming Brain)

How to build keyword and semantic search in MariaDB using Python, LangChain, and AI embeddings. [...]

Practical Data Masking in Percona Server for MySQL 8.4 (from Percona Database Blog)

♦Data masking lets you hide sensitive fields (emails, credit-card numbers, job titles, etc.) while keeping data realistic for reporting, support, or testing. It is particularly useful when you collaborate with external entities and need to share your data for development reasons. You also need to protect your data and keep your customers’ privacy safe. Last […] [...]

Building and testing MySQL 8.0.44 / 8.4.7 / 9.5.0 releases on macOS (from Laurynas Biveinis' blog)

p Oracle MySQL 8.0.44 / 8.4.7 / 9.5.0 are out and it's time for me to build and run their tests on macOS, Apple Silicon hardware. I have skipped the review of the previous set of releases this summer due to personal reasons, so this covers the delta from 8.0.42 / 8.4.5 / 9.3.0, out in spring. /p Build p No need to use any of the bundled 3rd party libraries, and the current XCode (26.0.1) compile [...]

MySQL 9.5 – Thank you for your contributions! (from The Oracle MySQL Blog)

MySQL 9.5 has been released, here is a list of the contributions we included in it. Thank you to all contributors! [...]

MySQL 9.5 – Thank you for your contributions! (from lefred's blog)

On October 10th, 2025, we released MySQL 9.5, the latest Innovation Release. As usual, we released bug fixes for 8.0 and 8.4 LTS, but this post focuses on the newest release. In this release, we can see contributions related to Connector J and Connector Net, as well as to different server categories. Connector / J […] [...]

High Availability with MariaDB Galera Cluster Guide (from Mydbops Blog)

Ensure zero downtime and data consistency with our guide to setting up a MariaDB Galera Cluster, covering installation, configuration, and monitoring. [...]

MySQL Basics: The Inside Track—Speeding Up Searches with Indexes (from The Oracle MySQL Blog)

Unlock the secret to faster data searches with indexes! This post introduces beginners to the power of indexes in MySQL, using friendly library metaphors and simple SQL examples. Learn how—and why—to create indexes, understand their impact, and keep your growing database running at page-turning speed. [...]

Monday, 27. October 2025

Optimize and troubleshoot database performance in Amazon Aurora PostgreSQL by analyzing execution plans using CloudWatch Database Insights (from AWS Database Blog)

In this post, we demonstrate how you can use Amazon CloudWatch Database Insights to analyze your SQL execution plan to troubleshoot and optimize your SQL query performance in an Aurora PostgreSQL cluster. [...]

Effortless Document AI with MySQL HeatWave GenAI (from The Oracle MySQL Blog)

This post demonstrates how you can use HeatWave GenAI to transform an unstructured PDF of a purchase order into a structured, queryable format directly within your database. We'll walk through the process of loading a PO from an object store and then asking natural language questions to retrieve key details like order dates, item costs, and supplier information. [...]

Rethinking Scale: TiDB’s Evolution Into an AI Agent Database (from PingCAP Blog)

pRecently, I’ve been meeting customers across industries including AIaaS, Web3, and FinTech. No matter where I go, the conversation always turns to one thing: AI. Everyone’s asking the same question: “How will AI transform our business, and how does TiDB embrace this change?” So, I started sharing what had been on my mind lately. “The era […]/p pThe post Rethinking Scale: TiD [...]

ClusterControl 2.3.4 Adds MySQL Group Replication, Streamlined Air-Gapped Installation, and Controller Pooling for Scalable Management (from Severalnines Blog)

pWe’re happy to announce the release of ClusterControl v2.3.4, delivering powerful updates that strengthen high availability, secure deployment options, and scalability for enterprise-scale database management.  As with every release, we’ve focused on tackling real-world challenges our users face. Below, we’ll dive into the key features that define this release, followed by additional improvem [...]

How to Replicate TiDB to a Mirrored Database in Microsoft Fabric with TiCDC (from PingCAP Blog)

pTiDB is an open-source distributed SQL database built for cloud-native, data-intensive, and AI-driven applications. It is MySQL compatible and features horizontal scalability, strong consistency, and high availability. By leveraging a TiCDC replication solution for Open Mirroring, TiDB seamlessly integrates with Microsoft Fabric. This unlocks continuous, real-time data synchronization from any TiD [...]

MariaDB Cloud – kicking the tires with openflights data (from MariaDB Foundation Blog)

pMariaDB plc recently acquired SkySQL and rebranded it MariaDB Cloud that offers serverless MariaDB as a service. Kaj Arnö interviewed the technical father, and now it is time for a practical, technical kick-the-tires look at MariaDB Cloud. … /p pContinue reading \"MariaDB Cloud – kicking the tires with openflights data\"/p pThe post MariaDB Cloud – kicking the tires wit [...]

Sunday, 26. October 2025

RAG Series – Agentic RAG (from dbi Blog)

pIntroduction In earlier parts, we moved from Naive RAG (vector search) to Hybrid RAG (dense + sparse) to Adaptive RAG (query classification and dynamic weighting). Each step improved what we retrieve. Agentic RAG goes further: the LLM decides if and when to retrieve at all and can take multiple steps (retrieve → inspect → refine […]/p pL’article RAG Series – Agentic RAG est apparu en premier [...]

Alfresco – When a JDBC driver breaks after years of stability (from dbi Blog)

pA customer recently contacted us regarding an issue with an old Alfresco Enterprise 4.2.2 environment. The system had been running stably for years, with a nightly restart of the Tomcat/Alfresco service to help recycle the memory and fix long-standing issues in this version. Earlier this week, one of these nightly restarts suddenly failed and since […]/p pL’article Alfresco – When a JDBC dri [...]

Do We Really Need RPO = 0 for Regional Disaster Recovery for database services? (from siddontang on Medium)

pA few years ago, if someone told me an entire AWS region could go down, I might have smiled politely and said, “Maybe in theory.” But then it actually happened./pWhen the Unthinkable Became RealitypDuring the world-shaking AWS DynamoDB outage in US-EAST-1, countless engineers across the globe were suddenly thrown into chaos./ppEveryone was frantically refreshing AWS status pages, hoping for one up [...]

Friday, 24. October 2025

How efficient is RocksDB for IO-bound, point-query workloads? (from Small Datum)

pHow efficient is RocksDB for workloads that are IO-bound and read-only? One way to answer this is to measure the CPU overhead from RocksDB as this is extra overhead beyond what libc and the kernel require to perform an IO. Here my focus is on KV pairs that are smaller than the typical RocksDB block size that I use -- 8kb.brbrBy IO efficiency I mean: br    (storage read IOPs from RocksDB [...]

Accelerate Similarity Search with Automatic HeatWave Vector Index (from The Oracle MySQL Blog)

Accelerate Similarity Search with Automatic HeatWave Vector Index [...]

Enhance Your Data Processing with HeatWave Temporary Tables (from The Oracle MySQL Blog)

Enhance Your Data Processing with HeatWave Temporary Tables [...]

Simplify Real-Time Analytics with MySQL HeatWave Auto-Refresh Materialized Views (from The Oracle MySQL Blog)

Simplify Real-Time Analytics with MySQL HeatWave Auto-Refresh Materialized Views [...]

MariaDB Cloud: A Semi-Technical Introduction (from MariaDB Foundation Blog)

pWhen co-founding MariaDB plc under the name SkySQL Corporation fifteen years ago (before MariaDB Foundation existed), we picked the name SkySQL with a bit of a reference to the cloud. … /p pContinue reading \"MariaDB Cloud: A Semi-Technical Introduction\"/p pThe post MariaDB Cloud: A Semi-Technical Introduction appeared first on MariaDB.org./p [...]

(from DoltHub Blog)

![CDATA[ Switch statements in Go have unique features that make it easy to write complex flow controls. Read this blog to see what makes them so special. ]] [...]

Thursday, 23. October 2025

Where can you find MySQL during November 2025 - January 2026! (from The Oracle MySQL Blog)

MySQL events in Nov-Jan 2026 [...]

MySQL Basics: Count Me In—Aggregating and Grouping Your Data (from The Oracle MySQL Blog)

Discover how to use aggregate functions and GROUP BY in MySQL to answer big questions about your data! This post guides beginners through counting, averaging, and categorizing records with friendly library metaphors, clear examples, and humor. A great way to level up your SQL skills and get your data stories told. [...]

Wednesday, 22. October 2025

Schema Changes Made Easy with MySQL Cluster/J 9.4 (from The Oracle MySQL Blog)

Introducing new APIs in Cluster/J to help applications handle schema changes [...]

Introducing MySQL Cluster/J 9.4 (from The Oracle MySQL Blog)

The first of two parts describing new features in Cluster/J, the NoSQL Java development environment for MySQL NDB Cluster. [...]

Introducing MariaDB Exa: 1,000x Faster Analytics on Live Data (from MariaDB Corporation Blog)

The Challenge: Grappling with Growing Datasets We are excited to announce our partnership with Exasol, a collaboration set to revolutionize […] [...]

UUIDv7 and Time-Based Partitioning in PostgreSQL 18 (from MinervaDB Blog)

UUIDv7 and Time-Based Partitioning in PostgreSQL 18: A Complete Guide Introduction: The UUID Evolution That Changes Everything PostgreSQL 18 introduces native support for UUIDv7, a game-changing identifier format that solves one of the database world’s [...] [...]

Faster Recommendations with User & Item Features: MySQL HeatWave's Two Tower Model (from The Oracle MySQL Blog)

We are excited to share how MySQL HeatWave brings powerful recommendation capabilities directly into your database with the integration of the TwoTower model, a deep learning architecture that's become the gold standard for large-scale recommender systems [...]

FromDual Backup and Recovery Manager for MariaDB and MySQL 2.3.2 has been released (from Shinguz's Blog)

pFromDual has the pleasure to announce the release of the new version 2.3.2 of its popular Backup and Recovery Manager for MariaDB and MySQL (codebrman/code)./p pThe new FromDual Backup and Recovery Manager can be downloaded from here. The FromDual Repositories were updated. How to install and use the Backup and Recovery Manager is described in FromDual Backup and Recovery Manager (codebrman/code) [...]

Announcing the Release of MariaDB Enterprise Platform 2026 (from MariaDB Corporation Blog)

We are thrilled to announce the launch of MariaDB Enterprise Platform 2026, establishing MariaDB as the definitive database platform for […] [...]

What the AWS Outage Showed Us: Resilience is Built Across Clouds (from Continuent Blog)

An analysis of the AWS outage and how cross-cloud continuity ensures uptime across cloud providers using solutions like Tungsten Cluster.Tags: cloud resiliencecross-cloud continuityHigh Availabilitymulti-cloud strategy [...]

Tuesday, 21. October 2025

Monitoring multithreaded replication in Amazon RDS for MySQL, Amazon RDS for MariaDB, and Aurora MySQL (from AWS Database Blog)

In this post, we discuss methods to effectively monitor parallel replication performance and tune its related parameters for Amazon Aurora MySQL and Amazon Relational Database Service for MySQL and MariaDB. [...]

Overview and best practices of multithreaded replication in Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon Aurora MySQL (from AWS Database Blog)

In this first post, we dive into the world of MySQL replication, with a special focus on parallel replication techniques. We start with a quick overview of how MySQL replication works, then explore the intricacies of multithreaded replication. We discuss key configuration options and best practices for optimization. [...]

Advanced Database Performance Tuning for MariaDB (from MinervaDB Blog)

Advanced Database Performance Tuning for MariaDB Introduction MariaDB performance tuning is a multi-layered discipline that requires deep understanding of database internals, storage mechanisms, query execution paths, and system-level interactions. Effective optimization can yield performance improvements [...] [...]

Does Your Black Friday Database Scaling Strategy Involve Duct Tape and Prayers? (from Readyset Blog)

Scale MySQL for Black Friday traffic without read replicas. Readyset QueryPilot automates query caching to boost MySQL performance and stability. [...]

How to Stream Data from Kafka to TiDB (from PingCAP Blog)

pModern applications generate enormous amounts of event data with user actions, transactions, logs, and metrics all happening in real time. To handle this scale, many teams rely on Apache Kafka, a distributed messaging system that decouples applications from their data pipelines and ensures reliable, high-throughput data delivery. On the storage side, TiDB provides a distributed SQL [...]

MySQL Basics: Join the Party—Bringing Tables Together with JOINs (from The Oracle MySQL Blog)

Discover how to combine information from multiple tables using JOINs in MySQL! This beginner-friendly guide explains INNER JOINs (and friends) with fun library metaphors, approachable SQL examples, and practical tips to help you unlock the true power of your relational database. [...]

What’s New At Releem - September 2025 (from Releem Blog)

September was a month of momentum. We focused on problems that frustrate every DBA: deadlocks, incomplete visibility, and cloud deployment quirks. We’ve shipped real-time deadlock monitoring, expanded the weekly reports, and fixed key issues with Releem Agent for RDS. [...]

Monday, 20. October 2025

Determine how much concurrency to use on a benchmark for small, medium and large servers (from Small Datum)

pWhat I describe here works for me given my goal, which is to find performance regressions. A benchmark run at low concurrency is used to find regressions from CPU overhead. A benchmark run at high concurrency is used to find regressions from mutex contention. A benchmark run at medium concurrency might help find both./ppMy informal way for classifying servers by size is:/pp/pullismall - has less t [...]

How to Succeed in the MariaDB Python Hackathon, Bangalore (from MariaDB Foundation Blog)

pLast Friday, we hosted an Ask Me Anything session with HackerEarth – and we promised to share the same insights here in written form. So here it is: your guide to success in the MariaDB Python Hackathon! … /p pContinue reading \"How to Succeed in the MariaDB Python Hackathon, Bangalore\"/p pThe post How to Succeed in the MariaDB Python Hackathon, Bangalore appeared first on MariaDB.org [...]

Saturday, 18. October 2025

Measuring scaleup for MariaDB with sysbench (from Small Datum)

pThis post has results to measure scaleup for MariaDB 11.8.3 on a 48-core server./pptl;dr/pp/pulliScaleup is better for range queries than for point queries/liliFor tests where results were less than great, the problem appears to be mutex contention within InnoDB/li/ulp/ppBuilds, Configuration & Hardware/ppThe server has an AMD EPYC 9454P 48-Core Processor with AMD SMT disabled, 128G of RAM and [...]

Measuring scaleup for Postgres 18.0 with sysbench (from Small Datum)

pThis post has results to measure scaleup for Postgres 18.0 on a 48-core server./pptl;dr/pp/pulliPostgres continues to be boring (in a good way)/liliResults are mostly excellent/liliA few of the range query tests have a scaleup that is less than great but I need time to debug/li/ulpBuilds, Configuration & Hardware/ppThe server has an AMD EPYC 9454P 48-Core Processor with AMD SMT disabled, 128G [...]

Ten Years, Starting Again: My Journey with TiDB (from siddontang on Medium)

pThe most precious things in life are memories and reflection. After we released the next generation TiDB Cloud, I think it is time for some reflection./ppTime flies — ten years have passed. On April 1, 2015, Max asked me, very seriously on April Fools’ Day, “Do you want to start a company together?” From that moment, I jumped on the TiDB train. The ride has been bumpy and brilliant./ppIn these ten [...]

From Events to Impact: The Power of Shared Ownership (from siddontang on Medium)

pThe Blame Game After Every Event/ppContinue reading on Medium »/p [...]

SQL Anti-Patterns You Should Avoid (from One-Time MySQL Community/Ecosystem Posts)

Today, I will be talking about some of the common and high impact SQL anti-patterns I have seen from experience that can make queries and pipelines difficult to maintain, or have slower than expected performance. [...]

Friday, 17. October 2025

My Impressions from Oracle AI World 2025 – MySQL, AI, and Its Open Source Future (from Another Boring Tech Blog)

pNote: The opinions below represent my personal perspective only. They don’t include any confidential information or represent the views of Oracle or my current employer, Percona.   The question I brought home after this conference is: Was this an AI conference because everyone is already using AI, or because they want you to use AI?.../p pO post My Impressions from Oracle AI World 2025 – MySQ [...]

MySQL HeatWave feature announcements at Oracle AI World (from The Oracle MySQL Blog)

MySQL HeatWave feature announcements at Oracle AI World [...]

Welcoming Wolf Software Systems Ltd as a New Sponsor of the MariaDB Foundation (from MariaDB Foundation Blog)

pWe are excited to announce that Wolf Software Systems Ltd has joined the MariaDB Foundation as a new Silver sponsor! Their support helps strengthen our shared mission of advancing open-source database technology, and we warmly welcome them into our community. … /p pContinue reading \"Welcoming Wolf Software Systems Ltd as a New Sponsor of the MariaDB Foundation\"/p pThe post Welcoming Wolf S [...]

Thursday, 16. October 2025

Is MariaDB Used in Production? Real-World Setups, Proof & AI (from MariaDB Corporation Blog)

When interacting face-to-face with developers at meetups and conferences, I frequently get asked whether MariaDB is used in production for […] [...]

Why is RocksDB spending so much time handling page faults? (from Small Datum)

pThis week I was running benchmarks to understand how fast RocksDB could do IO, and then compared that to fio to understand the CPU overhead added by RocksDB. While looking at flamegraphs taken during the benchmark I was confused that about 20% of the samples were from page fault handling. This confused me at first.brbrThe lesson here is to run your benchmark long enough to reach a steady state bef [...]

Database Sharding Explained: Strategies for Scalable SQL Performance (from PingCAP Blog)

pDatabase sharding is a data architecture strategy that increases database performance by splitting up data into chunks and then spreading these chunks “intelligently” across multiple database servers (or database instances). These chunks of data are called shards, while each shard contains a subset of our data. All shards represent the entire set of data, and […]/p pThe post Database Shardin [...]

How Readyset Handles Window Functions Under the Hood (from Readyset Blog)

Learn how Readyset optimizes SQL Window Functions for faster, scalable queries on MySQL and Postgres with no code changes. [...]

Performance optimization strategies for MySQL on Amazon RDS (from AWS Database Blog)

In this post, we share infrastructure-level optimizations, RDS-specific performance features, and database design patterns to help improve MySQL performance on Amazon RDS. We focus on practical configurations and monitoring techniques that complement existing parameter tuning documentation, helping you make informed decisions for your specific workload requirements. [...]

Change Data Capture (CDC): A Complete Guide for Modern Data Teams (from PingCAP Blog)

pIn the areas of data management and real-time analytics, Change Data Capture (CDC) has become an indispensable tool. CDC is a software operation that enables you to monitor and record changes in your source database. From there, you can subsequently apply those changes to your target database. These changes could be new records, updates, or […]/p pThe post Change Data Capture (CDC): A Comple [...]

Supercharge MySQL: Introducing WebAssembly Integration for Next-Gen Data Apps (from The Oracle MySQL Blog)

This blog post introduces WebAssembly (Wasm) support in MySQL Heatwave! For the first time, you can bring high-performance, portable code, compiled from Rust, C++, and many more languages, directly to your MySQL data, unlocking a new universe of speed, flexibility, and innovation. [...]

MySQL HeatWave and MySQL AI integration with Model Context Protocol (from The Oracle MySQL Blog)

This blog is focused on Model Context Protocol (MCP). MCP is an open standard enabling seamless integration between applications powered by large language models (LLMs) and external data sources and/or tools. The MySQL HeatWave MCP Server provides a collection of specialized tools that help you leverage the full capabilities of both MySQL HeatWave and MySQL AI. [...]

Introducing Delta Lake in MySQL HeatWave Lakehouse (from The Oracle MySQL Blog)

MySQL HeatWave Lakehouse enables queries on file formats like Parquet, Avro, ND-JSON and CSV in an object store. This blog introduces support for the Delta Lake table format, thereby enabling ACID-compliant applications on data in the object store. [...]

Semantic and Keyword—Hybrid Search in MySQL HeatWave (from The Oracle MySQL Blog)

This blog explains Hybrid Search capabilities within MySQL HeatWave, describing how it combines the strengths of keyword-based (BM25) and semantic (embedding) search. It explains the benefits for advanced information retrieval and Retrieval Augmented Generation (RAG) pipelines, highlighting how hybrid search supports complex business scenarios that require both contextual understanding and exact ma [...]

This Month in MariaDB Foundation: September 2025 (from MariaDB Foundation Blog)

pSeptember was a month of big ideas, long-term thinking, and vibrant community energy for the MariaDB Foundation. Our Board of Directors met for what may well have been the most strategic session in Foundation history – … /p pContinue reading \"This Month in MariaDB Foundation: September 2025\"/p pThe post This Month in MariaDB Foundation: September 2025 appeared first on MariaDB.org./p [...]

Riding the Waves – the MariaDB adoption index in October 2025 (from MariaDB Foundation Blog)

pEven positive trends have hiccups. Last month we celebrated “onwards and upwards”. This month the adoption index took a bit of a knock. … /p pContinue reading \"Riding the Waves – the MariaDB adoption index in October 2025\"/p pThe post Riding the Waves – the MariaDB adoption index in October 2025 appeared first on MariaDB.org./p [...]

MySQL Basics: The Keys to the Kingdom—Primary and Foreign Keys Explained (from The Oracle MySQL Blog)

Unlock the secrets to reliable databases with primary and foreign keys! This beginner-friendly post uses engaging library metaphors and approachable SQL examples to show how keys keep your MySQL tables organized and your data relationships strong. Learn how to build, enforce, and practice these essential building blocks in your own projects. [...]

Wednesday, 15. October 2025

Streamlining GenAI and ML Application Development with the MySQL HeatWave Python SDK (from The Oracle MySQL Blog)

This document provides a walk-through of the MySQL HeatWave Python SDK. It offers helpful tips on how to use the SDK to accelerate your application development culminating in three demonstrations of developing applications to solve real-world problems with, a Retrieval Augmented Generation (RAG) bot, an LLM-based agent with tool-calling, and a machine learning pipeline for fraud detection. [...]

MySQL HeatWave Now FedRAMP Authorized and Live in OCI Government Realms (from The Oracle MySQL Blog)

Big news for our public sector customers! Oracle's MySQL HeatWave has achieved Authorization to Operate (ATO) in both the OC2 (FedRAMP High / DISA IL4) and OC3 (DISA IL5) realms of the Oracle Cloud Infrastructure (OCI) Government Cloud. This is a massive milestone that unlocks powerful new capabilities for government agencies, contractors, and other public sector organizations. Let's break down wha [...]

Top 50 MySQL Interview Questions and Answers for Every Skill Level  (from Devart MySQL Tool Blog)

pExplore the top 50 MySQL interview questions and answers fit both for newbies and experienced devs. Get prepared with real-world MySQL queries./p pThe post Top 50 MySQL Interview Questions and Answers for Every Skill Level  appeared first on Devart Blog./p [...]

Custom Port Support in Azure Database for MySQL – Flexible Server is Now Generally Available (from Azure for MySQL Blog)

pWe are excited to announce that custom port support for Azure Database for MySQL – Flexible Server is now generally available (GA). This long-requested feature gives you greater flexibility to align MySQL server deployments with your network and security requirements. By default, MySQL uses TCP port 3306; with this GA release, you can configure a custom port (between 25001 and 26000) when cre [...]

SaaS Multi-Region MySQL: Operational Excellence & Monitoring (from Continuent Blog)

A deep dive into operational excellence and monitoring strategies for multi-region MySQL in SaaS environments — including deployment automation, observability, compliance, and recovery best practices.Tags: multi-region mysqlSaaS operationsMySQL monitoringdatabase automationcompliance monitoringDisaster Recovery [...]

7 newer data science tools you should be using with Python (from InfoWorld)

pPython’s rich ecosystem of data science tools is a big draw for users. The only downside of such a broad and deep collection is that sometimes the best tools can get overlooked./p pHere’s a rundown of some of the best newer or less-known data science projects available for Python. Some, like Polars, are getting more attention but still deserve wider notice. Others, like C [...]

Sneak preview of State of MariaDB 2025 – survey still open! (from MariaDB Foundation Blog)

pThe State of MariaDB 2025 survey is well underway, and the insights are fascinating. Thank you to all who have participated so far! If you haven’t yet, the survey is open at: mariadb.typeform.com/survey-2025?utm_source=blogprvbr Take the survey now! … /p pContinue reading \"Sneak preview of State of MariaDB 2025 – survey still open!\"/p pThe post Sneak preview of State of MariaDB [...]

Amazon RDS for MySQL and PostgreSQL zero-ETL integration with Amazon Redshift now available in 8 additional regions (from AWS What's New)

pAmazon RDS for MySQL and Amazon RDS for PostgreSQL zero-ETL integration with Amazon Redshift is now available in the Asia Pacific (Hyderabad), Asia Pacific (Jakarta), Asia Pacific (Melbourne), Canada West (Calgary), Europe (Spain), Europe (Zurich), Israel (Tel Aviv), and Middle East (UAE) regions. Zero-ETL integrations enable near real-time analytics and machine learning (ML) on petabytes of trans [...]

(from DoltHub Blog)

![CDATA[ We've been testing out generative AI tooling and in this blog post we take a look at Replit's conversational web app builder and compare it to Vercel's v0.app. We build a small web app that loads data from a Dolt database, and use Dolt's version-control features to expose that version information in the web application. Read on to learn more about how the Replit experience compares to Verc [...]

Tuesday, 14. October 2025

Security Advisory: CVE Affecting Percona Monitoring and Management (PMM) (from Percona Database Blog)

♦A critical security vulnerability has been identified in the following software that Percona has made available and that you may be using:  PMM 3.x installations (that is, 3.0 and forward). The Common Vulnerabilities and Exposures (CVE) identifier for this issue is on request from mitre.org. Vulnerability details We were notified via an external report that […] [...]

MySQL HeatWave 9.4.2 - Improvements In Reloading Data Into The HeatWave Cluster After Rebooting (from The Oracle MySQL Blog)

This blog post explains the in-memory data cluster reloading improvements of MySQL HeatWave version 9.4.2 [...]

Amazon Aurora MySQL zero-ETL integration with Amazon SageMaker Lakehouse (from AWS Database Blog)

In this post, we explore how zero-ETL integration works, the key benefits it delivers for data-driven teams, and how it aligns with the broader zero-ETL strategy in AWS services. You'll learn how this integration can enhance your data workflows, whether you're building predictive models, entering interactive SQL queries, or visualizing business trends. By eliminating traditional extract, transform, [...]

Is it time for TPC-BLOB? (from Small Datum)

pIf you want to store vectors in your database then what you store as a row, KV pair or document is likely to be larger than the fixed-page size (when your DBMS uses fixed-page sizes) and you will soon care about efficient and performant support for large objects. I assume this support hasn't been the top priority for many DBMS implementations and there will be some performance bugs./ppIn a SQL DBM [...]

TiDB Cloud Essential Now Available in Public Preview on AWS and Alibaba Cloud (from PingCAP Blog)

pTiDB Cloud Essential is our new plan for teams that need a stronger balance of scalability, performance, and security than TiDB Cloud Starter, without the full enterprise surface area of TiDB Cloud Dedicated. Starting today, you can now provision fixed Request Capacity Units (RCUs) for predictable performance, grow instantly when you need more headroom, and […]/p pThe post TiDB Cloud Essenti [...]

Modular Magic: Reusing Code in MySQL with the New LIBRARY Feature (from The Oracle MySQL Blog)

An overview of Library Feature in the MySQL HeatWave managed cloud service and elsewhere. [...]

From MEM to Automation: Managing MySQL Enterprise with ClusterControl (from Severalnines Blog)

pWhen Oracle announced the deprecation of MySQL Enterprise Monitor (MEM), many organizations running MySQL Enterprise Server suddenly faced a gap in their operations stack. MEM had long been part of the Enterprise subscription, providing monitoring and limited automation. Now, DBAs and DevOps teams must look elsewhere for visibility and control. The good news? Moving away […]/p pThe post From [...]

Querying the Unstructured: Natural Language to SQL for JSON Data (from MySQL expert Diary)

pBridging natural language processing with semi-structured data brings both opportunity and complexity./p pMySQL HeatWave GenAI’s NL2SQL feature shows how natural language can simplify data interaction — even for JSON documents. Yet, because JSON embeds both data and metadata within a single column, LLMs may struggle without explicit schema cues./p pBy creating well-structured views that reveal JSO [...]

MySQL Basics: Turning the Page—Using LIMIT and OFFSET for Pagination (from The Oracle MySQL Blog)

Discover how to tame big tables using LIMIT and OFFSET in MySQL! This post makes pagination easy for newcomers, using friendly library metaphors, step-by-step SQL examples, and practical tips to help you view your data one page at a time. [...]

(from DoltHub Blog)

![CDATA[ Dolt now officially supports a wide range of MariaDB clients, verified through automated CI testing. ]] [...]

Benchmarking Postgres 17 vs 18 (from PlanetScale Blog)

Postgres 18 brings a significant improvement to read performance via async I/O and I/O worker threads. Here we compare its performance to Postgres 17. [...]

Monday, 13. October 2025

Removing the index guesstimate with MySQL Autopilot Indexing (from The Oracle MySQL Blog)

This blog post introduces the MySQL Autopilot Indexing feature. [...]

Interact with MySQL in natural language (from The Oracle MySQL Blog)

We are excited to announce the release of Natural Language to SQL (NL2SQL) capability for MySQL (with the AI option) and MySQL HeatWave cloud service. Natural language interface is essential for modern data platforms, allowing users to explore information more quickly. [...]

Top ideas in the MariaDB-Python hackathon (from MariaDB Foundation Blog)

pAs we blogged last week, the ideation phase of the MariaDB-Python hackathon ended with a heap of ideas. Due to the sheer mass, we had a tough time evaluating suitable ideas and teams for the development phase. … /p pContinue reading \"Top ideas in the MariaDB-Python hackathon\"/p pThe post Top ideas in the MariaDB-Python hackathon appeared first on MariaDB.org./p [...]

Build a Smart Weather Agent with LangChain and MySQL HeatWave GenAI (from The Oracle MySQL Blog)

This article showcases the power of combining the LangChain framework with an LLM hosted on MySQL HeatWave GenAI. Our goal is to create an agent that can answer the question, "What is the current weather in Fahrenheit?". To do this, the agent must first fetch the weather (which is in Celsius) and then convert it to Fahrenheit, a classic multi-step task. This agent will demonstrate how a Large Langu [...]

Build a RAG System with LangChain and MySQL HeatWave GenAI (from The Oracle MySQL Blog)

This post will guide you through building a simple RAG workflow using the popular LangChain framework, powered entirely by the in-database AI capabilities of MySQL HeatWave GenAI. We will ingest a public blog post, index it in the HeatWave Vector Store, and use a HeatWave-hosted LLM to answer questions based on its content following the LangChain guide to creating vector stores and using them for [...]

Friday, 10. October 2025

Updated MariaDB ODBC, Python, and Node.js Connectors now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/ODBC 3.2.7, Connector/Python 1.1.14, and Connector/Node.js 3.5.0. MariaDB Connector/ODBC 3.2.7 […] [...]

Do You Need An AI Assistant? (from Dave's MySQL Stuff)

p/pbrbr Artificial Intelligence has been over hyped the last several years. But one of the bright, shining spots for AI is acting as an assistant. a super-powerful IDE, when working with a database.p/pExamplepYou want to find your top three customers in the Sakila database. This database has been used for decades in the MySQL world./ppAs your question in English (or another language)/p♦The '@a [...]

On Teaching MySQL. Q&A with Michael Scott Brown (from ODBMS.org)

Q1. From your experience managing the Database System Technology Masters program and teaching at diverse institutions ranging from community colleges to Division I universities, how have you seen the role of MySQL evolve in database... [...]

Thursday, 09. October 2025

Advanced observability and troubleshooting with Amazon RDS event monitoring pipelines (from AWS Database Blog)

AWS provides a wide range of monitoring solutions for your Amazon RDS and Amazon Aurora instances, such as Amazon CloudWatch, Amazon CloudWatch Database Insights, and AWS CloudTrail. Amazon RDS event monitoring pipelines make troubleshooting operational events like reboots, errors, and failovers more efficient. In this post, we present a solution to get a head start on troubleshooting by sending an [...]

September 2025 Recap: Azure Database for MySQL (from Azure for MySQL Blog)

pJoin us live on our YouTube channel on October 15, 2025 for an exclusive webinar where we’ll dive deeper into the latest Azure Database for MySQL updates and answer your questions! Watch it live here./p Support for In-Place Major Version Upgrade from 8.0 to 8.4 pWe previously announced that Azure Database for MySQL version 8.4 is now generally available. We’re now happy to share that in- [...]

MySQL Basics: WHERE’s the Data? Filtering Results with WHERE Clauses (from The Oracle MySQL Blog)

Ready to grow your querying skills? This post introduces curious newcomers to the WHERE clause in MySQL, showing how simple conditions, clever operators, and cheerful library metaphors can help you filter data like a pro. Find the exact records you need using approachable SQL examples—no dusty catalogs required! [...]

(from DoltHub Blog)

![CDATA[ In this post, I'll walk you through my experience building an AI agent that can import data into Dolt. ]] [...]

Wednesday, 08. October 2025

Here’s the Message I Sent Welcoming Percona’s New CEO Peter Farkas (from Peter Zaitsev)

pFirst, I want to give a big thank-you to Bennie Grant, who has been our Interim CEO over the past few months. Stepping into the CEO role is never easy — and doing it on an interim basis can be even tougher. Bennie, we’re grateful for the way you’ve helped steer us through this transition […]/p pThe post Here’s the Message I Sent Welcoming Percona’s New CEO Peter Farkas appeared first o [...]

Introducing TiDB X: A New Foundation for Distributed SQL in the Era of AI (from PingCAP Blog)

pAsk any engineering team managing a modern application today, and you’ll hear the same frustrations: traffic spikes that can’t be predicted, autoscalers that react too slowly, and workloads that look nothing like they did yesterday. One hour you’re processing transactions, the next you’re serving analytical or vector queries — all in real time, all under […]/p pThe post Introducing TiDB X: A [...]

What’s New in MySQL HeatWave on AWS? (from The Oracle MySQL Blog)

We’re introducing a powerful set of enhancements aimed at boosting service availability and manageability thereby simplifying migrations from AWS Aurora, RDS, or MySQL on EC2, and improving performance. [...]

From Vision to Action: Strengthening the MariaDB Foundation Board – Welcome, Frank Karlitschek! (from MariaDB Foundation Blog)

pStrengthening the Board with industry leaders is a key goal for the MariaDB Foundation in 2025 – and beyond./p pAt the MariaDB Foundation, we believe that leadership in open source isn’t just about code — … /p pContinue reading \"From Vision to Action: Strengthening the MariaDB Foundation Board – Welcome, Frank Karlitschek!\"/p pThe post From Vision to Action: Strengthening [...]

Why MySQL on Kubernetes Fails Without the Right Operator (from Continuent Blog)

Challenges of running MySQL on Kubernetes and how Operators ensure reliability through replication, failover, and observability.Tags: kubernetesoperatorMySQL [...]

Tuning BLOB for performance in NDB [Part 2] (from The Oracle MySQL Blog)

This blog post shows the performance evaluation of the BLOB_INLINE_SIZE column option for NDB tables in comparison without it, as well as the benefits of batching BLOB read and writes. [...]

What is JPA? Introduction to Java persistence (from InfoWorld)

pThe Jakarta Persistence API (JPA) is a specification that defines a standardized framework for data persistence. Persistence is the fundamental mechanism for saving and retrieving data over time. In Java, the data we persist is held in objects. The JPA specification lets you define how your objects will be persisted while leaving the work itself to an underlying framework. /p [...]

Audit Log Filters Part II (from Percona Community Blog)

pIn my first post on the MySQL 8.4 Audit Log Filter component, I covered how to install the component and configure a basic filter that captures all events. The Audit Log Filter framework offers a highly granular and configurable auditing mechanism, enabling administrators to log specific events based on criteria such as user, host, or event type. This selective approach enhances observability, sup [...]

Tuesday, 07. October 2025

Celebrating a New Chapter: Percona Welcomes Peter Farkas as its New Chief Executive Officer (from One-Time MySQL Community/Ecosystem Posts)

Today, we are excited to announce that Peter Farkas will serve as Percona’s new Chief Executive Officer, where he will build on the company’s long-standing track record of success with an eye toward continuous innovation and growth. [...]

MySQL Basics: Seek and You Shall SELECT—Retrieving Data from Your Tables (from The Oracle MySQL Blog)

Curious about what's inside your MySQL tables? This post introduces beginners to the SELECT statement, using friendly library metaphors, approachable SQL examples, and helpful tips—including how to alias column names. Get ready to start exploring your data with confidence! [...]

Impressive stats from ideation phase of Bengaluru Python hackathon, now closed (from MariaDB Foundation Blog)

pThe ideation phase of the MariaDB-Python Hackathon wrapped up on Sunday — and the response was phenomenal!br A huge thanks to everyone who joined the journey: from the BangPypers’ … /p pContinue reading \"Impressive stats from ideation phase of Bengaluru Python hackathon, now closed\"/p pThe post Impressive stats from ideation phase of Bengaluru Python hackathon, now closed appea [...]

Let Your AI DBA Assistant Write Your MySQL Queries (from MySQL expert Diary)

pHaving explored the innovative MySQL HeatWave technology that converts Natural Language into SQL (Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave), our next article in this series, dives into a practical use case demonstrating how an AI DBA Assistant can significantly simplify your query generation workflow. In MySQL, there are 3 specialized […]/p The post Let Your AI D [...]

Why TiDB Is the Best Database for AI as a Service(AIaaS) (from siddontang on Medium)

pRecently, I visisted many customers, like AIaaS, Web3, Fintech, etc, different industires, but the same topic. No matter who I talked to, the conversation invevitably turned to AI./ppEveryone is trying to figure out how AI will help their bussiness, and wants to know how TiDB embraces AI. (Notice: feel free to visit TiDB Cloud to experience the TiDB x AI journey immediately)./ppSo I started to sha [...]

(from DoltHub Blog)

![CDATA[ Running Bats on Windows can be tricky, but with GoLand and BashSupportPro, you can run Bats tests with a single click. ]] [...]

Monday, 06. October 2025

September Product Update (from Readyset Blog)

♦pSpooky season is here, and so are the latest updates from Readyset:  /pQueryPilot Demo: It's Not Broken, It's Just That Fast. pQueryPilot automatically finds and optimizes your most expensive queries with zero manual tuning or configuration. Its performance is so instant that results are/p [...]

Optimizing queries by using observability (from InfoWorld)

pIn a modern enterprise data environment, the increasing volume of data, distributed architecture, and complex application dependencies challenge traditional query-tuning methods. Observability enhances query optimization by providing constant, fine-grained visibility into query behavior, resource consumption, and systemic interactions. Taking advantage of this data shifts th [...]

Launching the State of MariaDB 2025 survey (from MariaDB Foundation Blog)

pWe want to know how you’re really using MariaDB. Not the marketing version. Not the idealized case study. The real story—what you’re building, what tools you’re using, what’s working, and what’s frustrating. … /p pContinue reading \"Launching the State of MariaDB 2025 survey\"/p pThe post Launching the State of MariaDB 2025 survey appeared first on MariaDB [...]

Introducing Tungsten Dashboard v8.0.2 (from Continuent Blog)

Tungsten Dashboard v8.0.2 introduces major performance improvements, real-time cluster visibility, and enhanced usability with an intuitive Add/Edit Cluster workflow, namespace visibility, and configurable light/dark themes. The release also includes a redesigned installer with configuration reset, Docker Compose plugin support, and self-signed certificate generation. New tools like collect-diag.pl [...]

Introducing Tungsten Cluster & Tungsten Replicator v8.0.1 (from Continuent Blog)

Tungsten Cluster & Tungsten Replicator v8.0.1 focus on improving security, configuration management, and observability. The release introduces tpm INI upgrade and validation enhancements, dual MySQL SSL certificate for seamless certificate rotation, and new Prometheus metrics for deeper Replicator insights. It also delivers multiple CLI and stability fixes and adds certification for MariaDB 11. [...]

Sunday, 05. October 2025

Performance Framework Autobench3's Profiler Runner – MySQL Benchmarking Series #5 (from One-Time MySQL Community/Ecosystem Posts)

When chasing changes in performance, it’s not enough to know which commit introduced the change — we need to understand how it has changed workloads. [...]

Friday, 03. October 2025

When Oracle Drops the Ball: Why MariaDB is the Future of the MySQL World (from MariaDB Foundation Blog)

pThe news has circulated quietly in industry corners, but the implications are far too significant to brush aside: Oracle seems to have ended the Open Source era of MySQL. … /p pContinue reading \"When Oracle Drops the Ball: Why MariaDB is the Future of the MySQL World\"/p pThe post When Oracle Drops the Ball: Why MariaDB is the Future of the MySQL World appeared first on MariaDB.org./p [...]

Get Ready for MySQL HeatWave at Oracle AI World 2025! (from The Oracle MySQL Blog)

This blog gives you a complete overview of MySQL HeatWave sessions so you can plan your agenda, mark your calendar, and make the most of the event. [...]

(from DoltHub Blog)

![CDATA[ We loaded 100 real world Postgres dumps and failed almost all of them. Read more to find out why we did this, and how we're solving these issues. ]] [...]

Thursday, 02. October 2025

MariaDB C++ Connector 1.1.7 and 1.0.6 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/C++ 1.1.7 and 1.0.6 releases. Release Notes MariaDB Connector/C++ […] [...]

Data Integrity in a Database: How to Ensure Accuracy and Security (from Devart MySQL Tool Blog)

pLearn what data integrity in DBMS means, why it’s vital for database accuracy, and how to maintain it effectively. Read on to protect your data now./p pThe post Data Integrity in a Database: How to Ensure Accuracy and Security appeared first on Devart Blog./p [...]