Zabbix安装之后端数据存安装

rtre

一、安装环境

主机角色	主机IP	Vip	操作系统版本	软件版本
ServerA	192.168.1.101	192.168.1.100	CentOS 6.5 64bit	Zabbix-2.2.4
ServerB	192.168.1.102		CentOS 6.5 64bit	Zabbix-2.2.4
mysqlA	192.168.1.97	192.168.1.99	CentOS 6.5 64bit	mysql-5.6.21
mysqlB	192.168.1.98		CentOS 6.5 64bit	mysql-5.6.21

二、架构

架构详见：http://www.iyunv.com/thread-117959-1-1.html

三、Mysql安装

1. 创建目录和安装依赖包提前规划好数据库安装目录，具体如下：
安装目录：prefix dir

1	/usr/local/mysql/

sock目录：

1	/var/lib/mysql/mysql.sock

数据目录datadir
/data/ismdata/

Innodb数据目录
/data/idbdata

相关Logs目录：

1 2 3

/data/myqllog/slowlog/slow.log /data/mysqllog/errorlog/log-error.log /data/mysqllog/binlog/master-bin.log

mkdir -p/data/{ismdata,idbdata,mysqllog}
yuminstall sudo gdb ethtool ntp sysstat htop ntpdate irqbalance ncftp straceltrace hal gcc g++ cmake make bison libncurses5-dev gcc-c++ ncurses-devel
groupadd-g 900 mysql
useraddmysql -u 900 -g mysql -s /sbin/nologin
chownmysql.mysql -R /data/ismdata
chownmysql.mysql -R /data/idbdata
chownmysql.mysql -R /data/mysqllog

2. 解压编译安装mysqltar zxvf mysql-5.6.21.tar.gz
cd mysql-5.6.21
Cmak-DCMAKE_INSTALL_PREFIX=/usr/local/mysql/ -DMYSQL_DATADIR=/data/ismdata/-DENABLED_LOCAL_INFILE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock-DWITH_DEBUG=0 -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306  -DWITH_READLINE=1-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE-ENGINE=1-DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk-DENABLE_DOWNLOADS=1
make -j 4
make install
chmod 755scripts/mysql_install_db
./scripts/mysql_install_db --user=mysql--basedir=/usr/local/mysql --datadir=/data/ismdata

cp support-files/mysql.server /etc/init.d/mysqld&& chmod u+x /etc/init.d/mysqld && chkconfig --add mysqld
ln -s /usr/local/mysql/bin/mysql /usr/bin/