This page describes how to upgrade Xpand. If you have any questions, please contact MariaDB Support.
Confirm that the upgrade package you have is compatible with your current version of Xpand, including the OS version.
Passwordless SSH authentication must be configured for the Xpand daemon user (xpand). To verify this, confirm that the clx command returns successfully with no passwords requested:
shell> /opt/clustrix/bin/clx cmd 'date'
All Xpand upgrade packages will upgrade the database and XpandGUI. The upgrader should be run from a single node and will upgrade all nodes in the cluster. Xpand does not support downgrades.
Performing an upgrade will incur a short period of downtime.
Download the upgrade package to a single node
(Optional) if you are using a non-default ssh port, set an environment variable
|shell> export CLX_SSH_PORT= ssh_port_number|
Run the upgrader as the database daemon user (e.g. xpand). If the database has been installed with root users only, then run the upgrader as root.
|shell> sudo su xpand|
shell> ./xpand-xpdnode- version -upgrade.sh install
This will upgrade every node in the cluster. While the upgrade is in progress, there is a brief period during which the database is unavailable.
Because of an issue with the mariadb/mysql client, the command sudo -u xpand <command> does not use the correct user for sql logins and the upgrade will fail with an error. To upgrade successfully you must sudo to the xpand user with sudo su xpand or log in as that user directly.
Once the database portion of the upgrade is complete, the cluster is online. The UI portion of the upgrade will continue but the database is available. To verify that the upgrade has succeeded successfully, examine the value for clustrix_version
sql> select @@clustrix_version;
For more on how version strings are reported, see Xpand Version and MySQL Version Compatibility