The Ultimate Guide to High Availability with MariaDB

Upgrading MariaDB on Windows

You are viewing an old version of this article. View the current version here.

Contents

  1. General information on upgrade and version coexistence
  2. Upgrade Wizard
  3. mysql_upgrade_service
  4. Migration to 64 bit MariaDB from 32 bit
  5. Upgrading of the ZIP-based installations.

General information on upgrade and version coexistence

This section assumes MSI installations. MariaDB (and also MySQL) allows different versions of the product to co-exist on the same machine, as long as these versions are differ either in major or minor version numbers. For example, it is possible to have say MariaDB 5.1.51 and 5.2.6 to be installed on the same machine.

However only single instance of 5.2 can exist. If for example 5.2.7 is installed on the machine where 5.2.6 is already there, installer will just replace 5.2.6 executables with 5.2.7 ones.

Now imagine, that both 5.1 andf 5.2 are installed on the same machine and we want to upgrade database instance running on 5.1 to the new version. In this case special tools are requied. Traditionally, mysql_upgrade is used to accomplish such migration. On Windows, the MySQL upgrade is a manual complicated multiple-step process.

Since 5.2.6 MariaDB Windows distribution includes tools that simplify migration between different versions and also allow migration between MySQL and MariaDB.

Note. Automatic upgrades are only possible for DB instances that run as Windows service.

Upgrade Wizard

This is a GUI tool that is typically invoked at the end of MariaDB installation, if upgradable services are found. The UI allows you to select instances you want to upgrade.

UpgradeWizard

mysql_upgrade_service

This is a command line tool that performs upgrade. The tool requires full administrative privileges (required to start and stop services)

Example usage:

  mysql_upgrade_service --service=MySQL

mysql_upgrade_service accepts a single parameter - name of mysql service and performs all steps to convert MariaDB/MySQL instance running as the service to the current version.

Migration to 64 bit MariaDB from 32 bit

Earlier we said that only single instance of "MariaDB <major>.<minor>" version can be installed on the same machine. This was almost correct, because MariaDB MSI installations allow 32 and 64 version to be installed on the same machine, and in this case it is possible to have two instances of say 5.2 installation at the same time, x86 one and x64 one. One can use x64 Upgrade wizard to upgrade an instance running as 32 bit process to run as 64 bit.

Upgrading of the ZIP-based installations.

Both UpgradeWizard and mysql_upgrade_service can also be used to upgrade database instances that were installed with ZIP installation.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.