Connect from Kubernetes

This topic describes connecting to MariaDB from your managed Kubernetes cluster.

Prerequisites

Ensure that the following are available before connecting to the database:

• A datacenter with the following id: xyz-my-datacenter.

• A private LAN with id 3 using the network 10.1.1.0/24.

• A database connected to LAN 3 with the following IP address: 10.1.1.5/24.

• A Kubernetes cluster with the following id: xyz-my-cluster.

• ionosctl

Connect to the database from the cluster

In this example, we use DHCP to assign IP addresses to node pools. Therefore, the database must be in the same subnet as the DHCP server.

To enable connectivity, follow these steps:

1. Connect node pools to the private LAN, which is connected to the database:

ionosctlk8snodepoolcreate--cluster-idxyz-my-cluster--datacenter-idxyz-my-datacenter--lan-ids3--dhcp=true--name=my_nodepool

Note: It may take a while for the node pool to be ready.

1. Create a pod to test the connectivity. Schedule the pod exclusively for the node pools connected to the additional LAN if you have several node pools.

# pod.yamlapiVersion: v1kind: Podmetadata: name: connectivity-test labels: role: connectivity-testspec: containers: - name: connectivity-test image: mysql stdin: true tty: true command: - "/bin/bash"

Alternatively, you can also use the following commands:

1. Create the pod: kubectl apply -f pod.yaml

2. Attach the pod and test connectivity:

kubectl attach -it connectivity-testmysql -u <USERNAME> -p -h <DNS_NAME> --execute \"SHOW DATABASES;\"

Result: The database starts accepting connections.