Installing MariaDB Galera on IBM Cloud

Step-by-step IBM Cloud deployment of MariaDB Galera Cluster on IBM Kubernetes Service, with provisioning, IBM Block Storage plug-in setup, and Helm-based MariaDB Galera installation.

Get MariaDB Galera on IBM Cloud

You should have an IBM Cloud account; otherwise, you can register here. At the end of the tutorial, you will have a cluster with MariaDB up and running. IBM Cloud uses Bitnami charts to deploy MariaDB Galera with Helm

1. We will provision a new Kubernetes Cluster for you if, you already have one, skip to step 2

2. We will deploy the IBM Cloud Block Storage plug-in; if you already have it, skip to step 3

3. MariaDB Galera deployment

Step 1: Provision Kubernetes Cluster

• Click the Catalog button on the top

• Select Service from the catalog

• Search for Kubernetes Service and click on it

kubernetes-select

• You are now at the Kubernetes deployment page; you need to specify some details about the cluster

• Choose a standard or free plan; the free plan only has one worker node and no subnet. to provision a standard cluster, you will need to upgrade account to Pay-As-You-Go

• To upgrade to a Pay-As-You-Go account, complete the following steps:

• In the console, go to Manage > Account.

• Select Account settings, and click Add credit card.

• Enter your payment information, click Next, and submit your information

• Choose classic or VPC, read the docs, and choose the most suitable type for yourself

infra-select

• Now choose your location settings; for more information, please visit Locations

• Choose Geography (continent)

location-geo

• Choose Single or Multizone. In single zone, your data is only kept in one datacenter; on the other hand, with Multizone it is distributed to multiple zones, thus safer in an unforeseen zone failure

location-avail

• Choose a Worker Zone if using Single zones or Metro if Multizone

location-worker

• If you wish to use Multizone please set up your account with VRF or enable Vlan spanning

• If at your current location selection, there is no available Virtual LAN, a new Vlan will be created for you

• Choose a Worker node setup or use the preselected one, set Worker node amount per zone

worker-pool

• Choose Master Service Endpoint, In VRF-enabled accounts, you can choose private-only to make your master accessible on the private network or via VPN tunnel. Choose public-only to make your master publicly accessible. When you have a VRF-enabled account, your cluster is set up by default to use both private and public endpoints. For more information visit endpoints.

endpoints

• Give cluster a name

name-new

• Give desired tags to your cluster; for more information, visit tags

tasg-new

• Click create

create-new

• Wait for you cluster to be provisioned

cluster-prepare

• Your cluster is ready for usage

cluster-done

Step 2: Deploy IBM Cloud Block Storage Plug-in

The Block Storage plug-in is a persistent, high-performance iSCSI storage that you can add to your apps by using Kubernetes Persistent Volumes (PVs).

• Click the Catalog button on the top

• Select Software from the catalog

• Search for IBM Cloud Block Storage plug-in and click on it

block-search

• On the application page Click in the dot next to the cluster, you wish to use

• Click on Enter or Select Namespace and choose the default Namespace or use a custom one (if you get error please wait 30 minutes for the cluster to finalize)

block-cluster

• Give a name to this workspace

• Click install and wait for the deployment

block-storage-create

Step 3: Deploy MariaDB Galera

We will deploy MariaDB on our cluster

• Click the Catalog button on the top

• Select Software from the catalog

• Search for MariaDB and click on it

search

• On the application page Click in the dot next to the cluster, you wish to use

cluster-select

• Click on Enter or Select Namespace and choose the default Namespace or use a custom one

details-namespace

• Give a unique name to workspace, which you can easily recognize

details-name

• Select which resource group you want to use, it's for access controll and billing purposes. For more information please visit resource groups

details-resource

• Give tags to your MariaDB Galera, for more information visit tags

details-tag

• Click on Parameters with default values, You can set deployment values or use the default ones

parameters

• Please set the MariaDB Galera root password in the parameters

password

• After finishing everything, tick the box next to the agreements and click install

aggreement-create

• The MariaDB Galera workspace will start installing, wait a couple of minutes

in-progress

• Your MariaDB Galera workspace has been successfully deployed

done

Verify MariaDB Galera Installation

• Go to Resources in your browser

• Click on Clusters

• Click on your Cluster

resource-select

• Now you are at your clusters overview, here Click on Actions and Web terminal from the dropdown menu

cluster-main

• Click install - wait couple of minutes

terminal-install

• Click on Actions

• Click Web terminal, and a terminal will open up

• Type in the terminal; please change NAMESPACE to the namespace you choose at the deployment setup:

$ kubectl get ns

get-ns

$ kubectl get pod -n NAMESPACE -o wide

get-pod

$ kubectl get service -n NAMESPACE

get-svc

• Enter your pod with bash; please replace PODNAME with your mariadb pod's name

$ kubectl exec --stdin --tty PODNAME -n NAMESPACE -- /bin/bash

bash

• After you are in your pod , please verify that MariaDB is running on your pod's cluster. Please enter the root password after the prompt

mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_cluster_size'"

welcome

You have successfully deployed MariaDB Galera on IBM Cloud!

_{This page is licensed: CC BY-SA / Gnu FDL}