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

• 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

• Now choose your location settings, for more information please visit Locations
• Choose Geography (continent)

• 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

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

• 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

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

• Give cluster a name

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

• Click create

• Wait for you cluster to be provisioned

• Your cluster is ready for usage

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

• 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)

• Give a name to this workspace
• Click install and wait for the deployment

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

• 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

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

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

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

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

• Please set the MariaDB Galera root password in the parameters

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

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

• Your MariaDB Galera workspace has been successfully deployed

Verify MariaDB Galera installation

• Go to Resources in your browser
• Click on Clusters
• Click on your Cluster

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

• Click install - wait couple of minutes

• 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

$ kubectl get pod -n NAMESPACE -o wide 

$ kubectl get service -n NAMESPACE

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

$ kubectl exec --stdin --tty PODNAME -n NAMESPACE -- /bin/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'"

You have succesfully deployed MariaDB Galera on IBM Cloud!