#!/bin/bash

 #

 # Description: Automated Deployment compilation MySQL

 # Author: jiajunwei

 # Version: ---

 # Environment:

 #    . Mysql-Version: mysql-5.6.x

 #    . Operating system: CentOS .x

 # Advise: The MySQL data directory on a logical volume

 # Preparation: Need to put the source package mysql-5.6.x.tar.gz to /usr/local/src

 #####################[Preparatory work before compiling]######################

 # . Provide the compiler environment

 echo -e  "\033[31mThe First step:Check and Configure compile environment ......\033[0m"

 #if ! ping -c2 -w3 www.baidu.com &> /dev/null;then

 #    mkdir -p /etc/yum.repos.d/repo

 #    mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/repo

 #    cat << EOF > /etc/yum.repos.d/CentOS-Media.repo

 #    [c6-media]

 #    name=CentOS-$releasever - Media

 #    baseurl=file:///media/cdrom/

 #    gpgcheck=1

 #    enabled=1

 #    gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

 #EOF

 #    mkdir -p /media/cdrom

 #    if od -ax /dev/cdrom | head -1 &> /dev/null;then

 #        umount /dev/cdrom &> /dev/null

 #        mount -r /dev/cdrom /media/cdrom

 #    else

 #    echo "Please mount the disk and load the system image"

 #        exit 2

 #    fi

 #fi

 yum -y groupinstall "Development Tools" &> /dev/null

 yum -y install cmake bison ncurses-devel openssl-devel &> /dev/null

 if [ $? -eq 0 ];then

     echo "--------->Enviroment is ok "

 else

     echo "--->Failed to compile environment testing, please check"

     exit 3

 fi

 # 2. Add the operation of database users

 echo -e "\033[31mThe second step:Add the operation of database users with user mysql......\033[0m"

 [ ! `grep "mysql" /etc/group` ] && groupadd -r mysql

 [ ! `grep "mysql" /etc/passwd` ] && useradd -r -d /mydata/data -g mysql -s /bin/false mysql

 if id mysql &> /dev/null;then

     echo "--------->Add user complete "

 else

     echo "--->Add user failed "

     exit 4

 fi

 #[ -f /etc/yum.repos.d/repo/CentOS-Base.repo ] && mv /etc/yum.repos.d/repo/*.repo /etc/yum.repos.d/

 # 3. To determine the database directory and modify it belongs to the main group

 echo -e "\033[31mThe third step:Determine the data directory and modify the permissions......\033[0m"

 mkdir -p /mydata/data

 chown -R mysql.mysql /mydata/data

 echo "--->OK"

 ################################[Compile and install MySQL]#######################

 echo -e "\033[31mThe forth step:Compile and install MySQL......\033[0m"

 if ! ls -l /usr/local/src/mysql*.tar.* &> /dev/null;then

     echo " Copy your source package to this path:/usr/local/src"

     exit 5

 fi

 tar xf /usr/local/src/mysql*.tar.* -C /usr/local/src

 dir_count=`find /usr/local/src/  -maxdepth 1 -type d -name "mysql*" | wc -l`

 if [ $dir_count -eq 1 ];then

    dir=`find /usr/local/src/  -maxdepth 1 -type d -name "mysql*"`

 else

     echo "This path cannot have two MySQL directories at the same time"

     exit 5

 fi

 cd $dir

 cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

 -DMYSQL_DATADIR=/mydata/data/ \

 -DSYSCONFDIR=/etc/ -DWITH_INNOBASE_STORAGE_ENGINE=1 \

 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

 -DWITH_FEDERATED_STORAGE_ENGINE=1 \

 -DWITH_ARCHIVE_STORAGE_ENGINE=1 \

 -DWITH_READLINE=1 \

 -DWITH_SSL=system \

 -DWITH_ZLIB=system \

 -DWITH_LIBWRAP=0 \

 -DMYSQL_UNIX_ADDR=/mydata/data/mysql.sock \

 -DDEFAULT_CHARSET=utf8 \

 -DDEFAULT_COLLATION=utf8_general_ci \

 -DMYSQL_TCP_PORT=3306 \

 -DENABLED_LOCAL_INFILE=1 \

 -DWITH_DEBUG=0 -DENABLED_PROFILING=1 \

 -DWITH_EXTRA_CHARSETS=all \

 -DWITH_INNODB_MEMCACHED=1

 cpu_count=`cat /proc/cpuinfo | grep "processor" |wc -l`

 make -j $cpu_count && make install

 if [ $? -eq 0 ];then

     echo "------->installation is complete"

 else

     echo "--->Compile failed, please check"

     exit 6

 fi

 ############################[boot startup script]#######################

 echo -e "\033[31mThe Fifth step:Provide configuration files and sysV boot startup script for MySQL......\033[0m"

 [ -f /etc/my.cnf ] && \mv -f /etc/my.cnf{,.bak}

 cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

 sed -i '/^\[mysqld\]/ a \datadir=/mydata/data\nsocket=/mydata/data/mysql.sock\n \

 pid-file=/var/run/mysqld/mysqld.pid\n \

 log-error=/var/log/mysqld.log\n \

 user=mysql\n \

 innodb_file_per_table=ON\n \

 skip_name_resolve=ON\n \

 log-bin=/mydata/log-bin/mysql-bin' /etc/my.cnf

 mkdir -p /var/run/mysqld

 chown -R mysql.mysql /var/run/mysqld

 mkdir -p /mydata/log-bin

 chown -R mysql.mysql /mydata/log-bin

 [ -f /etc/init.d/mysqld ] && \mv -f /etc/init.d/mysqld{,.bak}

 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

 chmod 755 /etc/init.d/mysqld

 chkconfig --add mysqld

 chkconfig --level 35 mysqld on

 echo "------->OK"

 #############################[Export binary files]########################

 echo -e "\033[31mThe sixth step:Export MySQL related binary files......\033[0m"

 echo  "export PATH=/usr/local/mysql/bin:$PATH" > /etc/profile.d/mysql-5.6.sh

 #source /etc/profile

 exec bash

 if which mysqld_safe &> /dev/null;then

     echo "------>export is successful"

 else

     echo "--->export is faild"

 fi

 ###########################[MySQL database initialization]##################

 echo -e "\033[31mThe seventh step:MySQL database initialization .......\033[0m"

 cd /mydata/data

 tar -jcf mydata-data.tar.bz2 *

 unalias mv -f mydata-data.tar.bz2 /tmp/

 rm -rf *

 /usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf \

 --basedir=/usr/local/mysql \

 --datadir=/mydata/data/ \

 --user=mysql

 if [ $? -eq 0 ];then

     echo "--->initiate is finished "

 else

     echo "------->initiate is failed "

     exit 7

 fi

 ###########################[Database Startup Test]####################

 echo -e "\033[31mThe eighth step:Database Startup Test......\033[0m"

 # 1. Set firewall and SELinux

 service iptables stop

 setenforce 0

 # 2. Run  mysql service

 service mysqld start

 if netstat -lntp | grep "mysql" &> /dev/null;then

     echo "------->Service startup normal "

 else

     echo "---->Service startup failed "

     exit 8

 fi

 ########################[Run security setup script]#####################

 echo -e "\033[31mThe last step: Run security setup script......\033[0m"

 echo -e "\ny\nmysqldba\nmysqldba\ny\nn\ny\ny\n" | mysql_secure_installation

 if [ ! $? -eq 0 ];then

     echo "Security initialization failed, please run manually"

 fi

 echo -e "\033[31mPlease re check and configure the firewall policy and selinux, now they are disabled.\033[0m"