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/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
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/mysql−uroot−e"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/mysqld−−initialize−insecure−−usermysql−−datadir=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/mysql−uroot−Pport -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)]