Wed, 20 Mar 2024 15:58:45 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/postgresql-monitoring-with-percona-monitoring-and-management-a-redefined-summary/ https://www.percona.com/blog/postgresql-monitoring-with-percona-monitoring-and-management-a-redefined-summary/#respond Wed, 20 Mar 2024 15:58:45 +0000 https://www.percona.com/blog/?p=95168 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 that matters”? It goes like this: Is my database ALIVE (in other words: […]]]> https://www.percona.com/blog/postgresql-monitoring-with-percona-monitoring-and-management-a-redefined-summary/feed/ 0 95168 https://www.percona.com/blog/percona-monitoring-and-management-database-overview-dashboard-simplified/ https://www.percona.com/blog/percona-monitoring-and-management-database-overview-dashboard-simplified/#respond Tue, 19 Mar 2024 14:42:59 +0000 https://www.percona.com/blog/?p=95155 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 visibility.” Now, we present a redesigned dashboard focused on simplicity:Where is the simplicity coming from? At first, […]]]> https://www.percona.com/blog/percona-monitoring-and-management-database-overview-dashboard-simplified/feed/ 0 95155 https://www.percona.com/blog/an-introduction-to-vector-databases/ https://www.percona.com/blog/an-introduction-to-vector-databases/#comments Wed, 24 Jan 2024 14:00:33 +0000 https://www.percona.com/blog/?p=93516 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 Patagonia weather,” not thinking of a […]]]> https://www.percona.com/blog/an-introduction-to-vector-databases/feed/ 1 93516 https://www.percona.com/blog/percona-monitoring-and-management-high-availability-a-proof-of-concept/ https://www.percona.com/blog/percona-monitoring-and-management-high-availability-a-proof-of-concept/#respond Thu, 21 Dec 2023 16:41:05 +0000 https://www.percona.com/blog/?p=92520 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 database space, makes PMM one of the best database monitoring solutions on the market.Being software composed […]]]> https://www.percona.com/blog/percona-monitoring-and-management-high-availability-a-proof-of-concept/feed/ 0 92520 https://www.percona.com/blog/percona-labs-presents-infrastructure-generator-for-percona-database-as-a-service-dbaas/ https://www.percona.com/blog/percona-labs-presents-infrastructure-generator-for-percona-database-as-a-service-dbaas/#respond Thu, 16 Mar 2023 12:21:00 +0000 https://www.percona.com/blog/?p=86118 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 and get a glimpse of the fantastic feature with our […]]]> https://www.percona.com/blog/percona-labs-presents-infrastructure-generator-for-percona-database-as-a-service-dbaas/feed/ 0 86118 https://www.percona.com/blog/mysql-in-microservices-environments/ https://www.percona.com/blog/mysql-in-microservices-environments/#respond Mon, 26 Sep 2022 12:02:31 +0000 https://www.percona.com/blog/?p=82786 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 infrastructure management.However, all that beauty hides a dark truth:The hardest part of microservices is the data […]]]> https://www.percona.com/blog/mysql-in-microservices-environments/feed/ 0 82786 https://www.percona.com/blog/percona-monitoring-and-management-home-dashboard-whats-new/ https://www.percona.com/blog/percona-monitoring-and-management-home-dashboard-whats-new/#comments Wed, 14 Sep 2022 12:01:04 +0000 https://www.percona.com/blog/?p=82658 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 so we can tackle the known performance […]]]> https://www.percona.com/blog/percona-monitoring-and-management-home-dashboard-whats-new/feed/ 1 82658 https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/ https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/#comments Thu, 08 Sep 2022 11:54:14 +0000 https://www.percona.com/blog/?p=82462 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 defined to have this retention policy: 7 daily full backups […]]]> https://www.percona.com/blog/aws-rds-backups-whats-the-true-cost/feed/ 6 82462 https://www.percona.com/blog/how-to-find-query-slowdowns-using-percona-monitoring-and-management/ https://www.percona.com/blog/how-to-find-query-slowdowns-using-percona-monitoring-and-management/#comments Wed, 07 Oct 2020 15:37:14 +0000 https://www.percona.com/blog/?p=71807 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 form of the Query Analytics dashboard (QAN).But where to start? QAN helps […]]]> https://www.percona.com/blog/how-to-find-query-slowdowns-using-percona-monitoring-and-management/feed/ 3 71807 https://www.percona.com/blog/rate-limit-throttle-for-mysql-with-proxysql/ Fri, 02 Oct 2020 13:46:28 +0000 https://www.percona.com/blog/?p=71673 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? In plain words: holding up queries for a while, giving air to […]]]> 71673 https://www.percona.com/blog/data-consistency-for-rds-for-mysql-the-8-0-version/ Fri, 11 Sep 2020 16:11:40 +0000 https://www.percona.com/blog/?p=71132 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 with 8.0.1, MySQL introduced something called “Dynamic Privileges” which is a solution to grant more […]]]> 71132 https://www.percona.com/blog/data-consistency-for-rds-for-mysql-pt-table-checksum-pt-query-digest/ https://www.percona.com/blog/data-consistency-for-rds-for-mysql-pt-table-checksum-pt-query-digest/#comments Tue, 08 Sep 2020 16:07:51 +0000 https://www.percona.com/blog/?p=71023 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 running pt-table-checksum to verify data consistency between a primary […]]]> https://www.percona.com/blog/data-consistency-for-rds-for-mysql-pt-table-checksum-pt-query-digest/feed/ 2 71023 https://www.percona.com/blog/percona-audit-log-plugin-and-the-percona-monitoring-and-management-security-threat-tool/ Wed, 22 Jul 2020 17:59:45 +0000 https://www.percona.com/blog/?p=69858 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 compliance as you have the ability to run checks daily, get alerts […]]]> 69858 https://www.percona.com/blog/scaling-the-percona-kubernetes-operator-for-percona-xtradb-cluster/ https://www.percona.com/blog/scaling-the-percona-kubernetes-operator-for-percona-xtradb-cluster/#comments Thu, 09 Jul 2020 13:59:56 +0000 https://www.percona.com/blog/?p=69714 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 let’s say, 5 pods. It’s just a matter of running the following […]]]> https://www.percona.com/blog/scaling-the-percona-kubernetes-operator-for-percona-xtradb-cluster/feed/ 2 69714 https://www.percona.com/blog/proxysql-behavior-in-the-percona-kubernetes-operator-for-percona-xtradb-cluster/ Fri, 03 Jul 2020 14:24:40 +0000 https://www.percona.com/blog/?p=69617 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 happens around ProxySQL in the context of […]]]> 69617 https://www.percona.com/blog/deploying-the-percona-kubernetes-operator-for-xtradb-cluster-in-amazon-aws/ Tue, 21 Jan 2020 14:23:27 +0000 https://www.percona.com/blog/?p=64807 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 universally): a Kubernetes cluster + the Percona XtraDB […]]]> 64807 https://www.percona.com/blog/amazon-rds-mysql-minor-upgrades-not-so-fast/ Tue, 14 Jan 2020 13:56:47 +0000 https://www.percona.com/blog/?p=64527 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 upgrade” or modify the DB instance and schedule the upgrade to […]]]> 64527 https://www.percona.com/blog/mysql-distributed-logical-backups-a-proof-of-concept/ https://www.percona.com/blog/mysql-distributed-logical-backups-a-proof-of-concept/#comments Thu, 09 Jan 2020 18:22:55 +0000 https://www.percona.com/blog/?p=64381 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 mysqldump, mydumper, or mysqlpump. Each of them with a specific purpose, MTTRs, retention […]]]> https://www.percona.com/blog/mysql-distributed-logical-backups-a-proof-of-concept/feed/ 6 64381 https://www.percona.com/blog/contention-in-mysql-innodb-useful-info-from-the-semaphores-section/ https://www.percona.com/blog/contention-in-mysql-innodb-useful-info-from-the-semaphores-section/#comments Fri, 20 Dec 2019 17:33:18 +0000 https://www.percona.com/blog/?p=63960 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 Perf and Flame graphs to track down the function taking way more time than expected. That method is great but how […]]]> https://www.percona.com/blog/contention-in-mysql-innodb-useful-info-from-the-semaphores-section/feed/ 2 63960 https://www.percona.com/blog/grafana-plugins-and-percona-monitoring-and-management/ Thu, 19 Dec 2019 17:27:57 +0000 https://www.percona.com/blog/?p=63883 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 way to enhance the ability to have specialized graphs. One case that […]]]> 63883