by Sergey Pronin | Feb 24, 2021 | Cloud, Monitoring, MySQL, Percona Software
Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona...
by Sergey Pronin | Feb 12, 2021 | Cloud, Monitoring, Open Source, Percona Software
More and more companies are adopting Kubernetes, but after some time they see an unexpected growth around cloud costs. Engineering teams did their part in setting up auto-scalers, but the cloud bill is still growing. Today we are going to see how Percona Monitoring...
by Peter Zaitsev | Feb 12, 2021 | Insight for DBAs, Monitoring, Percona Software
One piece of feedback I often hear from users of Percona Monitoring and Management (PMM) is that while the Query Analytics feature is great and provides a lot of insights into queries the server handled, it can’t help us to see which queries are running now. Problem...
by Peter Zaitsev | Feb 9, 2021 | Monitoring, Open Source, Percona Software
I have a local Percona Monitoring and Management (PMM) instance at home, which I use to look after my local databases. With the release of PMM 2.14 and its support for monitoring of external “serverless” stuff, I decided to check if I can get some insights into my...
by Peter Zaitsev | Feb 8, 2021 | Insight for DBAs, Monitoring, Percona Software
About two years ago I wrote about installing Percona Monitoring and Management (PMM) on Linode using StackScripts. This is a great way to automate the process, and now you can do even better by deploying Percona Monitoring and Management from Linode Marketplace. The...
by Michael Coburn | Feb 3, 2021 | Monitoring, MySQL, Percona Software, Webinars
Hi and thanks to all who attended my webinar on Tuesday, January 26th titled Using PMM to Identify & Troubleshoot Problematic MySQL Queries! Like we do after all our webinars, we compile the list of questions that were answered verbally and also those that were...
by Vadim Yalovets | Jan 29, 2021 | Insight for DBAs, Monitoring, Percona Software
In Percona Monitoring and Management 2.12.0 (PMM), we replaced Prometheus with VictoriaMetrics. Metrics data can now be ‘pushed’ to the server as well as being ‘pulled’ by the server. This is useful if you want to keep open ports to a minimum or your monitored system...
by Mike Grayson | Jan 26, 2021 | Insight for DBAs, MongoDB, Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a great way to monitor your MongoDB deployment for things like memory, CPU, inter-database metrics like wiredTiger cache utilization, read/write ticket utilization, Query Analytics, and many, many more. Did you know that in...
by David Quilty | Jan 12, 2021 | Monitoring, MySQL, Percona Software, Webinars
Join us as Michael Coburn, Percona Product Manager, discusses two methods to identify and troubleshoot problematic MySQL queries using the RED Method and Percona Monitoring and Management (PMM) Query Analytics. He will also highlight specific Dashboards in PMM that...
by Diana Muina | Jan 12, 2021 | Monitoring, Open Source, Percona Services, Percona Software
This week we officially kick-off the Preview of Database as a Service (DBaaS) in Percona Monitoring and Management. We are still looking for users to test and provide feedback during this year-long program, and we would love you to participate! Our vision is...
by Puneet Kala | Dec 23, 2020 | Insight for DBAs, Monitoring, Percona Software
Percona Monitoring and Management (PMM) v2.12.0 comes with a lot of improvements and one of the most talked-about is the usage of VictoriaMetricsDB. The reason we are doing this comparison is that PMM 2.12.0 is a release in which we integrate VictoriaMetricsDB and...
by Brandon Fleisher | Dec 18, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
As strange as it sounds, there are types of software applications that are designed for users to NOT spend each minute of every day within the application (where the goal of so many software applications is to attract as many “eyeballs” for as long as possible to...
by Peter Zaitsev | Dec 16, 2020 | Insight for DBAs, Monitoring, Percona Software
Starting with Percona Monitoring and Management (PMM) 2.12, we use VictoriaMetrics instead of Prometheus as a metrics store. This blog is written as an FAQ to explain our reasoning for this change as well as to provide answers to various questions on what it may mean...
by Peter Zaitsev | Dec 15, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
If you’re building custom dashboards for Percona Monitoring and Management (PMM), chances are you would like to use Prometheus recording rules for better performance. In the nutshell, recording rules act somewhat as materialized views in relational databases,...
by Corrado Pandiani | Dec 9, 2020 | Insight for DBAs, Monitoring, Percona Software, Security
Whichever way you installed Percona Monitoring and Management 2 (PMM2), using the docker image or an OVF image for your supported virtualized environment, PMM2 enables, by default, two ports for the web connections: 80 for HTTP and 443 for HTTPS. Using HTTPS...
by Steve Hoffman | Dec 1, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
When I was in the interview process here at Percona, I was told I’d be leading the team that delivered Percona Monitoring and Management (PMM) and so naturally, I wanted to know just what that meant. I started researching the product and I got even more excited about...
by Peter Zaitsev | Nov 23, 2020 | Insight for DBAs, Insight for Developers, MySQL
If I ask you if running EXPLAIN on the query can change your database, you will probably tell me NO; it is common sense. EXPLAIN should show us how the query is executed, not execute the query, hence it can’t change any data. Unfortunately, this is the case where...
by Brandon Fleisher | Nov 23, 2020 | Insight for DBAs, Monitoring, Open Source, Percona Software
In the first quarter of 2021 (expected late January), Percona is slated to release a version of Percona Monitoring and Management (PMM) v2 that will include all of the critical functionality users of PMM v1 have come to know and love over the years. While PMM v2 has...
by Daniil Bazhenov | Nov 19, 2020 | Monitoring, Percona Software
We would love you to help us spread the word about Percona Monitoring and Management (PMM) to make sure even more people are aware of it and adopting it. And we are not afraid to offer (modest) bribes! If you already use PMM please write an independent review of its...
by Ivan Groenewold | Nov 5, 2020 | MongoDB, Monitoring, MySQL, Percona Software, PostgreSQL
Normally it is quite easy to deploy Percona Monitoring and Management (PMM) Server as a Docker container as per the official documentation. However, when working in very restrictive environments, it is possible the server doesn’t have access to the public...
