by Peter Zaitsev | Jul 14, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
In this blog post, I will show how to install the MySQL-compatible Percona XtraDB Cluster (PXC) Operator on Minikube as well as perform some basic actions. I am by no means a Kubernetes expert and this blog post is the result of my explorations preparing for a... by Peter Zaitsev | Apr 8, 2022 | Monitoring, Percona Software
Just the other day, one of my Percona Monitoring and Management (PMM) instances failed to update and ended up in a funny state: No matter how many times I clicked the “check for updates” button in the lower right, PMM still showed “no updates... by Peter Zaitsev | Aug 31, 2021 | Insight for DBAs, Insight for Developers, Monitoring, Percona Software
Percona Monitoring and Management (PMM) has dashboards that cover a lot of ground, yet PMM Superpowers come from the fact you do not need to stick to dashboards that are included with the product! You also can easily install additional dashboards provided by the... by Peter Zaitsev | May 3, 2021 | Cloud, Monitoring, Percona Software
Percona Monitoring and Management has been available for single-click deployment from AWS Marketplace for several years now, and we have hundreds of instances concurrently active and growing rapidly due to unparalleled ease of deployment.Today we’re announcing... by Peter Zaitsev | Apr 28, 2021 | Monitoring, Percona Software
One way to run Percona Monitoring and Management (PMM) v2 on Windows is using the Virtual Appliance installation method. It works well but requires you to run extra software to run Virtual Appliances, such as Oracle VirtualBox, VMWare Workstation Player, etc. Or, you... by Peter Zaitsev | Apr 22, 2021 | Insight for DBAs, Monitoring, Percona Software
A few years ago, I wrote about how to add information about processes to your Percona Monitoring and Management (PMM) instance as well as some helpful ways you can use this data.Since that time, PMM has released a new major version (PMM v2) and the Process Exporter... by Peter Zaitsev | Apr 6, 2021 | Monitoring, Open Source, Percona Software
I try to use Open Source when a good solution exists, so for my home firewall, I’m using OPNSense – a very powerful FreeBSD-based firewall appliance with great features along with a powerful GUI.One of the plugins available with OPNSense is ... 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... 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... 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... by Peter Zaitsev | Feb 2, 2021 | Database Trends, Insight for DBAs, Open Source
After MongoDB switched to SSPL I wrote part one of this article, titled “Why MongoDB’s SSPL is Bad For You”. At the time it was a MongoDB phenomenon, though over the last 2+ years more companies (typically VC-funded unicorns or public companies)... 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... 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 Peter Zaitsev | Dec 7, 2020 | MySQL, Open Source, Security
As you may know, MySQL 5.6 will reach EOL (“End of Life”) in February 2021. This means in about two months, there will be no more updates, and more importantly, no more security fixes for discovered vulnerabilities. You may be well ahead... 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 Peter Zaitsev | Nov 2, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Understanding how MySQL uses memory is key to tuning it for optimal performance as well as troubleshooting cases of unexpected memory usage, i.e. when you have MySQL Server using a lot more than you would expect based on your configuration settings.Early in MySQL... by Peter Zaitsev | Oct 14, 2020 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
I am very passionate about database observability, and I believe query performance observability is the most important insight you can get in your database. Why? Because if you look from an application developer’s point of view, once a database is... by Peter Zaitsev | Sep 28, 2020 | Monitoring, Percona Software
Percona Monitoring and Management 2.10 shipped a few days ago and while it is a minor release, it introduces some features which I absolutely love. In this blog post, I will talk about those features – what they are and why they are worth loving. 🙂 1.... by Peter Zaitsev | Sep 11, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
One of the questions you often will be faced with operating a Linux-based system is managing memory budget. If a program uses more memory than available you may get swapping to happen, oftentimes with a terrible performance impact, or have Out of Memory (OOM) Killer... by Peter Zaitsev | Aug 28, 2020 | Insight for DBAs, MySQL, ProxySQL
ProxySQL brings a lot of value to your MySQL infrastructures such as Caching or Connection Multiplexing but it does not come free — your database needs to go through additional processing traffic which adds some overhead. In this blog post, we’re going to...