######安装数据mysql数据库######
centos7下快速安装mysql
CentOS 7的yum源中貌似没有正常安装MySQL时的mysql-sever文件,需要去官网上下载
wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update
yum install mysql-community-server
######修改mysql配置文件######
vim /etc/my.cnf
[msyqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log_bin = /var/log/mysql/mysql-bin.log
log_error = /var/log/mysql/error.log
slow_query_log = ON
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 2
expire_logs_days = 7
max_binlog_size = 100M
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 50
max_connections = 400
query_cache_limit = 1M
query_cache_size = 16M
######启动mysql######
mkdir /var/log/mysql;chown mysql.mysql /var/log/mysql
systemctl start mysqld.service
######更新root密码及创建zabbix_proxy库和相关权限######
update mysql.user set Password = password('123456') where User = "root";
create database zabbix_proxy charset=utf8;
GRANT ALL PRIVILEGES ON zabbix_proxy.* TO 'zabbix'@'localhost' IDENTIFIED BY 'zabbix';
GRANT ALL PRIVILEGES ON zabbix_proxy.* TO 'zabbix'@'%' IDENTIFIED BY 'zabbix';
grant all privileges on *.* to root@'%' identified by "123456";
flush PRIVILEGES;
######安装zabbix_proxy######
rpm -ivh http://repo.zabbix.com/zabbix/3.0/rhel/7/x86_64/zabbix-release-3.0-1.el7.noarch.rpm
yum install -y zabbix-proxy zabbix-agent
######导入proxy数据之刚创建的zabbix_proxy库######
cd /usr/share/doc/zabbix-proxy-mysql-3.0.10/
zcat schema.sql.gz | mysql -uroot -p123456 zabbix_proxy
######修改zabbix_proxy配置及调优######
vim /etc/zabbix/zabbix_proxy.conf
Server=10.40.150.150 #同步指向的server端的IP,非本地IP。可以是server端的主机域名,但要确保proxy端解析server的域名,并且网络可达
Hostname=zabbix-proxy-test #proxy本地的名称,此名称需要与将来在server端的WEB页面上的代理程序名称一致,名称自定义
DBHost=localhost #与上面配置对应
DBName=zabbix_proxy #与上面配置对应
DBUser=zabbix #与上面配置对应
DBPassword=zabbix-proxy #与上面配置对应
DBPort=3306 #与上面配置对应
VMwareCacheSize=2G
StartTrappers=50
StartPollers=50
CacheSize=8G
Timeout=30
DataSenderFrequency=60
######启动proxy并加入开机启动
systemctl enable zabbix-proxy.service
systemctl start zabbix-proxy.service