The Ultimate Guide to High Availability with MariaDB

Installing and Configuring a ColumnStore System using the Google Cloud

You are viewing an old version of this article. View the current version here.

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

c. Firewalls - Select both HTTP and HTTPS traffic.

4. Setup on each instance

a. for root installs, need to update

<<code>> vi /etc/ssh/sshd_config

RootUserLogin Yes

PasswordAuthentication yes

  1. systemctl restart sshd

set root user password

  1. passwd <<code>>

b. Installed MariaDB ColumnStore dependent packages

5. 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

Comments

Comments loading...
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.