#####################################################
# 播控平台mysql安装脚本	                            #
# 2015年4月28日                                     #
# by  赵卫                                          #
#####################################################

#! /bin/sh
yum -y install libtool-ltdl-devel* 
mkdir /opt/`date +%Y%m%d`
cd /opt/`date +%Y%m%d`
wget -N http://211.103.207.119:81/mysql/mysql-5.6.24.tar.gz

##  install mysql  ##
yum -y install ncurses-devel make gcc gcc-c++ cmake autoconf automake perl-devel
tar xzf mysql-5.6.24.tar.gz
cd mysql-5.6.24
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/usr/local/mysql -DMYSQL_DATADIR=/data/db/mysql -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DWITH_DEBUG=0 -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1
make -j
make install
useradd mysql
groupadd mysql
cd /usr/local/mysql
wget -N http://211.103.207.119:81/mysql/my.cnf
sed -i 's/11023/$1/g' my.cnf
mkdir -p /data/db/mysql
./scripts/mysql_install_db  --defaults-file=./my.cnf
chown -R mysql:mysql /data/db/mysql
cd /etc/init.d/
wget -N http://211.103.207.119:81/mysql/mysqld
chmod 755 mysqld
chkconfig --add mysqld
chkconfig mysqld on
chown -R mysql:mysql /data/db/mysql
##  end  ##