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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
