Planet MariaDB Server

Table of contents Review One month later Size of the tables Process list Global variables Metadata Lock and InnoDB Transaction Lock Global status Review After we introduced dbstat for MariaDB (and MySQL) a good 5 weeks ago, we naturally also rolled it out on our systems to test the behaviour in daily use (eat your own dog food). This went quite well until we came up with the idea of activating dbstat on the passive dbstat node on our MariaDB active/passive master/master replication cluster (a similar situation would also occur with a Galera cluster). We realised that the design of… Read more

Table of contents Review One month later Size of the tables Process list Global variables Metadata Lock and InnoDB Transaction Lock Global status Review After we introduced dbstat for MariaDB (and MySQL) a good 5 weeks ago, we naturally also rolled it out on our systems to test the behaviour in daily use (eat your own dog food). This went quite well until we came up with the idea of activating dbstat on the passive dbstat node on our MariaDB active/passive master/master replication cluster (a similar situation would also occur with a Galera cluster). We realised that the design of… Read more

Elasticsearch is a complex software incomparable to other mainstream database software, whether it’s RDBMS or NoSQL. It functions primarily as your search engine and works as your document database to store valuable data for analytics. Elasticsearch works as part of the ELK stack (Elastic, Logstash, Beats, and Kibana). It can also be used with other […] The post How to setup and install Elasticsearch: From a single node to a cluster of nodes appeared first on Severalnines…. Read more

Elasticsearch is a complex software incomparable to other mainstream database software, whether it’s RDBMS or NoSQL. It functions primarily as your search engine and works as your document database to store valuable data for analytics. Elasticsearch works as part of the ELK stack (Elastic, Logstash, Beats, and Kibana). It can also be used with other […] The post How to setup and install Elasticsearch: From a single node to a cluster of nodes appeared first on Severalnines…. Read more

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