- https://downloads.mysql.com/archives/
[root@db01 app]# yum install -y mysql-shell-8.0.24-1.el7.x86_64.rpm
或者:
[root@db01 opt]# tar xf mysql-shell-8.0.24-linux-glibc2.12-x86-64bit.tar.gz
[root@db01 opt]# ln -s /opt/mysql-shell-8.0.24-linux-glibc2.12-x86-64bit
/usr/local/mysqlsh
[root@db01 bin]# vim /etc/profile
export PATH=/usr/local/mysqlsh/bin:$PATH
[root@db01 bin]# source /etc/profile
b. 创建连接用户
[root@db01 data]# mysql -S /tmp/mysql3357.sock
mysql> grant all on . to root@’10.0.0.%’ identified by ‘123’;
c. 预 检查
[root@db01 data]# mysqlsh root:123@10.0.0.51:3357 -e
“util.checkForServerUpgrade()” >/tmp/up.log
[root@localhost bin]# ./mysqlsh -S /tmp/mysql57.sock -e
“util.checkForServerUpgrade()”
d. 停原库(5.7.32)
[root@db01 data]# mysql -S /tmp/mysql3357.sock
oldguo-db01 [(none)]>set global innodb_fast_shutdown=0;
[root@db01 data]# /usr/local/mysql57/bin/mysqladmin -S /tmp/mysql3357.sock
shutdown
e. 使用高版本软件挂低版本数据启动
[root@db01 data]# /usr/local/mysql/bin/mysqld_safe —defaults-
file=/data/3357/my.cnf —skip-grant-tables —skip-networking &
[root@db01 data]# /usr/local/mysql/bin/mysqld_safe —defaults-
file=/data/3357/my.cnf &">新特性:
1、 mysql-shell工具,8.0以后,可以调用这个命令,升级之前的预检查。
例子:
[root@db01 ~]# mysqlsh root:123@10.0.0.51:3306 -e “util.checkForServerUpgrade()”
2、升级时不再需要手工 mysql_upgrade
3、限制:升级前必须要备份。否则无法回退
a. 下载 8.0.24 版本的 mysql-shell,并安装 。
https://downloads.mysql.com/archives/
[root@db01 app]# yum install -y mysql-shell-8.0.24-1.el7.x86_64.rpm
或者:
[root@db01 opt]# tar xf mysql-shell-8.0.24-linux-glibc2.12-x86-64bit.tar.gz
[root@db01 opt]# ln -s /opt/mysql-shell-8.0.24-linux-glibc2.12-x86-64bit
/usr/local/mysqlsh
[root@db01 bin]# vim /etc/profile
export PATH=/usr/local/mysqlsh/bin:$PATH
[root@db01 bin]# source /etc/profile
b. 创建连接用户
[root@db01 data]# mysql -S /tmp/mysql3357.sock
mysql> grant all on . to root@’10.0.0.%’ identified by ‘123’;
c. 预 检查
[root@db01 data]# mysqlsh root:123@10.0.0.51:3357 -e
“util.checkForServerUpgrade()” >/tmp/up.log
[root@localhost bin]# ./mysqlsh -S /tmp/mysql57.sock -e
“util.checkForServerUpgrade()”
d. 停原库(5.7.32)
[root@db01 data]# mysql -S /tmp/mysql3357.sock
oldguo-db01 [(none)]>set global innodb_fast_shutdown=0;
[root@db01 data]# /usr/local/mysql57/bin/mysqladmin -S /tmp/mysql3357.sock
shutdown
e. 使用高版本软件挂低版本数据启动
[root@db01 data]# /usr/local/mysql/bin/mysqld_safe —defaults-
file=/data/3357/my.cnf —skip-grant-tables —skip-networking &
[root@db01 data]# /usr/local/mysql/bin/mysqld_safe —defaults-
file=/data/3357/my.cnf &
