一个公司的运维基础，监控体系是必不可少的，常用的有很多，如：nagios\catai\zabbix等，今天我来分享一个zabbix 建立的过程：
一.安装mysql
1.建立Mysql账号
groupadd mysql
useradd -s /sbin/nologin -g mysql -M mysql
2.创建mysql软件目录并修改权限
mkdir -p /usr/local/mysql
mkdir -p /data/mysql
chown -R root:mysql /usr/local/mysql
chown -R mysql:mysql /data/mysql
3.安装依赖包
yum -y install make gcc-c++ cmake bison-devel ncurses-devel
4.下载源码包并解压
http://mirrors.sohu.com/mysql/
cd /usr/local/src
tar -zxf mysql-5.7.11.tar.gz
cd mysql-5.7.11
5.编译
cmake \
> -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
> -DMYSQL_DATADIR=/data/mysql \
> -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
> -DDEFAULT_CHARSET=utf8 \
> -DDEFAULT_COLLATION=utf8_general_ci \
> -DEXTRA_CHARSETS=all \
> -DENABLED_LOCAL_INFILE=1 \
> -DDOWNLOAD_BOOST=1 \
> -DWITH_BOOST=/usr/local/boost
6.安装
make && make install
7. 初始化MySQL
cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --datadir=/mysql/data --basedir=/usr/local/mysql --socket=/var/lib/mysql/mysql.sock
8. 添加MySQL服务并设置开机启动
cd /usr/local/mysql/support-files
cp mysql.server /etc/init.d/mysqld
cd /etc/init.d/
chkconfig --add mysqld
chkconfig --level 2345 mysqld on
9. 编辑my.cnf文件
vi /etc/my.cnf
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
user = mysql
basedir = /usr/local/mysql
datadir = /data/mysql
log-error = /var/log/mysql/mysqld.log
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
thread_cache_size = 8
query_cache_size = 8M
tmp_table_size = 16M
#skip-networking
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535
log-bin=mysql-bin
binlog_format = mixed
server-id = 1
expire_logs_days = 10
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
10. 重启MySQL
/etc/init.d/mysql start
Starting MySQL.. SUCCESS!
11. 登录MySQL
cd ../bin/
./mysql -uroot -p //第一次登录MySQL，密码文件在，也可以从make install 最后的一行看到密码，若看不到可以参考以下修改密码的步骤
Enter password:
12.忘记root密码可通过以下方法修改
vi /etc/my.cnf
[mysqld]
skip-grant-tables
重启mysqld服务，重新登陆已不需要密码
13.修改root密码
use mysql
update user set authentication_string=PASSWORD(‘zabbix‘) where User=‘root‘;
14.退出删除mysql.cnf中的skip-grant-tables，以新密码重新登陆即可
15.首次登陆需要重新设置一下新密码，否则任何命令都会提示：
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
set password for root@localhost = password(‘zabbix‘);
16.创建zabbix数据库
create database zabbix character set utf8 collate utf8_bin;
grant all privileges on zabbix.* to zabbix@localhost identified by ‘zabbix‘;
二.安装Zabbix
1.安装官方的yum源
rpm -ivh http://repo.zabbix.com/zabbix/3.0/rhel/7/x86_64/zabbix-release-3.0-1.el7.noarch.rpm
2.yum安装zabbix-server\zabbix-web\zabbix-agent
yum install zabbix-server-mysql zabbix-web-mysql zabbix-agent
3.初始化数据库
cd /usr/share/doc/zabbix-server-mysql-3.0.*
zcat create.sql.gz | mysql -uroot -pzabbix zabbix
4.编辑zabbix server配置文件
vi /etc/zabbix/zabbix_server.conf
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=zabbix
5.开启zabbix server以及agent服务并设置开机启动
systemctl start zabbix-server
systemctl enable zabbix-server
systemctl start zabbix-agent
systemctl enable zabbix-agent
6.确保php的配置符合zabbix的要求(默认已含下列配置)，并修改timezone为PRC
vi /etc/httpd/conf.d/zabbix.conf
php_value max_execution_time 300
php_value memory_limit 128M
php_value post_max_size 16M
php_value upload_max_filesize 2M
php_value max_input_time 300
php_value always_populate_raw_post_data -1
php_value date.timezone Asia/Shanghai
7.开启Apache服务并设置开机启动
systemctl start httpd
systemctl enable httpd
8.打开zabbix页面http://10.10.10.110/zabbix/，首次要求初始化，一路next配置下去就行
注意：确保mysql.sock协议文件在/var/lib/mysql/下，如果不在可通过my.cnf修改
9.修改语言
Zabbix 3.0.3可以直接在界面上修改为简体中文
三.Agent安装（客户端，内网IP需要修改成外网IP）
groupadd zabbix
useradd zabbix -g zabbix -s /sbin/nologin
cd /usr/local/src/
wget http://ufpr.dl.sourceforge.net/project/zabbix/ZABBIX%20Latest%20Stable/3.0.3/zabbix-3.0.3.tar.gz
tar -xzvf zabbix-3.0.3.tar.gz
cd zabbix-3.0.3
./configure --prefix=/usr/local/zabbix/ --enable-agent
make
make install
sed -i ‘s/^Server=.*/Server=10.10.10.110/g‘ /usr/local/zabbix/etc/zabbix_agentd.conf
sed -i ‘s/^ServerActive=.*/ServerActive=10.10.10.110/g‘ /usr/local/zabbix/etc/zabbix_agentd.conf
sed -i ‘s/^Hostname=.*/Hostname=TestHost/g‘ /usr/local/zabbix/etc/abbix_agentd.conf
启动agent服务
/usr/local/zabbix/sbin/zabbix_agentd start
设置开机启动
vi /etc/rc.d/rc.local
添加以下内容
/usr/local/zabbix/sbin/zabbix_agentd start
四.附加配置
1.开放系统防火墙端口
firewall-cmd --permanent --zone=public --add-rich-rule="rule family="ipv4" source address="192.168.17.0/24" port protocol="tcp" port="80" accept"
firewall-cmd --permanent --zone=public --add-rich-rule="rule family="ipv4" source address="192.168.17.0/24" port protocol="tcp" port="10050" accept"
firewall-cmd --permanent --zone=public --add-rich-rule="rule family="ipv4" source address="192.168.17.0/24" port protocol="tcp" port="10051" accept"
firewall-cmd --reload
