Wednesday, February 5, 2020

MySQL Upgrade (5.7.23 to 8.0.19)


1. Check for the Upgrade

[paul.f@sys-7 ~]# mysqlsh -A
MySQL JS > util.checkForServerUpgrade("root@localhost:3306");
MySQL JS > \quit

2. Download needed version of MySQL

[paul.f@sys-7 ~]# wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

3. Stop MySQL Service

[paul.f@sys-7 ~]# systemctl stop mysqld

4. Remove Current Version of MySQL (mysql-5.7.23)

[paul.f@sys-7 ~]# rpm -qa | grep -i mysql

[paul.f@sys-7 ~]# rpm -e mysql-community-server-5.7.23-1.el7.x86_64 mysql-community-client-5.7.23-1.el7.x86_64 mysql-community-embedded-devel-5.7.23-1.el7.x86_64 mysql-community-common-5.7.23-1.el7.x86_64 mysql-community-embedded-compat-5.7.23-1.el7.x86_64 mysql-community-devel-5.7.23-1.el7.x86_64 mysql-community-libs-5.7.23-1.el7.x86_64 mysql-community-embedded-5.7.23-1.el7.x86_64 mysql-community-libs-compat-5.7.23-1.el7.x86_64 --nodeps

5. Extract the MySQL-8 TAR File

[paul.f@sys-7 ~]# tar -xvf mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

6. Install Dependencies (if any)

[paul.f@sys-7 ~]# yum install 'perl(JSON)'

7. Install New Version of MySQL (mysql-8.0.19)

[paul.f@sys-7 ~]# rpm -ivh mysql-community-client-8.0.19-1.el7.x86_64.rpm mysql-community-server-8.0.19-1.el7.x86_64.rpm mysql-community-common-8.0.19-1.el7.x86_64.rpm mysql-community-embedded-compat-8.0.19-1.el7.x86_64.rpm mysql-community-devel-8.0.19-1.el7.x86_64.rpm mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm mysql-community-libs-8.0.19-1.el7.x86_64.rpm mysql-community-test-8.0.19-1.el7.x86_64.rpm

8. Start the MySQL Service

[paul.f@sys-7 ~]# systemctl start mysqld

9. Check the Start & Upgrade Process in the Error Log

[paul.f@sys-7 ~]# cat /etc/my.cnf | grep err


[paul.f@sys-7 ~]# tail -10f /var/log/mysqld.log