centos8编译mysql

```
#!/bin/bash
#centos8编译mysql的rpm包并利用sftp上传脚本
######################变量##########################
config=https://downloads.mysql.com/archives/get/p/23/file/mysql-community-5.7.32-1.el7.src.rpm
#截取名称，截取包名-版本，为编译与传输做准备，这是该组件通用，不用修改；
var=$config
#5.7.32-1.el7.src.rpm
rpmname="`echo ${var#*community-}`"
#5.7.32
version="`echo ${rpmname%-*}`"
#mysql-5.7.32.tar.gz
package="mysql-`echo $version`.tar.gz"
#获取解压后的包
#mysql-5.7.32
var2="mysql-`echo $version`"
#为修改mysqld.cc做准备
route="`echo $var2`/sql/mysqld.cc"
#获取大版本
bigver="`echo ${version%%.*}`"
#连接sftp
user=sftp
passwd='sftp'
port=18884
ip=192.168.0.173
#传输目的地
addr='/sftp/centos8/rpm'
 
#依赖安装
yum install  time libaio-devel ncurses-devel numactl-devel openssl-devel zlib-devel cyrus-sasl-devel openldap-devel perl-Env perl-Env.noarch cmake cmake3 gcc gcc-c++ make rpm-build vim  perl-devel autoconf libaio perl-JSON.noarch  perl-Data-Dumper perl  wget bison perl-JSON libtirpc-devel  automake libarchive -y 
yum install epel-release -y	
centos8安装rpcgen
#配源
curl -o /etc/yum.repos.d/openEulerOS.repo https://repo.huaweicloud.com/repository/conf/openeuler_aarch64.repo
yum install -y rpcgen
mv /etc/yum.repos.d/openEulerOS.repo /etc/yum.repos.d/openEulerOS.repo.bak
if [ $bigver -eq 5 ];then
	echo "正在centos8编译大版本为5的mysql"			
else			
	echo "正在centos8编译大版本为8的mysq"
	#gcc高版本快速安装,防止修改MySQL源码包里的cmake配置文件
	yum install devtoolset-10 -y
	source /opt/rh/devtoolset-10/enable
	#gcc -v
fi

wget $var
rpm -ivh *.rpm

#执行编译#4表示并发数，要小于内存除以2G ，例如16G内存，则并发数小于8，_smp_mflags -j4 等于同时使用4个内核去并发执行。
rpmbuild -bb --define '_smp_mflags -j4'  /root/rpmbuild/SPECS/mysql.spec

yum install createrepo -y
createrepo /root/rpmbuild/RPMS/aarch64
cd /root/rpmbuild/RPMS/

mkdir $var2
cd /root/rpmbuild/RPMS/aarch64/
cp -r *   ../$var2

#利用sftp传输脚本生成的包
yum install vim wget -y
yum install glibc-headers gcc-c++ make unzip -y
cd /opt
#编译tcl,expect编译依赖tcl
wget  http://core.tcl.tk/tcl/zip/release/tcl.zip
unzip tcl.zip
cd ./tcl/unix
./configure && make -j4 && make install
cd /opt
#编译expect，expect提供了shell中的人机交互
wget https://jaist.dl.sourceforge.net/project/expect/Expect/5.45.3/expect5.45.3.tar.gz --no-check-certificate
tar -xzvf expect5.45.3.tar.gz && cd expect5.45.3/
./configure --build=arm-linux && make -j4 && make install
#安装sftp,传输需要
yum install openssh-clients -y

cd /root/rpmbuild/RPMS

#利用expect工具和sftp协议进行传输编译的包 
/usr/local/bin/expect <<-EOF
set timeout -1
spawn sftp -oPort=$port  $user@$ip
expect {
"yes/no" { send "yes\r"; exp_continue }
"Password:" { send "$passwd\r"; exp_continue }
"sftp" { send "put -r  ./$var2/ $addr\r" }
}
send "exit\r"
expect eof
EOF

echo "make over finishjrt"