Though of you are talking about replicating over the public internet. very cool idea. how about - using JMS to shift the bin-logs? you'd get network-fault-tolerance, guaranteed sequential delivery, auth & auth, ease of subsequent configuration (ie pub-sub) all built in? You'd just have to build the clients...
: -----Original Message----- : From: Craig Collings [mailto:[EMAIL PROTECTED] : Sent: Wednesday, 10 November 2004 3:00 p.m. : To: 'Tomcat Users List' : Subject: RE: Multi-Site Clustering? (hot failover) : : : Hi Steve, : : I presume you are thing something like this: : http://dev.mysql.com/doc/mysql/en/Replication.html : : : -----Original Message----- : : From: Steven J.Owens [mailto:[EMAIL PROTECTED] : : Sent: Wednesday, 10 November 2004 2:55 p.m. : : To: [EMAIL PROTECTED] : : Subject: Multi-Site Clustering? (hot failover) : : : : : : Hi, : : : : I've heard tomcat supports clustering, but I'm thinking : : about a similar, but different situation: having a duplicate : : server at a distant hosting center, set up to take over if : : the first server or the first hosting center encounter problems. : : : : This isn't about load, so much as reliability. I don't : : *think* there are any special things I need to do at the : : tomcat level, but I figure it can't hurt to ask if I'm : : missing something. : : : : My basic configuration is apache/tomcat/mysql. I think : : I just need to keep the tomcat webapps on the same version of : : my application, and that's about it for apache and tomcat. I : : especially have to make sure the application code is using : : the same database schema, so I don't get inconsistent data : : being written to the database. : : : : The main trick isn't gonig to be tomcat but all, but : : rather making sure the mysql database on the second server is : : set up to mirror the first database, with frequent updates to : : minimize the window of lost data. The main worry is going to : : be if the second machine has to take over, and some new data : : is created in the first machine after that point (i.e. the : : data gets out of sync). I'm guessing the short answer is to : : either count that data as lost (i.e. "Doctor, my arm hurts : : when I do this." "Don't do that."), or selectively copy the : : new data over to the second machine, then drop the first : : database and copy the second database over to the first server. : : : : -- : : Steven J. Owens : : [EMAIL PROTECTED] : : : : "I'm going to make broad, sweeping generalizations and : : strong, declarative statements, because otherwise I'll be : : here all night and this document will be four times longer : : and much less fun to read. Take it all with a grain of : : salt." - http://darksleep.com/notablog : : : : : : : --------------------------------------------------------------------- : : To unsubscribe, e-mail: [EMAIL PROTECTED] : : For additional commands, e-mail: [EMAIL PROTECTED] : : : : : : ############################################################## : ####################### : Notice of Confidential information : The information contained in this electronic mail is : CONFIDENTIAL INFORMATION and may be LEGALLY PRIVILEGED, : intended only for the individual or entity named above. If : you are not the intended recipient, you are hereby notified : that the use, dissemination, distribution, or copying of this : document is strictly prohibited. If you have received this : electronic message in error, please immediately notify us by : return or telephone call collect to 07 577 6049) and destroy : the original message. Thank you, ABN AMRO Craigs Limited. : : This e-mail message has been scanned and cleared by : MailMarshal www.marshalsoftware.com : : ############################################################## : ####################### : : --------------------------------------------------------------------- : To unsubscribe, e-mail: [EMAIL PROTECTED] : For additional commands, e-mail: [EMAIL PROTECTED] : : ##################################################################################### Notice of Confidential information The information contained in this electronic mail is CONFIDENTIAL INFORMATION and may be LEGALLY PRIVILEGED, intended only for the individual or entity named above. If you are not the intended recipient, you are hereby notified that the use, dissemination, distribution, or copying of this document is strictly prohibited. If you have received this electronic message in error, please immediately notify us by return or telephone call collect to 07 577 6049) and destroy the original message. Thank you, ABN AMRO Craigs Limited. This e-mail message has been scanned and cleared by MailMarshal www.marshalsoftware.com ##################################################################################### --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
