From owner-freebsd-questions Wed May 29 11:46: 9 2002 Delivered-To: freebsd-questions@freebsd.org Received: from infinity.aesredfish.net (ns1.aesredfish.net [65.168.0.12]) by hub.freebsd.org (Postfix) with ESMTP id 301A437B400 for ; Wed, 29 May 2002 11:46:00 -0700 (PDT) Received: from potentialtech.com (mhope-dhcp-65-168-1-181.dashfast.com [65.168.1.181]) by infinity.aesredfish.net (8.11.6/8.11.0) with ESMTP id g4TIjkU20448; Wed, 29 May 2002 14:45:46 -0400 Message-ID: <3CF52335.30807@potentialtech.com> Date: Wed, 29 May 2002 14:51:33 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.0rc1) Gecko/20020502 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Lance M.Westerhoff" Cc: freebsd-questions@FreeBSD.ORG Subject: Re: DB2 on FreeBSD?? References: <40948B54-732F-11D6-B5D0-00039357F10C@psu.edu> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Lance M.Westerhoff wrote: > I'm not sure if this is the right list to send this question on, but.... Yeah, you're in the right place. > In the coming weeks we will be building a 20 processor (10 node) AMD > 2000+ MP cluster, and I would really like us to try to use FreeBSD > instead of Linux. If these machines would only be used to run > computations, I suspect we would have no trouble at all. But, we will > also be connecting a 1.5TB RAID to two of the machines (one will be used > to serve databases and web pages, and the other will be a file and > application server). I'm jealous... this sounds like a cool project. > What about database > software? As the databases grow, I expect each of them to encompass > several TB, so I don't think MySQL will work in the long run (though I > could be wrong). Therefore, we are looking at commercial database > solutions. Keep in mind, MySQL *is* a commercial database. Contact MySQL AB directly and inquire about db sizes, etc. The FAQ states that tables can be up to 8 million Tb ( 2^63 ), so you may be underestimating what MySQL can do. http://www.mysql.com/doc/T/a/Table_size.html Have you considered PostgreSQL? It's another _extremely_ powerful open-source database. > From the FreeBSD page, it seems that Linux-Oracle8 will run > (I assume that 9 will as well??). Does anyone know about DB2 from IBM? > Being a University, we have a much much better deal with IBM then with > Oracle. Other ideas? Lastly, what sort of performance hit, if any, can > we expect with using a Linux-native DBMS with FreeBSD's Linux > compatibility libraries? I can't say for sure with DBMS, but with other Linux software (Staroffice, Acrobat) I've seen 0 performance hit running under the FreeBSD Linuxulator. I also don't have experience with DB2 or Oracle on FreeBSD, so I can't give any advice there. There's an article in the handbook (I believe) on getting Oracle running under FreeBSD. -- Bill Moran Potential Technology http://www.potentialtech.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message