MariaDB ColumnStore Cluster Test Tool

You are viewing an old version of this article. View the current version here.

MariaDB ColumnStore Cluster Test Tool should be run after the "Preparing For ColumnStore Installation" steps are performed on the server(s)/node(s) that are being used for the MariaDB ColumnStore Product and before MariaDB ColumnStore Product is installed. It will validate that the server(s)/node(s) are setup and configured correctly to allow a clean install of the MariaDB ColumnStore Product.

Here is a link to the "Preparing For ColumnStore Installation" document:

https://mariadb.com/kb/en/mariadb/preparing-for-columnstore-installation

Here are the items that are tested/check during the running of this tool:

  • Node Ping test - ping test to remote nodes
  • Node SSH test -- SSH login test to remote nodes
  • ColumnStore Port (8600-8620) test - use 'nmap' to check connectivity on ColumnStore ports to remote Nodes
  • OS version - Detect, Validate, and Compare OS version to make sure they match on remote nodes with local node
  • Locale settings - Compare Locale setting to make sure they match on remote nodes with local node
  • Firewall settings - Verify that certain firewalls are disabled on all nodes.
  • Date/Time settings - Compare Date/Time settings to make sure they match on remote nodes with local node
  • Dependent packages installed - Checks that all dependency packages are installed on all nodes
  • For non-root user install - test permissions on /tmp and /dev/shm

This tool can be used on single-server installs also, not just clusters with multiple nodes On single-server installs, the following items will be tested:

  • Dependent packages installed
  • For non-root user install - test permissions on /tmp and /dev/shm

Tool Installation

To perform testing on a multi-node system, these 2 packages are required to be installed before the tool is run.

  • expect
  • mnap

MariaDB ColumnStore Cluster Test Tool is a tar package that consist of mutliple files. It can be download from here:

* NEED DOWNLOAD INFO ADDED *

The package needs be installed on the server/node that will be designated as the Performance Module #1 (pm1). This is the same server/node where the MariaDB ColumnStore installation script would be run, postConfigure. It should be installed in the home directory where the MariaDB ColumnStore Product will be installed. If MariaDB ColumnStore Product is going to be installed as root user, then place the place the package in /root to unpackaged and tested. If MariaDB ColumnStore Product is going to be installed as non-root user, please the package in /home/'user' to be unpackaged and tested.

The package name is ClusterTesterTool.tar.gz. To unpackage it, run the following:

tar zxvf ClusterTesterTool.tar.gz

Tool Usage

After downloading and unpackaging, here is how to execute the tool:

cd ClusterTesterTool
./columnstoreClusterTester.sh 'options'

Addition information from the tool can be obtained by running 'help'

# cd ClusterTesterTool
# ./columnstoreClusterTester.sh -h

This is the MariaDB ColumnStore Cluster System Test tool.

It will run a set of test to validate the setup of the MariaDB Columnstore system.
This can be run prior to the install of MariaDB ColumnStore to make sure the
servers/nodes are configured properly. It should be run as the user of the planned
install. Meaning if MariaDB ColumnStore is going to be installed as root user,
then run from root user. Also the assumption is that the servers/node have be
setup based on the Preparing for ColumnStore Installation

Items that are checked:
	Node Ping test
	Node SSH test
	ColumnStore Port test
	OS version
	Locale settings
	Firewall settings
        Date/Time Settings
	Dependent packages installed
        For non-root user install - test permissions on /tmp and /dev/shm

Usage: ./columnstoreClusterTester.sh [options]
OPTIONS:
   -h,--help			Help
   --ipaddr=[ipaddresses]	Remote Node IP Addresses, if not provide, will only check local node
   --os=[os]			Optional: Set OS Version (centos6, centos7, debian8, suse12, ubuntu16).
   --password=[password]	Provide a user password. (Default: ssh-keys setup will be assumed)
   -c,--continue		         Continue on failures
   --logfile=[filename]        Optional: Output results to a log file

NOTE: Dependent package : 'nmap' and 'expect' packages need to be installed locally

Options:

'ipaddr' - This is the list of IP Addresses or hostname of the other server/nodes that make up the MariaDB ColumnStore Cluster. If this is not provide, just the Single-Server Local node tests will be performed. You don't need to provide the IP address/hostname of the local node. You can enter multiple using one of these formats: --ipaddr=192.168.1.1,192.196.1.2 --ipaddr=serverum1,serverpm2

'os' - This os optional. Tool will determine the Local OS version and validate it againest the supported OS.

This is the list of support versions:

  • centos6
  • centos7
  • debian8
  • suse12
  • ubuntu16

'password' - The tool will log into the other server/nodes that make up the MariaDB ColumnStore Cluster to perform test. So the user password or ssh-key setup is required.

NOTE: If no 'password' is provided, the tool will assume ssh-keys are setup between the local node and the other server/nodes that make up the MariaDB ColumnStore Cluster.

'continue' - This option allows the user to run the tool to completion while reporting test/check failures. When this option is not used, then a prompt will be issued allowing the user to stop and fix the issue or continue.

Here is an example where an error is detected. When the 'continue' option is not specified, a prompt is given to the user to exit or continue the test once an error has been detected.

./columnstoreClusterTester.sh --ipaddr=x.x.x.x

*** This is the MariaDB Columnstore Cluster System test tool ***

** Run Ping access Test to remote nodes

x.x.x.x  Node Passed ping test

** Run SSH Login access Test to remote nodes

x.x.x.x  Node Passed SSH login test

** Run OS check - OS version needs to be the same on all nodes

Local Node OS Version : Linux Debian stretch/sid
x.x.x.x Node OS Version : Linux RedHat 6.9
Failed, x.x.x.x has a different OS than local node

Failure occurred, do you want to continue? (y,n) > n

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.