自动化部署MySQL5.6
#!/bin/bash
clear
echo "========================================================================="
echo ""
echo "Mysql for Centos6.x Install scripts "
echo "Default Install PATH:/usr/local/mysql"
echo "Default mysql default password:google123"
echo "========================================================================="
echo ""
echo "For more information please visit http://code.google.com/p/autosetup/ or https://github.com/akin520"
echo ""
read -p "If the OK! Press any key to start..."
base() {
echo "EVN Initialization..."
if [ "`uname -m`" == "x86_64" ]; then
rpm -Uhv http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm
rpm -Uhv http://mirrors.ustc.edu.cn/epel/6/x86_64/epel-release-6-8.noarch.rpm
elif [ "`uname -m`" == "i686" ]; then
rpm -Uhv http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.i686.rpm
rpm -Uvh http://mirrors.ustc.edu.cn/epel/6/i386/epel-release-6-7.noarch.rpm
fi
yum -y install unzip wget cmake bison bison-devel patch make gcc gcc-c++ libtool libtool-libs \
libart_lgpl libart_lgpl-devel autoconf libjpeg libjpeg-devel libpng libpng-devel fontconfig \
fontconfig-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel \
glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel\
krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers
yum install axel -y
}
download() {
echo "Download soft..."
if [ ! -s mysql-5.6.17.tar.gz ]; then
axel -n 10 http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.17.tar.gz
fi
if [ -s /etc/my.cnf ]; then
mv /etc/my.cnf /etc/my.cnf.auto
fi
if [ -s /etc/init.d/mysql ]; then
mv /etc/init.d/mysql /etc/init.d/mysql.auto
fi
}
install(){
useradd mysql
tar -zxvf mysql-5.6.17.tar.gz
cd mysql-5.6.17
mkdir -p source_downloads
cd source_downloads
axel -n 5 http://sourceforge.net/projects/autosetup/files/soft/gmock-1.6.0.zip
unzip gmock-1.6.0.zip
cd gmock-1.6.0
./configure
make
cd ../..
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_SSL=bundled -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DENABLE_DOWNLOADS=1
make && make install
cp support-files/my-default.cnf /etc/my.cnf
cp support-files/mysql.server /etc/init.d/mysql
cd /usr/local/mysql
./scripts/mysql_install_db --user=mysql
chown -R mysql /usr/local/mysql/data
chgrp -R mysql /usr/local/mysql/.
chmod 755 /etc/init.d/mysql
chkconfig --level 345 mysql on
echo "/usr/local/mysql/lib" >> /etc/ld.so.conf
ldconfig
service mysql start
cd -
cd ..
/usr/local/mysql/bin/mysqladmin -u root password google123
echo ‘export PATH="/usr/local/mysql/bin:$PATH"‘ >>/etc/profile
source /etc/profile
}
end() {
clear
echo ""
echo ""
echo "Run Script: /etc/init.d/mysql {start|stop|restart}"
echo "datadir /usr/local/mysql/data"
echo ""
echo ""
}
main() {
echo "Installtion MYSQL..."
base
download
install
end
}
main