合 PG高可用集群之Patroni + etcd + HAProxy + keepalived + Prometheus + Grafana监控 部署
Tags： PG高可用GrafanaPrometheuskeepalivedPatroniHAProxyetcd
👉 本文共约11377个字，系统预计阅读时间或需43分钟。
配置普罗米修斯监控
搭建过程参考：
使用Docker分分钟搭建漂亮的prometheus+grafana监控: https://www.dbaup.com/dbbao36shiyongdockerfenfenzhongdajianpiaoliangdeprometheusgrafanajiankong.html
监控利器PMM的使用–监控MySQL、PG、MongoDB、ProxySQL等：https://www.dbaup.com/dbbao41jiankongliqipmmdeshiyong-jiankongmysqlpgmongodbproxysqldeng.html
访问Grafana：http://172.72.6.79:3000/login 用户名和密码都为admin
export下载：https://prometheus.io/docs/instrumenting/exporters/
监控PG集群
https://github.com/prometheus-community/postgres_exporter
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | tar -zxvf postgres_exporter-0.10.1.linux-amd64.tar.gz mv postgres_exporter-0.10.1.linux-amd64/postgres_exporter /usr/local/bin/postgres_exporter useradd pg71 useradd pg72 useradd pg73 su - pg71 export DATA_SOURCE_NAME="postgresql://postgres:lhr@172.72.6.71:5432/postgres?sslmode=disable" nohup postgres_exporter --web.listen-address=":9187" >/dev/null 2>&1 & su - pg72 export DATA_SOURCE_NAME="postgresql://postgres:lhr@172.72.6.72:5432/postgres?sslmode=disable" nohup postgres_exporter --web.listen-address=":9188" >/dev/null 2>&1 & su - pg73 export DATA_SOURCE_NAME="postgresql://postgres:lhr@172.72.6.73:5432/postgres?sslmode=disable" nohup postgres_exporter --web.listen-address=":9189" >/dev/null 2>&1 & [root@lhrmonitor /]# netstat -tulnp | grep 918 tcp6 0 0 :::9187 :::* LISTEN 10829/postgres_expo tcp6 0 0 :::9188 :::* LISTEN 10929/postgres_expo tcp6 0 0 :::9189 :::* LISTEN 11027/postgres_expo [root@lhrmonitor /]# |
测试：
1 2 3 | curl http://localhost:9187/metrics curl http://localhost:9188/metrics curl http://localhost:9189/metrics |
Grafana导入监控模板：9628
监控HAProxy
https://github.com/prometheus/haproxy_exporter
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | tar -zxvf haproxy_exporter-0.13.0.linux-amd64.tar.gz mv haproxy_exporter-0.13.0.linux-amd64/haproxy_exporter /usr/local/bin/haproxy_exporter nohup haproxy_exporter --web.listen-address=":9101" --haproxy.scrape-uri="http://admin:admin@172.72.6.77:1080/haproxy?stats;csv" > /dev/null 2>&1 & nohup haproxy_exporter --web.listen-address=":9102" --haproxy.scrape-uri="http://admin:admin@172.72.6.78:1080/haproxy?stats;csv" > /dev/null 2>&1 & [root@lhrmonitor /]# netstat -tulnp | grep 91 tcp 0 0 127.0.0.1:5910 0.0.0.0:* LISTEN 1346/Xvnc tcp6 0 0 :::9187 :::* LISTEN 10829/postgres_expo tcp6 0 0 :::9188 :::* LISTEN 10929/postgres_expo tcp6 0 0 :::9189 :::* LISTEN 11027/postgres_expo tcp6 0 0 :::9100 :::* LISTEN 211/node_exporter tcp6 0 0 :::9101 :::* LISTEN 11462/haproxy_expor tcp6 0 0 :::9102 :::* LISTEN 11497/haproxy_expor [root@lhrmonitor /]# |
测试：
1 2 | curl http://localhost:9101/metrics curl http://localhost:9102/metrics |
Grafana导入监控模板：12865
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
笔耕不辍，我辈学习楷模。