HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   Mysql Bind-Address (http://www.howtoforge.com/forums/showthread.php?t=47604)

Rapid2214 28th July 2010 11:56

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

falko 29th July 2010 15:56

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

netstat -tap
?

Rapid2214 30th July 2010 14:30

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?

falko 31st July 2010 16:26

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

Rapid2214 31st July 2010 17:37

Humm, ok

Thanks

Marty


All times are GMT +2. The time now is 01:06.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.