{"id":519,"date":"2022-01-14T07:07:33","date_gmt":"2022-01-14T06:07:33","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/2022\/01\/14\/what-i-really-like-about-percona-pmm\/"},"modified":"2026-03-23T11:18:57","modified_gmt":"2026-03-23T10:18:57","slug":"what-i-really-like-about-percona-pmm","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/","title":{"rendered":"What I really like about Percona PMM"},"content":{"rendered":"

Percona Monitoring and Management tool (PMM<\/a>) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we can do much more with it!
\nI discovered this tool 2 years ago when I started a monitoring study for a customer, and ever since, I’ve been in love with it. I will explain you why.<\/p>\n

\"\"
\n<\/p>\n

It’s Open Source!<\/h2>\n

Even if money is not everything…<\/h3>\n

\"\"<\/a>
\nPMM is completely Open Source, and this is not surprising coming from Percona<\/a>. But as we know, the advantage of Open Source is not only the fact of being free…<\/p>\n

Let’s contribute<\/h3>\n

\"\"<\/a>
\nOne of the keys of Open Source is contribution. When I started using PMM and sometimes I cannot find all the information I needed and more details in the official documentation<\/a>, or when I discover a bug or have a question, or even if I would like to have a new feature implemented, a whole community is there to support and share knowledge in a very impressive short time:
\n– A JIRA<\/a> issue tracker to submit a bug report.
\n– A very useful blog<\/a> with plenty of posts about new features, technical step-by-step deployment information, tips and much more. And obviously the possibility to write to the author.
\n– A Percona Community Forum<\/a> to exchange with Percona experts.<\/p>\n

Evolution<\/h3>\n

\"\"<\/a>
\nOpen Source means also quick evolution of the product. PMM is getting better every month, with continuous improvements, new features, corrections of bugs and so on.<\/p>\n

One tool to monitor several technologies<\/h2>\n

\"\"<\/a>
\nIf we speak about monitoring solutions, what makes the difference nowadays? Except rare cases, each of us works with a mix of different database solutions: Open Source vs proprietary, On-Premises vs Cloud. And when we want to identify performance issues on our application, we also need system benchmarks, replication metrics, etc… PMM is a platform that we can use to centralize our monitoring data, because:
\n– Exporters to collect metrics for MySQL<\/a>, MariaDB<\/a>, PostgreSQL<\/a> and MongoDB<\/a> instances and their replication, the ProxySQL<\/a> and the HAProxy<\/a>, instances hosted on Amazon RDS<\/a> or on Google Cloud Platform<\/a> are embedded in the PMM tool as well as pre-configured dashboards, so the monitoring can be easily put in place.
\n– Even proprietary technologies such as Oracle<\/a> and SQL Server<\/a> can be integrated to PMM through external exporters. In this case we have the choice to develop our own exporter and design our own dashboards or use what is already been developed and designed by other contributors. Here<\/a> you can find the links to some Third-party exporters.<\/p>\n

Less maintenance tasks<\/h2>\n

\"\"<\/a>
\nThe PMM platform is based on a client-server model. The 2 main components on the server side are the following ones:
\n– VictoriaMetrics<\/a>, a time series database (replacing Prometheus<\/a> since PMM 2.12.0 version) that aggregates metrics collected by exporters
\n– Grafana<\/a> allowing to visualize the aggregated data in a web interface.
\nBut actually, we don’t have to care about that! We don’t need to install Prometheus or VictoriaMetrics components, install Grafana and then configure it to let them talk together. We can just see the PMM platform as a black box: we will have only one tool to install and to maintain.<\/p>\n

Sexy dashboards<\/h2>\n

Integrated dashboards are designed with accuracy and provide a detailed and temporal analysis of our data.
\nHere my favorite ones:
\n– Node Summary<\/strong>
\nIt’s the system dashboard. We can visualize here metrics such as CPU, memory, disk occupation and performances, processes, network traffic and get some information about our system architecture:
\n\"\"<\/a>
\nWe have also the possibility to compare several nodes:
\n\"\"<\/a>
\n– MySQL Summary<\/strong>
\nIt’s one of the MySQL dashboards which displays general metrics about our instance (uptime, version, InnoDB Buffer Pool size, connections, threads, table locks, traffic, and much more):
\n\"\"<\/a>
\nAnd we still have the option to compare different instances.
\n– MySQL Replication<\/strong>
\nIt’s the dashboard which offers us an overview on the MySQL Master-Slave Replication:
\n\"\"<\/a>
\n– Query Analytics<\/strong>
\nQAN is a special dashboard that allows us to analyze MySQL and PostgreSQL databases queries over time:
\n\"\"<\/a>
\nThis can be very useful to identify performance problems.<\/p>\n

Coming soon<\/h2>\n

\"\"<\/a>
\nCurrently the last PMM stable release is 2.25.0. As we told just above, the tool is evolving a lot, and nice features are already available in technical preview:
\n\"\"<\/a>
\nYou can already play with that even if for the moment it’s not suggested to use them for production environments. I tested for example the Integrated Alerting and I cannot wait to have it available as a stable feature (we don’t need then anymore to configure an External Prometheus Alertmanager to be alerted if something goes wrong on our systems).<\/p>\n

I hope you have enjoyed this introduction to PMM.
\nNow it’s up to you: don’t hesitate to test it! For my part, I will surely write again about PMM, so stay tuned! \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"

Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we can do much more with it! I discovered this tool 2 years ago when I started a monitoring […]<\/p>\n","protected":false},"author":42,"featured_media":534,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,229,1726,1316,59,83,99],"tags":[135,141,142,143,144,145,146],"type_dbi":[],"class_list":["post-519","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","category-database-administration-monitoring","category-mariadb","category-mysql","category-oracle","category-postgresql","category-sql-server","tag-cloud","tag-mariadb","tag-microsoft-sql-server","tag-monitoring","tag-mysql","tag-percona","tag-pmm"],"acf":[],"yoast_head":"\nWhat I really like about Percona PMM - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What I really like about Percona PMM\" \/>\n<meta property=\"og:description\" content=\"Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we can do much more with it! I discovered this tool 2 years ago when I started a monitoring […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-14T06:07:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-23T10:18:57+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png\" \/>\n\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t<meta property=\"og:image:height\" content=\"233\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Elisa Usai\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elisa Usai\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/\"},\"author\":{\"name\":\"Elisa Usai\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f\"},\"headline\":\"What I really like about Percona PMM\",\"datePublished\":\"2022-01-14T06:07:33+00:00\",\"dateModified\":\"2026-03-23T10:18:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/\"},\"wordCount\":826,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png\",\"keywords\":[\"Cloud\",\"MariaDB\",\"Microsoft SQL Server\",\"Monitoring\",\"MySQL\",\"Percona\",\"PMM\"],\"articleSection\":[\"Cloud\",\"Database Administration & Monitoring\",\"MariaDB\",\"MySQL\",\"Oracle\",\"PostgreSQL\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/\",\"name\":\"What I really like about Percona PMM - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png\",\"datePublished\":\"2022-01-14T06:07:33+00:00\",\"dateModified\":\"2026-03-23T10:18:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png\",\"width\":350,\"height\":233},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What I really like about Percona PMM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f\",\"name\":\"Elisa Usai\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g\",\"caption\":\"Elisa Usai\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/elisa-usai\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What I really like about Percona PMM - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/","og_locale":"en_US","og_type":"article","og_title":"What I really like about Percona PMM","og_description":"Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we can do much more with it! I discovered this tool 2 years ago when I started a monitoring […]","og_url":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/","og_site_name":"dbi Blog","article_published_time":"2022-01-14T06:07:33+00:00","article_modified_time":"2026-03-23T10:18:57+00:00","og_image":[{"width":350,"height":233,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png","type":"image\/png"}],"author":"Elisa Usai","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elisa Usai","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/"},"author":{"name":"Elisa Usai","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f"},"headline":"What I really like about Percona PMM","datePublished":"2022-01-14T06:07:33+00:00","dateModified":"2026-03-23T10:18:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/"},"wordCount":826,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png","keywords":["Cloud","MariaDB","Microsoft SQL Server","Monitoring","MySQL","Percona","PMM"],"articleSection":["Cloud","Database Administration & Monitoring","MariaDB","MySQL","Oracle","PostgreSQL","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/","url":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/","name":"What I really like about Percona PMM - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png","datePublished":"2022-01-14T06:07:33+00:00","dateModified":"2026-03-23T10:18:57+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/PMM-1-e1642165896895.png","width":350,"height":233},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/what-i-really-like-about-percona-pmm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What I really like about Percona PMM"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f","name":"Elisa Usai","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g","caption":"Elisa Usai"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/elisa-usai\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=519"}],"version-history":[{"count":9,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/519\/revisions"}],"predecessor-version":[{"id":43537,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/519\/revisions\/43537"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/534"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=519"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}