Date: Wed, 29 May 2002 14:51:33 -0400 From: Bill Moran <wmoran@potentialtech.com> To: "Lance M.Westerhoff" <lmw188@psu.edu> Cc: freebsd-questions@FreeBSD.ORG Subject: Re: DB2 on FreeBSD?? Message-ID: <3CF52335.30807@potentialtech.com> References: <40948B54-732F-11D6-B5D0-00039357F10C@psu.edu>
next in thread | previous in thread | raw e-mail | index | archive | help
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. <SNIP> > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3CF52335.30807>