单个mysqld_exporter监控多个MySQL实例

create user 'exporter'@'192.168.12.201' IDENTIFIED WITH mysql_native_password BY 'xxx' ; 
GRANT SELECT, RELOAD, PROCESS, SUPER, REPLICATION CLIENT ON *.* TO 'exporter'@'192.168.12.201';
复制

wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.15.1/mysqld_exporter-0.15.1.linux-amd64.tar.gz
复制

tar zxvf mysqld_exporter-0.15.1.linux-amd64.tar.gz -C usr/local/
mv usr/local/mysqld_exporter-0.15.1.linux-amd64 usr/local/mysqld_exporter
复制

vim /usr/local/mysqld_exporter/mysqld_exporter.cnf
复制

[client]
user=exporter
password=xxx
复制

vim /etc/systemd/system/mysqld_exporter.service
复制

[Unit]
Description=Prometheus
After=network-online.target




[Service]
User=prometheus
Restart=on-failure
ExecStart=/usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter/mysqld_exporter.cnf




[Install]
WantedBy=multi-user.target
复制

useradd prometheus
chown -R prometheus.prometheus usr/local/mysqld_exporter/
复制

systemctl daemon-reload
复制

systemctl start mysqld_exporter
复制

  - job_name: mysql
    params:
      auth_module: [client.servers]
    file_sd_configs:
      - files: ["/usr/local/prometheus/conf.d/mysql.json"]
        refresh_interval: 15s




    relabel_configs:
      - source_labels: [__address__]
        target_label: __param_target
      - source_labels: [__param_target]
        target_label: instance
      - target_label: __address__
        # The mysqld_exporter host:port
        replacement: 192.168.12.201:9104
复制

vim usr/local/prometheus/conf.d/mysql.json
复制

[
  {
    "targets": [
      "192.168.12.111:3306"
    ],
    "labels": {
          "project": "dba-test",
          "hostname": "sh-db-mysql-dbatest01"
    }
  },
  {
    "targets": [
      "192.168.12.112:3306"
    ],
    "labels": {
          "project": "dba-test",
          "hostname": "sh-db-mysql-dbatest02"
    }
  }
]
复制