On Mon, 10 Jan 2005 21:18:00 +0530, Suresh Ramasubramanian
<linux@xxxxxxxxxxxxxxxx> wrote:
Suraj wrote:For fail support only we are having conditions in the php code itself.
Rohit Baisakhiya wrote:
,----
| if it reads value 0 it will connect the master db server and if it
| gets value 1 it will connect slave server.
`----
What you should rather do is to run a local nameserver that does a
round-robin rotation for your mysql server.
That wont help failover which is what he wants to implement I guess.
It is basically overkill if all he has are two or three mysql servers -
better use them as a single cluster and cache mysql connections, using
sqlrelay or other mysql clustering app.