Minikube Exposing mysql as a service on localhost

Question

I am running minikube 0.17.1 on my local machine to simulate the environment for my setup in AWS. I want to run mysql outside of my kubernetes cluster.

I just want to now how I can expose my local mysql instance to the kubernetes cluster using minikube?

Answer 1

You can create services without selector in kubernetes and the cluster will not create a related endpoint for the created service. This is used in the situation like yours, where you want to access an outside component.

1. Firstly, create a service without selector

   apiVersion: v1
   kind: Service
   metadata:
       name: my-service
   spec:
       ports:
           - protocol: TCP
             port: 1443
             targetPort: <YOUR_MYSQL_PORT>
   

2. Now, create a relative Endpoint object

   apiVersion: v1
   kind: Endpoints
   metadata:
       name: my-service
   subsets:
       - addresses:
           - ip: <YOUR_MYSQL_ADDR>
         ports:
           - port: <YOUR_MYSQL_PORT>
   

3. Get service IP

   $ kubectl get svc my-service
   NAME         CLUSTER-IP     EXTERNAL-IP   PORT(S)   AGE
   my-service   <SERVICE_IP>   <none>        1443/TCP    18m
   

4. Access your MYSQL from service <SERVICE_IP>:1443 or my-service:1443

Comments

What is <YOUR_MYSQL_PORT> when the service is running on my localhost?

---

here the <YOUR_MYSQL_PORT> would be the port on which the service is hosted, could be port 80 or 8080.