Wed, 10 Apr 2024 12:49:04 +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/percona-monitoring-and-management-setup-on-kubernetes-with-nginx-ingress-for-external-databases/ https://www.percona.com/blog/percona-monitoring-and-management-setup-on-kubernetes-with-nginx-ingress-for-external-databases/#respond Wed, 10 Apr 2024 12:49:04 +0000 https://www.percona.com/blog/?p=95637 It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The Ingress NGINX Controller is one of the most popular choices for managing the inbound traffic to K8s. It acts as a reverse proxy and load […]]]> https://www.percona.com/blog/percona-monitoring-and-management-setup-on-kubernetes-with-nginx-ingress-for-external-databases/feed/ 0 95637 https://www.percona.com/blog/postgresql-column-alignment-and-padding-how-to-improve-performance-with-smarter-table-design/ https://www.percona.com/blog/postgresql-column-alignment-and-padding-how-to-improve-performance-with-smarter-table-design/#comments Tue, 13 Feb 2024 18:17:49 +0000 https://www.percona.com/blog/?p=94370 In this blog post, we are going to briefly discuss the reasons why column order matters when creating tables -or relations- in PostgreSQL.AlignmentIn its internal representation of tuples, Postgres will set each column at a position depending on the alignment defined for the data type used (following the same sequential order as the one used […]]]> https://www.percona.com/blog/postgresql-column-alignment-and-padding-how-to-improve-performance-with-smarter-table-design/feed/ 3 94370 https://www.percona.com/blog/postgresql-checkpoints-buffers-and-wal-usage-with-percona-monitoring-and-management/ https://www.percona.com/blog/postgresql-checkpoints-buffers-and-wal-usage-with-percona-monitoring-and-management/#comments Thu, 09 Nov 2023 14:55:26 +0000 https://www.percona.com/blog/?p=91997 In this blog post, we will discuss how to extend Percona Monitoring and Management (PMM) to get PostgreSQL metrics on checkpointing activity, internal buffers, and WAL usage. With this data, we’ll be able to better understand and tune our Postgres servers.We’ll assume there are working PostgreSQL and PMM environments set up already. You can search […]]]> https://www.percona.com/blog/postgresql-checkpoints-buffers-and-wal-usage-with-percona-monitoring-and-management/feed/ 2 91997 https://www.percona.com/blog/monitoring-a-postgresql-patroni-cluster/ https://www.percona.com/blog/monitoring-a-postgresql-patroni-cluster/#comments Fri, 09 Jun 2023 13:42:03 +0000 https://www.percona.com/blog/?p=88386 Percona Monitoring and Management (PMM) boasts many functionalities that support its extension, be it by using Custom Queries, Custom Scripts, or by collecting data from already available External Exporters.In this short blog post, we will see how to quickly (and easily) monitor a PostgreSQL cluster managed by Patroni. I will assume you already have an […]]]> https://www.percona.com/blog/monitoring-a-postgresql-patroni-cluster/feed/ 1 88386 https://www.percona.com/blog/turbocharging-percona-monitoring-and-management-with-lokis-log-shipping-functionality/ https://www.percona.com/blog/turbocharging-percona-monitoring-and-management-with-lokis-log-shipping-functionality/#respond Thu, 06 Apr 2023 13:13:22 +0000 https://www.percona.com/blog/?p=86845 In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs.Loki is a log aggregation tool developed by Grafana Labs. It integrates easily with the Grafana instance that is running […]]]> https://www.percona.com/blog/turbocharging-percona-monitoring-and-management-with-lokis-log-shipping-functionality/feed/ 0 86845 https://www.percona.com/blog/enabling-and-enforcing-ssl-tls-for-postgresql-connections/ https://www.percona.com/blog/enabling-and-enforcing-ssl-tls-for-postgresql-connections/#comments Tue, 05 Jul 2022 11:57:05 +0000 https://www.percona.com/blog/?p=81404 Enabling SSL in PostgreSQL is very straightforward. In just three steps we can make sure the connections to it are more secure, using in-transit encryption via SSL/TLS: Make sure we have the server certificate and key files available Enable the SSL configuration (ssl = on) Make sure the pg_hba.conf file rules are updated accordingly In […]]]> https://www.percona.com/blog/enabling-and-enforcing-ssl-tls-for-postgresql-connections/feed/ 1 81404 https://www.percona.com/blog/how-to-hide-credentials-from-percona-monitoring-and-management-client-commands/ https://www.percona.com/blog/how-to-hide-credentials-from-percona-monitoring-and-management-client-commands/#respond Wed, 06 Oct 2021 13:38:19 +0000 https://www.percona.com/blog/?p=78470 In this short blog post, we are going to review how to avoid using credentials in the Percona Monitoring and Management (PMM) client command line when adding new exporters. We will use an example with the MySQL exporter, but it is extensible to others (PostgreSQL, MongoDB, etc.).In the online documentation we can see the basic […]]]> https://www.percona.com/blog/how-to-hide-credentials-from-percona-monitoring-and-management-client-commands/feed/ 0 78470 https://www.percona.com/blog/compiling-a-percona-monitoring-and-management-v2-client-in-arm-raspberry-pi-3/ https://www.percona.com/blog/compiling-a-percona-monitoring-and-management-v2-client-in-arm-raspberry-pi-3/#comments Wed, 26 May 2021 15:20:55 +0000 https://www.percona.com/blog/?p=76271 In this follow-up blog to Compiling a Percona Monitoring and Management v2 Client in ARM Architecture, we will show what changes are needed to get the latest versions of PMM working on ARM architecture. In this case, we will do it using a Raspberry Pi 3, instead of the AWS EC2 ARM node. With these […]]]> https://www.percona.com/blog/compiling-a-percona-monitoring-and-management-v2-client-in-arm-raspberry-pi-3/feed/ 1 76271 https://www.percona.com/blog/how-to-manually-remove-client-instances-from-percona-monitoring-and-management-2/ https://www.percona.com/blog/how-to-manually-remove-client-instances-from-percona-monitoring-and-management-2/#comments Wed, 05 Aug 2020 18:46:47 +0000 https://www.percona.com/blog/?p=70344 In this blog post, we will take a look at how we can manually remove a client instance from Percona Monitoring and Management (PMM) version 2. Under normal operations, this shouldn’t be necessary, since a graceful PMM client uninstall shouldn’t leave any lingering instances around. However, it may happen that an instance is destroyed (for […]]]> https://www.percona.com/blog/how-to-manually-remove-client-instances-from-percona-monitoring-and-management-2/feed/ 2 70344 https://www.percona.com/blog/compiling-a-percona-monitoring-and-management-v2-client-in-arm-architecture/ Tue, 04 Aug 2020 16:39:44 +0000 https://www.percona.com/blog/?p=70291 In this blog, we are going to see how to compile a Percona Monitoring and Management 2 (PMM v2) client in ARM. For this, we are going to use an AWS EC2 ARM instance with Amazon Linux 2.Installing DependenciesFirst, let’s get some basic packages out of the way, which probably are installed in your environment […]]]> 70291 https://www.percona.com/blog/setting-up-a-mysql-and-orchestrator-docker-environment/ https://www.percona.com/blog/setting-up-a-mysql-and-orchestrator-docker-environment/#comments Mon, 01 Jun 2020 13:57:23 +0000 https://www.percona.com/blog/?p=68584 In a previous post, Using DBdeployer to manage MySQL, Percona Server, and MariaDB sandboxes, we covered how we use DBdeployer within the Support Team to easily create MySQL environments for testing purposes. Here, I will expand on what Peter wrote in Installing MySQL with Docker, to create environments with more than one node. In particular, […]]]> https://www.percona.com/blog/setting-up-a-mysql-and-orchestrator-docker-environment/feed/ 5 68584 https://www.percona.com/blog/using-different-mount-points-on-percona-monitoring-and-management-2-docker-deployments/ Mon, 18 May 2020 13:37:46 +0000 https://www.percona.com/blog/?p=68290 Two years ago, we showed how to use a different mount point on Percona Monitoring and Management (PMM) Docker deployments, in case you need to have data stored out of the default Docker paths. We have released PMM version 2 since, and the need for these steps is still current. However, there are a few […]]]> 68290 https://www.percona.com/blog/testing-percona-xtradb-cluster-8-0-using-vagrant/ Wed, 06 May 2020 12:45:53 +0000 https://www.percona.com/blog/?p=67423 As Alkin and Ramesh have shown us in their Testing Percona XtraDB Cluster 8.0 with DBdeployer post, it is now possible to easily deploy an environment to test the features provided by the brand new release of Percona XtraDB Cluster 8.0.We have also worked on creating a testing environment available for those that use Vagrant […]]]> 67423 https://www.percona.com/blog/using-flame-graphs-to-process-outputs-from-pt-pmp/ Wed, 15 Jan 2020 19:58:14 +0000 https://www.percona.com/blog/?p=64611 In a previous post Profiling Software Using perf and Flame Graphs, we took a look at how to generate Flame Graphs from perf outputs. In this short follow-up, we will use Flame Graphs to process outputs from pt-pmp. Flame Graphs were not originally thought of for this purpose, but since pt-pmp outputs are similar to […]]]> 64611 https://www.percona.com/blog/profiling-software-using-perf-and-flame-graphs/ https://www.percona.com/blog/profiling-software-using-perf-and-flame-graphs/#comments Wed, 20 Nov 2019 18:47:10 +0000 https://www.percona.com/blog/?p=63493 In this blog post, we will see how to use perf (a.k.a.: perf_events) together with Flame Graphs. They are used to generate a graphical representation of what functions are being called within our software of choice. Percona Server for MySQL is used here, but it can be extended to any software you can take a […]]]> https://www.percona.com/blog/profiling-software-using-perf-and-flame-graphs/feed/ 2 63493 https://www.percona.com/blog/using-linux-fincore-to-check-linux-page-cache-usage/ https://www.percona.com/blog/using-linux-fincore-to-check-linux-page-cache-usage/#comments Fri, 30 Aug 2019 00:57:14 +0000 https://www.percona.com/blog/?p=61866 In this short blog post, we will check how to use linux-fincore to check which files are in the in-memory Linux page cache. To have an introductory read about the Linux page cache check here and here.In summary, whenever you read from or write to a file (unless you are using Direct_IO to bypass the […]]]> https://www.percona.com/blog/using-linux-fincore-to-check-linux-page-cache-usage/feed/ 2 61866 https://www.percona.com/blog/percona-universities-in-south-america-next-week/ Tue, 16 Apr 2019 17:48:04 +0000 https://www.percona.com/blog/?p=56444 There’s just one week to go before the first of this year’s Percona University events in South America. We’re really pleased with the lineup for all three events. We’re also incredibly happy with the response that we have had from the community. While we realize that a free event is… well… free… you are still […]]]> 56444 https://www.percona.com/blog/percona-university-travels-to-south-america/ https://www.percona.com/blog/percona-university-travels-to-south-america/#comments Wed, 27 Mar 2019 15:28:39 +0000 https://www.percona.com/blog/?p=56135 We started hosting Percona University a few years back with the aim of sharing knowledge with the open source database community. The events are held in cities across the world. The next Percona University days will visiting Uruguay, Argentina, and Brazil, in a lightning tour at the end of April. Montevideo, Tuesday, April 23 2019 […]]]> https://www.percona.com/blog/percona-university-travels-to-south-america/feed/ 4 56135 https://www.percona.com/blog/open-source-database-conference-cfp-deadline-sun-jan-27/ Fri, 25 Jan 2019 11:10:37 +0000 https://www.percona.com/blog/?p=55010 This year at our Open Source Database Conference we’re celebrating open source database technologies that don’t fit into the MySQL®, MongoDB®, MariaDB®, or PostgreSQL realms by featuring them in their very own track. The glamorously-named Other Open Source Databases track! As unbiased champions of open source database solutions, we embrace all flavors of open source […]]]> 55010 https://www.percona.com/blog/customizing-per-process-metrics-in-pmm/ Tue, 15 Jan 2019 16:20:44 +0000 https://www.percona.com/blog/?p=54684 If you have set up per-process metrics in Percona Monitoring and Management, you may have found yourself in need of tuning it further to not only group processes together, but to display some of them in isolation. In this blogpost we will explore how to modify the rules for grouping processes, so that you can […]]]> 54684