2、安装mysql多实例

#!/bin/bash
echo "开始安装mariadb"
yum -y install mariadb-server
mkdir -pv /mysql/{3306,3307,3308}/{data,etc,socket,log,bin,pid}
chown -R mysql.mysql /mysql

echo "正在生成数据库文件：/mysql/330*/data"
mysql_install_db --datadir=/mysql/3306/data --user=mysql
mysql_install_db --datadir=/mysql/3307/data --user=mysql
mysql_install_db --datadir=/mysql/3308/data --user=mysql

echo "正在准备配置文件：/mysql/330*/etc/mysql.cnf"
echo -e "[mysqld] 
port=3306
datadir=/mysql/3306/data
socket=/mysql/3306/socket/mysql.sock
log-error=/mysql/3306/log/mysql.log 
pid-file=/mysql/3306/pid/mysql.pid" > /mysql/3306/etc/my.cnf
sed 's/3306/3307/' /mysql/3306/etc/my.cnf > /mysql/3307/etc/my.cnf
sed 's/3306/3308/' /mysql/3306/etc/my.cnf > /mysql/3308/etc/my.cnf

echo "正在准备启动脚本：/mysql/3306/bin/mysqld"
port=3306
mysql_user="root"
mysql_pwd="root"
cmd_path="/usr/bin"
mysql_basedir="/mysql"
mysql_sock="${mysql_basedir}/${port}/socket/mysql.sock"
echo -e "#!/bin/bash
port=3306
mysql_user="root"
mysql_pwd="root"
cmd_path="/usr/bin"
mysql_basedir="/mysql"
mysql_sock="${mysql_basedir}/${port}/socket/mysql.sock"
function_start_mysql()
{
	if [ ! -e "$mysql_sock" ];then
                ${cmd_path}/mysqld_safe --defaults-file=${mysql_basedir}/${port}/etc/my.cnf &> /dev/null &
        else
                exit
        fi
}
function_stop_mysql()
{
        if [ ! -e $mysql_sock ];then
                exit
        else
                ${cmd_path}/mysqladmin -u${mysql_user} -p${mysql_pwd} -S ${mysql_sock} shutdown
        fi
}
function_restart_mysql()
{
        printf "Restarting MySQL...\n"
        function_stop_mysql
        sleep 2
        function_start_mysql
}
case $"1" in
start)
        function_start_mysql
;;
stop)
        function_stop_mysql
;;
restart)
        function_restart_mysql
;;
*)
        printf "ERROR FORMAT"
esac">/mysql/3306/bin/mysqld
sed 's/3306/3307/' /mysql/3306/bin/mysqld > /mysql/3307/bin/mysqld
sed 's/3306/3308/' /mysql/3306/bin/mysqld > /mysql/3308/bin/mysqld
chmod +x /mysql/330{6,7,8}/bin/mysqld

echo "正在启动服务"
/mysql/3306/bin/mysqld start
/mysql/3307/bin/mysqld start
/mysql/3308/bin/mysqld start
sleep 10
ss -ntl

echo "设置默认root密码为root"
mysqladmin -uroot -S /mysql/3306/socket/mysql.sock password 'root'
mysqladmin -uroot -S /mysql/3307/socket/mysql.sock password 'root'
mysqladmin -uroot -S /mysql/3308/socket/mysql.sock password 'root'