Planet MariaDB

FOSDEM 2022 is going to happen on the next weekend and I am still missing blog posts supporting my unusual upcoming talk there, this time devoted to building and using MariaDB server on macOS. So tonight I am going to contribute something new to refer to during my talk or followup questions. I'll try to document my way to build MariaDB Server from GitHub source on old (early 2015) MacBook Air running macOS 10.13.6 High Sierra. I am also going to show why one may want to use macOS there instead of installing Linux and having way more usual environment… Read more

There are some details on intra-L0 compaction on the public RocksDB wiki. This post has more details.The purpose for intra-L0 is to reduce read-amplification when compaction is behind by reducing the number of SSTs in the L0. Intra-L0 compaction merges smaller L0 SSTs into a larger SST that remains in the L0. It can be done when L0- >L1 compaction is needed but blocked. From the discussion of DBPCF below I suspect that intra-L0 increases write-amplification by = 1 either because there are too many SSTs in L0 or the L0 SSTs are too large. The compaction score is computed… Read more

Operators are a software framework that extends Kubernetes API and enables application deployment and management through the control plane. For such complex technologies as databases, Operators play a crucial role by automating deployment and day-to-day operations. At Percona we have the following production-ready and enterprise-grade Kubernetes Operators for databases: Percona Distribution for MySQL Operator Leverage […]… Read more

Managing database users and their passwords can be a hassle. Sometimes, they could even wait in various configuration files, hardcoded. Using certificates can help you avoid the toil of managing, rotating, and securing user passwords, so let’s see how to have x509 certificate authentication with the Percona Server for MongoDB Operator and cert-manager. cert-manager is […]… Read more

With Continuent, it’s not just your MySQL databases that remain available… Continuent’s 24//7/365 Support team, consisting of highly experienced DBAs, SysAdmins and Architects, is also always available. The Continuent Tungsten team pioneers the need for cloud-savvy business-critical MySQL databases that are platform-agnostic, highly-available, and globally-scaling. Continuent’s flagship product is a tightly-integrated and fully-tested clustering solution handling billions of transactions per day and protecting over $20 billion dollars in annual revenue. Enjoy a sunny (and windy) San Francisco day on a sailboat with Continuent’s Founder and CEO, Eero Teerikorpi, to learn more about Continuent Support!   Video Transcript Hello, I’m Eero… Read more

Let’s say you have a fresh MySQL installation. Are there any possible steps to improve performance right away? Yes, there are! Recently, Marcos Albe (Principal Support Engineer, Percona) did an online tuning on the MySQL Meetup hosted by Matt Yonkovit (Head of Open Source Strategy, Percona). Here are some steps you can consider to make your fresh MySQL installation to run better right from the start. So, we have a very basic default MySQL installation with some workload…. Read more

2.26.0 Preview Release Percona Monitoring and Management 2.26.0 is now available as a Preview Release. PMM team really appreciates your feedback! We encourage you to try this PMM Preview Release in testing environments only, as these packages and images are not fully production-ready. The final version is expected to be released through the standard channels in the coming week. Release Notes can be found here PMM server docker Instructions docker tag: perconalab/pmm-server:2…. Read more

Sometimes it’s the little things that matter. While I have been (rightly) accused of routinely talking about open source strip … Continued… Read more

I have a deep understanding of LSM performance in general but not enough understanding of RocksDB internals. That is a risky combination that I am fixing by reading source code. I will share what I learn via blog posts. My approach here is to document as I read and the result might be a lot of detail without a high-level overview.This post is about soft and hard_pending_compaction_bytes_limit. Their comments in the header are brief (I expect to send a diff to improve them), so reading code is required. Before reading code I misunderstood how bytes pending compaction was computed. Below… Read more

New MariaDB Connector/J 3.0 GA features enhancements including faster connection creation, smaller size, data exchange improvements and increased performance…. Read more

MariaDB Xpand is a distributed SQL database that offers built-in HA and linear scalability. This blog explains the newest feature in Xpand, columnar indexing which enables faster analytical queries…. Read more

Recently, a few PostgreSQL users reported that they got connection failures after switching to PostgreSQL 14. “Why do I get the error FATAL:  password authentication failed for a user in the new server?” has become one of the most intriguing questions. At least in one case, it was a bit of a surprise that the […]… Read more

Automating the deployment and management of MongoDB on Kubernetes is an easy journey with Percona Operator. By default, MongoDB is deployed using persistent volume claims (PVC). In the cases where you seek exceptional performance or you don’t have any external block storage, it is also possible to use local storage. Usually, it makes sense to […]… Read more

It’s time for the release roundup! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers […]… Read more

This week I came across an old known issue reported in May 2010: Master/Slave Replication with binlog_format = ROW and tables without a Primary Key is a bad idea! Especially if these tables are huge. Why this is a bad idea is described in the bug report #53375: if one runs DML on a table that has no indexes, a full table scan is done. with RBR, the slave might need to scan the full table for *each* row changed. The consequence of this behaviour is that the Slave starts lagging. It was further mentioned: Worst part is that PROCESSLIST,… Read more