概述: 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