mysql_exporter_Prometheus监控实战之mysqld_exporter使用(第五篇)

概述： mysql_exporter是用来收集MysQL或者Mariadb数据库相关指标的，mysql_exporter需要连接到数据库并有相关权限。

步骤：

一、安装MysQL或者Mariadb

安装MysQL-8.0社区版

# wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

# yum -y localinstall mysql80-community-release-el7-3.noarch.rpm

# yum search mysql --showduplicates

# yum -y install mysql-community-server-8.0.21-*

# systemctl enable mysqld

# systemctl start mysqld

说明：初始密码在/var/log/mysqld.log 中。

使用mysqladmin修改root的初始密码

# mysqladmin -u root password Mysql@123 -p

或者用初始密码登录后用alter user修改

mysql> alter user root@localhost identified by 'Mysql@123';

或者安装Mariadb 10.4，以下是使用阿里云yum源配置

# cat > /etc/yum.repos.d/mariadb.repo  <

[Mariadb]

name=Mariadb Official Repository - \$basearch

baseurl=https://mirrors.aliyun.com/mariadb/yum/10.4/centos7-amd64

enabled=1

gpgcheck=1

gpgkey=https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB

EOF

# yum -y install MariaDB-server-10.4.12-*

# systemctl enable mariadb

# systemctl start mariadb

reference: https://github.com/prometheus/mysqld_exporter

二、下载mysql_exporter

# wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz

# tar xvf mysqld_exporter-0.12.1.linux-amd64.tar.gz  -C /usr/local/

# ln -s mysqld_exporter-0.12.1.linux-amd64/ mysqld_exporter

一、创建用于监视数据库的用户exporter

mysql -u root -p

mysql> set global validate_password.policy=LOW;   # 降低MySQL8 密码规则策略，或者按规则设置密码

mysql> CREATE USER 'exporter'@'localhost' IDE