Shulou(Shulou.com)06/01 Report--

Deploy zabbix to monitor mysql

(1) install LAMP environment

[root@localhost ~] # yum-y installmysql-server http php

(2) install the dependency packages required by zabbix web

[root@localhost ~] # yum-y installmysql-dev gcc net-snmp-devel curl-devel perl-DBI php-gd php-mysql php-bcmathphp-mbstring php-xml

Install Fping:

[root@localhost zabbix] # wget http://www.fping.org/dist/fping-3.13.tar.gz

[root@localhost zabbix] # tar xffping-3.13.tar.gz

[root@localhost zabbix] # cd fping-3.13

[root@localhost fping-3.13] #. / configure

[root@localhost fping-3.13] # make&& make install

(3) create a user running Zabbix

[root@localhost fping-3.13] # groupaddzabbix

[root@localhost fping-3.13] # useradd-gzabbix zabbix

[root@localhost fping-3.13] # chownroot:zabbix / usr/local/sbin/fping

[root@localhost fping-3.13] # chmod 4710/usr/local/sbin/fping

(4) install zabbix server:

[root@localhost zabbix] # wget http://jaist.dl.sourceforge.net/project/zabbix/ZABBIX%20Latest%20Stable/3.0.2/zabbix-3.0.2.tar.gz

[root@localhost zabbix] # tar xfzabbix-3.0.2.tar.gz

[root@localhost zabbix] # cd zabbix-3.0.2

[root@localhost zabbix-3.0.2] # / configure--prefix=/usr/local/zabbix-- enable-server-- enable-agent-- enable-proxy--with-mysql=/usr/bin/mysql_config-- with-net-snmp-- with-libcurl

[root@localhost zabbix-3.0.2] # make

[root@localhost zabbix-3.0.2] # make install

Zabbix server configuration and startup

(1) create Zabbix database and Mysql users

Mysql > create schema zabbix characterset utf8

Query OK, 1 row affected (0.00 sec)

Mysql > create user "zabbix" @ "%" identified by "123456"

Query OK, 0 rows affected (0.00 sec)

Mysql > grant all on zabbix.* to "zabbix" @ "%"

Query OK, 0 rows affected (0.00 sec)

Mysql > grant all on zabbix.* to "zabbix" @ localhost identified by "123456"

Mysql > flush privileges

Query OK, 0 rows affected (0.00 sec)

(2) Import the initial data of zabbix database

[root@localhost zabbix-3.0.2] # cddatabase/mysql/

[root@localhost mysql] # ll

The total dosage is 3012

-rw-r--r-- 1 1000 1000 990351 April 20 18:01 data.sql

-rw-r--r-- 1 1000 1000 1978341 April 20 17:51 p_w_picpaths.sql

-rw-r--r-- 1 1000 1000 113197 April 20 18:01 schema.sql

[root@localhost mysql] #

[root@localhost mysql] # mysql-u zabbix-p zabbix

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.