mysql-proxy-discuss team mailing list archive

[Joshua Zhu <zhuzhaoyuan@xxxxxxxxx>]

I hope I've understood :)

On Wed, Feb 11, 2009 at 5:49 PM, Pierre <mail@xxxxxxxx> wrote:

> Ok, let's restart from scratch:
>
>
> A client wants to connect to its mysql server. So he puts sql.client1.com.
> Let's say sql.client1.com is a CNAME to mysqlproxy.master.com OR a 'A' to
> mysql.proxy.ip.address .
>
> Another client would have the same configuration: sql.client2.com ->
> mysqlproxy.master.com (or mysql.proxy.ip.address).
>
> With a consequence, all clients requests are "redirected" to the proxy.
>
>
> Now, I still want different mysql server for my clients. For exemple:
> sql.client1.private.master.com
> sql.client2.private.master.com
>
>
> To do that, I would like to know if mysql proxy is able to tell me from
> which ip or address it has been called by. (sorry if the sentence is not
> correct)
>
> In other words, I would like the proxy to tell me:
> "Somebody called me using sql.client1.com" -> I would know it's client1's
> request, and I redirect it to sql.client1.private.master.com (or the
> equivalent ip)
>
> "Somebody called me using sql.client2.com" -> I would know it's client1's
> request, and I redirect it to sql.client2.private.master.com (or the
> equivalent ip)
>
>
> Eventually, the question is:
> Is mysqlproxy able to tell me the destination address of the requests, ie
> sql.client{1,2}.com ?
>


No, MySQL Proxy does NOT know this kind of information. And actually it is
not an issue of MySQL Proxy's , but TCP/IP's. That is to say, a server does
not know the hostnames that its clients use to connect to, unless the
hostnames are specified clearly in the protocol (e.g. HTTP).

Possible solutions to your problem:
1) Add more records in your DNS server, so you can redirect the clients to
the right MySQL server, for example:
    mysql1.client1.com    IN    A    192.168.0.1
    mysql2.client2.com    IN    A    192.168.0.2

So, the clients connect to mysql1.client1.com will be redirected to
192.168.0.1 (MySQL #1); the clients connect to mysql2.client1.com will be
redirected to 192.168.0.2 (MySQL #2)... You don't need MySQL Proxy here, I
think.

2) Add the hostname as a hint in your SQLs, then parse and redirect it to
the MySQL backend you want, using MySQL Proxy.

I prefer solution 1.

Regards!

-- 
Joshua Zhu
http://blog.zhuzhaoyuan.com