Planet MariaDB Server

We are pleased to inform you that a new maintenance release of MariaDB Enterprise Server 10.6 is available. This is … Continued… Read more

Percona.connect, a series of free events hosted by Percona database performance experts, is coming to a city near you!  This amazing learning opportunity spans six cities — across two continents — and includes educational sessions, customer testimonials, networking activities, and more. Don’t miss your chance to talk with technical evangelists, MySQL, PostgreSQL, and MongoDB experts, Percona […]… Read more

Progress Software on April 19 said more about “considering” an offer for MariaDB plc (the company not the foundation). They own NuSphere which had a dispute with MySQL AB which was settled in 2002. My happy history as a MySQL employee biases me but I thought that NuSphere was not acting angelically. I think it… Continue Reading Short note re Progress and NuSphere… Read more

Apples or oranges?Tea or coffee?Books or eBooks?Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. Do you know what else belongs on this list?MariaDB or MySQL?It’s time we discuss the age-old debate of MariaDB versus MySQL and see if […]… Read more

This post has results for the Insert Benchmark on a small server with a cached workload. The goal is to compare MariaDB and MySQL.This work was done by Small Datum LLC and sponsored by the MariaDB Foundation.The workload here has some concurrency (4 clients) and the database is cached. The results might be different when the workload is IO-bound or has more concurrency. Results were recently shared for a workload with low concurrency (1 client),The results here are similar to the results on the low-concurrency benchmark.tl;drModern MariaDB (11.4.1) is faster than modern MySQL (8.0.36) on all benchmark steps except for qr* (range query) and… Read more

Welcome to this blog post! Today, our primary goal is to guide you through deploying Percona Everest on GCP using Kubectl, specifically for users on Windows 11. It’s been some time since I last used Windows, so this will be an excellent opportunity to do it from scratch. Let me tell you a little bit about Percona Everest. You may have already heard it recently. It is the new open source tool launched by Percona and is already well-received by Kubernetes database users…. Read more

In a hypothetical scenario where an application rolls back a transaction in MySQL, especially when using the InnoDB storage engine, several key processes and implications come into play. This scenario can serve as an instructive […] The post Explain Hypothetical Scenario: The Application Rolls Back the Transaction in MySQL appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

I often use HWE kernels with Ubuntu and currently use Ubuntu 22.04. Until recently that meant I ran Linux 6.2 but after a recent update I am now on Linux 6.5.I am far from an expert on this topic and what I write here might just be notes to myself. Be wary of following my advice.Disabling turbo boost yesterdayI have been disabling turbo boost for many years on my home test servers to reduce performance variance from hardware, especially as the weather gets warm because I don't have a server room with AC.  The problem with turbo boost on some… Read more

Is performance important for you, along with the latest features and long-term support? Go with MariaDB 11.4. But don’t take our word for it. We asked well known benchmarking expert Mark Callaghan to check out a number of MariaDB and MySQL releases, hit them hard with a tool of his choice, and share his findings. … Continue reading "How MariaDB and MySQL performance changed over releases" The post How MariaDB and MySQL performance changed over releases appeared first on MariaDB.org…. Read more

Conflict-free Replicated Data Types (CRDTs) are advanced data structures that enable distributed databases to achieve high availability and strong eventual consistency without requiring complex conflict resolution procedures. Although PostgreSQL itself does not natively support CRDTs […] The post Integrating Conflict-Free Replicated Data Types (CRDTs) with PostgreSQL for Distributed Systems appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more

Percona software releases and updates April 2 – April 17, 2024. Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software…. Read more

In the fast-paced world of enterprise databases, reliability, scalability, and performance are paramount. Cloud deployment flexibility is critically important to … Continued… Read more

We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on MySQL but have some questions regarding this change, please check out Migrating to utf8mb4: Things to Consider by Sveta Smirnova.Some of the questions […]… Read more

With the first quarter of 2024 out of the way, we can take a look at the contribution statistics for the last three months. For the Foundation, this has been a very busy quarter, we have had a few big events to prepare for and attend. … Continue reading "MariaDB Contribution Statistics, April 2024" The post MariaDB Contribution Statistics, April 2024 appeared first on MariaDB.org…. Read more

Bloom indexes in PostgreSQL are a specialized type of index that provides an efficient way to test whether an element is a member of a set. They are particularly useful for speeding up queries involving […] The post How do Bloom Indexes work in PostgreSQL? appeared first on The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB and ClickHouse…. Read more