1、前期准备 1.1项目依赖链接 依赖开源工程工程链接普罗米修斯https://github.com/prometheus/pushgatewayopengauss_exporthttps://github.com/enmotech/opengauss_exporterpushgatewayhttps://github.com/prometheus/pushgatewayopenGausshttps://gitee.com/opengauss/openGauss-server1.2 工具包准备 系统环境工具版本ARM+openEulerprometheus-2.21.0.linux-arm64.tar.gz、pushgateway-1.2.0.linux-arm64.tar.gz、grafana-7.1.5-1.aarch64.rpmX86+openEulerprometheus-2.21.0.linux-amd64.tar.gz、pushgateway-1.3.0.linux-amd64.tar.gz、grafana-7.2.1-1.x86_64.rpm2、监控系统安装部署 2.1 tpmC采集和发送 '''功能描述：在benchmarksql工具测试过程的输出信息通过tee命令 固定输出到/tmp/tpcc.log（便于在不同环境上部署），采集函数从/tmp/tpcc.log文件获取到tpmC值，发送函数将值发送到pushgateway服务。'''#日志信息采集并转换为tpmCdef collect_tpmc(): log_file = "/tmp/tpcc.log" cmd = "tail -1 %s > /home/tpmc;awk -F ':' '{print $(NF-2)}' /home/tpmc | awk '{print $1}'" % log_file tpmc = os.popen(cmd).read().strip() tpmc = float(tpmc) * 0.45 count_tpmc = "count_tpmc{count_tpmc="count_tpmc"} " + str(tpmc) + "n" print("count_tpmc : %s" %count_tpmc) return count_tpmc#向pushgateway发送采集到的数据def send_data(data_type, node): if data_type == "cpu": send_cmd = "cat {file_cpu} | curl --data-xsdhsary @- pushgateway_ip:port/metrics/job/{node}/instance/{data_type}".format( file_cpu=file_cpu, node=node, data_type=data_type) os.popen(send_cmd) 2.2 pushgateway的使用 cd pushgateway-1.2.0.linux-arm64./pushgateway
网页显示效果如下：
2.3 opengauss_exporter的使用 GO GET配置git config --global http.proxy http://域账号:密码git config --global https.proxy https://域账号:密码git config --global http.sslverify falsegit config --global https.sslverify falseGO MODULE配置export GO111MODULE=onexport GOPROXY=http://***/export GONOSUMDB=*配置数据库白名单host all all ip md5配置启动opengauss_exportercd opengauss_exporter-mastermake buildexport DATA_SOURCE_NAME="postgresql://tpcc:******@ip:port/tpcc?sslmode=disable"./xsdhs/opengauss_exporter --config="og_exporter_default.yaml"注：默认端口为9187
启动效果
2.4 prometheus的使用 prometheus.yml 文件配置参考scrape_configs: # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config. - job_name: 'prometheus' # metrics_path defaults to '/metrics' # scheme defaults to 'http'. static_configs: - targets: ['prometheus_ip:9090'] - job_name: 'pushgateway' static_configs: - targets: ['pushgateway_ip:9091'] labels: instance: pushgateway - job_name: 'opgs_report' static_configs: - targets: ['opgs_report:9187'] labels: instance: opgs_report #启动方式 ./prometheus
启动效果
2.5 grafana的使用 yum install grafana-7.1.5-1.aarch64.rpmservice grafana-server start网访问prometheus_ip:3000初始用户名密码均为admin
数据源的配置
Dashboard的导入
openGauss_exporter工程 界面模板路径如下opengauss_exporter-masteropengauss_exporter-masterdashboard模板也可根据自己需求灵活配置
界面效果如下
tpmC显示panel的添加