When you said you modified the scripts, are these the scripts on the 12 webservers (mysql clients) ?
If not, then these mysql clients (webservers) would still be wanting to send to IP addres 192.168.1.71 as configured for php or in your client. Best regards Nils Valentin Tokyo/Japan 2003年 6月 27日 金曜日 14:58、Keith Bussey さんは書きました: > Neither of these two machines send the request. > > I have 12 webservers, which send the requests. > I have 5 database servers, 1 master(for updates/inserts/deletes) and 4 > slaves(for selects). > > Machine A below was the current Master DB server, however it is old and was > being replaced by machine B > > > -- > Keith Bussey > > Wisol, Inc. > Chief Technology Manager > (514) 398-9994 ext.225 > > Quoting Nils Valentin <[EMAIL PROTECTED]>: > > Hi Keith, > > > > soory now I got confused. Which machine is sending the requests (client) > > and > > > > which machine is the mysql server (server). Do you use php or something > > like > > > > this (webinterface) on the client ? > > > > If yes, than my suggestions below apply. > > If no than I we will have to think the next step. > > > > Best regards > > > > Nils Valentin > > Tokyo/Japan > > > > 2003å¹´ 6æ 27æ¥ éææ¥ 11:29ãKeith Bussey ããã¯æ¸ãã¾ãã: > > > Ok but that's not what I meant..... > > > > > > I'll try to explain better. > > > > > > Machine A: IP = 192.168.1.71 > > > Machine B: IP = 192.168.1.79 > > > > > > 1) Scripts goto 192.168.1.71 - Everything is OK > > > 2) Changed scripts to 192.168.1.79 - Site works at first, but processes > > > pile up until server is killed > > > 3) Halt machine B > > > 4) Give machine A IP 192.168.1.79 (so now it has 2 IPs) > > > 5) Problem persists even though it's a different machine, site works > > > but then processes pile up and kill machine > > > 6) Change scripts to use 192.168.1.71 again > > > 7) Site works fine > > > > > > > > > What I don't get is why do processes run normally with IP 192.168.1.71, > > > > but > > > > > NOT with IP 192.168.1.79 even when they are on the same machine ? > > > > > > -- > > > Keith Bussey > > > > > > Wisol, Inc. > > > Chief Technology Manager > > > (514) 398-9994 ext.225 > > > > > > Quoting Nils Valentin <[EMAIL PROTECTED]>: > > > > Hi Keith, > > > > > > > > The wrong IP address could only avoid a client to connect to the > > > > database > > > > > > server. > > > > > > > > If you have the TCP/IP address specified in /etc/php.ini or for > > > > phpmyadmin in > > > > > > > > config.inc.php or which ever tool you use than of course it will try > > > > to connect to this IP address. > > > > > > > > Best regards > > > > > > > > Nils Valentin > > > > Tokto/Japan > > > > > > > > 2003å¹´ 6æ 27æÂÂ¥ > > > > éÂÂæÂÂæÂÂ¥ 11:02ãÂÂKeith > > > > Bussey > > > > ãÂÂãÂÂã¯æ¸ãÂÂã¾ãÂÂãÂÂ: > > > > > Hrmm....meaning if I do "id mysql", that information (group etc..) > > > > > ? > > > > > > > > > > I've halted that server and moved everything back to my original > > > > server > > > > > > for > > > > > > > > > now, I had too much downtime. I did notice something else > > > > > interesting though: > > > > > > > > > > The old mahcine's IP is 192.168.1.71 > > > > > New machine's IP is 192.168.1.79 > > > > > > > > > > Now that it's halted, instead of changing the IP back to .71 in my > > > > > pages/scripts I added .79 to the .71 machine so it has both > > > > > > > > > > Now that machine experienced the exact same problem. Switching my > > > > > code to use .71 again however, and no problems. > > > > > > > > > > Could somehow there be a problem with the IP address 192.168.1.79?? > > > > > It seems very strange, however tomorrow I will try putting the .71 > > > > > on the new machine and see if it works or not > > > > > > > > -- > > > > --- > > > > Valentin Nils > > > > Internet Technology > > > > > > > > E-Mail: [EMAIL PROTECTED] > > > > URL: http://www.knowd.co.jp > > > > Personal URL: http://www.knowd.co.jp/staff/nils > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > > --- > > Valentin Nils > > Internet Technology > > > > E-Mail: [EMAIL PROTECTED] > > URL: http://www.knowd.co.jp > > Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]