Installing MariaDB Galera on IBM Cloud

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 on 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 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 plan standard or free, the free plan only has one worker node and no subnet, to provision a standard cluster, you will need to upgrade you 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 on datacenter, on the other hand with Multizone it is distributed to multiple zones, thus safer in an unforseen 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 you 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 --> 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 pods cluster. Please enter the root password after the prompt
mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_cluster_size'"

welcome

You have succesfully deployed MariaDB Galera on IBM Cloud!

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.