现在的环境✅ Rocky Linux 9✅ Prometheus 3.12.0✅ MySQL 8.0.46 ✅ 不使用 root 用户一、创建运行用户sudouseradd--no-create-home--shell/bin/false mysqld_exporter二、安装 mysqld_exportercd/tmpwgethttps://github.com/prometheus/mysqld_exporter/releases/download/v0.19.0/mysqld_exporter-0.19.0.linux-amd64.tar.gztar-xvfmysqld_exporter-0.19.0.linux-amd64.tar.gzsudomvmysqld_exporter-0.19.0.linux-amd64/mysqld_exporter /usr/local/bin/sudochownmysqld_exporter:mysqld_exporter /usr/local/bin/mysqld_exporter三、MySQL 授权登录 MySQL mysql-uroot-p执行 CREATEUSERIF NOT EXISTSexporterlocalhostIDENTIFIED BYExporter123!WITH MAX_USER_CONNECTIONS3;GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TOexporterlocalhost;FLUSH PRIVILEGES;四、MySQL Exporter 配置sudomkdir-p/etc/mysqld_exportersudotee/etc/mysqld_exporter/.my.cnf/dev/nullEOF [client] userexporter passwordExporter123! hostlocalhost port3306 EOFsudochown-Rmysqld_exporter:mysqld_exporter /etc/mysqld_exportersudochmod600/etc/mysqld_exporter/.my.cnf五、systemd 服务MySQL Exportersudotee/etc/systemd/system/mysqld_exporter.service/dev/nullEOF [Unit] DescriptionMySQL Exporter Afternetwork.target mysqld.service [Service] Usermysqld_exporter ExecStart/usr/local/bin/mysqld_exporter \ --config.my-cnf/etc/mysqld_exporter/.my.cnf \ --web.listen-address:9104 Restartalways [Install] WantedBymulti-user.target EOF初始化systemctl并启动mysqld_exportersudosystemctl daemon-reloadsudosystemctlenable--nowmysqld_exporter六、验证1、MySQL Exporter 状态sudosystemctl status mysqld_exporter2、端口ss-lntp|grep91043、MySQL 是否成功采集curlhttp://localhost:9104/metrics|grepmysql_up✅ 正确结果% Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed100175k0175k009250k0--:--:-- --:--:-- --:--:-- 9250k# HELP mysql_up Whether the MySQL server is up.# TYPE mysql_up gaugemysql_up1七、Prometheus 验证浏览器访问http://服务器IP:9090→ Status → Targets✅ 应看到JobStateprometheus✅ UPmysql✅ UP
