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