Prometheus Server --- Prometheus组件中的核心部分，负责实现对监控数据的获取，存储以及查询。
node_exporter 用于采集服务器层面的运行指标，类似于传统主机监控维度的 zabbix-agent node-export 
mysql_exporter主要是获取中的内建的指标，
alertmanager --- 若Promtheus Server中发现某监控项满足PromQL中定义的告警规则，则会产生一条告警，并将其交于AlertManager进行管理。在AlertManager中可以配置各种通知方式，也可以定义Webhook自定义告警处理方式。AlertManager即Prometheus体系中的告警处理中心。

[root@xkf ~]# systemctl stop firewalld.service 
[root@xkf ~]# setenforce 0
root@xkf ~]# rz -E
rz waiting to receive.
[root@xkf ~]# mkdir -p /usr/share/prome
[root@xkf ~]# tar -xzvf prometheus-2.43.0.linux-amd64.tar.gz -C /usr/share/prome/

[root@xkf ~]# wget https://dl.grafana.com/enterprise/release/grafana-enterprise-7.4.5-1.x86_64.rpm
[root@xkf ~]# yum install grafana-enterprise-7.4.5-1.x86_64.rpm
[root@xkf ~]# systemctl start grafana-server
[root@xkf ~]# systemctl enable grafana-server
[root@xkf ~]# netstat -lntp | grep grafana
tcp6       0      0 :::3000                 :::*                    LISTEN      2623/grafana-server 

[root@master ~]# vim /etc/my.cnf
[mysqld]
server_id=102    #为当前节点设置一个全局惟一的ID号
log-bin=/data/mysql/logbin/mysql-bin  #将新产生的二进制文件放到此目录下便于查找
[root@master ~]# mkdir -p /data/mysql/logbin 
[root@master ~]# chown -R mysql.mysql /data/mysql  #修改目录的所有者，所属组为mysql
[root@master ~]# yum -y install psmisc
[root@master ~]# killall mysqld
[root@master ~]# systemctl restart mysqld
[root@master ~]# ll /data/mysql/logbin/
total 8
-rw-r-----. 1 mysql mysql 157 Mar 25 19:50 mysql-bin.000001
-rw-r-----. 1 mysql mysql  36 Mar 25 19:50 mysql-bin.index
##创建一个有复制权限的用户账号mysql> 
select @@server_id;+-------------+
| @@server_id |
+-------------+
|         102 |
+-------------+
mysql>  show master logs;
+------------------+-----------+-----------+
| Log_name         | File_size | Encrypted |
+------------------+-----------+-----------+
| mysql-bin.000001 |       157 | No        |
+------------------+-----------+-----------+
mysql> create user xkf@'192.168.26.%' identified WITH mysql_native_password by '1234';
mysql> grant replication slave on *.* to xkf@'192.168.26.%';

[root@slave ~]# vim /etc/my.cnf
server_id=103
read-only
[root@slave ~]# killall mysqld 
[root@slave ~]# systemctl restart mysqld 
##使用有复制权限的用户账号连接至主服务器，并启动复制线程
mysql> change master to
    -> master_host='192.168.26.102',
    -> master_user='xkf',
    -> master_password='1234',
    -> master_port=3306,
    -> master_log_file='mysql-bin.000001',
    -> master_log_pos=157;
Query OK, 0 rows affected, 9 warnings (0.02 sec)
##开启同步
mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.01 sec)
##查看MySQL的复制状态
mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for source to send event
                  Master_Host: 192.168.26.102
                  Master_User: xkf
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000001
          Read_Master_Log_Pos: 680
               Relay_Log_File: slave-relay-bin.000002
                Relay_Log_Pos: 849
        Relay_Master_Log_File: mysql-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
yes表示主从复制部署成功

注：master和slave数据库都要部署mysql_exporter

注意###第2步.需要授权用户给exporter使用，在master执行即可，其他步骤slave节点依然要全部执行

1.下载mysql_exporter并解压
[root@master ~]# rz -E
rz waiting to receive.
[root@master ~]# ls
\  anaconda-ks.cfg  mysqld_exporter-0.14.0.linux-amd64.tar.gz
[root@master ~]# tar -zxvf mysqld_exporter-0.14.0.linux-amd64.tar.gz -C /usr/local/
2.创建MySQL监控用户
mysql>  create user exporter@'192.168.26.%' identified  by '123456';
Query OK, 0 rows affected (0.01 sec)

mysql> grant  process,replication client,select on *.* to 'exporter'@'192.168.26.%';
Query OK, 0 rows affected (0.00 sec)
3.配置mysql连接信息
在mysqld_exporter路径下创建my.cnf，添加刚才创建的exporter用户和密码
[root@master ~]# cd /usr/local/mysqld_exporter-0.14.0.linux-amd64/
[root@master mysqld_exporter-0.14.0.linux-amd64]# vim my.cnf
[client]
user=exporter 
password=123456
4.添加system系统服务
[root@master systemd]# vim /usr/lib/systemd/system/mysqld_exporter.service
[Unit]
Description=mysqld_exporter
After=network.target

