[MCOL-1145] One step configuration of Single Server Node Created: 2018-01-07  Updated: 2018-08-07  Resolved: 2018-08-07

Status: Closed
Project: MariaDB ColumnStore
Component/s: installation
Affects Version/s: None
Fix Version/s: 1.1.6

Type: Task Priority: Major
Reporter: Dipti Joshi (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 1
Labels: None

Epic Link: ColumnStore Installation Improvements
Sprint: 2018-13, 2018-14, 2018-15, 2018-16

 Description   

At present single node and multi-node install requires postConfig to be run after binary has been installed. postConfig is interactive configuration utility.

Please provide a utility for Single node install - that simply takes no parameter and then applies all the default parameters for postConfig automatically without user interaction in the background.



 Comments   
Comment by David Hill (Inactive) [ 2018-07-05 ]

Implementation options:

1. Adding an options to postConfigure for a user to provide the 'quick-install' for single-server and 'system name'. Example is shown here:

/home/david_hill/mariadb/columnstore/bin/postConfigure -i /home/david_hill/mariadb/columnstore -qs -sn david

2. Adding a new script that a user can enter where it will run both the post-install and postConfigure scripts. This works for both root and non-root installs.
Here is an example run of that for a non-root install

./quick_installer_single_server.sh
Run post-install script

The next steps are:

If installing on a pm1 node:

export COLUMNSTORE_INSTALL_DIR=/home/david_hill/mariadb/columnstore
export LD_LIBRARY_PATH=:/home/david_hill/mariadb/columnstore/lib:/home/david_hill/mariadb/columnstore/mysql/lib
/home/david_hill/mariadb/columnstore/bin/postConfigure -i /home/david_hill/mariadb/columnstore

If installing on a non-pm1 using the non-distributed option:

export COLUMNSTORE_INSTALL_DIR=/home/david_hill/mariadb/columnstore
export LD_LIBRARY_PATH=:/home/david_hill/mariadb/columnstore/lib:/home/david_hill/mariadb/columnstore/mysql/lib
columnstore/bin/columnstore start

Run postConfigure script

This is the MariaDB ColumnStore System Configuration and Installation tool.
It will Configure the MariaDB ColumnStore System and will perform a Package
Installation of all of the Servers within the System that is being configured.

IMPORTANT: This tool requires to run on the Performance Module #1

===== Quick Single-Server Install Configuration =====

Single-Server install is used when there will only be 1 server configured
on the system. It can also be used for production systems, if the plan is
to stay single-server.

===== Performing Configuration Setup and MariaDB ColumnStore Startup =====

NOTE: Setting 'NumBlocksPct' to 50%
Setting 'TotalUmMemory' to 25% of total memory.

Running the MariaDB ColumnStore setup scripts

post-mysqld-install Successfully Completed
post-mysql-install Successfully Completed

Starting MariaDB Columnstore Database Platform

MariaDB ColumnStore Database Platform Starting, please wait ...... DONE

MariaDB ColumnStore Install Successfully Completed, System is Active

Enter the following command to define MariaDB ColumnStore Alias Commands

. /home/david_hill/mariadb/columnstore/bin/columnstoreAlias

Enter 'mcsmysql' to access the MariaDB ColumnStore SQL console
Enter 'mcsadmin' to access the MariaDB ColumnStore Admin console

NOTE: The MariaDB ColumnStore Alias Commands are in /etc/profile.d/columnstoreAlias.sh

david_hill@ubuntu-18-ss:~/mariadb/columnstore/bin$

Comment by David Hill (Inactive) [ 2018-07-06 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/514

Comment by David Hill (Inactive) [ 2018-07-09 ]

to test. install CS package on single server, root or non-root and run

.../mariadb/columnstore/bin/quick_installer_single_server.sh

Comment by Daniel Lee (Inactive) [ 2018-07-16 ]

Build tested: GitHub source

/root/columnstore/mariadb-columnstore-server
commit 1741c7e7d522d1245ec9c1e4c7c7474574f09bd2
Merge: 2adc4b5 6abef48
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Tue Jun 19 09:51:48 2018 -0500

Merge pull request #113 from mariadb-corporation/davidhilldallas-patch-3

update readme

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 32bd7d4e270f46a6052df64cff871f2c3371bb3a
Merge: af6108d 400ae51
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Thu Jul 12 15:36:42 2018 -0500

Merge pull request #518 from mariadb-corporation/MCOL-1146

Mcol 1146 - multi node quick install

root installation using rpm. succeeded
non-root installation using bin, library error reported. It seems to be a path issue
Using the same VM, manual installation by running postConfigure was successful.

[guest@localhost bin]$ ./quick_installer_single_server.sh
Run post-install script

The next steps are:

If installing on a pm1 node:

export COLUMNSTORE_INSTALL_DIR=/home/guest/mariadb/columnstore
export LD_LIBRARY_PATH=:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib
/home/guest/mariadb/columnstore/bin/postConfigure -i /home/guest/mariadb/columnstore

If installing on a non-pm1 using the non-distributed option:

export COLUMNSTORE_INSTALL_DIR=/home/guest/mariadb/columnstore
export LD_LIBRARY_PATH=:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib
/home/guest/mariadb/columnstore/bin/columnstore start

Run postConfigure script

/home/guest/mariadb/columnstore/bin/postConfigure: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory

Comment by Daniel Lee (Inactive) [ 2018-07-26 ]

Reopen per last test result

Comment by David Hill (Inactive) [ 2018-08-01 ]

I reproduced Daniels failed test case, investigating

guest@ip-172-31-37-130:~/mariadb/columnstore/bin$ ./quick_installer_single_server.sh
Run post-install script

The next steps are:

If installing on a pm1 node:

export COLUMNSTORE_INSTALL_DIR=/home/guest/mariadb/columnstore
export LD_LIBRARY_PATH=:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib
/home/guest/mariadb/columnstore/bin/postConfigure -i /home/guest/mariadb/columnstore

If installing on a non-pm1 using the non-distributed option:

export COLUMNSTORE_INSTALL_DIR=/home/guest/mariadb/columnstore
export LD_LIBRARY_PATH=:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib:/home/guest/mariadb/columnstore/lib:/home/guest/mariadb/columnstore/mysql/lib
/home/guest/mariadb/columnstore/bin/columnstore start

Run postConfigure script

/home/guest/mariadb/columnstore/bin/postConfigure: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory
guest@ip-172-31-37-130:~/mariadb/columnstore/bin$

Comment by David Hill (Inactive) [ 2018-08-01 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/530

Comment by Daniel Lee (Inactive) [ 2018-08-07 ]

Build verified: 1.1.6-1 source

/root/columnstore/mariadb-columnstore-server
commit 513775738f72ec990d055a5d47e2511e3c0e34dd
Merge: 3c37210 9236098
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Jul 18 09:37:17 2018 +0100

Merge pull request #123 from drrtuy/MCOL-970

MCOL-970 Slow query log now contains original query even in vtable mode

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit ee40c3ac050ad7b64302673fc4ab08640f64892f
Merge: 0df1b92 979d00a
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Mon Aug 6 13:02:08 2018 -0500

Merge pull request #523 from mariadb-corporation/MCOL-1579

MCOL-1579 Remove chmod of /dev/shm

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