Mysql Bind-Address

[Rapid2214]

Hello,

What i am trying to do is make MySql listen on 2 out of 3 interfaces... I've been looking around but this doesn't seem possible, I have other services running like it but i need to do it with MySql.

Any idea?

Thanks

Marty

[falko]

What's in your my.cnf? What's the output of

netstat -tap

?

[Rapid2214]

This is the record from netstat - tap

 tcp 0 0 *:mysql *:* LISTEN 657/mysqld

Ideally i only want it to listen on 192.168.11.51 & 127.0.0.1, as i have another service (haproxy) listening on 192.168.11.50:3306 to balance the requests.

(client) ->192.168.11.50(haproxy) -> 192.168.11.51 (mysql) OR 192.168.11.52 (mysql)

any idea, how i can make mysql only listen on 2 ips instead of 3?

[falko]

According to http://dev.mysql.com/doc/refman/5.1/...d_bind-address , this is not possible.

[Rapid2214]

Humm, ok

Thanks

Marty