[MCOL-723] MariabDB ColumnStore Cluster tester tool Created: 2017-05-20  Updated: 2023-10-26  Resolved: 2017-05-30

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: None
Fix Version/s: 1.0.10

Type: New Feature Priority: Minor
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2017-11

 Description   

create a script that will test the following items on a cluster (set of servers) where ColumnStore is being installed.

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



 Comments   
Comment by David Hill (Inactive) [ 2017-05-20 ]

completed..

./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.
It should also be run on the server that is designated as Performance Module #1.
This is the same server where the MariaDB ColumnStore package would be installed
and where the install script would be executed from, postConfigure.

Additional information on Tool is documented at:

https://mariadb.com/kb/en/mariadb/*****/

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/Hostnames, if not provide, will only check local node
examples: 192.168.1.1,192.168.1.2 or serverum1,serverpm2
--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] Output results to a log file

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

Comment by David Hill (Inactive) [ 2017-05-20 ]

Added into the engine report in the utils directory

mariadb-columnstore-engine/utils/clusterTester

commit fa21239a7efa9e6a260348eef1ecb0937532c248
Author: David Hill <david.hill@mariadb.com>
Date: Sat May 20 17:41:22 2017 -0500

Comment by David Hill (Inactive) [ 2017-05-23 ]

commit 37ead3c076bf1be5c30a2a76f50b521c0911ccb2
Author: David Hill <david.hill@mariadb.com>
Date: Tue May 23 10:47:01 2017 -0500

add ipaddr to the /tmp log files

utils/clusterTester/columnstoreClusterTester.sh | 70 +++++++++++++++++++++++++++++++++++-----------------------------------
1 file changed, 35 insertions, 35 deletions

Comment by Daniel Lee (Inactive) [ 2017-05-30 ]

Build verified: Git source 1.0.10

[root@localhost mariadb-columnstore-server]# git show
commit 478209c9d58e0c34d0a177b39b42ed865ad30ccf
Author: David Hill <david.hill@mariadb.com>
Date: Thu May 18 15:11:05 2017 -0500

[root@localhost mariadb-columnstore-engine]# git show
commit ccbdb07007dfde95c610fcead008b62e30d7411f
Author: david hill <david.hill@mariadb.com>
Date: Fri May 26 10:52:17 2017 -0500

Have been testing with the prior builds and the above is the latest build tested.

Generated at Thu Feb 08 02:23:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.