Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1145

One step configuration of Single Server Node

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.1.6
    • installation
    • None

    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.

      Attachments

        Activity

          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$

          hill David Hill (Inactive) added a comment - 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$
          hill David Hill (Inactive) added a comment - https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/514

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

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

          hill David Hill (Inactive) added a comment - to test. install CS package on single server, root or non-root and run .../mariadb/columnstore/bin/quick_installer_single_server.sh

          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

          dleeyh Daniel Lee (Inactive) added a comment - 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

          Reopen per last test result

          dleeyh Daniel Lee (Inactive) added a comment - Reopen per last test result

          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$

          hill David Hill (Inactive) added a comment - 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$
          hill David Hill (Inactive) added a comment - https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/530

          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

          dleeyh Daniel Lee (Inactive) added a comment - 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

          People

            dleeyh Daniel Lee (Inactive)
            dshjoshi Dipti Joshi (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.