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.