!/bin/bash

BOOSTURL="https://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz"

PERCONAURL="https://www.percona.com/downloads/Percona-Server-LATEST/Percona-Server-5.7.18-15/source/debian/percona-server-5.7_5.7.18-15.orig.tar.gz"

install_filepath=$(dirname $0)

基础配置

port=3308
basedir=/data/app/mysql5.7
rundir=$basedir/run
databasedir=/data/dbdata/mysql${port}
datadir=${databasedir}/data

log/tmp/redo/ibdata 文件目录｛日志文件、临时文件、共享表空间文件可独立其他目录存储如存储到ssd区域｝

otherdir=/opt/dbdata/mysql${port}
logdir=${otherdir}/log
tmpdir=${otherdir}/tmp
redodir=${otherdir}/redo
ibdatadir=${otherdir}

基础配置选项文件my.cnf

mycnf=$install_filepath/my.cnf

主机基础信息并产生server_id参数【IP尾号+端口】

LOCALGW=$(route -n|awk '{if( $1 == "0.0.0.0"){print $2}}')
LOCALIP=$( ifconfig -a|awk '{print $2}'|grep $(echo $LOCALGW |awk -F"." '{print $1"."$2"."$3}') )
SERVERID=$(echo $LOCALIP|awk -F"." '{print $4}')$port

对临时目录判断[安装时也作为临时目录使用]

if [ -d $tmpdir ] ;then
install_filepath=$tmpdir
else
install_filepath=$(dirname $0)
fi

mysql用户与组判断，不存在则创建

gmysql=$(grep mysql /etc/group)
if [ -z $gmysql ] ;then
groupadd mysql
fi
umysql=$(grep mysql /etc/passwd)
if [ -z $umysql ] ;then
useradd -g mysql -s /bin/bash mysql
fi

function object_is_null ()
{
if [ -z "$1" ] ; then
echo "$1 is null"
return 1
else
echo "$1 is exist"
return 0
fi

}

function permission_exist()
{
if [ "mysql.mysql" = $(ll $1 |awk '{print $3"."$4}') ] ;then
echo "permission successed"
else
echo "Permission denied: May be you can chown -R mysql.mysql $1 "
fi
}
function dir_is_exist ()
{
if [ -d $1 ] ; then
echo "$1 is exist"
if [ $(ls -A $1 |wc -l) -gt 0 ] || [ -z "$(ls -A $1 |wc -l)" ];then
echo -e "$1 is empty , check Success "
else
echo -e " \033[41;33m $1 is not empty ,check Failed \033[0m "
exit 1
fi
return 1
else
echo "$1 is not exist"
echo "creating $1"
echo -e " \033[41;33m mkdir -p $1 \033[0m "
mkdir -p $1
return 0
fi

}

####目录验证

dir_is_exist $basedir
dir_is_exist $rundir
dir_is_exist $databasedir
dir_is_exist $logdir
dir_is_exist $datadir
dir_is_exist $tmpdir
dir_is_exist $redodir
dir_is_exist $ibdatadir

# cp $mycnf $basedir

权限验证

chown -R mysql.mysql $basedir
chown -R mysql.mysql $rundir
chown -R mysql.mysql $databasedir
chown -R mysql.mysql $logdir
chown -R mysql.mysql $datadir
chown -R mysql.mysql $tmpdir
chown -R mysql.mysql $redodir
chown -R mysql.mysql $ibdatadir

yum -y install perl-DBD-MySQL.x86_64 perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker perl-CPAN perl-Time-HiRes
yum install cmake make gcc gcc-c++ bison ncurses ncurses-devel zlib zlib-devel -y
yum install perl readline readline-devel -y

安装包检查，检查是否有安装包，不存在，则下载

if [ -z $( ls $install_filepath |grep boost ) ] ;then
wget -c -P $install_filepath $BOOSTURL
if [ $? -eq 0 ];then
echo -e "get Success :$BOOSTURL "
else
echo -e " \033[41;33m get Failed :$BOOSTURL \033[0m "
exit 1
fi
fi

