Steps to upgrade a MySQL installation

Below are the steps mentioned to upgrade a MySQL installation −

• Upgrade the paths

• Prepare the installation for an upgrade

• Upgrade the MySQL binary or package-based installation on Unix or Linux

• MySQL can also be upgraded using MySQL yum repository or APT repository or SLES repository or on Windows.

• The next step is to upgrade the docker installation of MySQL

• Upgrade the troubleshooting

• The tables or indexes have to be rebuilt or repaired.

• The MySQL databases have to be copied to the other machine.

MySQL binary and package-based installations can be done on Unix or linux in many different ways. They have been mentioned below.

• In−place upgrade

• Logical upgrade

• MySQL cluster upgrade

Let us understand each of the above mentioned methods in brief −

In-place Upgrade

• An in-place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or the packages with the new ones.

• Once this is done, the MySQL server is restarted on the existing data directory.

• After this, the remaining parts of the existing installation, that require some kind of upgrade, are upgraded.

Logical Upgrade

• A logical upgrade involves exporting the SQL from old MySQL instance.

• This is done with the help of a backup or export utility such as ‘mysqldump’ or ‘mysqlpump’.

• The new MySQL server is installed by applying the SQL to the new MySQL instance.

MySQL Cluster Upgrade

• The MGM nodes are upgraded.

• The data nodes are upgraded one at a time.

• The API nodes are upgraded one at a time, and this includes the MySQL servers.

• The data dictionary is upgraded.

• The system tables are upgraded.

• The system is restarted.