[Service]
User=root
Type=simple
ExecStart=/usr/local/mysqld_exporter-0.14.0.linux-amd64/mysqld_exporter \
--config.my-cnf /usr/local/mysqld_exporter-0.14.0.linux-amd64/my.cnf \
--collect.info_schema.processlist

Restart=on-failure

[Install]
WantedBy=multi-user.target

 使my.cnf文件生效
[root@master mysqld_exporter-0.14.0.linux-amd64]# ./mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter-0.14.0.linux-amd64/my.cnf
若报msg="Error pinging mysqld" err="Error 1045: Access denied for user 'exporter'@'localhost' (using password: YES)"错误说明密码正确但是访问数据库被拒绝，
此错误实际上是远程错误。本地IP没有访问权限，访问被拒绝。我们需要在数据库中添加对本地IP的访问权限：
我直接把原来的exporter  MySQL监控用户删除，重新添加允许所有网段的exporter用户给予所有权限
       drop user 'exporter'@'192.168.26.%';
mysql> CREATE USER 'exporter'@'%' IDENTIFIED BY '123456'
    -> ;
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'exporter'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
mysql> FLUSH PRIVILEGES;
也可以指定的ip开放访问权限
GRANT ALL PRIVILEGES ON *.* TO 'exporter'@'127.0.0.1' IDENTIFIED BY ‘123456' WITH GRANT OPTION;


5.master开启服务查看端口
[root@master systemd]# systemctl daemon-reload
[root@master systemd]# systemctl start mysqld_exporter.service
[root@master systemd]# netstat -lntup | grep "9104"
tcp6       0      0 :::9104                 :::*                    LISTEN      8542/mysqld_exporte 
6.slace开启服务查看端口
[root@slave ~]# systemctl daemon-reload
[root@slave ~]# systemctl start mysqld_exporter.service
[root@slave ~]# netstat -lntup | grep "9104"
tcp6       0      0 :::9104                 :::*                    LISTEN      10825/mysqld_export 

注：两台MySQL节点都要部署，命令同样执行；

下载mysql_exporter并解压
[root@master systemd]# cd
[root@master ~]# rz -E
rz waiting to receive.
[root@master ~]# tar zxf node_exporter-1.5.0.linux-amd64.tar.gz -C /opt
[root@master ~]# cd /opt/
[root@master opt]# mv node_exporter-1.5.0.linux-amd64/ node_exporter
system系统启动node_exproter
[root@master opt]# vim  /usr/lib/systemd/system/node_exporter.service
[root@master opt]# cat /usr/lib/systemd/system/node_exporter.service
[Unit]
  Description=node_exporter
  Documentation=https://prometheus.io/
  After=network.target

  [Service]
  Type=simple
  User=root
  ExecStart=/opt/node_exporter/node_exporter
  Restart=on-failure

  [Install]
  WantedBy=multi-user.target
[root@master opt]# systemctl daemon-reload
[root@master opt]# systemctl start node_exporter
[root@master opt]# systemctl enable node_exporter
Created symlink from /etc/systemd/system/multi-user.target.wants/node_exporter.service to /usr/lib/systemd/system/node_exporter.service.
[root@master opt]# ss -antp | grep 9100
LISTEN     0      128       [::]:9100                  [::]:*                   users:(("node_exporter",pid=8600,fd=3))
[root@master opt]# 
[root@slave opt]# ss -antp | grep 9100
LISTEN     0      128       [::]:9100                  [::]:*                   users:(("node_exporter",pid=10873,fd=3)

[root@xkf prometheus-2.43.0.linux-amd64]# pwd
/usr/share/prome/prometheus-2.43.0.linux-amd64
[root@xkf prometheus-2.43.0.linux-amd64]# vim prometheus.yml 
- job_name: 'mysql-mater-slave'
    scrape_interval: 5s
    static_configs:
    - targets: ['192.168.26.102:9104','192.168.26.103:9104']
  - job_name: 'nodes'
    scrape_interval: 5s
    static_configs:
    - targets: ['192.168.26.102:9100','192.168.26.103:9100']

启动
[root@xkf ~]# cd /usr/share/prome/prometheus-2.43.0.linux-amd64/
[root@xkf prometheus-2.43.0.linux-amd64]# nohup ./prometheus &
[1] 6556
[root@xkf prometheus-2.43.0.linux-amd64]# nohup: ignoring input and appending output to ‘nohup.out’
#检查nohup.out日志文件，如果有以下信息则说明启动成功msg="Server is ready to receive web requests."