MySQL 8 Administrator???s Guide

In-place upgrade of MySQL

As the name implies, this is a process where we replace the existing old version package of MySQL with a newer version. Before starting, make sure the old server has stop and after replacing the package, restart the MySQL 8 server on the existing data directory with the mySQL upgrade.

Perform the following steps for in-place upgradation:

1. With an encrypted InnoDB tablespace, rotate the master key with the following command:

        ALTER INSTANCE ROTATE INNODB MASTER KEY;

2. Configure the shutdown parameters with the innodb_fast_shutdown command:

        SET GLOBAL innodb_fast_shutdown = 1; -- fast shutdown        SET GLOBAL innodb_fast_shutdown = 0; -- slow shutdown

3. Shut down the old MySQL version, using the following command:

 mysqladmin ...