setting a timeout on db connection

[thom2002]

Hi All,

 

 

First posting here and I come with a question 

 

 

I have a script with database (script A) running on one server (Server A).

 

I have a plugin script (script B) installed into script A.

 

Script B connects to a database on another server (server B)

 

 

Everything works perfectly - except...

 

If server B goes down then script B times out and stops execution of script A.

 

What I need to happen is...

 

IF server B is unavailable, then script A ignores script B and continues execution of script A.

 

And it needs to happen within 2 seconds.

 

 

Is there any way to add code to script B to accomplish this?

 

 

I am open to suggestions 

 

 

best wishes

 

Thom

 

[mrMarcus]

well, how are you connecting to this database?  let's see some code.  or are you just looking for theory?

[thom2002]

Thanks for taking a look

 

 

$dbHost="000.000.000.000";  // ip address of server
$dbUser="username";
$dbPass="password";
$dbDB="dbname";

$dbh=mysql_connect ("$dbHost", "$dbUser", "$dbPass");
mysql_select_db ("$dbDB");

 

Script B does an insert to db on server B.

Then does a select from server B

Then does an update to db on server A

 

As you can see, straight forward connection to server B. Except no exit or die   as I want  script A to continue no matter what happens with the plugin script B.

 

 

On one occasion server B went down and the script B timeout caused script A to also timeout. That is what I must avoid happening.

 

best wishes

 

Thom

 

[mrMarcus]

why not just a simple:

 

<?php
if ($dbh = mysql_connect($dbHost, $dbUser, $dbPass))
{
     mysql_select_db($dbDB);
     //continue with script B on server server B;
}
else
{
     //continue with script A;
}
?>

 

something like that.

 

of course it all has to do with how your code/script is setup to in order to properly execute the conditions.

[thom2002]

 

Yep it really could be that simple

 

It is amazing how a problem can be made more complicated than it is... when a potential disaster is thrown at you.

 

 

Thank you

 

best wishes

 

Thom

 

[mrMarcus]

no worries.  just a second set of eyes was needed.