Grafana Dashboard for Pgpool-II Exporter

-

Pgpool-II Exporter is a tool that periodically collects Pgpool-II and PostgreSQL Cluster's metrics and exports the results as Prometheus metrics. 

Pgpool-II Exporter uses SHOW command to collect Pgpool-II and PostgreSQL Cluster's metrics, including:

name Description
pgpool2_frontend_total Number of total child processes
pgpool2_frontend_used Number of used child processes
pgpool2_frontend_used_ratio Ratio of used child processes to total child processes (0.0 to 1.0)
pgpool2_pool_nodes_status Backend node Status (1 for up or waiting, 0 for down or unused)
pgpool2_pool_nodes_replication_delay Replication delay
pgpool2_pool_backend_stats_error_cnt Error message counts returned from backend
pgpool2_pool_backend_stats_fatal_cnt Fatal message counts returned from backend
pgpool2_pool_backend_stats_panic_cnt Panic message counts returned from backend
pgpool2_pool_backend_stats_select_cnt SELECT statement counts issued to each backend
pgpool2_pool_backend_stats_insert_cnt INSERT statement counts issued to each backend
pgpool2_pool_backend_stats_update_cnt UPDATE statement counts issued to each backend
... ...

Grafana is an open source data-visualization web application, which supports Prometheus data source.

This post describes how to use Grafana to visualize the metrics collected by Pgpool-II Exporter.

Prerequisites

Before you start, ensure that:

  • Pgpool-II Exporter and Prometheus server are running.
  • Prometheus server is configured for scraping Pgpool-II Exporter metrics.

For details, refer to the previous post.

Configuring Grafana

Pgpool-II community provides a Grafana Dashboard template for Pgpool-II Exporter. Download this dashboard and import it into your Grafana. 

After importing the dashboard from JSON file, you can find the Pgpool-II dashboard in your Grafana Home page.


 


Comments

Post a Comment

Popular posts from this blog

Installing Pgpool-II on Debian/Ubuntu

-
First of all, many thanks to the PostgreSQL Global Development Group (PGDG) for creating Pgpool-II packages for Debian and Ubuntu. This post shows you step by step how to install Pgpool-II using official APT repository provided by PGDG. Prerequisites This blog assumes you have already installed two PostgreSQL 14 servers and setup streaming replication between the PostgreSQL servers.   For testing purpose,we set trust authentication in pg_hba.conf . In a production environment, Please follow the PostgreSQL and Pgpool-II documentation to configure proper authentication settings.  Install Pgpool-II To use the PostgreSQL apt repository, follow the steps below. Create the repository configuration file: # echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list Import the repository signing key: # wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - Update the package lists: # ...
Read more

Authentication in Pgpool-II

-
Image
    Pgpool-II is a proxy software for PostgreSQL cluster and it supports several authentication methods. How does Pgpool-II perform user authentication? In this post, I will introduce the authentication methods which Pgpool-II supports and how Pgpool-II authentication mechanism works. Authentication methods in Pgpool-II Pgpool-II supports several authentication methods: Trust Authentication MD5 Password Authentication   scram-sha-256 Authentication (Pgpool-II 4.0 or later) Certificate Authentication   PAM Authentication LDAP Authentication (from the next major release 4.2)  Starting with Pgpool-II 4.0, Pgpool-II supports scram-sha-256 authentication. scram-sha-256 authentication method is strongly recommended because it is the most secure password-based authentication method. How does Pgpool-II authentication mechanism work? Since Pgpool-II is a PostgreSQL proxy that works between clients and PostgreSQL servers, the authentication comprises two steps: Authen...
Read more

Query Load Balancing in Pgpool-II

-
Image
Pgpool-II is a PostgreSQL cluster management tool. The major features of Pgpool-II are: Connection pooling Query load balancing Automated failover Watchdog (High availability of Pgpool-II) Replication In memory query cache In this post, I will describe the query load balancing mechanism in Pgpool-II and the relevant configuration parameters. Why use query load balancing? Query load balancing can distribute database server workloads across multiple PostgreSQL servers. Nowadays, most database systems use multiple replicated database servers to achieve high availability for PostgreSQL. Pgpool-II takes the advantage of the replication feature in order to distribute the workloads across multiple PostgreSQL servers. If there is a PostgreSQL cluster with multiple PostgreSQL servers, Pgpool-II is able to distribute READ queries across those PostgreSQL servers. The benefit of READ queries load balancing is, improve the system's throughput reduce the load on each PostgreSQL server optimize...
Read more