Planet MariaDB Server

We live in a world where national interests intertwine with IT vendor interests. Interest is currently booming in “European Alternatives“. I’m happy to note that MariaDB Server is unaffected by considerations related to protectionism. … Continue reading "MariaDB, an Open Source Alternative" The post MariaDB, an Open Source Alternative appeared first on MariaDB.org…. Read more

Exactly one month ago, I found myself stepping into the role of CEO at MariaDB Foundation. It was a bit like being handed the keys to a beloved old ship and being told, “Don’t worry, it mostly steers itself… … Continue reading "The Accidental Queen of the Database Dominion – Month one" The post The Accidental Queen of the Database Dominion – Month one appeared first on MariaDB.org…. Read more

The ideation phase of the MariaDB AI RAG Hackathon is nearing its deadline on Monday (by end of March).  We have several cool submissions so far. … Continue reading "Last chance to apply to AI RAG Hackathon" The post Last chance to apply to AI RAG Hackathon appeared first on MariaDB.org…. Read more

The MySQL library is libmysqlclient.so, the MariaDB library is libmariadbclient.so or libmariadb.so. I’ll list some quirks that I think are relatively unknown but good to know. I’ll end with a pointer to a function that’s good to have. mysql and mariadb clients don’t themselves use .so libraries To illustrate, here’s the file mysql.dir/link.txt that I… Continue Reading MySQL and MariaDB client .so libraries on Linux… Read more

I recently shared two posts (here and here) with results for sysbench on a large server using Postgres versions 10 through 17. In general there were several large improvements over time, but one small regression that arrived in Postgres 11.x. This blog post provides more details on the problem using results from Postgres 10.23, 11.22 and 17.4.The regression occurs starting in Postgres 11.22 because Postgres is more likely to use bitmap index scan starting in 11.x. I have yet to learn why or how to prevent that.Index scan vs bitmap index scanExperts gave me great advice based on a few… Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.5.3, 3.4.2, and 3.3.4 releases. Download Now Release … Continued… Read more

In a recent conversation, I had the pleasure of speaking with Michal Schorm, the maintainer of MariaDB packages for Red Hat and Fedora – and newly elected Observer on the MariaDB Foundation Board. … Continue reading "A Conversation with Michal Schorm: MariaDB in Red Hat and Fedora" The post A Conversation with Michal Schorm: MariaDB in Red Hat and Fedora appeared first on MariaDB.org…. Read more

MariaDB has had a voting feature in its issue tracker Jira since the dawn of time, but it hasn’t got much active attention. Despite that, there are now many Jira community items that have collected a fair amount of votes over the years. … Continue reading "Give MariaDB Jira votes and comments" The post Give MariaDB Jira votes and comments appeared first on MariaDB.org…. Read more

MariaDB SEQUENCE is a storage engine that generates a sequence of positive integer numbers. However, in this article I will show you that it’s easy to use SEQUENCE to generate more complex sequences, that are not necessarily numeric. This is a very convenient way to generate relatively simple synthetic data. Numeric sequences SEQUENCE generates a numeric sequence, even though these numbers can be converted to something else. We specify a minimum, a maximum, and optionally a step (or increment). SEQUENCE tables are created on the fly when you query a non-existing table with a name that follows a certain pattern…. Read more

When performing backups, reducing the amount of time your server is locked can significantly improve performance and minimize disruptions. Percona XtraBackup 8.4 Pro introduces improvements in how DDL (Data Definition Language) locks (aka Backup Locks) are managed, allowing for reduced locking during backups. In this post, we’ll explore the impact of these enhancements. TL;DR (Summary) […]… Read more

One week left to join the AI RAG Hackathon with MariaDB Vector and Python!  Winners get to demo at the Helsinki Python meetup in May, receive merit and publicity from MariaDB Foundation and Open Ocean Capital, and prizes from Finnish verkkokauppa.com.  … Continue reading "One week left to join AI RAG Hackathon by Helsinki Python meetup (remote participation possible)" The post One week left to join AI RAG Hackathon by Helsinki Python meetup (remote participation possible) appeared first on MariaDB.org…. Read more

MariaDB supports stored procedures written in procedural SQL. Which essentially means “SQL with IF’s and loops”. Most DBMSs do the same, but every project supports different, incompatible syntaxes. MariaDB implemented Oracle’s dialect, called PL/SQL. The base of the current procedural language was implemented in MySQL, before MariaDB existed. As far as I know, MySQL Community Edition improved triggers a bit, but never improved the procedural language itself. MariaDB developed several features and optimisations and made stored procedures and triggers faster and easier to develop and maintain. Some PL/SQL features were included in the native language, with the same or similar… Read more

New maintenance releases for MariaDB Enterprise Server 11.4.5-3, 10.6.21-17, and 10.5.28-22 are now available. These releases include new backported features. … Continued… Read more

I just submitted a MySQL Contribution and I would like to gather feedback about it.  Depending on the received feedback, I might submit an updated contribution.  The contribution is Counters for Slow InnoDB Sync Reads, and its goal is to make MySQL easier to operate on “complex” IO subsystems (like network drives in the cloud). The bug report / feature request Bug #117740 :… Read more

This guide explains how to set up a MongoDB 8 Replica Set and monitor it using PMM 3, all within Docker. We’ll guide you through the steps to create a local environment, configure the necessary components, and connect them for effective monitoring and management. The guide is written in detail for beginners. In the conclusion section there are ready configurations for the experienced. The recent release of Percona Monitoring and Management 3 introduces several new features:… Read more