Please follow this guide to learn how to migrate to SingleStore tools.
This topic describes how to upgrade MemSQL from an earlier version.
To upgrade MemSQL from versions 3.2 and earlier, see Upgrading MemSQL from 3.2 and earlier. This page describes how to upgrade MemSQL from versions 4.0 and later. This page assumes the MemSQL cluster is managed by MemSQL Ops.
Prior to upgrading:
- Taking a backup is recommended as a standard precautionary measure.
- If necessary, add your license key (see Replacing a MemSQL License). This does not apply to Community Edition.
Step 1: Upgrade MemSQL Ops
Execute the following command:
$ memsql-ops agent-upgrade
Step 2: Upgrade MemSQL
There are two approaches to upgrading a MemSQL cluster:
Option 1: Offline upgrade
Note: This upgrade method is referred to as an “offline” upgrade because your existing MemSQL cluster will be shut down and restarted over the course of the upgrade. You do not need to shut down your cluster prior to starting the upgrade.
The simplest upgrade process is an offline cluster upgrade. This will upgrade all nodes at the same time, shutting down the entire cluster for the duration of the upgrade.
Execute the following command to start an offline upgrade:
$ memsql-ops memsql-upgrade [- -version <VERSION>]
This command will shut down the entire cluster for the duration of the upgrade. For more information, see the full documentation for the command MEMSQL-UPGRADE.
Option 2: Online upgrade (High Availability clusters only)
If the cluster is running with High Availability, you also have the option to perform an online, incremental cluster upgrade, which maintains cluster availability throughout the upgrade process. Follow the instructions in Online Upgrade.
