Planet MariaDB

We are thrilled to announce the Percona Platform, which brings together database distributions, support expertise, services, management, and automated insights into a single product. Building on our expertise with databases including MySQL, PostgreSQL, and MongoDB, the new Percona Platform will simplify how you can monitor, manage, and optimize their database instances across any infrastructure. In […]… Read more
By Donnie Berkholz
2021-12-08
Source: Percona
MySQL Transaction Reporting In chapter 8 of my forthcoming book (more on this later), I discuss reporting MySQL transactions (among many other related topics). In the book, I note that the state of the art is practically nonexistent: transactions are important, but we just don’t monitor or report them in the world of MySQL. Historically (in older versions of MySQL), there was basically no way to do this because neither the general log nor the slow log printed transaction IDs…. Read more
2021-12-08
Source: Hack MySQL
Percona in 2021 is heavily invested in making the PostgreSQL ecosystem better and contributing to it from different angles: We have created pg_stat_monitor – query performance monitoring tool for PostgreSQL Percona Distribution for PostgreSQL Operator was released in October Greatly improved PostgreSQL monitoring with Percona Monitoring and Management At PGConf NYC 2021 we were a […]… Read more
By Sergey Pronin
2021-12-08
Source: Percona
CONNECT is a storage engine (SE) plugin used to access external, local or remote data. In this blog we are going to show how to install the CONNECT storage engine in a Docker container and how to share JSON data between containers. … Continue reading "Using CONNECT SE to access remote JSON data with demo examples in Docker" The post Using CONNECT SE to access remote JSON data with demo examples in Docker appeared first on MariaDB.org…. Read more
By Anel Husakovic
2021-12-08
Recently a Customer Asked “Are there any issues with running a specific node with parallel apply enabled, and the rest of the nodes using a single stream (parallel disabled)? Just curious because that would be easiest for A/B testing of the replication effects.” In this blog post we explore the implications and best practices for using Parallel Apply on a single node in the cluster. Firstly, the answer is yes, you may certainly enable Parallel Apply on a single node within a Tungsten Cluster. The caveat is that a node with Parallel Apply enabled cannot be a provisioning source for… Read more
By erics
2021-12-07
While we prepare to enter 2022 and start to sum up its results and schedule a plan for the future, let’s look back at the awesome posts published in the Percona Blog and find out which products and themes raised more engagement among readers. We count the number of views of each blog post and […]… Read more
By Aleksandra Abramova
2021-12-07
Source: Percona
This is a blog post version of our paper “Simulation of thread pool for database server” that will be published in CEUR Workshop Proceedings. In the article, we consider an object-oriented simulation model for thread pool. The implementation of thread pool in MariaDB and Percona Server was taken as a basis. Model’s input flow and their distributions are described. Model’s output results are consistent with known “concurrency level – throughput” dependency patterns for IO- and CPU-bound workloads. The model is written in C++ and its software architecture is also considered, including provided classes, methods and call graph. The model takes… Read more
By Ilya Trub
2021-12-06
It’s release roundup time again here at Percona! 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. […]… Read more
By David Quilty
2021-12-06
Source: Percona
We are pleased to announce the FOSDEM22 MariaDB devroom committee. In February 2022, MariaDB will be hosting its second dedicated devroom at FOSDEM, and the committee have the job of narrowing down the submissions to choose the most interesting final selection for the FOSDEM and MariaDB communities. … Continue reading "FOSDEM22 MariaDB devroom committee" The post FOSDEM22 MariaDB devroom committee appeared first on MariaDB.org…. Read more
By Ian Gilfillan
2021-12-04
For a long time, MyDumper has been in Max Bubenick’s personal GitHub repository. Now, we decided to move to a new MyDumper’s Organization as requested earlier this year by a user from the community. There were also two other reasons why we decided to move it. The first one is related to how the project […]… Read more
By David Ducos
2021-12-03
Source: Percona
First, I want to thank everyone who attended my November 9, 2021 webinar “Introduction to MySQL Query Tuning for Dev[Op]s“. Recording and slides are available on our webinars page. Here are answers to the questions from participants which I was not able to provide during the webinar due to a technical issue we experienced at […]… Read more
By Sveta Smirnova
2021-12-02
Source: Percona
This video tutorial describes how to install Galera Manager in 15 minutes while also deploying a Galera Cluster in Amazon Web Services (AWS), all in an automated fashion!   WATCH THE VIDEO… Read more
By Sakari Keskitalo
2021-12-02
Source: Galera Cluster
As more people test, utilise and deploy Galera Manager, there is always room for support requests, and we see that at the Galera Manager Support Repository on Github. We encourage you to file requests, as they help with our roadmap as well! We have had a feature request to run within a Docker container, and […]… Read more
By Sakari Keskitalo
2021-12-02
Source: Galera Cluster
Working on a real case scenario in a five node Percona XtraDB Cluster (PXC), we were forced to use wsrep_sync_wait = 1, because the app does reads-after-write and we send reads to all the nodes. We had the idea to leave some nodes in DESYNC mode to reduce the flow control messages during peak load […]… Read more
By David Ducos
2021-12-01
Source: Percona
MariaDB is happy to again be hosting a devroom at FOSDEM 2022. This year’s event will be the second virtual FOSDEM, and the MariaDB devroom will take place on Saturday 5 February 2022. … Continue reading "CfP for the MariaDB devroom FOSDEM 2022 now open" The post CfP for the MariaDB devroom FOSDEM 2022 now open appeared first on MariaDB.org…. Read more
By Ian Gilfillan
2021-12-01