Once you have completed file system and OS configuration, you are now ready to install Xpand.

Step 1: Install Xpand on each node

Log into each Xpand node as either the root Linux user, or a non-root Linux user that has sudo privileges.

Download the Xpand installation, then untar and run the installer script: 

shell> tar xvf xpand-current_version.el7.tar.bz2
shell> cd xpand-current_version
shell> sudo ./xpdnode_install.py
By default, the installer will configure the xpand Linux user as the Xpand daemon user, and xpandm as the Xpand management user. Please see Xpand Operating System Users for more information. Once installation is complete, these users cannot be modified. 

The installer will present you with a list of options based on your server specifications. You may use the default values for most.

This page summarizes the list of ports used by Xpand. If using network security such as firewalls or security groups, the following network traffic must be allowed.

Internal Access Between Xpand Nodes

These network ports are required for communication between Xpand nodes. They must each be accessible by other nodes within the cluster.

TCP22SSHAdministration and upgrade
TCP, UDP2048Control PortXpand specialized administrative tool
TCP, UDP2424 Nanny Portnanny - Xpand process manager

Database communication

TCP7888clxdbiDatabase interface for XpandGUI
TCP, UDP24378 - 24410MultiportXpand internode communication

External Access

These network ports are used to access Xpand externally from your applications and for cluster administration.

ProtocolPort                UseReason
TCP22SSHRemote management and cluster access   
TCP3306SQLDatabase access
TCP3581Health CheckHeartbeat monitor for cluster

*For root installation, XpandGUI uses port 80.

Type Yes to accept the terms of use and proceed with installation. Once the installer completes, the Xpand software is running on the server but is not yet part of a cluster.

Repeat these steps on each node using the same configuration options.

Step 2: Set Up Network Security

Xpand requires a number of ports to be accessible by external applications and for internode communication. This step should be performed for all nodes. 

Option A: Allow All Communication Between Nodes 

Xpand recommends placing nodes within a secure environment and allowing access between all nodes on all ports.

Option B: Open Specific Ports

Unable to render {include} The included page could not be found.

Step 3: Form the Xpand Cluster

From a single node only, connect to Xpand using the mysql (MariaDB) client. 

shell> sudo mysql -A

The -A option is specified here to work around an issue with some versions of the mysql client, including the one included with CentOS 7. The workaround is no longer needed if using a client from 10.4.5-MariaDB or higher.

You can confirm you are running Xpand by examining the clustrix_version variable:

sql> SELECT @@clustrix_version;

Next, set a password for the root user, set the license and form a cluster:

Then run the following SQL commands to set the cluster's license:

sql> SET GLOBAL license = 'license key';

You are now ready to cluster your nodes.

shell> ALTER CLUSTER ADD ' node2_ip_address', 'node3_ip_address';

After the ALTER CLUSTER command, there will be a brief period of unavailability while the cluster forms. 

To verify that all nodes are in the cluster, run the following query: 

select * from system.nodeinfo;

All the nodes you added to the cluster should appear in this list.

Now that you have completed installation, proceed to Configure SSH Authentication.

  • No labels