Well then, I recommend Oracle 10g. But if price is an option msSQL can cluster nicely as well. Almost all enterprise dbs have some sort of hot and cold replication / backups. The major difference between the two, does it require a manual procedure to switch to the failover? The cheapest easiest solution is going to be the manual option. In which all you are doing is replicating from db1 to db2 and if db1 goes offline, replace it with db2.
..... so how fast does the failover need to be? Does all the data need to be present to maintain the application's value? You could always just have a primary db, and an empty schema on a secondary db. When db1 goes offline, db2 starts taking the population. Then once db1 is fixed you can merge the data from db2 into. Then clear off db2 and you are back to squre one. This is by far the cheapest solution. It just involves a little bit of manual labor. -Adam On 4/14/05, jacksonj @ calib. com jacksonj @ calib. com <[EMAIL PROTECTED]> wrote: > >So is your question "How can I cluster mySQL?" > > > >You want to focus on the replication end between multiple nodes. I'm > >not sure what mySQLs capabilities are. Have a failover system, not a > >load balanced system. (i.e. no need for the Radware... save those > >ports for your webservers) > > > >-Adam > > Thanks for the reply, but *not exactly.* MySQL is one option, and I don't > think the question is *how* to cluster it, as much as it is *whether* this is > an enterprise-level solution. > > Also this is just one option: The solution doesn't have to involve MySQL at > all; I just want the cheapest, most perfect solution (of course ;). > > Thanks again, > Jamie > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202851 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
