/home/mariadb-user/mariadb/columnstore/bin/postConfigure -i /home/mariadb-user/mariadb/columnstore 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] (2) > 2 ===== Setup System Module Type Configuration ===== There are 2 options when configuring the System Module Type: separate and combined 'separate' - User and Performance functionality on separate servers. 'combined' - User and Performance functionality on the same server Select the type of System Module Install [1=separate, 2=combined] (1) > 1 Seperate Server Installation will be performed. NOTE: Local Query Feature allows the ability to query data from a single Performance Module. Check MariaDB ColumnStore Admin Guide for additional information. Enable Local Query feature? [y,n] (n) > n NOTE: The MariaDB ColumnStore Schema Sync feature will replicate all of the schemas and InnoDB tables across the User Module nodes. This feature can be enabled or disabled, for example, if you wish to configure your own replication post installation. MariaDB ColumnStore Schema Sync feature is Enabled, do you want to leave enabled? [y,n] (y) > y NOTE: Amazon AWS CLI Tools are installed and allow MariaDB ColumnStore to create Instances and EBS Volumes Do you want to have ColumnStore use the Amazon AWS CLI Tools [y,n] (y) > y NOTE: MariaDB ColumnStore Replication Feature is enabled Enter System Name (columnstore-1) > mycs ===== Setup Storage Configuration ===== ----- Setup User Module MariaDB ColumnStore Data Storage Mount Configuration ----- There are 2 options when configuring the storage: internal and external 'internal' - This is specified when a local disk is used for the Data storage. 'external' - This is specified when the MariaDB ColumnStore Data directory is externally mounted. Select the type of Data Storage [1=internal, 2=external] (1) > 1 ----- 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) > 2 NOTE: The volume type. This can be gp2 for General Purpose SSD, io1 for Provisioned IOPS SSD, st1 for Throughput Optimized HDD, sc1 for Cold HDD, or standard for Magnetic volumes. Enter EBS Volume Type (gp2, io1, sc1, st1, standard) : (gp2) > Enter EBS Volume storage size in GB: [1,16384] (1) > 100 ===== Setup Memory Configuration ===== NOTE: Setting 'NumBlocksPct' to 70% Setting 'TotalUmMemory' to 50% ===== Setup the Module Configuration ===== Amazon Install: For Module Configuration, you have the option to provide the existing Instance IDs or have the Instances created. You will be prompted during the Module Configuration setup section. ----- User Module Configuration ----- Enter number of User Modules [1,1024] (1) > 1 *** User Module #1 Configuration *** Create Instance for um1 [y,n] (y) > n Enter EC2 Instance ID (unassigned) > i-00034ee914048a7c9 Getting Private IP Address for Instance i-00034ee914048a7c9, please wait... Private IP Address of i-00034ee914048a7c9 is 172.31.31.126 Create an EBS volume for um1 ? [y,n] (y) > n Enter Volume ID assigned to module 'um1' () > vol-014d42fc59b06bb3c Volume vol-014d42fc59b06bb3c is attached ----- Performance Module Configuration ----- Enter number of Performance Modules [1,1024] (1) > 3 *** Parent OAM Module Performance Module #1 Configuration *** EC2 Instance ID for pm1: i-039be8c5e9acb4946 Getting Private IP Address for Instance i-039be8c5e9acb4946, please wait... Private IP Address of i-039be8c5e9acb4946 is 172.31.21.7 Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm1' (1) > 1 *** Setup External EBS Volume for DBRoot #1 *** *** NOTE: You have the option to provide an existing EBS Volume ID or have a Volume created Create a new EBS volume for DBRoot #1 ? [y,n] (y) > 1 Invalid Entry, please enter 'y' for yes or 'n' for no Create a new EBS volume for DBRoot #1 ? [y,n] (y) > y Create AWS Volume for DBRoot #1 Formatting DBRoot #1, please wait... Attaching, please wait... Volume vol-0ace4a76da5154016 is now attached *** Performance Module #2 Configuration *** Create Instance for pm2 [y,n] (y) > n Enter EC2 Instance ID (unassigned) > i-06dbe640f9fb8a81a Getting Private IP Address for Instance i-06dbe640f9fb8a81a, please wait... Private IP Address of i-06dbe640f9fb8a81a is 172.31.16.111 Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm2' () > 2 *** Setup External EBS Volume for DBRoot #2 *** *** NOTE: You have the option to provide an existing EBS Volume ID or have a Volume created Create a new EBS volume for DBRoot #2 ? [y,n] (y) > y Create AWS Volume for DBRoot #2 Formatting DBRoot #2, please wait... Attaching, please wait... Volume vol-04461a9d67fa3acca is now attached *** Performance Module #3 Configuration *** Create Instance for pm3 [y,n] (y) > n Enter EC2 Instance ID (unassigned) > i-0fe4d00c4850a90eb Getting Private IP Address for Instance i-0fe4d00c4850a90eb, please wait... Private IP Address of i-0fe4d00c4850a90eb is 172.31.23.30 Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm3' () > 3 *** Setup External EBS Volume for DBRoot #3 *** *** NOTE: You have the option to provide an existing EBS Volume ID or have a Volume created Create a new EBS volume for DBRoot #3 ? [y,n] (y) > y Create AWS Volume for DBRoot #3 Formatting DBRoot #3, please wait... Attaching, please wait... Volume vol-08b59d91a14b375e9 is now attached ===== System Installation ===== System Configuration is complete. Performing System Installation. Performing a MariaDB ColumnStore System install using a Binary package located in the /home/mariadb-user directory. Next step is to enter the password to access the other Servers. This is either your password or you can default to using a ssh key If using a password, the password needs to be the same on all Servers. Enter password, hit 'enter' to default to using a ssh key, or 'exit' > ----- Performing Install on 'um1 / i-00034ee914048a7c9' ----- Install log file is located here: /tmp/um1_binary_install.log ----- Performing Install on 'pm2 / i-06dbe640f9fb8a81a' ----- Install log file is located here: /tmp/pm2_binary_install.log ----- Performing Install on 'pm3 / i-0fe4d00c4850a90eb' ----- Install log file is located here: /tmp/pm3_binary_install.log MariaDB ColumnStore Package being installed, please wait ... DONE ===== Checking MariaDB ColumnStore System Logging Functionality ===== The MariaDB ColumnStore system logging is setup and working on local server ===== MariaDB ColumnStore System Startup ===== System Configuration is complete. Performing System Installation. ----- Starting MariaDB ColumnStore on local server ----- MariaDB ColumnStore successfully started MariaDB ColumnStore Database Platform Starting, please wait ............ DONE System Catalog Successfully Created Run MariaDB ColumnStore Replication Setup.. DONE MariaDB ColumnStore Install Successfully Completed, System is Active Enter the following command to define MariaDB ColumnStore Alias Commands . /home/mariadb-user/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