Connecting from Inside the cluster
OneDB Native SQLI connection are accessible through the OneDB Connection Manager. A
kubernetes service will be created with the deployment and that service name is used for
connections. A kubernetes service is created for the non-SQLI types as
well.
kubectl get services
NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE
helm-1-odbp-explore ClusterIP 10.96.220.30 <none> 8080/TCP 20m
helm-1-odbp-mongo ClusterIP 10.96.44.208 <none> 27017/TCP 20m
helm-1-odbp-rest ClusterIP 10.96.90.21 <none> 8080/TCP 20m
onedbcm-cm-service ClusterIP 10.96.159.103 <none> 10000/TCP,20000/TCP 19m
The OneDB Connection manager supports “Redirected” and “Proxied” connections. For internal connections it is recommended to use “Redirected” connections. The following table shows the Internal connection string to use for each driver type. From within the cluster the .{namespace}.svc.cluster.local may not be needed from the URL below.
Driver | URL | Example URL |
OneDB driver (SQLI-Primary) | onedbcm-cm-service.{namespace}.svc.cluster.local:10000 | jdbc:onedb://{url}/sysmaster |
OneDB driver (SQLI-Secondary) | onedbcm-cm-service.{namespace}.svc.cluster.local:10001 | jdbc:onedb://{url}/sysmaster |
OneDB driver (SQLI-Any) | onedbcm-cm-service.{namespace}.svc.cluster.local:10002 | jdbc:onedb://{url}/sysmaster |
OneDB driver (SQLI-Primary-SSL) | onedbcm-cm-service.{namespace}.svc.cluster.local:10020 | jdbc:onedb://{url}/sysmaster |
OneDB driver (SQLI-Secondary-SSL) | onedbcm-cm-service.{namespace}.svc.cluster.local:10021 | jdbc:onedb://{url}/sysmaster |
OneDB driver (SQLI-Any-SSL) | onedbcm-cm-service.{namespace}.svc.cluster.local:10022 | jdbc:onedb://{url}/sysmaster |
Mongo combatible driver | <Release-Name>-odbp-mongo:27017 | mongodb://<release-name>-odbp-mongo:27017 |
REST | <Release-Name>-odbp-rest:8080 | http://<release-name>-odbp-rest:8080 |
Explore | <Release-Name>-odbp-explore:8080 | http://<release-name>-odbp-explore:8080 |