Step 1: Install MariaDB Xpand
This page is part of MariaDB's Documentation.
The parent of this page is: Deploy Xpand Topology
Topics on this page:
Overview
This page details step 1 of the 6-step procedure "Deploy Xpand Topology".
This step installs MariaDB Xpand 6.1.
MariaDB Xpand requires three or more nodes. Nodes must meet requirements.
Interactive commands are detailed. Alternatively, the described operations can be performed using automation.
Disable firewalld
To reduce the likelihood of conflicts, stop the system firewall during Xpand installation.
These instructions describe stopping and disabling firewalld
. If another firewall is deployed, alternative action will be required.
This action is performed on each Xpand node.
To disable firewalld
:
$ sudo systemctl stop firewalld
$ sudo systemctl disable firewalld
For additional information, see "TCP Ports for MariaDB Xpand".
Configure Disk-based OS logging
We recommend configuring journald
to store its logs on disk, instead of in RAM in the tmpfs.
This action is performed on each Xpand node.
Modify /etc/systemd/journald.conf
on each node, then reboot for it to take effect:
$ cat Storage=persistent /etc/systemd/journald.conf
Disable Swap
Swap should be disabled if it's not already disabled.
This action is performed on each Xpand node.
Identify swap devices and files:
$ cat /proc/swaps
Disable swap:
$ swapoff -a
Modify
/etc/fstab
to remove matching entries.
Download MariaDB Xpand
MariaDB Xpand is distributed as a binary tarball.
The binary tarball is downloadable (with authorized login) from the MariaDB Downloads page.
Place the downloaded file on each Xpand node.
Install MariaDB Xpand
This action is performed on each Xpand node.
To install Xpand:
Install dependencies:
$ sudo yum install bzip2
If using Red Hat Enterprise Linux (RHEL), edit the repository file (not required on CentOS):
$ sudo yum-config-manager --enable rhui-REGION-rhel-server-optional
Untar the Xpand package:
$ tar xvf xpand-6.1.2.el7.tar.bz2
$ cd xpand-6.1.2.el7
Run the
xpdnode_install.py
installation wizard:$ sudo ./xpdnode_install.py
Node checks are performed for certain Xpand requirements. If the requirements are not met, the
xpdnode_install.py
installation wizard exits with an error message or raises a warning.Use the wizard to perform additional configuration as needed. Default memory and storage settings are based on auto-detection of available resources.
For additional information about the supported configuration options, see "Installation Options for MariaDB Xpand".
Accept the Terms of Use to configure and start the Xpand service:
0 - Memory to use for MariaDB Xpand, in MiB: 9886 MiB 1 - CPU cores to use for MariaDB Xpand: All 2 - Database Storage Path: /data/clustrix 3 - Storage space to pre-allocate to MariaDB Xpand: 22 GiB 4 - Database Logs Path: /data/clustrix/log 5 - MySQL Protocol Unix Socket: /var/lib/mysql/mysql.sock 6 - Database Listen Address (Front-End IP): 0.0.0.0 (Listen on all available interfaces) 7 - Database MySQL TCP Port: 3306 8 - Private (Back-End) IP: 192.0.2.1/255.255.255.0 9 - Back End Network TCP/UDP Port: 24378 10 - Health Monitor Network TCP Port: 3581 11 - OS User: xpand (user will be created) 12 - Management User: xpandm (user will be created) 13 - Reduce TCP retry count: Yes 14 - ClxDBI Install Path: /opt/clustrix/clxdbi 15 - ClxDBI Listen Address: 0.0.0.0 (Listen on all available interfaces) 16 - ClxDBI Listen TCP Port: 7888 17 - ClxDBI Log Path: /data/clustrix/log/clxdbi 18 - ClxDBI PID File Path: /opt/clustrix/var/run 19 - ClxGUI Install Path: /opt/clustrix/clxgui 20 - ClxGUI Data Cache Path: /opt/clustrix/var/cache 21 - ClxGUI Listen Address: 0.0.0.0 (Listen on all available interfaces) 22 - ClxGUI Listen TCP Port: 8080 23 - ClxGUI Log Path: /data/clustrix/log/clxgui 24 - ClxGUI PID File Path: /opt/clustrix/var/run 25 - Display MariaDB Xpand Terms of Use Q - Quit H - Help Select item to change or enter 'Yes' to accept Terms of Use and continue: Yes
Set Xpand Binary Path
MariaDB Xpand installs Xpand-related commands to a custom binary path. To enable the Xpand administrator account (xpandm
) to execute commands without fully qualifying the path, add the Xpand binary path to the $PATH
environment variable.
If you are using an alternative shell or alternative system user account, you will need to adjust these instructions.
This action is performed on each Xpand node.
To add the Xpand binary path:
Edit the
.bash_profile
file:$ sudo vim /home/xpandm/.bash_profile
At the very end of the file, add the Xpand binary path to the
$PATH
variable:# Append Xpand Bin to $PATH export PATH=$PATH:/opt/clustrix/bin
After adding this text, save and close the file.
Set the owner of the
.bash_profile
file:$ sudo chown xpandm:xpandm /home/xpandm/.bash_profile
The path change will take effect upon next login as
xpandm
account.To add the Xpand binary path for your current session:
$ export PATH=$PATH:/opt/clustrix/bin