#!/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'
2、安装mysql多实例
于 2022-01-25 11:24:21 首次发布