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 Howtoforge Staff Moderator HowtoForge Supporter 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 Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

  5. Rapid2214

    Rapid2214 New Member

    Humm, ok

    Thanks

    Marty
     

Share This Page