Planet MariaDB

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

Troubleshooting performance degradation caused by pileup of queries stuck in "Waiting for query cache lock" state in MySQL and MariaDB The post MySQL: Waiting for query cache lock appeared first on Shattered Silicon…. Read more

Running MongoDB in Kubernetes is becoming the norm. The most common use cases for running databases in Kubernetes are: Create a private Database as a Service (DBaaS). Maintain coherent infrastructure, where databases and applications run on the same platform. Avoid vendor lock-in and be able to run their databases anywhere utilizing the power of Kubernetes […]… Read more

I have been working with Postgres now for many years, most recently as a consultant at Percona for companies with new implementations of Postgres as a result of migrating from Oracle or some other legacy database engine. In some cases, these are Fortune 100 companies with many talented people working for them. However, not all […]… Read more

I started at Percona a few weeks ago and was looking for a quick way to learn about PMM (Percona Monitoring and Management), which is one of my favorite technologies within Percona to monitor the health of our database infrastructure, explore new patterns in the database behavior, manage and improve the performance of our databases, all with customizable dashboards and real-time alerts using Grafana and VictoriaMetrics. The best of all is that PMM is Open Source, you can check the PMM repository in case you want to contribute…. Read more

Percona Monitoring and Management (PMM) is an open source database monitoring, observability, and management tool that can be used for monitoring the health of your database infrastructure, exploring new patterns in database behavior, and managing and improving the performance of your databases no matter where they are located or deployed. PMM is designed to work with MySQL (including Percona Server for MySQL, Percona XtraDB Cluster, Oracle MySQL Community Edition, Oracle MySQL Enterprise Edition, and MariaDB), PostgreSQL (including Percona Distribution for PostgreSQL), MongoDB (including Percona Server for MongoDB), Amazon RDS, Amazon Aurora, Proxy SQL, and Percona XtraDB Cluster…. Read more

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.0.7 GA release. Download Now Release Notes MariaDB … Continued… Read more

When working with databases, there are always some projects oriented to performing analytics and reporting tasks over the information stored in the database. Usually, these tasks leverage window functions to do calculations “across a set of table rows that are somehow related to the current row,” as is described in the documentation. There are several […]… Read more

After having been in long-term support (LTS) for the past two years, Debian 9 (“Stretch”) has now reached End of Life (EOL) on 2022-06-30. We generally align our OS platform end-of-life dates with the upstream platform vendor. We publish the platform end-of-life dates in advance on our website on the Percona Release Lifecycle Overview page. […]… Read more

In part one and part two of this series, we introduced the different ways to manage MySQL configurations and precedence when using the Percona XtraDB Cluster (PXC) object and ConfigMap. In this post, we will see the precedence when secrets are used for MySQL configurations in Percona Operator for MySQL based on Percona XtraDB Cluster. […]… Read more

Learn how to enable an audit log plugin on the Community version of MySQL 8 Server. Continue reading How to set up AWS Audit Log plugin for MySQL 8 Community→ The post How to set up AWS Audit Log plugin for MySQL 8 Community appeared first on Vettabase…. Read more

We get to see and troubleshoot a lot of different problems at Percona. Here’s the latest one that got me scratching my head for a while recently. The scenario We have a sharded cluster environment running MongoDB 4.0 that needs to be upgraded to MongoDB 4.2. Easy right? The only thing particular about this environment […]… Read more

In part one of this series, we introduced the different ways to manage MySQL configurations. In this post, we will walk through different possibilities and the changes happening while modifying MySQL configurations with the operator. Percona Distribution for MySQL Operator based on Percona XtraDB Cluster (PXC) provides three ways for managing MySQL, but the question […]… Read more

Compaction in Percona Server for MongoDB (PSMDB) There are two ways to reclaim disk space in Percona Server for MongoDB (PSMDB): run compact on nodes or resync the node. In this blog, we will see the best practice for reclaiming the fragmented space on a disk in PSMDB using compact. Disk storage is a critical resource […]… Read more

In this blog, I will cover important aspects which you need to test when benchmarking replication setup. MySQL has great tools that could be used to test its performance. They include: sysbench – https://github.com/akopytov/sysbench BMK-kit – http://dimitrik.free.fr/blog/posts/mysql-perf-bmk-kit.html mysqlslap – https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html LinkBench – https://github.com/facebookarchive/linkbench I will not describe how to use them here, as you can […]… Read more