Openshift - get domain name for MySQL database -
in env variable there host mysql database. ip in local network (starts 127...). how can make mysql available external world via domain name db?
this not possible. openshift platform-as-a-service (paas) shields internals of implementation in paradigm allows access through api connector such php , database cartidge. or through ssh tunneling. not expose ip address of mysql server sitting there port 3306 use in development such db libraries c#, java, python, etc. or mysql workbench or like.
in fact, not mysql server as shared one.
infrastruture-as-a-service (iaas) platforms such aws ec2 allow native port 3306 connections , public ip address exposed if opened firewall them.
with openshift, in order achieve connections such things mysql workbench, need pki key pair , ssh tunnel. same native app, say, written in c#, need likes of ssh.net . these configurations bearable single developer, don't scale rollout users, speaking. unless task of doing that. is, key management.
it 1 of drawbacks, 1 of security guarantees can bank on. can enjoy simplicity. has shortcomings. have converted people away openshift once have realized this. same limitations exist major shared hosts ssh way in.
i hope have answered question.