#master

# 安装ntp服务（用于提供时间同步源）
yum install -y ntp

# 编辑ntp配置文件，设置本地为时钟源
vim /etc/ntp.conf
# 在文件末尾添加以下两行（按i进入编辑模式，添加后按esc，输入:wq保存退出）
# server 127.127.157.0  # 本地时钟源，157对应网段192.168.157.x
# fudge 127.127.157.0 stratum 8  # 时间层级设为8（范围1-15，层级越低越优先）

# 启动ntp服务并设置开机自启
systemctl start ntpd
systemctl enable ntpd  # 确保重启后服务自动运行

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

#slave

# 安装ntp和ntpdate（ntpdate用于主动同步时间）
yum install -y ntp ntpdate

# 启动ntp服务并设置开机自启
systemctl start ntpd
systemctl enable ntpd

# 手动同步主库时间（立即执行一次，确保当前时间对齐）
/usr/sbin/ntpdate 192.168.157.80  # 同步主库80的时间

# 设置定时任务，每30分钟自动同步一次主库时间
crontab -e  # 编辑定时任务（按i进入编辑模式，添加后按esc，输入:wq保存退出）
# 添加以下内容：
# */30 * * * * /usr/sbin/ntpdate 192.168.157.80  # 每30分钟执行一次时间同步

tar -zxvf prometheus-3.7.2.linux-amd64.tar.gz	
cp -R prometheus-3.7.2.linux-amd64 /usr/local/prometheus
vim /usr/lib/systemd/system/prometheus.service

[Unit]
Description=Prometheus
Documentation=https://prometheus.io/
After=network.target

[Service]
Type=simple
User=root
WorkingDirectory=/usr/local/prometheus
ExecStart=/usr/local/prometheus/prometheus 
Restart=on-failure

[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemctl enable prometheus.service
systemctl start prometheus.service

yum install -y grafana-enterprise-11.0.0-1.x86_64.rpm


# 开机启动
systemctl enable grafana-server
# 启动
systemctl start grafana-server

tar -zxvf node_exporter-1.10.2.linux-amd64.tar.gz
cp -R node_exporter-1.10.2.linux-amd64 /usr/local/node_exporter

vim /usr/lib/systemd/system/node_exporter.service


[Unit]
Description=node_exporter
After=network.target

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

[Install]
WantedBy=multi-user.target

systemctl daemon-reload
systemctl enable node_exporter.service
systemctl start node_exporter.service

# 查看服务状态
systemctl status node_exporter.service

global:
  scrape_interval: 15s  # 全局默认拉取间隔，job级配置会覆盖此值
  evaluation_interval: 15s

scrape_configs:
  # MySQL主从节点的MySQL指标（MySQL Exporter，端口9104）
  - job_name: 'mysql-master-slave'
    scrape_interval: 5s  # 5秒一次高频采集MySQL指标
    static_configs:
      - targets: ['192.168.157.80:9104', '192.168.157.81:9104', '192.168.157.82:9104']  # 主+2从
    # 自动标记主从角色（方便Grafana筛选）
    relabel_configs:
      - source_labels: [__address__]
        regex: '192.168.157.80:9104'  # 匹配主库IP
        target_label: 'mysql_role'
        replacement: 'master'  # 标记为主库
      - source_labels: [__address__]
        regex: '192.168.157.81:9104|192.168.157.82:9104'  # 匹配两个从库
        target_label: 'mysql_role'
        replacement: 'slave'   # 标记为从库

  # 服务器基础指标（Node Exporter，端口9100）
  - job_name: 'nodes'
    scrape_interval: 5s  # 5秒一次采集服务器指标
    static_configs:
      - targets: ['192.168.157.80:9100', '192.168.157.81:9100', '192.168.157.82:9100']  # 主+2从
    # 自动标记服务器对应的MySQL角色
    relabel_configs:
      - source_labels: [__address__]
        regex: '192.168.157.80:9100'
        target_label: 'mysql_role'
        replacement: 'master'
      - source_labels: [__address__]
        regex: '192.168.157.81:9100|192.168.157.82:9100'
        target_label: 'mysql_role'
        replacement: 'slave'

systemctl restart prometheus

tar -zxvf mysqld_exporter-0.18.0.linux-amd64.tar.gz
mv mysqld_exporter-0.18.0.linux-amd64 /usr/local/mysql_exporter
cd /usr/local/mysql_exporter

#配置数据库的信息
vim /usr/local/mysql_exporter/my-exporter.cnf


[client]
user=root
password=xxxx   #填写自己的密码
host=localhost
port=3306

vim /etc/systemd/system/mysqld_exporter.service


[Unit]
Description=mysqld_exporter
After=network.target
[Service]
Type=simple
User=root
ExecStart=/usr/local/mysql_exporter/mysqld_exporter --config.my-cnf=/usr/local/mysql_exporter/my-exporter.cnf
Restart=on-failure
[Install]
WantedBy=multi-user.target

# 重新加载系统配置
systemctl daemon-reload
# 开机启动
systemctl enable mysqld_exporter.service
# 启动服务
systemctl start mysqld_exporter
# 查看状态
systemctl status mysqld_exporter

vim /usr/local/prometheus/prometheus.yml


- job_name: 'mysql_exporter'
    static_configs:
      - labels:
          instance: master:3306
        targets:
          - 192.168.157.80:9104  # 主库MySQL Exporter地址
      - labels:
          instance: slave1:3306
        targets:
          - 192.168.157.81:9104  # 从库81 MySQL Exporter地址
      - labels:
          instance: slave2:3306
        targets:
          - 192.168.157.82:9104  # 从库82 MySQL Exporter地址