好用开源的Zabbix-mysql监控插件
来源:互联网 发布:手机网络配置文件 编辑:程序博客网 时间:2024/04/29 20:03
Percona Monitoring Plugins for Zabbix
Mysql安装
下载mysql二进制包
[root@linux-node1 ~]
# cd /usr/local/src
# wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz
创建mysql用户
[root@linux-node2 ~]
# groupadd mysql
[root@linux-node2 ~]
# useradd -r -g mysql -s /bin/false mysql
解压mysql二进制包
[root@linux-node2 ~]
# cd /usr/local/src
[root@linux-node2 src]
# tar zxf mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz
[root@linux-node2 src]
# mv mysql-5.6.30-linux-glibc2.5-x86_64 /usr/local/
[root@linux-node1 ~]
# chown -R mysql:mysql /usr/local/mysql-5.6.30-linux-glibc2.5-x86_64
初始化mysql
[root@linux-node1 ~]
# ln -s /usr/local/mysql-5.6.30-linux-glibc2.5-x86_64/ /usr/local/mysql
[root@linux-node1 ~]
# ln -s /usr/local/mysql/mysql.sock /var/lib/mysql/mysql.sock
[root@linux-node1 ~]
# chown -R mysql:mysql /usr/local/mysql
上传压缩包中的my.cnf到/usr/local/mysql目录下
[root@linux-node1 ~]
# /usr/local/mysql/scripts/mysql_install_db \
--defaults-
file
=
/usr/local/mysql/my
.cnf \
--user=mysql --basedir=
/usr/local/mysql/
\
--datadir=
/usr/local/mysql/data
启动mysql
/usr/local/mysql/bin/mysqld
--defaults-
file
=
/usr/local/mysql/my
.cnf &
连接mysql
/usr/local/mysql/bin/mysql
-S
/usr/local/mysql/mysql
.sock
Zabbix安装
请参考官方档:
https://www.zabbix.com/documentation/3.0/manual/installation/install_from_packages#installing_repository_configuration_package
rpm -ivh http:
//repo
.zabbix.com
/zabbix/3
.0
/rhel/7/x86_64/zabbix-release-3
.0-1.el7.noarch.rpm
yum
install
zabbix-server-mysql zabbix-web-mysql
yum
install
zabbix-agent
创建zabbix数据库
/usr/local/mysql/bin/mysql
-S
/usr/local/mysql/mysql
.sock
mysql> create database zabbix character
set
utf8 collate utf8_bin;
mysql>grant all on zabbix.* to zabbix@
'localhost'
identified by
'zabbix'
;
导入zabbix数据源
# cd /usr/share/doc/zabbix-server-mysql-3.0.0
# zcat create.sql.gz | mysql -uroot zabbix
配置zabbix-server
# grep "^[a-Z]" /etc/zabbix/zabbix_server.conf
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
DBSocket=
/usr/local/mysql/mysql
.sock
启动zabbix-server
#systemctl restart zabbix-server.services
配置zabbix-agent
# grep "^[a-Z]" /etc/zabbix/zabbix_agentd.conf
Server=192.168.56.12
启动zabbix-agent
systemctl restart zabbix-agent.service
Percona Monitoring Plugin安装
官方参考网址:
https://www.percona.com/doc/percona-monitoring-plugins/1.1/zabbix/index.html#installation-instructions
yum
install
percona-zabbix-templates
cp
/var/lib/zabbix/percona/templates/userparameter_percona_mysql
.conf
/etc/zabbix/zabbix_agentd
.conf.d
/userparameter_percona_mysql
.conf
创建percona连接数据库配置文件
# vim /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php.cnf
<?php
$mysql_user =
'zabbix'
;
$mysql_pass =
'zabbix'
;
编辑ss_get_mysql_stats.php文件,将cactiuser替换为zabbix
# grep zabbix ss_get_mysql_stats.php
$mysql_user =
'zabbix'
;
$mysql_pass =
'zabbix'
;
修改get_mysql_stats_wrapper.sh
sed
-i
"s#mysql -e#/usr/local/mysql/bin/mysql -S /usr/local/mysql/mysql.sock -e#g"
get_mysql_stats_wrapper.sh
重启zabbix_agent
#systemctl restart zabbix-agent.service
测试脚本
[root@linux-node2 scripts]
# /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg
970
添加监控
访问:http://192.168.56.12/zabbix
导入模版,请使用下面我上传的zbx_export_percona-templates.xml(3.0zabbix自带模版有点坑)
zbx_export_percona-templates.xml
添加模版
出图Monitoring——Grapha
- 好用开源的Zabbix-mysql监控插件
- ZABBIX 3.X加载percona mysql插件来监控mysql5.6的详细实现过程
- zabbix自带的模板监控mysql
- zabbix监控mysql最简单的方法
- zabbix监控parameter mysql的状态
- zabbix全面监控mysql
- MySQL监控软件zabbix
- Zabbix 2.4 监控 MySQL
- zabbix 监控 mysql
- ZABBIX监控MYSQL
- zabbix监控mysql客户端
- zabbix监控mysql
- 用zabbix监控mysql
- zabbix 监控 mysql
- zabbix监控mysql
- zabbix 配置mysql监控
- [Zabbix] MySQL 监控
- Zabbix配置mysql监控
- 解决mac matlab mex -setup 找不到编译器的问题
- 高精度整数加法(OJ)
- 如何在IntelliJ IDEA中快速配置Tomcat
- MFC 实现圆形进度图以及一些其他图形绘画
- spark基础知识
- 好用开源的Zabbix-mysql监控插件
- 后台处理get与post请求
- PIL简介
- 【LeetCode】常用算法之快速排序
- qml的绘图Canvas
- spring dubbo整合详细
- 浅谈Object类和其常用方法
- RobHess实现SIFT源码分析:sift.h和sift.c
- MySql避免重复插入记录