Mysql Bind-Address

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

 

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

Code:

netstat -tap

?

 

This is the record from netstat - tap

Code:

 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?

 

According to http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_bind-address , this is not possible.

 

Humm, ok

Thanks

Marty