Date: Tue, 15 Aug 2000 10:25:26 -0500 From: Kim Shrier <kim@tinker.com> To: Steve Reid <sreid@sea-to-sky.net> Cc: freebsd-isp@FreeBSD.ORG Subject: Re: FreeBSD database server questions Message-ID: <399960E6.D9A2E63D@tinker.com> References: <20000814181031.B13301@grok.localnet>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?399960E6.D9A2E63D>