I'd double check this cronjob script... possible scenario.. kaibash idea
if you can prove it's invalid.
"> ServerB has a script that runs every 20 minutes, which does a very
quick/simple select from DB1, then loops though the results and does
updates/deletes on a different database server."
run
On Wed, 13 Aug 2003, Keith Bussey wrote:
> > Are you sure all connection attempts fail? not just insert attempts?
>
> Yes, i have it write to my log if the sock is empty (mysql_connect
> fails)...before it gets to the insert
But you mention mysql reports no connection errors... perhaps wait for
That's the problem, when the script runs, I can connect from serverA fine!...but
seems the webpages can't ;/
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting [EMAIL PROTECTED]:
>
> On Wed, 13 Aug 2003, Keith Bussey wrote:
> > > Are you sure all connection a
Possible?
Are you sure all connection attempts fail? not just insert attempts?
Server B does some updates/deletes... Chances are this causes some table
locks, which makes Server A unable to perform it's inserts until Server B
releases the lock.
On Wed, 13 Aug 2003, Keith Bussey wrote:
> Hi,
Quoting [EMAIL PROTECTED]:
> Are you sure all connection attempts fail? not just insert attempts?
Yes, i have it write to my log if the sock is empty (mysql_connect
fails)...before it gets to the insert
> Server B does some updates/deletes... Chances are this causes some table
> locks, which m
Hi, I am having a very weird problem with one of my database servers.
Let's take the following setup:
10 load-balanced servers (I'll call them ServerA)
1 admin server (ServerB)
1 database server (DB1)
Now ServerA has a function to insert a row into a table on DB1 whenever someone
hits certain pa