RE: [PHP-DB] MySQL Clustering, redundancy From: Adam Voigt (adam.voigt <email protected>)
Date: 06/18/02

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.

Adam Voigt
adam.voigt <email protected>

On Tue, 2002-06-18 at 09:12, Matt Babineau wrote:
> Thanks for your response Adam!
>
> Do you know if there is any way MySQL can be spread across multiple
> machines? I am looking at a huge application for a client, that will
> need to support thousands of simultaneous users. I am wondering if MySQL
> can handle load like that. That's why I was asking about clustering
> MySQL servers for the ability to handle more users simultaneously.
>
> Has anyone had any experience with a large scale application on MySQL?
>
> Matt Babineau
> Freelance Internet Developer
> -----------------------------------------
> e: matt <email protected>
> p: 603.943.4237
> w: http://www.criticalcode.com
> PO BOX 601
> Manchester, NH 03105
>
>
> -----Original Message-----
> From: Adam Voigt [mailto:adam.voigt <email protected>]
> Sent: Tuesday, June 18, 2002 8:55 AM
> To: php-db <email protected>
> Cc: Matt Babineau
> Subject: Re: [PHP-DB] MySQL Clustering, redundancy
>
>
> Yes,it's called Replication in the MySQL documentation. However, since
> the info in the manual is kind of sparse so I would hop on google and do
> a search for specific instructions on how to do it when your ready, but
> to answer your question, yes, MySQL does do Redundancy/Failover.
> (Ofcourse you must take account of this in your code interacting with
> the server, but the data will be sync'd).
>
> Adam Voigt
> adam.voigt <email protected>
>
> On Tue, 2002-06-18 at 08:47, Matt Babineau wrote:
> > Hi All:
> >
> > I quickly skimmed the MySQL manual and didn't see any information on
> > clustering. Does MySQL have any support for clustering or some type of
>
> > redundant failover systems?
> >
> > Thanks!
> >
> > Matt Babineau
> > Freelance Internet Developer
> > -----------------------------------------
> > e: <mailto:matt <email protected>> matt <email protected>
> > p: 603.943.4237
> > w: <http://www.criticalcode.com/> http://www.criticalcode.com PO BOX
> > 601 Manchester, NH 03105
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php