I am trying to connect my spring-boot api inside a kubernetes pod to an external database (a separate machine but within the local network), however when running, I get SQLNonTransientConnectionException, UknownHostException: mysql-svc, the api cannot connect to the database but whenever I ping the database address from inside the pod using kubectl exec -it, I can ping it successfully, anybody who has experienced the same error as mine?

here is my application.properties connection uri and kubernetes objects:

spring.datasource.url=jdbc:mysql://mysql-svc/test?autoReconnect=true

---

apiVersion: v1

kind: Service

metadata:

name: mysql-svc

spec:

type: ClusterIP

ports:

- port: 3306

targetPort: 3306

---

apiVersion: v1

kind: Endpoints

metadata:

name: mysql-svc

subsets:

- addresses:

- ip: 10.0.123.28

ports:

- port: 3306

name: mysql-svc

解决方案

After hours of digging and reconfiguring, I finally get it to work, thanks to Xenwar from kubernetes group for pointing out the externalIP property, it turns out that i need to point my app to an external ip, in this case the database, here is the service object:

apiVersion: v1

kind: Service

metadata:

name: db-con

spec:

selector:

app: api2

ports:

- name: http

protocol: TCP

port: 3306

targetPort: 3306

externalIPs:

- 10.0.123.28