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 [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: [EMAIL PROTECTED] > p: 603.943.4237 > w: http://www.criticalcode.com > PO BOX 601 > Manchester, NH 03105 > > > -----Original Message----- > From: Adam Voigt [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 18, 2002 8:55 AM > To: [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 > [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:[EMAIL PROTECTED]> [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