Complementing Chris : <http://www.onlamp.com/lpt/a/6549>Asume that your Application Server is Tomcat.
BALANCING SERVERS: You can implement some servers or appliance only for balancing your primary connections. This servers or appliance you must implement using Hearbeat ( only). For example one of the balancing servers fail. APPLICATION SEVER Your x ( quantity) of applications servers receive the connections from Balancing Servers and distribute across the diferent nodes of MySQL using LVS. You must implement Hearbeat for each application server too ( just in case of failure of some app. server). DATABASE SERVERS MySQL and multimaster replication, please see below http://www.onlamp.com/lpt/a/6549 Technology : for OS try to use Linux, for Hearbeat try to use UltraMonkey ( www.ultramonkey.org) for Balancing try to use LVS ( Linux). I hope this help. Regards. Juan Eduardo On 2/26/07, Chris McKeever <[EMAIL PROTECTED]> wrote:
On 2/26/07, Chris W < [EMAIL PROTECTED]> wrote: > > Can someone here give some insight and suggest other options I could > look into? you could replicate all the data between web/application servers, and use the local store as a read-only database, and push all your updates to a central update 'master' server. You could also play with multiple-master replication. > > -- > Chris W > KE5GIX > > "Protect your digital freedom and privacy, eliminate DRM, > learn more at http://www.defectivebydesign.org/what_is_drm" > > Gift Giving Made Easy > Get the gifts you want & > give the gifts they want > One stop wish list for any gift, > from anywhere, for any occasion! > http://thewishzone.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]