Planet MariaDB Server

On May 6, 2025, we released maintenance versions of MariaDB Community Server: 11.4.6 and 10.11.12. Thanks to the swift feedback from our valued community, we’ve identified performance issues in these releases that are affecting some users. We deeply appreciate your reports, which are critical to helping us maintain MariaDB’s quality and reliability. We’ve confirmed that some users are… Source… Read more

Modern applications need to be highly available and easy to scale. A three-node MySQL InnoDB Cluster—built on MySQL Group Replication and connected through MySQL Router—provides a reliable way to support critical workloads. To set up this architecture, you start by deploying three MySQL server instances. In this example, the nodes are assigned the following hostname-to-IP […]… Read more

On Monday we had our final submission day for the MariaDB AI RAG Hackathon. We got several high quality replies in both tracks: integration and innovation. … Continue reading "Impressive Submissions at the MariaDB AI RAG Hackathon" The post Impressive Submissions at the MariaDB AI RAG Hackathon appeared first on MariaDB.org…. Read more

Most tables have a concept of “duplicate rows”, where duplicates should never be allowed. Typical examples are: But should happen when the application tries to insert a duplicate? This depends from case to case. The possible effects are the following: Let’s see how to handle each of these case in SQL, in a simple way, without re-inventing the wheel. You will save yourself some useless effort, and will avoid bugs in some corner cases. Duplicate creation should fail with an error Use cases: new user sign-up, email change A user is attempting to sign up. The user will entry its… Read more

Innodb Cluster or ClusterSet topologies already have secondary instances that can act as a failover for primary or also offload read requests. However, with MySQL 8.4, we now have the feasibility of adding a separate async replica to the cluster for serving various special/ad-hoc queries or some reporting purposes. This will also help offload read traffic away […]… Read more

We at MariaDB Foundation are thrilled to see Amazon at the forefront of applying artificial intelligence to open source contributions — with MariaDB as their pilot.  … Continue reading "Amazon’s AI-agents for MariaDB Contributions" The post Amazon’s AI-agents for MariaDB Contributions appeared first on MariaDB.org…. Read more

Right after the recent MariaDB Meetup in London, I had the pleasure of sitting down with Steve Shaw – founder and CEO of HammerDB, former Principal Engineer at Intel, and board member of the MariaDB Foundation. … Continue reading "Open Source Performance, Benchmarks and MariaDB: A Conversation with Steve Shaw" The post Open Source Performance, Benchmarks and MariaDB: A Conversation with Steve Shaw appeared first on MariaDB.org…. Read more

 This post has benchmark results for RocksDB 10.x, 9.x, 8.11, 7.10 and 6.29 on a large server.tl;drThere are several big improvementsThere are no new regressionsFor the block cache hyperclock does much better than LRU on CPU-bound testsSoftwareI used RocksDB versions 6.0.2, 6.29.5, 7.10.2, 8.11.4, 9.0.1, 9.1.2, 9.2.2, 9.3.2, 9.4.1, 9.5.2, 9.6.2, 9.7.4, 9.8.4, 9.9.3, 9.10.0, 9.11.2, 10.0.1, 10.1.3, 10.2.1. Everything was compiled with gcc 11.4.0.For 8.x, 9.x and 10.x the benchmark was repeated using both the LRU block cache (older code) and hyperclock (newer code). That was done by setting the –cache_type argument:lru_cache was used for versions 7.6 and earlierhyper_clock_cache was used… Read more

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.6, 10.11.12, 10.6.22, and 10.5.29 maintenance releases. See […]… Read more

We’re excited to welcome RAVATAR as our Silver Sponsor! A bold innovator in artificial intelligence, RAVATAR is defining the emerging Face of AI through high-quality interactive digital humans and real-time AI avatars. … Continue reading "RAVATAR becomes Silver Sponsor of MariaDB Foundation" The post RAVATAR becomes Silver Sponsor of MariaDB Foundation appeared first on MariaDB.org…. Read more

After reading a blog post from JFG on changes to innodb_doublewrite_pages and bug 111353, I wanted to understand the impact from that on the Insert Benchmark using a large server.I test the impact from:using a larger (non-default) value for innodb_doublewrite_pagesdisabling the doublewrite buffertl;drUsing a larger value for innodb_doublewrite_pages improves QPS by up to 10%Disabling the InnoDB doublewrite buffer is great for performance, but bad for durability. I don't suggest you do this in production.Builds, configuration and hardwareI compiled upstream MySQL 8.0.41 from source.The server is an ax162-s from Hetzner with 48 cores, AMD 128G RAM and AMD SMT disabled. It uses Ubuntu… Read more

I suppose not all of my readers have a first hand (or even second hand) experience of the girls-night-in. So let me shed some light on this sacred ritual of tea, sympathy and soul-baring conversation that zigzags from the ridiculous to the profound and back again in under 30 seconds. … Continue reading "The Queen, the contributions and the wardrobe" The post The Queen, the contributions and the wardrobe appeared first on MariaDB.org…. Read more

I had the delight of being accepted to talk about “Making AI transparent with RAG on your own data” at foss-north 2025 in Gothenburg, Sweden. … Continue reading "MariaDB Vector and RAG at foss-north 2025" The post MariaDB Vector and RAG at foss-north 2025 appeared first on MariaDB.org…. Read more

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 with being known since 16 Jul 2024, has not been talked about much, so this deserves a blog post…. Read more

We’re pleased to welcome Kinsta as a Silver Sponsor of the MariaDB Foundation. Kinsta, one of the leading managed WordPress hosting providers, powers thousands of websites globally with a platform built for speed, scalability, and security — … Continue reading "New Silver Sponsor: Kinsta Chooses MariaDB for Scalable, Open WordPress Hosting" The post New Silver Sponsor: Kinsta Chooses MariaDB for Scalable, Open WordPress Hosting appeared first on MariaDB.org…. Read more