Installing MariaDB on IBM Cloud

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.

1. Choose a plan: standard or free.

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.

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

2. Choose Geography (continent)

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.

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

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.

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.

1. Give Cluster name

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

1. Click Create

1. Wait for you cluster to be provisioned

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

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

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)

1. Give a Name to this workspace

2. Click Install and wait for the deployment

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

1. Please select IBM Kubernetes Service

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

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

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

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

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

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

1. Please set the MariaDB root password in the parameters

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

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

1. Your MariaDB workspace has been successfully deployed

Verify MariaDB installation

1. Go to Resources in your browser

2. Expand Clusters. Click on your cluster

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

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

$ kubectl get pod -n NAMESPACE -o wide

$ kubectl get service -n NAMESPACE

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

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

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

$ mysql -u root -p

You have successfully deployed MariaDB IBM Cloud!

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