mysql-exporter监控mysql

mysql-exporter监控mysql

创建授权账号

#登录mysql
mysql -uroot -p
#创建账号并授权
mysql> CREATE USER 'exporter'@'mysql-exporter-ip' IDENTIFIED BY 'Tianji@0315' WITH MAX_USER_CONNECTIONS 3;
mysql> GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'mysql-exporter-ip';
mysql> flush privileges;

下载并启动mysql-exporter

#下载
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.14.0/mysqld_exporter-0.14.0.linux-amd64.tar.gz
#解压
tar xf mysqld_exporter-0.14.0.linux-amd64.tar.gz
mv mysqld_exporter-0.14.0.linux-amd64 /usr/local/mysqld_exporter/
cd /usr/local/mysqld_exporter/

创建配置文件

mkdir config
cat > .my.cnf<< EOF
[client]
host = mysql-ip
port = mysql-prot
user = exporter
password = Tianji@0315
EOF

启动exporter

#后台启动exporter
nohup ./mysqld_exporter --web.listen-address=":9104" --config.my-cnf=./config/.my.cnf >> mysql-exporter.log &

配置prometheus

• prometheus.yml

  - job_name: mysql
    static_configs:
      - targets:
        - exporter-ip:9104

热加载重启prometheus

热加载需要开启参数-web.enable-lifecycle

curl -XPOST http://prometheus-ip:9090/-/reload

grafana配置监控面板

• https://grafana.com/grafana/dashboards/?plcmt=footer&search=mysql

• 监控面板ID：14057

• 监控面板ID：7362