自动化部署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