Hi Baker: We have a warehouse that runs 24/7 and cannot be down, not even for backups. They are 100% Web based except for the handhelds which run on a telnet interface. The warehouse's backup machine is used by the warehouse's customers access to the their data via the internet. So the data must be current at all times and available should the main server suffer a hardware or software failure.
Since we run on Unidata and Universe we had to have a solution that worked on both. We wrote replication technology that is handled in our middleware (U2WebLink) for all of our web applications. All changes to the database create a transaction record. There is a process always running that picks up those records sending them to the backup machine where the backup machine does the update. Our telnet programs create transactions as well and those are replicated to the other machine. We surround each write or delete in our Basic code with a call to a subroutine to capture the before and after images. In this case they manually switch the IP address to the new machine when we tested the worst case scenario, but this can be done with hardware. My client was not willing to purchase any more hardware to accomplish this switch over. Regards, Doug BTW: We are just finish up a Continuous Backup program that runs in Eclipse that continually copies data from one machine to another or can copy it up to the cloud company such as Amazon. You should be seeing announcement soon. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Monday, July 26, 2010 7:38 AM To: 'U2 Users List' Subject: [U2] 24 X 7 MV systems Hey y'all, I'm interested in hearing from folks who are currently on, or have worked with fault tolerant MV systems. We'd like to host our Business Layer on the MV system and serve It to our e-commerce portals, instead of re-coding our business rules first in Basic, then in .Net In order to get there though we must meet the primary business requirement of zero downtime (not even 2 minutes to manually switch). We're not talking about different levels of Raid - it's assumed the storage array is up and available. If the MV system has a hiccup of more than a few seconds it needs to hot failover to a backup twin sister. Is anyone doing this or something close to it? When I worked in public safety, Stratus sold such an automatic hot failover. I'm sure the EnRoute folks are doing something like this still. Maybe Nick G. or Margaret M. is listening in today. Thanks, -Baker ________________________________ This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users