Nov 28, 2022 |
Cloud, Database Trends, Open Source
At its core, the cloud is a fantastic innovation — I do not think many of us will long for the days when it required days, weeks, or even months to provision a new server. Programmable, instantly accessible infrastructure comes with so much flexibility. It allows new deployment and management approaches we could not even […]
Oct 10, 2022 |
Percona Announcements
I have decided to step down from the role of CEO at Percona and take on the Founder role. Ann Schlemmer takes over as Percona CEO. I believe at this point this is the right step for the Company and myself personally. When – together with Vadim – we started Percona more than 16 years […]
Sep 09, 2022 |
Database Trends, MySQL, Open Source
Another day, another company announces it changed its license away from open source while claiming “We Believe In A Model Of Sustainable Open Source.” I’m not sure about you, but this rings to me as similar to an alleged quote about the Vietnam War: “We had to destroy the village in order to save it.” […]
Sep 08, 2022 |
Insight for DBAs, Monitoring, MySQL, Percona Software
In my previous blog post, ProcFS UDF: A Different Approach to Agentless Operating System Observability in Your Database, I wrote about the ProcFS UDF MySQL plugin, which allows you to get operating systems stats, through the MySQL database, without having shell access to the server and any local agent installation. Some of you wondered whether […]
Sep 01, 2022 |
Insight for DBAs, MySQL, Percona Software
When you look at database performance, it does not only depend on internal database operations but also on things going on in the operating system, network, storage system, hardware, etc. With that, if you’re building software to help analyze and optimize database performance, such as Percona Monitoring and Management (PMM), you need access to information […]
Aug 25, 2022 |
Cloud, Insight for DBAs, MySQL, Percona Software
With the economy slowing down and inflation raging in many parts of the world, your organization will love you if you find ways to reduce the costs of running their MySQL databases. This is especially true if you run MySQL in the cloud, as it often allows you to see the immediate effect of those […]
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 local MySQL Meetup, so if you have […]
Apr 08, 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 available”. Basically, PMM forgot what version it is and because […]
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 Community, as well as implement your own. In this blog post, […]
May 03, 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 we are changing pricing for Percona Monitoring and Management on AWS Marketplace. Currently, Percona Monitoring and Management (PMM) […]
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 can use Docker. Docker is not shipped with Windows 10, though you […]
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 went through many changes, so it’s time […]
Apr 06, 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 node_exporter, which exposes a lot of operating system metrics through the Prometheus protocol. […]
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 Statement Real-time access to queries that are running […]
Feb 09, 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 local networking. I have a TP-Link TL-SG108PE […]
Feb 08, 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 process can now be done in even fewer clicks! Click on “Deploy […]
Feb 02, 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) changed licenses to SSPL or similar. This culminated in Elastic changing their license […]
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 for you. Why is Percona Monitoring and Management moving […]
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, pre-computing and storing results of complicated queries, to limit data crunching needed during dashboard load. As an example, […]
Dec 07, 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 of the curve and have already updated to MySQL 5.7 or […]