From owner-freebsd-questions@FreeBSD.ORG Sat Mar 29 05:05:55 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 57C311065671 for ; Sat, 29 Mar 2008 05:05:55 +0000 (UTC) (envelope-from tedm@toybox.placo.com) Received: from mail.freebsd-corp-net-guide.com (mail.freebsd-corp-net-guide.com [65.75.192.90]) by mx1.freebsd.org (Postfix) with ESMTP id 13A648FC15 for ; Sat, 29 Mar 2008 05:05:54 +0000 (UTC) (envelope-from tedm@toybox.placo.com) Received: from TEDSDSK (nat-rtr.freebsd-corp-net-guide.com [65.75.197.130]) by mail.freebsd-corp-net-guide.com (8.13.8/8.13.8) with SMTP id m2T55eU4070326; Fri, 28 Mar 2008 22:05:42 -0700 (PDT) (envelope-from tedm@toybox.placo.com) From: "Ted Mittelstaedt" To: "B. Bonev" , Date: Fri, 28 Mar 2008 21:07:03 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) In-Reply-To: <007401c890c7$28c15670$f800000a@chameleon> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914 Importance: Normal X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-3.0 (mail.freebsd-corp-net-guide.com [65.75.192.90]); Fri, 28 Mar 2008 22:05:44 -0700 (PDT) Cc: freebsd-questions@freebsd.org Subject: RE: fault tolerance with FreeBSD for old DOS app X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 29 Mar 2008 05:05:55 -0000 > -----Original Message----- > From: owner-freebsd-questions@freebsd.org > [mailto:owner-freebsd-questions@freebsd.org]On Behalf Of B. Bonev > Sent: Friday, March 28, 2008 3:31 AM > To: bseklecki@collaborativefusion.com > Cc: freebsd-questions@freebsd.org > Subject: Re: fault tolerance with FreeBSD for old DOS app > > > ----- Original Message ----- > From: "Brian A. Seklecki" > To: "B. Bonev" > Cc: > Sent: Tuesday, March 25, 2008 12:12 AM > Subject: Re: fault tolerance with FreeBSD for old DOS app > > > > > > On Mon, 2008-03-24 at 19:36 +0200, B. Bonev wrote: > >> I want advice for old DOS app on Windows PC, that I need to make on 2 > >> PC-s > >> fault tolerant. Any advice for working solution on FreeBSD? > > > > Yep...rewrite the database in SQL with a PHP front end. Import the data > > from the old system. Use a Radware/F5 Load Balancer for the web and > > Slony-I for the database replication. > > > > Welcome to 2008. > It is a accounting program, and will be too much efford for > nothing. And I'm > not a programmer. > I 'm thinking for something like heartbeat, or realtime > replication server - > 2 identical machines, > and when one of them break, staff to continue their work, without too much > trouble... > > You really want to be careful about using FreeBSD+Samba here. Dos/Lanmanager/Windows networking provides a very rich set of network file locking calls, something like 20 or so. Not all directly map to the UNIX filesystem. There are also vendor-specific stuff like Btrieve that UNIX has never heard of. If this old DOS app uses temp lock files in the directory the data files are located in, you probably will be fine. But if it uses some of the esoteric DOS file locking calls you may find that when you move the accounting database off whatever Novell or Windows NT or IBM Lanmanger server that it is currently on, that suddenly you will find users bitching because some of them cannot get into the accounting program. And when the nightly update is run, you may find the accounts having wrong dollar amounts in them. If your DOS app runs fine in a DOS window on Windows XP your smartest thing you can do is right now, before Microsoft forces everyone to stop selling XP, run out and forklift-replace -all- of the clients with new XP systems. And make your CFO understand that they better start saving their money up because in another 5 years or so, when those XP systems start dying off, that it will be the end of being able to use the accounting program. With these DOS apps the server is actually unimportant. You can easily find an old Mylex SCSI RAID-5 controller and a pile of 10,000 RPM ultra SCSI disks out there that will give you all the redundancy you need - run Windows 2K Server or 2003 Server on that and you will have a bulletproof server. All of the horsepower in the application is actually being done on the clients, and it is very easy for a client that has a hardware fault - like for example a failing network adapter card - to write garbage into the accounting database ans scotch it for everyone. Stuff like this is why people are abandoning those old DOS accounting programs right and left. Like the other poster said, start shopping for a new MySQL-based with PHP front end accounting package. Ted