MySQL自动安装esb

#!/bin/bash
# author jiadk ------ email: jiadk@paraview.cn
# version : 1.0.0
echo "--------------------开始安装ESB运行环境(mysql)--------------------"
########################################################
#
#    1. 保证机器有足够的磁盘空间
#    2. 安装包的路径为/home/software
#    3. 所安装软件均在/home目录下
#    4. 所有执行用户为root用户（包括启动此脚本！）
#
########################################################
## 软件的安装包的地址(请根据实际版本及文件安装包名称进行修改)

#mysql安装包路径
mysql_SRC=/home/software/mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz
#mysql解压后文件名（原安装包名去掉后缀名）
mysql_NAME=mysql-8.0.28-linux-glibc2.12-x86_64

#####关闭防火墙#####
echo ---  关闭防火墙状态：---
systemctl stop firewalld.service
systemctl disable firewalld.service
########################################################



###################mysql安装##########################
precheck_mysql()
{
if [ ! -f "${mysql_SRC}"  ]; then
echo －－提示：mysql安装文件或openfire安装文件不存在,请将它们拷贝过来再运行!
exit 1;
fi
echo －－提示：－－－－－－－操作系统情况－－－－－－－－
#lsb_release -a
cat /etc/issue

echo －－提示：－－－－－－－磁盘使用空间情况－－－－－－－－
df -h

echo －－提示：－－－－－－－内存使用空间情况－－－－－－－－
free -m
}

#############################################
# 开始安装配置mysql
install_mysql(){
cd /home/software
groupadd mysql
useradd -g mysql mysql
mkdir -p /home/mysql/data
tar -xvf ${mysql_SRC} -C /home/mysql --strip-components 1
cd /home/mysql/
chown -R mysql:mysql /home/mysql/
chmod -R 775 /home/mysql/data

echo "[mysqld]" > /etc/my.cnf
echo "server-id                      = 1" >> /etc/my.cnf
echo "port                           = 3306" >> /etc/my.cnf
echo "basedir                         =/home/mysql" >> /etc/my.cnf
echo "datadir                        = /home/mysql/data" >> /etc/my.cnf
echo "socket                         = /tmp/mysql.sock" >> /etc/my.cnf
echo "pid-file                       = /tmp/mysqld.pid" >> /etc/my.cnf
echo "log-error                      = error.log" >> /etc/my.cnf
echo "slow-query-log                 = 1" >> /etc/my.cnf
echo "slow-query-log-file            = slow.log" >> /etc/my.cnf
echo "long_query_time                = 0.2" >> /etc/my.cnf
echo "log-bin                        = mysql-bin" >> /etc/my.cnf
echo "relay-log                      = relay.log" >> /etc/my.cnf
echo "binlog_format                 =ROW" >> /etc/my.cnf
echo "relay_log_recovery            = 1" >> /etc/my.cnf
echo "character-set-client-handshake = FALSE" >> /etc/my.cnf
echo "character-set-server           = utf8mb4" >> /etc/my.cnf
echo "collation-server               = utf8mb4_unicode_ci" >> /etc/my.cnf
echo "init_connect                   ='SET NAMES utf8mb4'" >> /etc/my.cnf
echo "innodb_buffer_pool_size        = 1G" >> /etc/my.cnf
echo "join_buffer_size               = 128M" >> /etc/my.cnf
echo "sort_buffer_size               = 2M" >> /etc/my.cnf
echo "read_rnd_buffer_size           = 2M" >> /etc/my.cnf
echo "log_timestamps                 = SYSTEM" >> /etc/my.cnf
echo "lower_case_table_names         = 1" >> /etc/my.cnf
echo "default_authentication_plugin  = mysql_native_password" >> /etc/my.cnf
echo "max_connections                = 500" >> /etc/my.cnf
echo "wait_timeout                   = 600" >> /etc/my.cnf
echo "interactive_timeout            = 600" >> /etc/my.cnf
echo "max_binlog_size                      = 50M" >> /etc/my.cnf
echo "expire_logs_days             = 7" >> /etc/my.cnf
echo "max_allowed_packet                           = 500M" >> /etc/my.cnf
cp -a /home/mysql/support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/rc.d/init.d/mysql
chkconfig --add mysql
echo 'export PATH=/home/mysql/bin:/home/mysql/lib:$PATH' >> /etc/profile
source /etc/profile
mysqld --initialize --user=mysql --basedir=/home/mysql/ --datadir=/home/mysql/data
service mysql start
echo ----------------mysql安装结束！-------------
}





# *******************************
# main routing
# *******************************

echo 是否安装mysql（y/n）
read num
if [ $num = "y" ]; then
echo 开始安装mysql:
precheck_mysql
install_mysql
fi