zabbix对mysql相关性能监控

zabbix监控mysql

1.关闭防火墙，关闭SElinux

systemctl stop firewalld
setenforce  0

2.时间同步

yum -y install ntpdate
ntpdate  pool.ntp.org
date

3.上传zabbix镜像到yum.repos.d目录下
4.安装zabbix相关组件

yum -y install zabbix-server-mysql zabbix-web-mysql zabbix-agent mariadb mariadb-server

5.开启数据库

systemctl start mariadb

6.创建zabbix数据库

MariaDB [(none)]> create database zabbix character set utf8 collate utf8_bin;

7.创建授权用户zabbix

MariaDB [(none)]> grant all on zabbix.* to zabbix@localhost identified by 'zabbix';

8.刷新授权表

MariaDB [(none)]> flush privileges;

9.导入zabbix 初始数据库

zcat  /usr/share/doc/zabbix-server-mysql-4.4.10/create.sql.gz |mysql -uzabbix -pzabbix zabbix 

（注意zabbix-server-mysql-4.4.10版本）

10.编辑zabbix-server 配置文件

vim /etc/zabbix/zabbix_server.conf

[root@bogon ~]# cat  /etc/zabbix/zabbix_server.conf |grep -v "^#"|sed '/^$/d'|grep DB
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix

11.开启httpd zabbix-server zabbix-agent

systemctl start httpd zabbix-server zabbix-agent

验证：

[root@bogon ~]# netstat  -lptnu|egrep "80|10050|10051"
tcp        0      0 0.0.0.0:10050           0.0.0.0:*               LISTEN      13120/zabbix_agentd 
tcp        0      0 0.0.0.0:10051           0.0.0.0:*               LISTEN      13118/zabbix_server 
tcp6       0      0 :::10050                :::*                    LISTEN      13120/zabbix_agentd 
tcp6       0      0 :::10051                :::*                    LISTEN      13118/zabbix_server 
tcp6       0      0 :::80                   :::*                    LISTEN      13113/httpd       

12.更改时区

vim /etc/php.ini

进入php.ini配置文件进行更改

date.timezone = Asia/Shanghai

重启Apache

systemctl restart httpd

浏览器访问
http://“主机IP地址” /zabbix

14.默认登录账户密码
账号：Admin
密码 ：zabbix

修改中文界面
中文乱码问题：
cd /usr/share/zabbix/assets/fonts/
rm -rf graphfont.ttf
mv simkai.ttf graphfont.ttf