Prometheus and Grafana kullanarak PostgreSQL Veritabanı İzleme(Monitoring)

Merhaba, bildiğiniz üzere sistemleri izlemek ve bu izleme sonucunda oluşan alarm ve metriklere göre aksiyonlar almak en önemli işlerden birisidir.
Bu yazımızda PostgreSQL veritabanını izlemek için Prometheus+Exporter+Grafana ürünlerini kullanarak izleme alt yapısı kurmaya çalışacağız. Kısaca bahsetmek gerekirse Prometheus eski Google çalışanları tarafından geliştirilmiş yeni nesil açık kaynak kodlu izleme aracıdır. Client üzerindeki Prometheus Exporter aracılığı ile ilgili metrikler toplanarak Prometheus formatına dönüştürülür. Prometheus ilgili metrikleri SNMP veya agent kullanmadan doğrudan http üzerinden kendi local veritabanına yazar. AlertManager ile bu metrikler üzerinde oluşan değerler için istenilen şekilde alarm mekanızması yapılandırılabilir. Grafana ise toplanan verileri görselleştirme ve sorgulamamıza yarayan bir raporlama aracı diye düşünebiliriz.
Kurulumda 2 adet sunucu kullanılmıştır:
– dbmonitor: Prometheus,grafana ve node_exporter kurulumu yapılacak monitoring için kullanılan ayrı bir sunucudur.
– pgforenda01: node_exporter ve postgres_exporter kurulumu yapılacak olan ve aynı zamanda postgresql veritabanı sunucusudur.

1- Prometheus node_exporter kurulumu(node_export aracı sunucu ile ilgili metrikleri toplayacaktır,her iki sunucuyu da kurulacaktır):

[root@pgforenda01 ~]# tar -xf node_exporter-1.1.2.linux-amd64.tar.gz 
[root@pgforenda01 ~]# cp -r node_exporter-1.1.2.linux-amd64/node_exporter /usr/local/bin
[root@pgforenda01 ~]# useradd -rs /bin/false node_exporter
[root@pgforenda01 ~]# vi /etc/systemd/system/node_exporter.service
[Unit]
Description=Node Exporter
After=network.target

[Service]
User=node_exporter
Group=node_exporter
Type=simple
ExecStart=/usr/local/bin/node_exporter

