shell脚本多实例部署MySQL

《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！
chown -R mysql.mysql $data

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

if [ $look -eq 0 ];then

$route/mysql/bin/mysqld--initialize-insecure--usermysql--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"setpassword=password{(}^{\prime }$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--usermysql--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

最后

针对最近很多人都在面试，我这边也整理了相当多的面试专题资料，也有其他大厂的面经。希望可以帮助到大家。

最新整理面试题

上述的面试题答案都整理成文档笔记。也还整理了一些面试资料&最新2021收集的一些大厂的面试真题

最新整理电子书

最新整理大厂面试文档

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。
《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！
Y-1714653527163)]

最新整理大厂面试文档

[外链图片转存中…(img-n0g0TLv0-1714653527163)]

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。
《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！