Planet MariaDB Server

Personal opinion : the future of Galera ClusterAs you already know, MariaDB plc acquired Codership Oy, editor of the Galera clustering solution on 2025, June 1st.This acquisition makes a lot of sense given the tight integration of Galera into MariaDB server since MariaDB 10.0 in 2014. Galera Cluster brings distributed synchronous multi-master clustering to MariaDB, which differentiates it from other databases, be they proprietary like Oracle or open-source like PostgreSQL. Unlike Oracle RAC (which requires shared storage and Oracle’s expensive licensing) or PostgreSQL’s streaming replication (which is primarily master-slave), Galera provides true multi-master capability without shared storage dependencies, making MariaDB competitive with other… Read more

We continue our blog series on learning more about users of MariaDB. Searching LinkedIn for posts about MariaDB this morning we saw an impressive confident post about using MariaDB in a RAG solution named SemantiQ. … Continue reading "Can you do RAG with Full Text Search in MariaDB?" The post Can you do RAG with Full Text Search in MariaDB? appeared first on MariaDB.org…. Read more

New maintenance releases for MariaDB Enterprise Server 11.4.7-4, 10.6.22-18, and 10.5.29-23 are now available. These releases include new backported features. […]… Read more

This is my second attempt at an IO-bound Insert Benchmark results with a small server. The first attempt is here and has been deprecated because sloppy programming by me meant the benchmark client was creating too many connections and that hurt results in some cases for Postgres 18 beta1.There might be regressions from 17.5 to 18 beta1QPS decreases by ~5% and CPU increases by ~5% on the l.i2 (write-only) stepQPS decreases by 1.0 then performance improved over time. When it is < 1.0 then there are regressions. When it is 0.90 then I claim there is a 10% regression. The Q in… Read more

Scarf joins the MariaDB Foundation as a Gold Sponsor, bringing powerful analytics to help us understand and grow our open source community. Discover how this partnership supports transparency, adoption, and global collaboration. The post Scarf Joins as Gold Sponsor of the MariaDB Foundation appeared first on MariaDB.org…. Read more

After 20 years on MySQL, Glarotech chose MariaDB for PepperShop. Learn what drove the switch and how they run a scalable eCommerce platform today. The post Why Swiss eCommerce Leader Glarotech Migrated from MySQL to MariaDB – and What’s Next for PepperShop appeared first on MariaDB.org…. Read more

This is my second attempt at CPU-bound Insert Benchmark results with a small server. The first attempt is here and has been deprecated becau sloppy programming by me meant the benchmark client was creating too many connections and that hurt results in some cases for Postgres 18 beta1.tl;drPerformance between 17.5 and 18 beta1 is mostly similar18 beta1 might have small regressions from new CPU overheads on write-heavy stepsBuilds, configuration and hardwareI compiled Postgres from source using -O2 -fno-omit-frame-pointer for versions  14.0, 14.18, 15.0, 15.13, 16.0, 16.9, 17.0, 17.5 and 18 beta1.The server is an ASUS ExpertCenter PN53 with and AMD Ryzen 7… Read more

Cybersec : MariaDB, round2While being an Open source database management system developped and maintained by a team of immensely skilled developpers, MariaDB (and MySQL) is not immune to mismanagement and/or administrator-induced security risks.A not well known feature of MariaDB is init_file, a nice little parameter that allows to have a set of SQL statement executed once at each server startup. While potent and very usefull, this is also a potential security breache, as anyone who can edit this file can add a sql statement creating an admin user for example or expand someone’s privileges beyond any need.Let’s examine how we can mitigate this risk… Read more

Now is a good time to upgrade to the freshest MariaDB Server. MariaDB 11.8 is the yearly long term support release for 2025. It’s the first LTS with support for MariaDB Vector, and it includes a number of other updates based on user requests. … Continue reading "MariaDB 11.8 LTS Released" The post MariaDB 11.8 LTS Released appeared first on MariaDB.org…. Read more

This has results for a CPU-bound Insert Benchmark with Postgres on a large server. A blog post about a CPU-bound workload on the same server is here.tl;drinitial load step (l.i0)18 beta1 is 4% faster than 17.4create index step (l.x)18 beta1 with io_method =sync and =workers has similar perf as 17.4 and is 7% faster than 17.4 with =io_uringwrite-heavy steps (l.i1, l.i2)18 beta1 and 17.4 have similar performance except for l.i2 with 18 beta1 and io_method=workers where 18 beta1 is 40% faster. This is an odd result and I am repeating the benchmark.range query steps (qr100, qr500, qr1000)18 beta1 is up… Read more

TL;DR Percona Server for MySQL now offers experimental support for stored programs in the JS language. This free and open source alternative to Oracle’s Enterprise/Cloud-only feature enables users to write stored programs in a more modern, convenient, and often more familiar language. It is still in active development, and we would very much like your […]… Read more

You have a beautiful application, but a page is slow. After some investigation, you find out that a query is unexpectedly slow, ruining user experience and causing frustration for you. It is a simple query with a WHERE clause and nothing else. You tried to build an index with all the columns mentioned in the query, but nothing changed. The EXPLAIN command shows that the index is not used, which seems to you inexplicable. Why is this happening? This article will probably help you find out the reason! Query optimisation is not rocket science, but it is not always intuitive…. Read more

This has results for a CPU-bound Insert Benchmark with Postgres on a large server. A blog post about a similar workload on a small server is here.This report was delayed because I had to debug a performance regression (see below) and then repeat tests after implementing a workaround in my benchmark client.tl;drcreating connectionsthis is ~2.3X slower in 18 beta1 with io_method=io_uring vs 17.4initial load step (l.i0)18 beta1 is 1% to 3% faster than 17.4This step is short running so I don't have a strong opinion on the changecreate index step (l.x)18 beta1 is 1% to 3% slower than 17.4This step… Read more

MariaDB Community Server 11.8 is now generally available (GA) for download. This is the latest long-term maintenance (also known as […]… Read more

Last week we announced the winners of  the MariaDB AI RAG hackathon that we organized together with the Helsinki Python meetup group. Now is time to go for a deep dive into the innovation track winner. … Continue reading "Youtube Semantic Search is the winner of MariaDB AI RAG Hackathon innovation track" The post Youtube Semantic Search is the winner of MariaDB AI RAG Hackathon innovation track appeared first on MariaDB.org…. Read more