[Install]
WantedBy=multi-user.target
[root@pgforenda01 ~]# systemctl daemon-reload
[root@pgforenda01 ~]# systemctl enable node_exporter
Created symlink from /etc/systemd/system/multi-user.target.wants/node_exporter.service to /etc/systemd/system/node_exporter.service.
[root@pgforenda01 ~]# systemctl start node_exporter
[root@pgforenda01 ~]# systemctl status node_exporter
● node_exporter.service - Node Exporter
   Loaded: loaded (/etc/systemd/system/node_exporter.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2021-03-25 21:37:20 +03; 2s ago
 Main PID: 5647 (node_exporter)
    Tasks: 3
   CGroup: /system.slice/node_exporter.service
           └─5647 /usr/local/bin/node_exporter

Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.581Z caller=node_exporter.go:113 collector=thermal_zone
Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.581Z caller=node_exporter.go:113 collector=time
Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.581Z caller=node_exporter.go:113 collector=timex
Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.581Z caller=node_exporter.go:113 collector=udp_queues
Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.581Z caller=node_exporter.go:113 collector=uname
Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.581Z caller=node_exporter.go:113 collector=vmstat
Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.581Z caller=node_exporter.go:113 collector=xfs
Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.581Z caller=node_exporter.go:113 collector=zfs
Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.581Z caller=node_exporter.go:195 msg="Listening on" address=:9100
Mar 25 21:37:20 pgforenda01.localdomain node_exporter[5647]: level=info ts=2021-03-25T18:37:20.582Z caller=tls_config.go:191 msg="TLS is disabled." http2=false

http://pgforenda01:9100/metrics

yukarıdaki adımların aynısı dbmonitor sunucusu için de uygulandı ve aşağıdaki görüldüğü üzere çalışmaktadır:
[root@dbmonitor ~]# systemctl status node_exporter
● node_exporter.service - Node Exporter
   Loaded: loaded (/etc/systemd/system/node_exporter.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2021-03-25 21:42:50 +03; 8s ago
 Main PID: 5676 (node_exporter)
    Tasks: 3
   CGroup: /system.slice/node_exporter.service
           └─5676 /usr/local/bin/node_exporter

Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.961Z caller=node_exporter.go:113 collector=thermal_zone
Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.961Z caller=node_exporter.go:113 collector=time
Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.961Z caller=node_exporter.go:113 collector=timex
Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.961Z caller=node_exporter.go:113 collector=udp_queues
Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.961Z caller=node_exporter.go:113 collector=uname
Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.961Z caller=node_exporter.go:113 collector=vmstat
Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.961Z caller=node_exporter.go:113 collector=xfs
Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.961Z caller=node_exporter.go:113 collector=zfs
Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.961Z caller=node_exporter.go:195 msg="Listening on" address=:9100
Mar 25 21:42:50 dbmonitor node_exporter[5676]: level=info ts=2021-03-25T18:42:50.962Z caller=tls_config.go:191 msg="TLS is disabled." http2=false

http://dbmonitor:9100/metrics

2- Prometheus kurulumu(dbmonitor sunucusuna kurulacaktır)
Öncelikle dbmonitor ve pgforenda sunucuları arasında network erişimleri açık olmalı,/etc/hosts dosyasına da sunucu host bilgileri eklenmelidir.

[root@dbmonitor ~]# tar -xf prometheus-2.25.2.linux-amd64.tar.gz 
[root@dbmonitor ~]# ls -lhtr
total 64M
-rw-------. 1 root root 1.9K Dec 26 12:48 anaconda-ks.cfg
-rw-r--r--. 1 root root 1.9K Dec 26 12:53 initial-setup-ks.cfg
drwxr-xr-x. 2 root root    6 Feb 24 21:54 Templates
drwxr-xr-x. 2 root root    6 Feb 24 21:54 Downloads
drwxr-xr-x. 2 root root    6 Feb 24 21:54 Desktop
drwxr-xr-x. 2 root root    6 Feb 24 21:54 Videos
drwxr-xr-x. 2 root root    6 Feb 24 21:54 Public
drwxr-xr-x. 2 root root    6 Feb 24 21:54 Pictures
drwxr-xr-x. 2 root root    6 Feb 24 21:54 Music
drwxr-xr-x. 2 root root    6 Feb 24 21:54 Documents
drwxr-xr-x. 4 3434 3434  132 Mar 16 23:22 prometheus-2.25.2.linux-amd64
-rw-r--r--. 1 root root  64M Mar 16 23:25 prometheus-2.25.2.linux-amd64.tar.gz
[root@dbmonitor ~]# mkdir /etc/prometheus
[root@dbmonitor ~]# mkdir /var/lib/prometheus
[root@dbmonitor ~]# cp -r prometheus-2.25.2.linux-amd64/prometheus /usr/local/bin/
[root@dbmonitor ~]# cp -r prometheus-2.25.2.linux-amd64/promtool /usr/local/bin/
[root@dbmonitor ~]# cp -r prometheus-2.25.2.linux-amd64/consoles /etc/prometheus/
[root@dbmonitor ~]# cp -r prometheus-2.25.2.linux-amd64/console_libraries /etc/prometheus/
[root@dbmonitor ~]# vi /etc/prometheus/prometheus.yml
global:
  scrape_interval: 10s

scrape_configs:
  - job_name: 'prometheus_metrics'
    scrape_interval: 5s
    static_configs:
      - targets: ['localhost:9090']
  - job_name: 'node_exporter_metrics'
    scrape_interval: 5s
    static_configs:
      - targets: ['localhost:9100','pgforenda01:9100']

[root@dbmonitor ~]# useradd -rs /bin/false prometheus
[root@dbmonitor ~]# chown -R prometheus: /etc/prometheus /var/lib/prometheus
[root@dbmonitor ~]# vi /etc/systemd/system/prometheus.service
[Unit]
Description=Prometheus
Wants=network-online.target
After=network-online.target
 
[Service]
User=prometheus
Group=prometheus
Type=simple
ExecStart=/usr/local/bin/prometheus \
--config.file /etc/prometheus/prometheus.yml \
--storage.tsdb.path /var/lib/prometheus/ \
--web.console.templates=/etc/prometheus/consoles \
--web.console.libraries=/etc/prometheus/console_libraries
 
[Install]
WantedBy=multi-user.target

[root@dbmonitor ~]# systemctl daemon-reload
[root@dbmonitor ~]# systemctl enable prometheus
Created symlink from /etc/systemd/system/multi-user.target.wants/prometheus.service to /etc/systemd/system/prometheus.service.
[root@dbmonitor ~]# systemctl start prometheus
[root@dbmonitor ~]# systemctl status prometheus
● prometheus.service - Prometheus
   Loaded: loaded (/etc/systemd/system/prometheus.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2021-03-25 21:11:44 +03; 4s ago
 Main PID: 5213 (prometheus)
    Tasks: 6
   CGroup: /system.slice/prometheus.service
           └─5213 /usr/local/bin/prometheus --config.file /etc/prometheus/prometheus.yml --storage.tsdb.path /var/lib/prometheus/ --web.console.templates=/etc/prometheus/consoles --web.console.librarie...

Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.182Z caller=head.go:682 component=tsdb msg="On-disk memory mappable chunks replay completed" duration=3.963µs
Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.182Z caller=head.go:688 component=tsdb msg="Replaying WAL, this may take a while"
Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.183Z caller=tls_config.go:191 component=web msg="TLS is disabled." http2=false
Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.183Z caller=head.go:740 component=tsdb msg="WAL segment loaded" segment=0 maxSegment=0
Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.183Z caller=head.go:745 component=tsdb msg="WAL replay completed" checkpoint_replay_duration=15.22µs wal_repla…ation=710.202µs
Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.184Z caller=main.go:799 fs_type=XFS_SUPER_MAGIC
Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.184Z caller=main.go:802 msg="TSDB started"
Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.184Z caller=main.go:928 msg="Loading configuration file" filename=/etc/prometheus/prometheus.yml
Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.454Z caller=main.go:959 msg="Completed loading of configuration file" filename=/etc/prometheus/prometheus.yml totalDuration…µs
Mar 25 21:11:44 dbmonitor prometheus[5213]: level=info ts=2021-03-25T18:11:44.454Z caller=main.go:751 msg="Server is ready to receive web requests."
Hint: Some lines were ellipsized, use -l to show in full.
[root@dbmonitor ~]# 

[root@dbmonitor ~]# netstat -anpt|grep :9090
tcp6       0      0 :::9090                 :::*                    LISTEN      5213/prometheus     
tcp6       0      0 ::1:59734               ::1:9090                ESTABLISHED 5213/prometheus     
tcp6       0      0 ::1:9090                ::1:59734               ESTABLISHED 5213/prometheus 

[root@dbmonitor ~]# systemctl stop firewalld
http://dbmonitor:9090/targets

3- postgres_exporter kurulumu(pgforenda01 sunucusuna postgreSQL metriklerini toplamak için kurulucaktır):

[root@pgforenda01 ~]# mkdir /opt/postgres_exporter
[root@pgforenda01 ~]# cd /opt/postgres_exporter
[root@pgforenda01 ~]# wget https://github.com/prometheus-community/postgres_exporter/releases/download/v0.9.0/postgres_exporter-0.9.0.linux-amd64.tar.gz
[root@pgforenda01 ~]# tar -xf postgres_exporter-0.9.0.linux-amd64.tar.gz
[root@pgforenda01 ~]# cd postgres_exporter-0.9.0.linux-amd64/
[root@pgforenda01 postgres_exporter-0.9.0.linux-amd64]# cp postgres_exporter /usr/local/bin

[root@pgforenda01 postgres_exporter]# vi /etc/systemd/system/postgres_exporter.service
[Unit]
Description=Prometheus exporter for Postgresql
Wants=network-online.target
After=network-online.target
[Service]
User=postgres
Group=postgres
WorkingDirectory=/opt/postgres_exporter
EnvironmentFile=/opt/postgres_exporter/postgres_exporter.env
ExecStart=/usr/local/bin/postgres_exporter --web.listen-address=:9187 --web.telemetry-path=/metrics
Restart=always
[Install]

[root@pgforenda01 postgres_exporter]# systemctl daemon-reload
[root@pgforenda01 postgres_exporter]# systemctl enable postgres_exporter
Created symlink from /etc/systemd/system/multi-user.target.wants/postgres_exporter.service to /etc/systemd/system/postgres_exporter.service.
[root@pgforenda01 postgres_exporter]# systemctl start postgres_exporter
[root@pgforenda01 postgres_exporter]# systemctl status postgres_exporter
● postgres_exporter.service - Prometheus exporter for Postgresql
   Loaded: loaded (/etc/systemd/system/postgres_exporter.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2021-03-25 22:16:08 +03; 40s ago
 Main PID: 6184 (postgres_export)
   CGroup: /system.slice/postgres_exporter.service
           └─6184 /usr/local/bin/postgres_exporter --web.listen-address=:9187 --web.telemetry-path=/metrics

Mar 25 22:16:08 pgforenda01.localdomain systemd[1]: Started Prometheus exporter for Postgresql.
Mar 25 22:16:08 pgforenda01.localdomain postgres_exporter[6184]: time="2021-03-25T22:16:08+03:00" level=info msg="Starting Server: :9187" source="postgres_exporter.go:1850"

--postgres_exporter kurulduktan sonra prometheus.yaml dosyası aşağıdaki gibi postgres_exporter eklenerek restart edilir:
[root@dbmonitor ~]# vi /etc/prometheus/prometheus.yml
global:
  scrape_interval: 10s

scrape_configs:
  - job_name: 'prometheus_metrics'
    scrape_interval: 5s
    static_configs:
      - targets: ['localhost:9090']
  - job_name: 'node_exporter_metrics'
    scrape_interval: 5s
    static_configs:
      - targets: ['localhost:9100','pgforenda01:9100']
  - job_name: 'postgres_exporter'
    static_configs:
      - targets: ['pgforenda01:9187']

[root@dbmonitor ~]# systemctl stop prometheus
[root@dbmonitor ~]# systemctl start prometheus
[root@dbmonitor ~]# systemctl status prometheus
● prometheus.service - Prometheus
   Loaded: loaded (/etc/systemd/system/prometheus.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2021-03-25 23:02:56 +03; 5s ago
 Main PID: 6559 (prometheus)
    Tasks: 6
   CGroup: /system.slice/prometheus.service
           └─6559 /usr/local/bin/prometheus --config.file /etc/prometheus/prometheus.yml --storage.tsdb.path /var/lib/prometheus/ --web.console.templates=/etc/prometheus/consoles --web.console.librarie...

Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.611Z caller=tls_config.go:191 component=web msg="TLS is disabled." http2=false
Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.628Z caller=head.go:740 component=tsdb msg="WAL segment loaded" segment=0 maxSegment=2
Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.763Z caller=head.go:740 component=tsdb msg="WAL segment loaded" segment=1 maxSegment=2
Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.763Z caller=head.go:740 component=tsdb msg="WAL segment loaded" segment=2 maxSegment=2
Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.763Z caller=head.go:745 component=tsdb msg="WAL replay completed" checkpoint_replay_duration=41.967µs wal_repl…on=179.362675ms
Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.766Z caller=main.go:799 fs_type=XFS_SUPER_MAGIC
Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.766Z caller=main.go:802 msg="TSDB started"
Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.766Z caller=main.go:928 msg="Loading configuration file" filename=/etc/prometheus/prometheus.yml
Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.767Z caller=main.go:959 msg="Completed loading of configuration file" filename=/etc/prometheus/prometheus.yml totalDuration…µs
Mar 25 23:02:56 dbmonitor prometheus[6559]: level=info ts=2021-03-25T20:02:56.767Z caller=main.go:751 msg="Server is ready to receive web requests."
Hint: Some lines were ellipsized, use -l to show in full.

aşağıdaki link üzerinden target'lar görüntülenebilir.

http://dbmonitor:9090/targets

4- Grafana kurulumu(dbmonitor sunucusuna kurulacaktır,toplanan verileri görselleştirmek amaçlı kullanılacaktır)

[root@dbmonitor ~]# vi /etc/yum.repos.d/grafana.repo
[grafana]
name=grafana
baseurl=https://packages.grafana.com/oss/rpm
repo_gpgcheck=1
enabled=1
gpgcheck=1
gpgkey=https://packages.grafana.com/gpg.key
sslverify=1
sslcacert=/etc/pki/tls/certs/ca-bundle.crt
[root@dbmonitor ~]# yum makecache fast
[root@dbmonitor ~]# yum install  -y grafana
[root@dbmonitor ~]# systemctl enable --now grafana-server.service
[root@dbmonitor ~]# systemctl status grafana-server
● grafana-server.service - Grafana instance
   Loaded: loaded (/usr/lib/systemd/system/grafana-server.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2021-03-25 23:12:17 +03; 13s ago
     Docs: http://docs.grafana.org
 Main PID: 6769 (grafana-server)
    Tasks: 7
   CGroup: /system.slice/grafana-server.service
           └─6769 /usr/sbin/grafana-server --config=/etc/grafana/grafana.ini --pidfile=/var/run/grafana/grafana-server.pid --packaging=rpm cfg:default.paths.logs=/var/log/grafana cfg:default.paths.data...

Mar 25 23:12:17 dbmonitor grafana-server[6769]: {"@level":"debug","@message":"datasource: registering query type handler","@timestamp":"2021-03-25T23:12:17.427985+03:00","queryType":"arrow"}
Mar 25 23:12:17 dbmonitor grafana-server[6769]: {"@level":"debug","@message":"datasource: registering query type handler","@timestamp":"2021-03-25T23:12:17.427990+03:00","queryType":"annotations"}
Mar 25 23:12:17 dbmonitor grafana-server[6769]: {"@level":"debug","@message":"datasource: registering query type handler","@timestamp":"2021-03-25T23:12:17.427995+03:00","queryType":"table_static"}
Mar 25 23:12:17 dbmonitor grafana-server[6769]: {"@level":"debug","@message":"datasource: registering query type handler","@timestamp":"2021-03-25T23:12:17.427999+03:00","queryType":"rando..._with_error"}
Mar 25 23:12:17 dbmonitor grafana-server[6769]: {"@level":"debug","@message":"datasource: registering query type handler","@timestamp":"2021-03-25T23:12:17.428003+03:00","queryType":"server_error_500"}
Mar 25 23:12:17 dbmonitor grafana-server[6769]: {"@level":"debug","@message":"datasource: registering query type handler","@timestamp":"2021-03-25T23:12:17.428007+03:00","queryType":"logs"}
Mar 25 23:12:17 dbmonitor grafana-server[6769]: {"@level":"debug","@message":"datasource: registering query type handler","@timestamp":"2021-03-25T23:12:17.428011+03:00","queryType":"node_graph"}
Mar 25 23:12:17 dbmonitor grafana-server[6769]: {"@level":"debug","@message":"datasource: registering query type fallback handler","@timestamp":"2021-03-25T23:12:17.428016+03:00"}
Mar 25 23:12:17 dbmonitor systemd[1]: Started Grafana instance.
Mar 25 23:12:17 dbmonitor grafana-server[6769]: t=2021-03-25T23:12:17+0300 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
Hint: Some lines were ellipsized, use -l to show in full.
aşağıdaki link üzerinden grafanaya erişebiliriz:
http://dbmonitor:3000/
default username/password: admin/admin

5- Grafanaya Prometheus data source eklenerek entegrasyon sağlanır:
http://dbmonitor:3000/datasources sekmesinden “Add data source ” diyerek Prometheus seçilir

Daha sonra aşağıdaki ekranda sadece http kısmındaki URL localhost:9090 yazılarak geri kalan kısımlar default bırakılır ve save&test butonuna basılarak sağlıklı çalıştığı test edilir.

Yukarıdaki test başarılı olduktan sonra grafana dashboard aşağıdaki gibi import edilir.
(https://grafana.com/grafana/dashboards/9628 linkinden json formatında dashboard içeriği indirilerek kopyalanır ve bu kopyalan json içeriği aşağıdaki gibi import edilir:
http://dbmonitor:3000/dashboard/import sekmesinde panel json kısmına yapıştırılarak “Load” butonuna basılır.

Daha sonra data source olarak default Prometheus seçilir ve “Import” butonuna basılır.

import işlemi bittikten sonra aşağıdaki gibi bir ekran gelecektir:

Grafana ile ilgili birçok dashboard bulabilirsiniz. Kurduğumuz bu yapıda AlertManager ile ilgili kısmı da başka bir yazımızda aktarmaya çalışacağız.
Ek olarak eğer ortamda çok fazla sunucu ve veritabanı varsa Consul For Monitoring Dynamic Services kullanabilirsiniz. Eğer Zabbix kullanıyorsanız farkları görmeniz açısından hem PMM hem de Prometheus araçlarını da test etmenizi kesinlikle tavsiye ederiz. Bu araçlarda alarm mekanızması sağlıklı çalışıyor mu?Yüksek kaynak kullanım anlarında gerçekten monitoring süreci sağlıklı mı,mesela PostgreSQL veritabanı sunucusu CPU kullanımı %100’e yaklaştığında monitoring aracınız sağlıklı çalışabiliyor mu? Geriye dönük analiz yapabiliyor musunuz gibi soruların cevaplarını hangi araçta bulabildiğinizden emin olmanızı tavsiye ederiz.

Faydalı olması dileğiyle.
dba@forenda.com.tr