Prometheus之监控mysql服务

	1.部署MySQL(只是为了演示，使用docker快速部署)
[root@jenkins211 ~]# docker run --name mysql-server -d \
             -e MYSQL_USER="zqylinux" \
             -e MYSQL_PASSWORD="123456" \
             -e MYSQL_ALLOW_EMPTY_PASSWORD="yes" \
             --network=host \
			 --restart unless-stopped \
             mysql:8.3.0-oracle \
             --character-set-server=utf8mb4 --collation-server=utf8mb4_bin \
             --default-authentication-plugin=mysql_native_password
			 
[root@jenkins211 ~]# docker ps -l
CONTAINER ID   IMAGE                COMMAND                  CREATED          STATUS          PORTS     NAMES
5db1d0101b5c   mysql:8.3.0-oracle   "docker-entrypoint.s…"   13 seconds ago   Up 13 seconds             mysql-server
[root@jenkins211 ~]# 
[root@jenkins211 ~]# ss -ntl | grep 3306                  # 因为使用了host网络，所以不用端口映射
LISTEN 0      151                *:3306             *:*          
LISTEN 0      70                 *:33060            *:*          
[root@jenkins211 ~]# 



	2.下载mysql exporter 
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.15.1/mysqld_exporter-0.15.1.linux-amd64.tar.gz


	3.安装mysql exporters
[root@jenkins211 ~]# tar xf mysqld_exporter-0.15.1.linux-amd64.tar.gz -C /usr/local/bin/ mysqld_exporter-0.15.1.linux-amd64/mysqld_exporter  --strip-components=1
[root@jenkins211 ~]# 
[root@jenkins211 ~]# ll /usr/local/bin/
total 15452
drwxr-xr-x  2 root root     4096 Aug 16 14:48 ./
drwxr-xr-x 10 root root     4096 Aug 10  2023 ../
-rwxr-xr-x  1 1001 1002 15811157 Dec 12  2023 mysqld_exporter*
[root@jenkins211 ~]# 



	4.准备MySQL的链接认证文件，创建MySQL的配置，指定默认的用户名和密码
[root@jenkins211 ~]# cat  ~/.my.cnf 
[client]
user=zqylinux
password=123456
[root@jenkins211 ~]# 

	
	5.运行mysqld-exporter
[root@jenkins211 ~]# mysqld_exporter --mysqld.address="10.0.0.211:3306" --web.listen-address=:9104 --config.my-cnf="/root/.my.cnf"

	6.访问mysqld_exporter的webUI
http://10.0.0.211:9104/metrics

	7.修改Prometheus的配置文件
[root@prometheus-server31 ~]# vim /zqylinux/softwares/prometheus-2.53.2.linux-amd64/prometheus.yml 
...
  - job_name: zqylinux-mysql
    static_configs:
    - targets:
      - 10.0.0.211:9104

[root@prometheus-server31 ~]# check 
Checking /zqylinux/softwares/prometheus-2.53.2.linux-amd64/prometheus.yml
SUCCESS: /zqylinux/softwares/prometheus-2.53.2.linux-amd64/prometheus.yml is valid prometheus config file syntax

[root@prometheus-server31 ~]# 
[root@prometheus-server31 ~]# rr
[root@prometheus-server31 ~]# 


	8.查看Prometheus是否监控到数据
http://10.0.0.31:9090/targets

	9.grafana出图展示，id可选以下
18949
17320
14057