Re: URGENT problem with mysql processes

Quoting Nils Valentin <[EMAIL PROTECTED]>: > When you said you modified the scripts, are these the scripts on the 12 > webservers (mysql clients) ? Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12 webservers > If not, then these mysql clients (webservers) would stil

Re: URGENT problem with mysql processes

;Nils Valentin" <[EMAIL PROTECTED]> > To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, June 27, 2003 1:30 PM > Subject: Re: URGENT problem with mysql processes > > > Hi Keith, > > from your last e-mail I understand no

Re: URGENT problem with mysql processes

No, the slaves replicate fine and I can see their entries in the processlist normally (as their hostname), not as "unauthenticated user".. -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting Nils Valentin <[EMAIL PROTECTED]>: > Hi Keith, > > from your last e-m

Re: URGENT problem with mysql processes

Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 1:30 PM Subject: Re: URGENT problem with mysql processes Hi Keith, from your last e-mail I understand now finally that we are talking about replication here. Would have been a short cut to mention it in your

Re: URGENT problem with mysql processes

Hi Keith, from your last e-mail I understand now finally that we are talking about replication here. Would have been a short cut to mention it in your first e-mail. The failed login attempts couldn't be from your slaves trying to login, but you havent set them up on the master yet ? Just a gu

Re: URGENT problem with mysql processes

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月

Re: URGENT problem with mysql processes

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 --

Re: URGENT problem with mysql processes

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) Gi

Re: URGENT problem with mysql processes

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 Val

Re: URGENT problem with mysql processes

Hi Keith, 2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました: > Major problem! > > I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is > > - quad-xeon (500mhz each cpu) > - 3 gig RAM > - Linux Redhat 7.3 > > When I start up mysql, processes looking like the following begin to pile

URGENT problem with mysql processes

Major problem! I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is - quad-xeon (500mhz each cpu) - 3 gig RAM - Linux Redhat 7.3 When I start up mysql, processes looking like the following begin to pile up until it kills the server: | 106 | unauthenticated user | 192.168.1.