#!/bin/bash
if [ "$(whoami)" != 'root' ]; then
echo "You have no permission to run $0 as non-root user."
exit 1;
fi
INDIR=/opt/software
if [ ! -d "$INDIR" ]; then
mkdir -p $INDIR
echo "create dir install"
fi
yum -y install numactl libaio-devel.x86_64 libaio
cd $INDIR
echo "dir is:"$(pwd)
#echo "DOWNLOADING mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz"
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
echo "Install mysql Server"
tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.26-linux-glibc2.12-x86_64 mysql
cd mysql
echo "groupadd mysql and user mysql"
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql.mysql mysql
yum -y install numactl
./bin/mysqld --initialize --user=mysql --basedir=$INDIR/mysql --datadir=$INDIR/mysql/data
sleep 30
#config my.cnf
wget http://axe555.1024xyz.xyz/wget/my.cnf
mkdir -p binlog_relay binlog_data logs
chown -R mysql.mysql ./*
wget http://axe555.1024xyz.xyz/wget/mysql.server
chmod 755 ./mysql.server
#start mysql
nohup ./bin/mysqld --defaults-file=./my.cnf>>./nohup.out 2>&1 &
while true
do
result=$(netstat -na | grep 2849 | wc -l)
if [ $result == 0 ]; then
echo "mysql starting,pleale wait ......."
sleep 2
else
echo "mysql started"
break;
fi
done
echo "please running command :"\"./bin/mysql_secure_installation\" "for change password and Initialization configuration"
echo "-----running Directory:"$INDIR"/mysql"
#config mysql env
cat >> /etc/profile <<EOF
#mysql env
export MYSQL_HOME="$INDIR/mysql"
export PATH="\$PATH:\$MYSQL_HOME/bin"
EOF
source /etc/profile
cd ..
source /etc/profile
#添加mysql服务和开机自启动
cp /opt/software/mysql/mysql.server /etc/init.d/mysqld
chkconfig --add /etc/init.d/mysqld
#start firewall mysql port
sed -i '/service name="ssh"/a <port protocol="tcp" port="2849"/>' /etc/firewalld/zones/public.xml
firewall-cmd --reload