RE: [PHP-DB] MySQL Clustering, redundancy

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@cryptocomm.com 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@criticalcode.com > p: 603.943.4237 > w: http://www.criticalcode.com > PO BOX 601 > Manchester, NH 03105 > > > -----Original Message----- > From: Adam Voigt [mailto:adam.voigt@cryptocomm.com] > Sent: Tuesday, June 18, 2002 8:55 AM > To: php-db@lists.php.net > 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@cryptocomm.com > > 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@criticalcode.com> > > matt@criticalcode.com > > 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 >