shell脚本多实例部署MySQL

最新推荐文章于 2022-09-22 11:09:47 发布

1314444

最新推荐文章于 2022-09-22 11:09:47 发布

阅读量148

点赞数

分类专栏： MYSQL 文章标签： mysql linux 数据库

1314444

本文链接：https://blog.csdn.net/qq_48289488/article/details/122017044

版权

MYSQL 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

多实例部署MySQL

//创建一个目录存放脚本
[root@master ~]# mkdir /script
[root@master packages]# pwd
/script/packages
[root@master packages]# ls
mysql-5.7.34-linux-glibc2.12-x86_64.tar.gz

//编写脚本
[root@master script]# cat mysql.sh
#!/bin/bash
route=/usr/local
data=/opt/data
read -p "请输入要部署的实例个数:" deploy
if [ -z $deploy ];then
	deploy=1
fi

echo $deploy | grep -E '^[0-9]+$' &> /dev/null
if [ $? -ne 0 ];then
	$deploy=1
fi

read -sp "请输入要设置的数据库密码: " passwd
if [ -z $passwd ];then
	passwd=123
fi

function first(){
    if [ ! -d $data ];then
        mkdir -p $data
    fi
    chown -R mysql.mysql $data
    look=$(ls $data | wc -l)
    if [ $look -eq 0 ];then
        $route/mysql/bin/mysqld --initialize-insecure --user mysql --datadir=$data
    fi
    
    if [ ! -d $route/mysql ];then
        cat > /etc/my.cnf << EOF
[mysqld]
basedir = $route/mysql
datadir = $data
socket = /tmp/mysql.sock
port = 3306
pid-file = $data/mysql.pid
skip-name-resolve
user = mysql
EOF
    fi
    sed -ri "s#^(basedir=).*#\1$route/mysql#g" $route/mysql/support-files/mysql.server
    sed -ri "s#^(datadir)=.*#\1$data#g" $route/mysql/support-files/mysql.server

    cat > /usr/lib/systemd/system/mysqld.service <<EOF
[Unit]
Description=mysql server daemon
After=network.target

[Service]
Type=forking
ExecStart=$route/mysql/support-files/mysql.server start
ExecStop=$route/mysql/support-files/mysql.server stop
ExecReload=/bin/kill -HUP \$MAINPID

[Install]
WantedBy=multi-user.target
EOF
    systemctl daemon-reload
    systemctl enable --now mysqld
    sleep 3
    $route/mysql/bin/mysql -uroot -e "set password=password('$passwd')"
}

function many(){
    port=3305
    cat > /etc/my.cnf << EOF
[mysqld_multi]
mysqld = $route/mysql/bin/mysqld_safe
mysqladmin = $route/mysql/bin/mysqladmin

EOF
    for i in $(seq $deploy);do
	let port++
	if [ ! -d $data/$port ];then
            mkdir -p $data/$port
	fi
	chown -R mysql.mysql $data/port
	look=$(ls $data/$port | wc -l)
	if [ $look -eq 0 ];then
            $route/mysql/bin/mysqld --initialize-insecure --user mysql --datadir=$data/$port
	fi
        cat >> /etc/my.cnf <<EOF
[mysqld$port]
datadir = $data/$port
port = $port
socket = /tmp/mysql$port.sock
pid-file = $data/$port/mysql.pid
log-error=/var/log/$port.log

EOF
        $route/mysql/bin/mysqld_multi start $port
	sleep 3
	$route/mysql/bin/mysql -uroot -P$port -h127.0.0.1 -e "set password=password('$passwd')"
    done
    cat > /usr/lib/systemd/system/mysqld.service <<EOF
[Unit]
Description=mysql server daemon
After=network.target

[Service]
Type=forking
ExecStart=$route/mysql/support-files/mysqld_multi.server start
ExecStop=$route/mysql/support-files/mysqld_multi.server stop
ExecReload=/bin/kill -HUP \$MAINPID

[Install]
WantedBy=multi-user.target
EOF
   systemctl daemon-reload
   systemctl enable mysqld
}

yum -y install ncurses-compat-libs perl libncurses*

id mysql &>/dev/null
if [ $? -ne 0 ];then
    useradd -r -M -s /sbin/nologin mysql
fi

if [ ! -d $route/mysql-5.7.32-linux-glibc2.12-x86_64 ] && [ ! -d $route/mysql ];then
	tar xf packages/mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz -C $route
        ln -s $route/mysql-5.7.32-linux-glibc2.12-x86_64/ $route/mysql
fi

chown -R mysql.mysql $route/mysql*
echo "export PATH=$route/mysql/bin:\$PATH" > /etc/profile.d/mysql.sh 
. /etc/profile.d/mysql.sh
if [ $deploy -eq 1 ];then
	first
else
	many
fi