Introduction
MariaDB is a popular open-source relational database management system (RDBMS) that is a fork of the MySQL database system. It was created by the original developers of MySQL when concerns arose over its acquisition by Oracle Corporation, which caused many users to migrate to MariaDB.
Kubernetes is a free and open source container management tool, we can deploy and manage containerized applications across a cluster of nodes. It provides features such as automated rollouts and rollbacks, self-healing, load balancing, and scaling, all of which make it easier to manage and scale containerized applications.
In this post, We will show you how to deploy MariaDB database on Kubernetes cluster.
Step 1: Deploy Configmap
We need to create a configmap that container mariadb’s variable like password, Use the following command.
nano mariadb-configmap.yaml
Paste the following configmap.
apiVersion: v1
kind: ConfigMap
metadata:
name: mariadb-config
labels:
app: mariadb
data:
MARIADB_ROOT_PASSWORD: password
We need to replace the MARIADB_ROOT_PASSWORD
value in real env and save and exit from the nano editor.
kubectl create -f mariadb-configmap.yaml
To validate the configmap.
kubectl get configmap
Step 2: Deploy Storage
To create a storage configuration yaml file.
nano mariadb-storage.yaml
Paste the following storage configuration.
kind: PersistentVolume
apiVersion: v1
metadata:
name: mariadb-pv-volume
labels:
type: local
app: mariadb
spec:
storageClassName: manual
capacity:
storage: 10Gi
accessModes:
- ReadWriteMany
hostPath:
path: "/mnt/mariadb_data"
---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
name: mariadb-pv-claim
labels:
app: mariadb
spec:
storageClassName: manual
accessModes:
- ReadWriteMany
resources:
requests:
storage: 10Gi
We need to replace the k8s node mounting path and storage capicity and save the edit from nano editor.
To deploy the mariadb storage.
kubectl create -f mariadb-storage.yaml
To validate the volume storage.
kubectl get pvc
Step 3: Deploy MariaDB
To create maroadb-deployment yaml file.
nano mariadb-deployment.yaml
Paste the following deployment config like replica and docker container repo and ports.
apiVersion: apps/v1
kind: Deployment
metadata:
name: mariadb
spec:
replicas: 1
selector:
matchLabels:
app: mariadb
template:
metadata:
labels:
app: mariadb
spec:
containers:
- name: mariadb
image: mariadb:latest
imagePullPolicy: "IfNotPresent"
ports:
- containerPort: 3606
envFrom:
- configMapRef:
name: mariadb-config
volumeMounts:
- mountPath: /var/lib/mysql
name: mariadb
volumes:
- name: mariadb
persistentVolumeClaim:
claimName: mariadb-pv-claim
To create mariab deployment.
kubectl create -f mariadb-deployment.yaml
To validate the deployment.
kubectl get deployment
To validate the pods.
kubectl get pods
Step 4: Deploy MariaDB Service
To make mariadb accessable from the network we need to create mariadb serice yaml file.
nano mariadb-service.yaml
Paste the following configuration.
apiVersion: v1
kind: Service
metadata:
name: mariadb
labels:
app: mariadb
spec:
type: NodePort
ports:
- port: 3306
selector:
app: mariadb
We need to replace the port number and network type as per your needs and save edit from nano editor.
To deploy service of mariadb.
kubectl create -f mariadb-service.yaml
To validate the service.
kubectl get svc
Step 5: Accessing MariaDB Shell
We need to get the mariadb pods and then we need to execute the given command to take MariaBD shell login.
kubectl exec -it [pod-name] -- mysql
![](https://www.geohosting.in/wp-content/uploads/2023/05/image-1024x389.png)
Conclusion
We have successfully deployed the mariaDB database on the K8S cluster. If you are still facing problems, feel free to leave a commit.