if [ -z $( ls $install_filepath |grep percona-server ) ] ;then

wget -c -P $install_filepath $PERCONAURL
if [ $? -eq 0 ];then
echo -e "get Success :$PERCONAURL "
else
echo -e " \033[41;33m get Failed :$PERCONAURL \033[0m "
exit 1
fi
fi

进入下载后目录

cd $install_filepath

查看本地是否存在boost或percona-server压缩包，不存在则解压刚下载的包

for codefile in $( ls *.tar.gz |grep -e boost -e percona-server)
do
if [ -f $codefile ] ;then
codedir=$(echo $codefile|awk -F "." '{print $1}')
codedirs=$( ls |grep $codedir|grep -v tar.gz )
echo $codedir
echo $codedirs
if [ $codedirs ] ;then
echo -e " \033[41;33m $codedirs is exist \033[0m "

    exit 1
    else
    tar zxvf $codefile
    fi
else
echo $codefile is not exist
fi

done

截取对应包名字（去除.tar.gz）

boost=$( ls |grep boost|grep -v tar.gz )
percona=$( ls |grep percona-server|grep -v tar.gz )

首先生成my.cnf文件

cat /dev/null > $basedir/my.cnf

基础配置信息写入 my.cnf

echo -e '
[mysql]
prompt="\\u@\\h:\\d \\r:\\m:\\s> "
'>>$basedir/my.cnf

目录相关配置地址

echo -e "
no_auto_rehash
[mysqld]
basedir=$basedir
datadir=$datadir
tmpdir=$tmpdir
pid-file=$rundir/mysqld.pid
socket=$rundir/mysql.sock
port=$port
log_error=$logdir/alert.log
slow_query_log_file=$logdir/slow.log
log_bin=$logdir/mysql_bin
innodb_data_home_dir=$ibdatadir
innodb_log_group_home_dir=$redodir
relay_log=$logdir/mysql_relay
relay_log_index=$logdir/mysql_relay.index
slave_load_tmpdir=$tmpdir
server_id=$SERVERID
" >>$basedir/my.cnf

其他需要配置项可写入当前目录下的default-my.cnf并写入my.cnf文件

if [ -f "$install_filepath/default-my.cnf" ];then
cat $install_filepath/default-my.cnf >>$basedir/my.cnf
echo -e " \033[41;33m copy $install_filepath/default-my.cnf into $basedir/my.cnf \033[0m "

else
echo -e " \033[41;33m $basedir/my.cnf . No other configuration options . \033[0m "
fi

echo -e '
[client]
socket=$rundir/mysql.sock

'>>$basedir/my.cnf

####开始编译
cd $percona
cmake . -DWITH_BOOST=../$boost \
-DCMAKE_INSTALL_PREFIX=$basedir \
-DMYSQL_DATADIR=$datadir \
-DSYSCONFDIR=$basedir \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DEXTRA_CHARSETS=all \
-DENABLED_LOCAL_INFILE=1

验证编译是够正常

if [ $? -ne 0 ] ;then
echo "cmake error"
else

编译正常，则进入make

make -j16
if [ $? -ne 0 ] ; then
echo "make error"
exit 1
fi
make install
if [ $? -ne 0 ] ; then
echo "make install error"
exit 1
else
###编译安装均正常，则copy 相关文件到系统环境变量目录。并初始化，加入开机启动项
cd $basedir
ln -s $basedir/bin/* /usr/bin/
mysqld --defaults-file=$basedir/my.cnf --initialize --user=mysql
ln -s $basedir/support-files/mysql.server /etc/init.d/mysql
chkconfig --add mysql
chkconfig mysql on
service mysql start

fi

fi

因编译时my.cnf 选择$basedir/my.cnf，因此取消或替换/etc/my.cnf配置文件

if [ -f /etc/my.cnf ];then
mv /etc/my.cnf /etc/my.cnf.bak
fi