Re: Re: Moving from MySQL to MSSQL Server 2000
| From: | Manuel Lemos | Date: | Tue, 29 Jan 2002 05:53:56 +0000 |
| Subject: | Re: Re: Moving from MySQL to MSSQL Server 2000 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16270@lists.php.net to get a copy of this message | ||
Hello,
Boaz Yahav wrote:
>
> Fail Over is not for when the cluster is too busy, it's for when the
> server dies, or when someone killed it's power, or when you loose your
> network, or when you get a blue screen (assuming you are on windows :).
Ok, it is the same. When the server is dead, the response is the same:
none.
> Then, in about 30 seconds the cluster will do a fail over to the 2nd
> node and the site will continue to work as if nothing happens... it's
> pretty amazing to see this in action :)
I had requests to implement that in Metabase. The problem is that PHP
database connection functions do not let you define the connection
timeout parameters or check if the current persistent connection is
still alive. Anyway, nothing that a good middleware could not do better
for you.
Regards,
Manuel Lemos