Step 1: Install MariaDB Xpand

Overview

This page details step 1 of the 6-step procedure "Deploy Xpand Performance Topology".

This step installs MariaDB Xpand 5.3.

MariaDB Xpand requires three or more nodes. Nodes must meet requirements.

Interactive commands are detailed. Alternatively, the described operations can be performed using automation.

Enable ntpd

Xpand requires that system clocks be synchronized and that NTP be configured on all nodes.

This action is performed on each Xpand node.

To enable ntpd:

$ sudo systemctl enable ntpd
$ sudo systemctl start ntpd

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.

  1. Identify swap devices and files:

    $ cat /proc/swaps
    
  2. Disable swap:

    $ swapoff -a
    
  3. Modify /etc/fstab to remove matching entries.

Download MariaDB Xpand

MariaDB Xpand is distributed as a binary tarball.

Download MariaDB Xpand from the page that matches your use case:

  • If you are participating in a 45-day Xpand trial, access the Xpand downloads link on the Xpand Trial page.

  • MariaDB Enterprise customers with an Xpand license for production use can download MariaDB Xpand from the MariaDB Downloads page. Login is required.

Place the downloaded file on each Xpand node.

Install MariaDB Xpand

This action is performed on each Xpand node.

To install Xpand:

  1. Install dependencies:

    $ sudo yum install bzip2 mdadm ntp ntpdate screen wget xz
    
  2. 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
    
  3. Untar the Xpand package:

    $ tar xvf xpand-5.3.21.el7.tar.bz2
    
    $ cd xpand-5.3.21.el7
    
  4. Run the xpdnode_install.py installation wizard:

    $ sudo ./xpdnode_install.py --wizard
    

    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.

  5. 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".

  6. 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:

  1. Edit the .bash_profile file:

    $ sudo vim /home/xpandm/.bash_profile
    
  2. 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.

  3. Set the owner of the .bash_profile file:

    $ sudo chown xpandm:xpandm /home/xpandm/.bash_profile
    
  4. The path change will take effect upon next login as xpandm account.

  5. To add the Xpand binary path for your current session:

    $ export PATH=$PATH:/opt/clustrix/bin
    

Next Step

Navigation in the procedure "Deploy Xpand Performance Topology":

  • This page was step 1 of 6.