Planet MariaDB Server

My first experiments creating an MCP Server to provide AI access to a PostgreSQL database using the FastMCP Python framework and Anthropic’s and OpenAI’s APIs highlighted an important requirement: for now, these two APIs can only communicate with an MCP server through HTTPS over a public URL. While researching how to make this work (which […]… Read more

The Ford–Cadillac Parable In 1902, Henry Ford’s second car company was taken over by investors and renamed Cadillac. The designs were his. The engineering was his. … Continue reading "“I Am Not Building Cadillacs Anymore”" The post “I Am Not Building Cadillacs Anymore” appeared first on MariaDB.org…. Read more

Some Connector/C options can have better explanations than what’s in the MySQL or MariaDB manuals. Here they are. Files Putting together the MySQL and MariaDB Connector/C manuals’ words, Connector/C reads these files in this order: /etc/my.cnf MYSQL always. MariaDB only if DEFAULT_SYSCONFDIR not defined /etc/mysql/my.cnf MySQL always. MariaDB only if DEFAULT_SYSCONFDIR not defined SYSCONFDIR/my.cnf MYSQL… Continue Reading Options for MySQL or MariaDB Connector C libraries… Read more

What happens when your new application needs a production-ready database cluster in hours, not days? If you’re relying on traditional deployment methods that involve manual provisioning, tedious configuration, and complex integrations, then good luck. But what if you could achieve cloud-like deployment speeds for your database infrastructure, whether it’s on bare metal, virtual machines, or […] The post How to rapidly deploy databases on bare metal, VMs, and containers appeared first on Severalnines…. Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Python 1.1.13 release. Release Notes MariaDB Connector/Python 1.1.13 MariaDB […]… Read more

The process goes like this: Running the MariaDB MCP Server using Docker Compose You can start a MariaDB MCP Server […]… Read more

I beat the MariaDB optimizer: from 94 seconds to just 55 millisecondsSome client of mine recently migrated from MySQL 8 to MariaDB 11.4CS. YAY to them !!!!As a side effect, this particular query saw a massive performance drop down to 1min 34sec from 148ms. NAY to this !!!!SELECT sd.ID, sd.NUMERO_DOSSIER, sd.LAST_SYNC_DATE, sd.NS_REFERENCE, sd.METIER, sd.STATUS, sd.IS_SCHEDULEDFROM schema1.sync_dossier sdLEFT JOIN schema2.dossier dON d.NUMERO_DOSSIER = sd.NUMERO_DOSSIERWHERE d.NUMERO_DOSSIER IS NULL AND sd.METIER = "sps"LIMIT 10;It is decently easy to understand why : LEFT JOINs with searching only for NULL values usually means you have to read the whole table (or an index in the best case scenario)… Read more

We are thrilled to announce that Rumahweb, one of Indonesia’s most trusted and long-standing web hosting providers, has joined the MariaDB Foundation as a Silver Sponsor. … Continue reading "MariaDB Foundation Welcomes Rumahweb as a Silver Sponsor" The post MariaDB Foundation Welcomes Rumahweb as a Silver Sponsor appeared first on MariaDB.org…. Read more

For historical reasons, the handling of FOREIGN KEY constraints in MariaDB Server is somewhat peculiar. Unlike CHECK constraints, which are being enforced at the query execution layer for all tables, FOREIGN KEY constraint definitions will simply be ignored unless the underlying storage engine supports them. … Continue reading "Per-table unique FOREIGN KEY constraint names – new feature in MariaDB 12.1" The post Per-table unique FOREIGN KEY constraint names – new feature in MariaDB 12.1 appeared first on MariaDB.org…. Read more

At some point, nearly every developer encounters a common challenge: working with deeply nested JSON only to run into an arbitrary depth limit imposed by the database. … Continue reading "Make JSON DEPTH unlimited – new feature in MariaDB 12.1" The post Make JSON DEPTH unlimited – new feature in MariaDB 12.1 appeared first on MariaDB.org…. Read more

In Part 1 of this series, we discussed what active-active databases are and identified some “good” reasons for considering them, primarily centered around extreme high availability and critical write availability during regional outages. Now, let’s turn our attention to the less compelling justifications and the substantial challenges that come with implementing such a setup. What are “bad” reasons? 1. Scaling write throughput Trying to scale your write capacity by deploying active-active across regions may sound like a clean horizontal solution, but it is rarely that simple. Write coordination, conflict resolution, and replication overhead introduce latency that defeats the purpose.
If you… Read more

MariaDB’s new unified documentation platform, at mariadb.com/docs/, centralizes all Knowledge Base and Enterprise Documentation onto a modern website. It offers a consistent look, streamlined navigation, AI-powered search, quickstart guides, version-specific tabs, and improved community contributions via GitHub. For years, MariaDB users have navigated documentation that resided in various… Source… Read more

making MariaDB cloud native : a (fairy ?) tale of decoupling compute from storageSince my early days with MariaDB, i loved the internal deisgn of the server, especially the link in between execution plan and data retrieval from storage. For thos who dont know, as displayed in the schema below, MariaDB (and MySQL of course) treats storage as plugin. Which means Monty & friends had to think of a standardized way to lookup and fetch datas : they basically created a storage agnostic data retrieval API. This soft decoupling of “SQL” layer and the physical retrieval of datas is such a powerful and elegant… Read more

We’re pleased to share the release of ClusterControl v2.3.3, introducing major enhancements for elevated user privileges with Privileged Access Management integration of BeyondTrust’s PowerBroker pbrun, as well as support for MongoDB 8.0 and MariaDB 11.8 major versions and dark mode for our recently added Watchlists feature. PowerBroker pbrun integration pbrun is a command-line utility provided […] The post ClusterControl now supports PowerBroker pbrun for secure privilege management appeared first on Severalnines…. Read more

Years ago, it was extremely common to store user-uploaded images and other multimedia contents in a database. This practice became less common over time, but I still hear questions like: would it be a bad idea to store images in our database? Or, more specifically: how bad would it be to store images in a database? In this article, we’ll discuss the pros and cons. TL;DR: No, you shouldn’t store images in a database. But it’s a very simple solution, so in your team is undersized or your website is trivial, keep reading. Pros Yes, there are obvious pros in… Read more