shell脚本多实例部署MySQL

look=$(ls $data | wc -l)

if [ $look -eq 0 ];then

r o u t e / m y s q l / b i n / m y s q l d − − i n i t i a l i z e − i n s e c u r e − − u s e r m y s q l − − d a t a d i r = route/mysql/bin/mysqld --initialize-insecure --user mysql --datadir= route/mysql/bin/mysqldinitializeinsecureusermysqldatadir=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

r o u t e / m y s q l / b i n / m y s q l − u r o o t − e " s e t p a s s w o r d = p a s s w o r d ( ′ route/mysql/bin/mysql -uroot -e "set password=password(' route/mysql/bin/mysqluroote"setpassword=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 d a t a / data/ data/port ];then

mkdir -p d a t a / data/ data/port

fi

chown -R mysql.mysql $data/port

look=$(ls d a t a / data/ data/port | wc -l)

if [ $look -eq 0 ];then

r o u t e / m y s q l / b i n / m y s q l d − − i n i t i a l i z e − i n s e c u r e − − u s e r m y s q l − − d a t a d i r = route/mysql/bin/mysqld --initialize-insecure --user mysql --datadir= route/mysql/bin/mysqldinitializeinsecureusermysqldatadir=data/$port

fi

cat >> /etc/my.cnf <<EOF

[mysqld$port]

datadir = d a t a / data/ data/port

po
作者私人号:vip1024c
rt = $port

socket = /tmp/mysql$port.sock

pid-file = d a t a / data/ data/port/mysql.pid

log-error=/var/log/$port.log

EOF

$route/mysql/bin/mysqld_multi start $port

sleep 3

r o u t e / m y s q l / b i n / m y s q l − u r o o t − P route/mysql/bin/mysql -uroot -P route/mysql/bin/mysqlurootPport -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

技术学习总结

学习技术一定要制定一个明确的学习路线,这样才能高效的学习,不必要做无效功,既浪费时间又得不到什么效率,大家不妨按照我这份路线来学习。

最后面试分享

大家不妨直接在牛客和力扣上多刷题,同时,我也拿了一些面试题跟大家分享,也是从一些大佬那里获得的,大家不妨多刷刷题,为金九银十冲一波!

98212)]

[外链图片转存中…(img-SffUm4rY-1721063298212)]

最后面试分享

大家不妨直接在牛客和力扣上多刷题,同时,我也拿了一些面试题跟大家分享,也是从一些大佬那里获得的,大家不妨多刷刷题,为金九银十冲一波!

[外链图片转存中…(img-6iY0ne5M-1721063298212)]

[外链图片转存中…(img-GzenkqUJ-1721063298213)]

  • 9
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值