by Agustín | 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... by Agustín | 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... by Agustín | Nov 9, 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... by Agustín | Jun 9, 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... by Agustín | Apr 6, 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... by Agustín | Jul 5, 2022 | PostgreSQL, Security
Enabling SSL in PostgreSQL is very straightforward. In just three steps we can make sure the connections to it are more secure, using in-transit encryption via SSL/TLS: Make sure we have the server certificate and key files available Enable the SSL configuration (ssl... by Agustín | Oct 6, 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,... by Agustín | 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... by Agustín | Aug 5, 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... by Agustín | Aug 4, 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,... by Agustín | Jun 1, 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... by Agustín | 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... by Agustín | May 6, 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... by Agustín | 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... by Agustín | 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... by Agustín | Aug 29, 2019 | MySQL, Open Source
In this short blog post, we will check how to use here and https://dbsake.readthedocs.io/en/latest/commands/uncache.html (Updated: Check LeFred’s comments below for more insight on this.) As an added bonus, DBSake has a fincore tool you can use!vmtouch... by Agustín | 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... by Agustín | 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... by Agustín | 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... by Agustín | Jan 15, 2019 | MySQL, Percona Software
If you have set up per-process metrics in Percona Monitoring and Management, you may have found yourself in need of tuning it further to not only group processes together, but to display some of them in isolation. In this blogpost we will explore how to modify the...