prometheus+grafana利用mysql_exporter监控mysql

1.利用mysql_exporter监控mysql主机

1.1.安装配置mysql

1.安装mysql
[root@192_168_81_160 ~]# yum -y install mariadb

2.启动mysql
[root@192_168_81_160 ~]# systemctl start mariadb
[root@192_168_81_160 ~]# systemctl enable mariadb

3.创建用户并赋权
[root@192_168_81_160 ~]# mysql
MariaDB [(none)]> grant select,replication client,process on *.* to 'mysql_monitor'@'localhost' identified by '123';
MariaDB [(none)]> flush privileges;
  
 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
 

1.2.安装mysql_exporter

1.下载mysql_exporter
[root@192_168_81_160 ~]# weget https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz

2.安装mysql_exporter
[root@192_168_81
  
 

  
1
  
2
  
3
  
4
 

文章来源: jiangxl.blog.csdn.net，作者：Jiangxl~，版权归原作者所有，如需转载，请联系作者。

原文链接：jiangxl.blog.csdn.net/article/details/111581807