Installing and Configuring a ColumnStore System using the Google Cloud - Source

Revision: 65427
User: David Hill
Date: 2018-02-15 04:21

<<toc title=''  layout=standalone>>

=== Introduction
MariaDB ColumnStore can be used a Single Node or a Multi-Node system in the Google Cloud environment. You would follow the setup procedure from the Setup document. This document shows how to set Google Cloud Instances.

You will need to have an Google Google account setup to access plus some basic knowledge of accessing and launching Google Cloud Instances.

These are the support configuration options:

1. Single-Node install

2. Multi-Node Install

* Setup with User Module and Performance Module functionality on the same
          Instance(s)

* Setup with User Module and Performance Module functionality on different
          Instance(s)

=== Google Cloud Platform page

1. Create a Project

2. Go to Compute Engine Page

3. Go to Images page and select and Create an image, recommend Centos 7 is you don't have a preference. If planning a multi-node system, create # number of instances you need for your system. A 1um and 2 pm (3 instances) is a typical setup.

a. Machine type - Minimum for testing would be 8 vCPU's, the more cpu and 
        memory you have the better the performance will be.

b. SSD disk, minimum 100gb. But this again is based on the size you would need 
         for your database

=== SSH into Instance(s)

Check the Google Cloud Document on the different ways to access the instances using ssh.

https://cloud.google.com/compute/docs/instances/connecting-to-instance

Here is a link to the initial setup document that you will need to follow:

https://mariadb.com/kb/en/mariadb/preparing-for-columnstore-installation

1. Setup on each instance

a. It is recommended that ssh-keys be setup for multi-node installs, so that would need
        to be done on all nodes. 'ssh' is used during the installation process.

b. Installed MariaDB ColumnStore dependent packages

c. make sure the firewalls are disabled as stated in the Prepare Document.

2. On just one of the instance, which will be used as pm1

a. Installed MariaDB ColumnStore

b. Run postConfigure and configured pm1

NOTE: Can you follow the postConfigure install instructions from the Single-Server Install document and the Multi-server Install Document.

https://mariadb.com/kb/en/mariadb/installing-and-configuring-mariadb-columnstore

https://mariadb.com/kb/en/mariadb/installing-and-configuring-a-multi-server-columnstore-system

NOTE: When configuring the nodes, use the Internal IP addresses.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Installing and Configuring a ColumnStore System using the Google Cloud - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB