zabbix监控

两台centos服务器
192.168.81.1 zabbix服务器
192.168.81.2 zabbix客户端

zabbix服务器
关闭防火墙
systemctl stop firewalld
setenforce 0
配置yum源
cp zabbix_Aliyun.repo /etc/yum.repos.d/
yum repolist
安装zabbix和mariadb
yum -y install zabbix-server-mysql zabbix-web-mysql zabbix-agent mariadb mariadb-server zabbix-get
启动mariadb
systemctl start mariadb
mysql -e "create database zabbix charset utf8;"
mysql -e "grant all on zabbix.* to 'zabbix'@'localhost' identified by 'zabbix';"
mysql -e "exit"
导入初始数据
zcat /usr/share/doc/zabbix-server-mysql-4.2.8/create.sql.gz | mysql -uzabbix -pzabbix zabbix
修改zabbix-server，连接数据库的配置
vim /etc/zabbix/zabbix_server.conf
DBUser=zabbix
DBPassword=zabbix
修改时区
vim /etc/httpd/conf.d/zabbix.conf
php_value date.timezone Asia/Shanghai
启动所有服务
systemctl restart zabbix-server zabbix-agent
systemctl enable zabbix-server zabbix-agent
测试键值
zabbix_get -s 192.168.81.2 -k net.tcp.listen[3306]
zabbix字体修正
rm -rf /usr/share/fonts/dejavu/DejaVuSans.ttf
cp DejaVuSans.ttf /usr/share/fonts/dejavu/
systemctl restart zabbix-server.service
查看端口
netstat -nltp | grep zabbix

zabbix客户端
关闭防火墙
systemctl stop firewalld
setenforce 0
配置yum源
cp zabbix_Aliyun.repo /etc/yum.repos.d/
yum repolist
安装zabbix-agent
yum -y install zabbix-agent
修改配置文件
vim /etc/zabbix/zabbix_agentd.conf
Server=192.168.81.1
重启zabbix-agent
systemctl restart zabbix-agent
部署mysql常规
安装启动mariadb
yum -y install mariadb mariadb-server
systemctl start mariadb
mkdir /etc/zabbix/scripts/
vim /etc/zabbix/scripts/mysql.sh
#!/bin/bash
case $1 in
        Bytes_sent) #流量发送
        mysqladmin extended-status|grep Bytes_sent|awk '{print $4}'
        ;;
        Bytes_received) #流量接收
        mysqladmin extended-status|grep Bytes_received|awk '{print $4}'
        ;;
        Com_insert) #增
        mysqladmin extended-status | grep -w Com_insert | awk '{print $4}'
        ;;
        Com_delete) #删
        mysqladmin extended-status | grep -w Com_delete | awk '{print $4}'
        ;;
        Com_update) #改
        mysqladmin extended-status | grep -w Com_update | awk '{print $4}'
        ;;
        Com_select) #查
        mysqladmin extended-status | grep -w Com_select | awk '{print $4}'
        ;; 
        uptime) #运行时间
        mysqladmin status | awk '{print $2}'
        ;;
        qps) #qps每秒查询处理量qps=question/uptime
        mysqladmin status | awk '{print $6/$2}'
        ;;
        tps) #每秒处理事务数tps=(commit + rollback)/uptime
        uptime=$(mysqladmin status | awk '{print $2}')
        commit=$(mysqladmin extended-status | grep -w Com_commit | awk '{print $4}')
        rollback=$(mysqladmin extended-status | grep -w Com_rollback | awk '{print $4}')
        count=$[$commit+$rollback]
        echo "$uptime $count" > /tmp/tps.txt
        cat /tmp/tps.txt | awk '{print $2/$1}'
        ;;
        db)
        mysql -e "select concat(round(sum(data_length/1024),2),'KB') from information_schema.tables where table_schema='mysql';" | sed -n "2p"
        ;;
        tb)
        mysql -e "select concat(round(sum(data_length/1024),2),'KB') from information_schema.tables where table_schema='mysql' and table_name='db';" | awk 'NR==2'
        ;;
esac

vim /etc/zabbix/zabbix_agentd.d/mysql.conf
UserParameter=mysql_status[*],/etc/zabbix/scripts/mysql.sh $1
授予权限
chmod -R 777 /etc/zabbix/scripts/mysql.sh
chmod -R 777 /tmp/tps.txt
重启zabbix-agent
systemctl restart zabbix-agent
完毕！