Re: MySQL Clustering, redundancy
| From: | Edward Marczak | Date: | Tue, 18 Jun 2002 19:50:27 +0000 |
| Subject: | Re: MySQL Clustering, redundancy | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19867@lists.php.net to get a copy of this message | ||
On 6/18/02 9:19 AM, "Adam Voigt" adam.voigt@cryptocomm.com pressed the keys
forming the message:
> I have never actually tried to program against something which talks to
> multiple DB's, the quickest way would be in your DB connection code to
> have something that will either:
>
> A. Try the first DB and connect to the second if it's down.
> B. Randomly choose a SQL server.
>
> The most "fluid" solution I could think of would be an application
> gateway of some sort which will load balance properly to different IP's
> while in your code you only point to one.
I vaguely remember an article talking about how to implement your choice A.
Try weberdev or maybe even webmonkey (heck - just try google.).
--
Ed Marczak
marczak@usa.net