From owner-freebsd-isp  Tue Aug 15  8:17:44 2000
Delivered-To: freebsd-isp@freebsd.org
Received: from tinker.com (troll.tinker.com [216.91.221.226])
	by hub.freebsd.org (Postfix) with ESMTP id EE16D37BB40
	for <freebsd-isp@FreeBSD.ORG>; Tue, 15 Aug 2000 08:17:29 -0700 (PDT)
	(envelope-from kim@tinker.com)
Received: by localhost (8.8.5/8.8.5)
Received: by mail.tinker.com via smap (V2.0)
	id xma029299; Tue Aug 15 10:14:58 2000
Received: by localhost (8.8.8/8.8.8) id KAA05660; Tue, 15 Aug 2000 10:10:38 -0500 (CDT)
Message-ID: <399960E6.D9A2E63D@tinker.com>
Date: Tue, 15 Aug 2000 10:25:26 -0500
From: Kim Shrier <kim@tinker.com>
Organization: Shrier and Deihl
X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.2-RELEASE i386)
X-Accept-Language: en
MIME-Version: 1.0
To: Steve Reid <sreid@sea-to-sky.net>
Cc: freebsd-isp@FreeBSD.ORG
Subject: Re: FreeBSD database server questions
References: <20000814181031.B13301@grok.localnet>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-isp@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.org

You might want to check out the following article:

http://apachetoday.com/news_story.php3?ltsn=2000-08-14-008-01-PR-MR-SW

Kim

Steve Reid wrote:
> 
> I will soon be setting up a database (among other things, for now)
> server running FreeBSD 4.1-R. This will be doing the usual web-type
> transaction processing.
> 
> Any tips? Specifically...
> 
> I'd prefer to run an open-source RDBMS; PostgreSQL and Interbase look
> like the contenders (I'm not interested in MySQL). First-hand
> experiences? I'll probably end up testing them both but if there's
> anything specific I should be watching out for I'd like to know
> beforehand.
> 
> Vinum? RAID-1 mirroring seems to be a minimum. Can I assume that RDBMSs
> will be able to take advantage of RAID-10 concurrency? The vinum man
> page has a "gotchas" section; any other foot-shooters I should be aware
> of?
> 
> Also, what about softupdates? As I understand it, softupdates is like
> async writes except the writes are re-ordered so as to prevent the disk
> from ever being left in a corrupt state. Is it possible for this
> delaying and re-ordering to interfere with a RDBMS's ACIDity? Should I
> stick with sync writes for the RDBMS space?
> 
> TIA.
> 
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-isp" in the body of the message

-- 
 Kim Shrier - principal, Shrier and Deihl - mailto:kim@tinker.com
Remote Unix Network Admin, Security, Internet Software Development
  Tinker Internet Services - Superior FreeBSD-based Web Hosting
                     http://www.tinker.com/


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-isp" in the body of the message