Jul 05, 2025 |
PostgreSQL, Security
This post was originally published in July 2022, and we’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. Protecting data in transit is just as important as protecting it at rest. If connections to your PostgreSQL database aren’t encrypted, sensitive information like usernames, passwords, and SQL queries […]
Jun 04, 2024 |
Insight for DBAs, Monitoring, Percona Software
Downsampling is the process by which we can selectively prune (discard, summarize, or recalculate) data from a series of samples in order to decrease how much storage is consumed. This has the downside of reducing the accuracy of the data, but has the great benefit of allowing us to store data from a wider sampling […]
Apr 10, 2024 |
Cloud, Insight for DBAs, Monitoring, MySQL
It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The Ingress NGINX Controller is one of the most popular choices for managing the inbound traffic to K8s. It acts as a reverse proxy and load […]
Feb 13, 2024 |
Insight for DBAs, PostgreSQL
In this blog post, we are going to briefly discuss the reasons why column order matters when creating tables -or relations- in PostgreSQL. Alignment In its internal representation of tuples, Postgres will set each column at a position depending on the alignment defined for the data type used (following the same sequential order as the […]
Nov 09, 2023 |
Monitoring, Percona Software, PostgreSQL
In this blog post, we will discuss how to extend Percona Monitoring and Management (PMM) to get PostgreSQL metrics on checkpointing activity, internal buffers, and WAL usage. With this data, we’ll be able to better understand and tune our Postgres servers. We’ll assume there are working PostgreSQL and PMM environments set up already. You can […]
Jun 09, 2023 |
Insight for DBAs, Monitoring, PostgreSQL
Percona Monitoring and Management (PMM) boasts many functionalities that support its extension, be it by using Custom Queries, Custom Scripts, or by collecting data from already available External Exporters. In this short blog post, we will see how to quickly (and easily) monitor a PostgreSQL cluster managed by Patroni. I will assume you already have […]
Apr 06, 2023 |
Insight for DBAs, Monitoring, MySQL, Percona Software, PostgreSQL
In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Loki is a log aggregation tool developed by Grafana Labs. It integrates easily with the Grafana instance that is […]
Oct 06, 2021 |
Monitoring, MySQL, Percona Software
In this short blog post, we are going to review how to avoid using credentials in the Percona Monitoring and Management (PMM) client command line when adding new exporters. We will use an example with the MySQL exporter, but it is extensible to others (PostgreSQL, MongoDB, etc.). In the online documentation we can see the […]
May 26, 2021 |
Cloud, Monitoring, Percona Software
In this follow-up blog to Compiling a Percona Monitoring and Management v2 Client in ARM Architecture, we will show what changes are needed to get the latest versions of PMM working on ARM architecture. In this case, we will do it using a Raspberry Pi 3, instead of the AWS EC2 ARM node. With these […]
Aug 05, 2020 |
Monitoring, Percona Software
In this blog post, we will take a look at how we can manually remove a client instance from Percona Monitoring and Management (PMM) version 2. Under normal operations, this shouldn’t be necessary, since a graceful PMM client uninstall shouldn’t leave any lingering instances around. However, it may happen that an instance is destroyed (for […]
Aug 04, 2020 |
Cloud, Insight for DBAs, Monitoring, Percona Software
In this blog, we are going to see how to compile a Percona Monitoring and Management 2 (PMM v2) client in ARM. For this, we are going to use an AWS EC2 ARM instance with Amazon Linux 2. Installing Dependencies First, let’s get some basic packages out of the way, which probably are installed in […]
Jun 01, 2020 |
Insight for DBAs, MySQL, Open Source
In a previous post, Using DBdeployer to manage MySQL, Percona Server, and MariaDB sandboxes, we covered how we use DBdeployer within the Support Team to easily create MySQL environments for testing purposes. Here, I will expand on what Peter wrote in Installing MySQL with Docker, to create environments with more than one node. In particular, […]
May 18, 2020 |
Monitoring, Percona Software
Two years ago, we showed how to use a different mount point on Percona Monitoring and Management (PMM) Docker deployments, in case you need to have data stored out of the default Docker paths. We have released PMM version 2 since, and the need for these steps is still current. However, there are a few […]
May 06, 2020 |
MySQL, Percona Software
As Alkin and Ramesh have shown us in their Testing Percona XtraDB Cluster 8.0 with DBdeployer post, it is now possible to easily deploy an environment to test the features provided by the brand new release of Percona XtraDB Cluster 8.0. We have also worked on creating a testing environment available for those that use […]
Jan 15, 2020 |
MySQL, Percona Software
In a previous post Profiling Software Using perf and Flame Graphs, we took a look at how to generate Flame Graphs from perf outputs. In this short follow-up, we will use Flame Graphs to process outputs from pt-pmp. Flame Graphs were not originally thought of for this purpose, but since pt-pmp outputs are similar to […]
Nov 20, 2019 |
MySQL, Percona Software
In this blog post, we will see how to use perf (a.k.a.: perf_events) together with Flame Graphs. They are used to generate a graphical representation of what functions are being called within our software of choice. Percona Server for MySQL is used here, but it can be extended to any software you can take a […]
Aug 29, 2019 |
MySQL, Open Source
In this short blog post, we will check how to use here and extended blog post on this matter, which has more tools and how to use them. uncache – https://hoytech.com/vmtouch/ mincore –
Apr 16, 2019 |
MongoDB, MySQL, Percona Events, PostgreSQL
There’s just one week to go before the first of this year’s Percona University events in South America. We’re really pleased with the lineup for all three events. We’re also incredibly happy with the response that we have had from the community. While we realize that a free event is… well… free… you are still […]
Mar 27, 2019 |
MariaDB, MongoDB, MySQL, Percona Events, PostgreSQL
We started hosting Percona University a few years back with the aim of sharing knowledge with the open source database community. The events are held in cities across the world. The next Percona University days will visiting Uruguay, Argentina, and Brazil, in a lightning tour at the end of April. Montevideo, Tuesday, April 23 2019 […]
Jan 25, 2019 |
Insight for DBAs, MongoDB, MySQL, Percona Events, PostgreSQL
This year at our Open Source Database Conference we’re celebrating open source database technologies that don’t fit into the MySQL®, MongoDB®, MariaDB®, or PostgreSQL realms by featuring them in their very own track. The glamorously-named Other Open Source Databases track! As unbiased champions of open source database solutions, we embrace all flavors of open source […]