Planet MariaDB Server

In some situations, an application needs to run a single logical transaction that involves multiple database technologies: in our example, they’ll be MariaDB and PostgreSQL. This is not an optimal scenario and I’m not recommending to design systems in this way. But it’s simply a situation that you might have to deal with in real life, for various reasons that are outside of the scope of this article. Multi-database work implies several problems, because a transaction must be atomic, but in a distributed architecture this is very hard to guarantee. This article explores how to run distributed transactions using similar… Read more

Standardize operator-driven database ops with GitOps while keeping Kubernetes and traditional environments under one roof Kubernetes database operators have become the default way to run databases in-cluster. They bring automation, self-healing patterns, and declarative lifecycle management, but they also introduce new complexity: operator-specific CRDs, dependencies, and “one-off” ways of doing the same Day-2 tasks across […] The post ClusterControl Kubernetes Database Operator Management now GA appeared first on Severalnines…. Read more

We spent a long time, two blog posts to be specific, talking about OAuth/OIDC in theory. Now we’ll take a more practical look at the topic: how can we configure PostgreSQL with a popular open source identity provider, Keycloak, and our pg_oidc_validator plugin? We’ll not only look at the PostgreSQL configuration part, but also discuss the environment requirements and setting up Keycloak. Docker containers If you are only interested in trying out a working demo installation, we have a ready-to-use Docker Compose configuration available [in our GitHub repo](LINK TODO). This setup includes a Keycloak instance, a PostgreSQL server, and a… Read more

Deploying databases on Kubernetes is getting easier every year. The part that still hurts is making deployments repeatable and predictable across clusters and environments, especially from Continuous Integration(CI) perspective. This is where PR-based automation helps; you can review a plan, validate changes, and only apply after approval, before anything touches your cluster.  If you’ve ever […]… Read more

We are pleased to welcome Sylvain Arbaudie as a sponsor of the MariaDB Foundation. Sylvain Arbaudie is an independent consultant with extensive experience helping organisations design reliable, scalable data infrastructures. … Continue reading "Arbaudie.IT becomes silver sponsor of MariaDB Foundation" The post Arbaudie.IT becomes silver sponsor of MariaDB Foundation appeared first on MariaDB.org…. Read more

I explained in this post that there is a possible performance regression for Postgres with IO-bound sysbench. It arrived in Postgres 16 and remains in Postgres 18. I normally run sysbench with a cached database, but I had a spare server so I repeated tests with an IO-bound workload.The bad news for me is that I need to spend more time explaining the problem. The good news for me is that I learn more about Postgres by doing this. And to be clear, I have yet to explain the regression but this post documents my debugging efforts.sysbenchThis post explains how… Read more

Configuring the Component Keyring in Percona Server and PXC 8.4 (Or: how to make MySQL encryption boring, which is the goal) Encryption is one of those things everyone agrees is important, right up until MySQL refuses to start and you’re staring at a JSON file wondering which brace ruined your evening. With MySQL 8.4, encryption has firmly moved into the component world, and if you’re running Percona Server 8.4 or Percona XtraDB Cluster (PXC) 8.4, the supported path forward is the component_keyring_file component…. Read more

In this blog post, we will be discussing the PXC Replication Manager script/tool which basically facilitates both source and replica failover when working with multiple PXC clusters, across different DC/Networks connected via asynchronous replication mechanism. Such topologies emerge from requirements like database version upgrades, reporting or streaming for applications, separate disaster recovery or backup solutions, […]… Read more

If you care about supporting open source software, and still use MySQL in 2026, you should switch to MariaDB like so many others have already done. The number of git commits on github.com/mysql/mysql-server has been significantly declining in 2025. The screenshot below shows the state of git commits as of writing this in January 2026, and the picture should be alarming to anyone who cares about software being open source. This is not surprising – Oracle should not be trusted as the steward for open source projects When Oracle acquired Sun Microsystems and MySQL along with it back in 2009,… Read more

The MariaDB Foundation is pleased to welcome HammerDB as a Silver Sponsor. HammerDB is the industry-standard open-source database benchmark, widely used across the database, cloud, and hardware ecosystem to evaluate mission-critical performance, scalability, and real-world workload behaviour. … Continue reading "MariaDB Foundation welcomes HammerDB as a Silver Sponsor" The post MariaDB Foundation welcomes HammerDB as a Silver Sponsor appeared first on MariaDB.org…. Read more

This has results to measure the impact of calling fsync (or fdatasync) per-write for files opened with O_DIRECT. My goal is to document the impact of the innodb_flush_method option. The primary point of this post is to document the claim:For an SSD without power loss protection, writes are fast but fsync is slow.The secondary point of this post is to provide yet another example where context matters when reporting performance problems. This post is motivated by results that look bad when run on a server with slow fsync but look OK otherwise. tl;drfor my mini PCs I will switch from the Samsung 990… Read more

At the MariaDB Foundation, clarity of purpose matters. In an ecosystem as foundational as open-source databases, confidence is built not through slogans, but through predictability, restraint, and long-term commitment. … Continue reading "Making MariaDB the Natural Successor to MySQL" The post Making MariaDB the Natural Successor to MySQL appeared first on MariaDB.org…. Read more

I am upset about this one : I have a hard time not seeing this as negligence, and it starts to become a pattern…  So please forgive me if this post is not my most diplomatic, because I really think someone deserves a kick in the butt !  But what is all this about… There is a MySQL bug, which can lead to data corruption, opened for 8.0 in September 2023, fixed in MySQL 8.4.0 (… Read more

For decades, we’ve accepted a painful compromise: if you wanted logic inside the database, you had to write SQL/PSM (Persistent Stored Modules). It’s clunky, hard to debug, and declarative by nature, making it terrible for algorithmic tasks. That ends with Percona Server 8.4.7-7. We are introducing JS Stored Programs as a Tech Preview. Unlike Oracle’s […]… Read more

The patent expired for US7680791B2. I invented this while at Oracle and it landed in 10gR2 with claims of ~5X better performance vs the previous sort algorithm used by Oracle. I hope for an open-source implementation one day. The patent has a good description of the algorithm, it is much easier to read than your typical patent. Thankfully the IP lawyer made good use of the functional and design docs that I wrote.The patent is for a new in-memory sort algorithm that needs a name. Features include:common prefix skippingskips comparing the prefix of of key bytes when possibleadaptiveswitches between quicksort and most-significant… Read more