MySQL主从架构小版本升级

从库

一、新版本mysql环境准备

1.解压mysql 5.7.31

tar -zxf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz -C /software/

2. 替换软链接

[root@study04 software]# ll
total 0
drwxr-xr-x 3 mysql mysql 209 Apr 12 14:14 3307
drwxr-xr-x 3 mysql mysql 209 Apr 12 14:22 3308
lrwxrwxrwx 1 mysql mysql  35 Apr 12 11:36 mysql -> mysql-5.7.25-linux-glibc2.12-x86_64
drwxr-xr-x 9 mysql mysql 129 Apr 12 11:30 mysql-5.7.25-linux-glibc2.12-x86_64
drwxr-xr-x 9  7161 31415 129 Jun  2  2020 mysql-5.7.31-linux-glibc2.12-x86_64

[root@study04 software]# unlink mysql

[root@study04 software]# ln -s mysql-5.7.31-linux-glibc2.12-x86_64 mysql

[root@study04 software]# ll
total 0
drwxr-xr-x 3 mysql mysql 209 Apr 12 14:14 3307
drwxr-xr-x 3 mysql mysql 209 Apr 12 14:22 3308
lrwxrwxrwx 1 root  root   35 Apr 12 14:28 mysql -> mysql-5.7.31-linux-glibc2.12-x86_64
drwxr-xr-x 9 mysql mysql 129 Apr 12 11:30 mysql-5.7.25-linux-glibc2.12-x86_64
drwxr-xr-x 9  7161 31415 129 Jun  2  2020 mysql-5.7.31-linux-glibc2.12-x86_64

3.修改目录权限

chown -R mysql.mysql mysql-5.7.31-linux-glibc2.12-x86_64