by Daniel Guzmán Burgos | Mar 20, 2024 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
When checking for how good (or bad) a PostgreSQL instance is behaving, one just wants to see everything that matters on a single-ish page. That’s what the new summary dashboard in Percona Monitoring and Management (PMM) is achieving:So, what is “everything... by Daniel Guzmán Burgos | Mar 19, 2024 | Insight for DBAs, Monitoring, Percona Software
Percona Monitoring and Management (PMM) overview dashboards were always meant to be a starting point for DBAs to check the overall health of the databases. Current overview dashboards can be a little overwhelming, based on an approach of “full... by Daniel Guzmán Burgos | Jan 24, 2024 | Database Trends, Insight for DBAs
Imagine that winter is coming to the south of the planet, that you are going on a vacation trip to Patagonia, and you want to buy some cozy clothes. You go to that nice searcher page that says “do no evil” and write in the search field “Jackets for... by Daniel Guzmán Burgos | Dec 21, 2023 | Insight for DBAs, Insight for Developers, Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a state-of-the-art piece of software that exists in part thanks to great open source projects like VictoriaMetrics, PostgreSQL, and ClickHouse. The integration of those projects, plus the years of Percona expertise in the... by Daniel Guzmán Burgos | Mar 16, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Let’s look at how you can run Percona databases on Kubernetes, the easy way.Chances are that if you are using the latest Percona Monitoring and Management (PMM) version, you have seen the availability of the new Percona Database as a Service (DBaaS). If not, go... by Daniel Guzmán Burgos | Sep 26, 2022 | Cloud, MySQL, Percona Software
The microservice architecture is not a new pattern but has become very popular lately for mainly two reasons: cloud computing and containers. That combo helped increase adoption by tackling the two main concerns on every infrastructure: Cost reduction and... by Daniel Guzmán Burgos | Sep 14, 2022 | Insight for DBAs, Monitoring, Percona Software
The all-new Percona Monitoring and Management (PMM) Home dashboard is the answer to some of the main concerns of our users: A clear entry point (where do I start?) Context (is everything okay?)How did we achieve this? By coming up with a redesign of the Home dashboard... by Daniel Guzmán Burgos | Sep 8, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
You have your database instance deployed with AWS and you are using AWS RDS for MySQL. All work smoothly in terms of satisfying queries for your application and delivering reliable uptime and performance. Now you need to take care of your backup strategy. Business is... by Daniel Guzmán Burgos | Oct 7, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Visibility is a blessing, and with databases, visibility is a must. That’s true not only for metrics but for the queries themselves. Having info on all the stats around query execution is priceless, and Percona Monitoring and Management (PMM) offers that in the... by Daniel Guzmán Burgos | Oct 2, 2020 | Insight for DBAs, Insight for Developers, MySQL, ProxySQL
Maybe one of the more “obscure” operations when dealing with replica lag, or, in general, when one needs to control writes to the database, is the Rate limit. It’s also lately one of the most popular conversations around the community.But what is it?... by Daniel Guzmán Burgos | Sep 11, 2020 | Cloud, Insight for DBAs, MySQL
In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency.Starting... by Daniel Guzmán Burgos | Sep 8, 2020 | Cloud, Insight for DBAs, MySQL
MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of... by Daniel Guzmán Burgos | Jul 22, 2020 | Insight for DBAs, Monitoring, Percona Software, Security
The Security Threat Tool has been available since Percona Monitoring and Management 2.6.0 (PMM) and starting from that first release it is proving to be a severely-needed feature. If you’re not familiar with the Security Threat Tool (STT), it helps you to ensure... by Daniel Guzmán Burgos | Jul 9, 2020 | Cloud, MySQL, Percona Software
You got yourself a Kubernetes cluster and are now testing our Percona Kubernetes Operator for Percona XtraDB Cluster. Everything is working great and you decided that you want to increase the number of Percona XtraDB Cluster (PXC) pods from the default 3, to... by Daniel Guzmán Burgos | Jul 3, 2020 | Cloud, MySQL, Percona Software, ProxySQL
The Percona Kubernetes Operator for Percona XtraDB Cluster(PXC) comes with ProxySQL as part of the deal. And to be honest, the behavior of ProxySQL is pretty much the same as in a regular non-k8s deployment of it. So why bother to write a blog about it? Because what... by Daniel Guzmán Burgos | Jan 21, 2020 | Cloud, MySQL, Percona Software, ProxySQL
Being that Amazon is one of the most-used cloud vendors, it is only natural that one may ask “How can Kubernetes be used in AWS?”. And the answer is – not that different than with other cloud vendors. What one needs is two things (and this applies... by Daniel Guzmán Burgos | Jan 14, 2020 | Cloud, Insight for DBAs, MySQL
The promise of DBaaS like RDS is to reduce operational overhead (among other things) and one of the stellar cases is upgrades (major and minor). The suggested procedure involves just a couple of steps. For example, using AWS Console, you can enable “Auto minor... by Daniel Guzmán Burgos | Jan 9, 2020 | MySQL, Percona Software
The importance of having periodic backups is a given in Database life. There are different flavors: binary ones (Percona XtraBackup), binlog backups, disk snapshots (lvm, ebs, etc) and the classic ones: logical backups, the ones that you can take with tools like... by Daniel Guzmán Burgos | Dec 20, 2019 | Insight for DBAs, MySQL, Storage Engine
In a high concurrency world, where more and more users->connections->threads are used, contention is a given. But how do we identify the contention point easily?Different approaches had been discussed previously, like the one using SHOW ENGINE INNODB STATUS... by Daniel Guzmán Burgos | Dec 19, 2019 | Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is built upon the shoulder of giants like Prometheus and Grafana. And speaking of Grafana, one of the coolest features that come with it is the ability to customize the experience through 3rd party plugins.Plugins are an easy...