Mysql Bind-Address

Discussion in 'HOWTO-Related Questions' started by Rapid2214, Jul 28, 2010.

  1. Rapid2214

    Rapid2214 New Member

    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
     
  2. falko

    falko Super Moderator ISPConfig Developer

    What's in your my.cnf? What's the output of
    Code:
    netstat -tap
    ?
     
  3. Rapid2214

    Rapid2214 New Member

    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?
     
  4. falko

    falko Super Moderator ISPConfig Developer

  5. Rapid2214

    Rapid2214 New Member

    Humm, ok

    Thanks

    Marty
     

Share This Page