MCS AWS AMI, Centos7

1. yes, configuration values can be passed into postConfigure using the following example.
This is would be for a Single Server Install. So you could tweak the config file to match whatever system you wanted to configure.. just provide an value for each prompt.

1. cat ss-config.txt
   1
   mcs-1
   1
   1

1. cat ss-config.txt | /usr/local/mariadb/columnstore/bin/postConfigure

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 should only be run on the Parent OAM Module
which is a Performance Module, preferred Module #1

Prompting instructions:

Press 'enter' to accept a value in (), if available or
Enter one of the options within [], if available, or
Enter a new value

===== Setup System Server Type Configuration =====

There are 2 options when configuring the System Server Type: single and multi

'single' - 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.

'multi' - Multi-Server install is used when you want to configure multiple servers now or
in the future. With Multi-Server install, you can still configure just 1 server
now and add on addition servers/modules in the future.

Select the type of System Server install [1=single, 2=multi] (1) > 1

Performing the Single Server Install.
Enter System Name (columnstore-1) > mcs-1

===== Setup Storage Configuration =====

----- Setup Performance Module DBRoot Data Storage Mount Configuration -----

There are 2 options when configuring the storage: internal or external

'internal' - This is specified when a local disk is used for the DBRoot storage.
High Availability Server Failover is not Supported in this mode

'external' - This is specified when the DBRoot directories are mounted.
High Availability Server Failover is Supported in this mode.

Select the type of Data Storage [1=internal, 2=external] (1) > 1

Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm1' (1) > 1

===== 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

. /usr/local/mariadb/columnstore/bin/columnstoreAlias

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

[root@ip-172-30-0-119 ~]#

2. There is no Cloud Formation template for ColumnStore at this time. MicroSoft Azure is a cloud system is being considered for ColumnStore in the future and we current release AMI's on Amazon.

Thanks David.

the solution works fine till it reaches the below step. Since I'm using ssh keys i have to manally hit enter.
Enter password, hit 'enter' to default to using a ssh key, or 'exit' >

do this to get around that ssh key issue, you can pass in the password or ssh as a command line argument

cat ss-config.txt | /usr/local/mariadb/columnstore/bin/postConfigure -p ssh

Thanks I will give it a try.