Hi I have something silly like idea to proxying mysql connections.
I have upload an image of my concept to here http://i52.tinypic.com/o7src3.png
There is a single machine on local network running multiple mysql servers on different ports. This machine cannot reveal to Internet directly due to security reasons. clients are connecting to default mysql port (3306) without knowing these ports. Client requests are routed to correct mysql server port by identifying their domain name.
I tried to use mysql-proxy, but seems this scenario cannot achieve using mysql-proxy (I didn't tried much harder).
Is there a way to achieve this using iptables or any other method?
Your replies are highly appreciated.