Installing MariaDB on IBM Cloud

Step-by-step instructions for deploying MariaDB on IBM Cloud Kubernetes Service, including provisioning clusters and configuring storage.

Get MariaDB 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 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 deployment

Step 1 provision Kubernetes Cluster

1. Click the Catalog button on the top.

2. Select Service from the catalog.

3. Search for Kubernetes Service and click on it.

kubernetes-select

1. Choose a plan: standard or free.

The free plan includes one worker node and no subnet.

1. To provision a standard cluster, upgrade your account to Pay-As-You-Go.

2. To upgrade to a Pay-As-You-Go account, follow these steps:

   1. In the console, go to Manage > Account.

   2. Select Account settings, and click Add credit card.

   3. Enter your payment information, click Next, and submit your information.

3. Choose between classic or VPC after reviewing the documentation to determine the most suitable option.

infra-select

1. Now choose your location settings, for more information please visit Locations

2. Choose Geography (continent)

location-geo

1. Select either Single-Zone or Multi-Zone storage. Single Zone stores your data in one data center, while Multi-Zone distributes your data across multiple zones, offering greater safety in the event of unexpected zone failures.

location-avail

1. Choose a Worker Zone if using Single zones or Metro if Multizone

location-worker

1. Set up your account with VRF or enable VLAN spanning to use Multizone.

2. If no Virtual LAN is available at your selected location, a new VLAN will be created for you.

3. Choose a Worker node setup or use the preselected one.

4. Set the Worker node per zone.

worker-pool

1. Choose Master Service Endpoint, In VRF-enabled accounts, you can choose Private endpoint only to make your master accessible on the private network or via VPN tunnel. Choose Public endpoint 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

1. Give Cluster name

name-new

1. Give desired Tags to your cluster, for more information visit tags

tasg-new

1. Click Create

create-new

1. Wait for you cluster to be provisioned

cluster-prepare

1. 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).

1. Click the Catalog button on the top

2. Select Software from the catalog

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

block-search

1. On the application page, select the cluster you wish to use

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

1. Give a Name to this workspace

2. Click Install and wait for the deployment

block-storage-create

Step 3 deploy MariaDB

We will deploy MariaDB on our cluster

1. Click the Catalog button on the top

2. Select Software from the catalog

3. Search for MariaDB and click on it

search

1. Please select IBM Kubernetes Service

target-select

1. On the application page, select the cluster you wish to use

cluster-select

1. Click on Enter or select namespace and choose the default Namespace or use a custom one

details-namespace

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

details-name

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

1. Give Tags to your MariaDB, for more information visit tags

details-tags

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

parameters

1. Please set the MariaDB root password in the parameters

root-password

1. After finishing everything, tick the box next to the agreements and click Install

aggreement-create

1. The MariaDB workspace will start installing, wait a couple of minutes

in-progress

1. Your MariaDB workspace has been successfully deployed

done

Verify MariaDB installation

1. Go to Resources in your browser

2. Expand Clusters. Click on your cluster

resource-select

1. On the Overview page, click Actions, then select Web Terminal from the dropdown menu.

cluster-main

1. Click Install and wait for sometime

2. Click on Actions

3. Click Web terminal. A terminal window will open up

4. On the terminal window, 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-pods

$ kubectl get service -n NAMESPACE

get-service

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

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

bash

1. After you are in your pod please enter Mariadb and enter your root password after the prompt

$ mysql -u root -p

welcome

You have successfully deployed MariaDB IBM Cloud!

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