MYSQL Pod connection

[Montassar Dridi]

Usually I create one mysql pod and connect it to my java application pod buy getting the sql pod ip address and replace my db_uri as follow jdbc:mysql://MYSQL-POD-IP:3306/ THEN THE CONNECTION WILL BE RUNNING FINE WITH NO ISSUE. but then I tried to create MYSQL pod using Deployments and replica sets following the link bellow and then when I tried to replace the db_uri as follow jdbc:mysql://SERVICE-CLUSTER-IP:3306/ NO CONNECTION WAS ACCOMPLISHED.

https://github.com/kubernetes/kubernetes/tree/master/examples/mysql-wordpress-pd#gce-persistent-disk

How am I suppose to connect to the sql pod through the deployment service.

[sebgoa]

Hi,

Usually, the kubernetes-users list is better for this:

https://groups.google.com/forum/#!forum/kubernetes-users

In the case below, make sure you expose your deployment with a service, then assuming you have a DNS add-on properly running, reach your mysql with its DNS name (not the cluster IP).

Happy to follow up on the users list or slack.

-sebastien

> --
> You received this message because you are subscribed to the Google Groups "Kubernetes developer/contributor discussion" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to kubernetes-de...@googlegroups.com.
> To post to this group, send email to kuberne...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/kubernetes-dev/cb416284-9bd1-4537-b5cf-8f175b3ec589%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

[Montassar Dridi]

thank you for listing the group I already joined it

I exposed my deployment with a service and used the following address and none of them worked

 jdbc:mysql://SERVICE-NAME:3306/

 jdbc:mysql://SERVICE-NAME-default.svc.cluster.local:3306/

what am i missing ?

[Montassar Dridi]

sorry for your trouble

I already solved it, it was a mysql privilege error preventing the connection and fix it 

thanks