普罗米修斯Prometheus监控MySQL

普罗米修斯Prometheus监控MySQL

添加数据库用户

CREATE USER monitor_prometheus@'192.168.245.%' IDENTIFIED BY 'Abcde@123';
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO monitor_prometheus@'192.168.245.%';

创建mysql配置文件

cat >.my.cnf <<EOF
[client]
user=monitor_prometheus
password=Abcde@123
EOF

安装并启动mysql采集客户端

wget -c https://github-production-release-asset-2e65be.s3.amazonaws.com/32075541/113de280-b210-11e9-8359-0f8a58a8c694?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20200131%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20200131T060047Z&X-Amz-Expires=300&X-Amz-Signature=05e5d6005958462b34a47be2ac470e09666e2502bc5ae4e2b789f2bbff2997e5&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dmysqld_ex