下面开始：
1、配置zabbix源
# wget http://repo.zabbix.com/zabbix/3.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.0-1+trusty_all.deb
# dpkg -i zabbix-release_3.0-1+trusty_all.deb
# apt-get update
<a href="http://s5.51cto.com/wyfs02/M01/87/0C/wKiom1fSMf2AjB4DAABkN0cnFZY591.jpg-wh_500x0-wm_3-wmp_4-s_36633031.jpg" target="_blank"></a>
2、安装zabbix-porxy
# apt-get install zabbix-proxy-mysql
<a href="http://s3.51cto.com/wyfs02/M01/87/0A/wKioL1fSMgqzs20wAAB_ljM-ork049.jpg-wh_500x0-wm_3-wmp_4-s_293972048.jpg" target="_blank"></a>
3、这里会安装MySQL数据库，安装过程需要设置数据root用户密码
<a href="http://s3.51cto.com/wyfs02/M02/87/0A/wKioL1fSMhvB9QmhAABToYAuG8o742.jpg-wh_500x0-wm_3-wmp_4-s_3916705496.jpg" target="_blank"></a>
确认密码
<a href="http://s2.51cto.com/wyfs02/M01/87/0C/wKiom1fSMiyBYTVFAAAzi2abjd0876.jpg-wh_500x0-wm_3-wmp_4-s_1274665138.jpg" target="_blank"></a>
4、创建zabbix_proxy数据库用于收集存储监控主机、服务信息。
root@zabbix-proxy:~# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.28-0ubuntu0.15.04.1 (Ubuntu)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database zabbix_proxy;
Query OK, 1 row affected (0.00 sec)
mysql> grant all on zabbix_proxy.* to zabbix_proxy@localhost identified by 'you_password';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
mysql> \q
Bye
<a href="http://s1.51cto.com/wyfs02/M02/87/0C/wKiom1fSMkqiryXjAADY2qyjuW8477.jpg" target="_blank"></a>
5、数据初始化导入表结构
root@zabbix-proxy:~# cd /usr/share/doc/zabbix-proxy-mysql/
root@zabbix-proxy:/usr/share/doc/zabbix-proxy-mysql# ls
changelog.Debian.gz copyrightschema.sql.gz
root@zabbix-proxy:/usr/share/doc/zabbix-proxy-mysql# gunzip schema.sql.gz
changelog.Debian.gz copyrightschema.sql
root@zabbix-proxy:/usr/share/doc/zabbix-proxy-mysql# mysql -hlocalhost -uzabbix_proxy -pBd_zabbix zabbix_proxy < schema.sql
Warning: Using a password on the command line interface can be insecure.
6、配置zabbix_proxy.conf
root@zabbix-proxy:~# vi /etc/zabbix/zabbix_proxy.conf
ProxyMode=0
Server= 121.40.58.147
ServerPort=10051
Hostname=Zabbix_proxy
DBName=zabbix_proxy
DBUser=zabbix_proxy
DBPassword=Bd_zabbix
7、启动zabbix_proxy服务
root@zabbix-proxy:~# /etc/init.d/zabbix-proxy restart
[ ok ] Restarting zabbix-proxy (via systemctl): zabbix-proxy.service.
8、查看监听端口
root@zabbix-proxy:~# netstat -ntpl |grep zabbix_proxy
tcp 00 0.0.0.0:100510.0.0.0:* LISTEN 31174/zabbix_proxy
tcp6 00 :::10051:::* LISTEN 31174/zabbix_proxy
1、创建Proxy
Administrationè ProxiesèCreate proxy
<a href="http://s4.51cto.com/wyfs02/M02/87/0C/wKiom1fSMqfRek_AAAAy26PCpcU633.jpg" target="_blank"></a>
2、配置proxy信息Create proxy
<a href="http://s1.51cto.com/wyfs02/M01/87/0A/wKioL1fSMrywUl9KAAAmiWaleok828.jpg" target="_blank"></a>
<a href="http://s3.51cto.com/wyfs02/M02/87/0C/wKiom1fSMs7h_rdwAAA5140w4w8560.jpg" target="_blank"></a>
3、添加监控主机
<a href="http://s1.51cto.com/wyfs02/M02/87/0A/wKioL1fSMt7hdz1OAACxyuZSsxM870.jpg-wh_500x0-wm_3-wmp_4-s_2019663097.jpg" target="_blank"></a>
<a href="http://s2.51cto.com/wyfs02/M02/87/0C/wKiom1fSMxyjfePeAABwgDYIG-Y878.jpg" target="_blank"></a>
4、完成查看信息
<a href="http://s2.51cto.com/wyfs02/M01/87/0A/wKioL1fSMy7BssO6AABbpUM5bLk564.jpg" target="_blank"></a>
本文转自 运维小当家 51CTO博客，原文链接：http://blog.51cto.com/solin/1851030，如需转载请自行联系原作者
![【MySQL数据库】数据库索引事务1.索引2.事务[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)