Test for MySQL server and try another if not found

[makaveliuk]

Is there a way to have a PHP script try to connect to a server and try another server if a connection cannot be established?

I have tried the following:

$link = @mysql_connect(server, username, password);
if( !$link ) {
$link = @mysql_connect(backupserver, username, password);
if( !$link ) {
header("Location: ./error.html");
}
}

But that fails every time if the first server is unavailable even though the 'backupserver' is available.

Any ideas where I'm going wrong? Is there a way to test for a connection without actually connecting maybe?

 

[sleipnir214]

That should work. What do you mean by "fails every time"?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[makaveliuk]

I mean it directs to error.html every time (As in the second failure) but if I remove the first one it works so there connection is definately available on the backup server.

 

[sleipnir214]

Under the assumption that you have posted pseudocode (you don't have $'s in front of your variable names), I can't duplicate your error.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[makaveliuk]

Those variables are declared using:

define(server, "192.000.000.000"); //Not the correct IP obviously

So they don't need $'s, I can't see any reason why shouldn't work either but for some reason it doesn't, it's weird.

 

[sleipnir214]

What version of PHP are you running on what platform? What version of MySQL?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[makaveliuk]

It's running PHP 4.3 and MySQL 4 on an OSX Server.

 

[sleipnir214]

I dunno. It could be differences in environments. I'm running PHP 5.0.2 with the Improved MySQL functions on Linux.

Want the best answers? Ask the best questions!

TANSTAAFL!!