For MySQL, I have one master and two slaves.

The link to the DB is via php. I want the slave servers to act also
redundant servers for providing data to my php code.

I tried the following

$db = mysql_connect(server1,user,pass) or mysql_connect(server2,user,pass)

but, if fails to go with to server2 if server1 is down, Is there any thing
that I am doing wrong ?

Anand

Try this:

$ db = mysql_connect(server1,user,passwd);
if (!$db) { $db = mysql_connect(server2,user2,passwd2); }

V/r,
Charles

to suppress the warning that gets on the page from the failed server

Anand