RE: Linux for Big(ish) Databases
Bill, In general terms, I would say that it is certainly suitable. That answer is based upon the information you provide below. The real answer could only be ascertained by evaluating other requirements: A) Availability B) Scalability C) 'Cost' of each user - what do the transactions look like Don't fall into the trap of treating the machine as a PC - many implementations of Linux/Oracle apply the cost-reduced approach all the way across the system. You save money on the server and OS, but you should still make sure your I/O requirements are well catered for. From a CPU standpoint, you are probably more than OK. A quad Xeon machine has more power than you need in all likelihood (again, APPLICATION DEPENDENT - a single user can suck down 4 Xeons if they want to...). Memory, no problem - 4GB should be more than enough, and Linux is pretty well proven up to this level. The big downsides are thus: A) PCI bus bandwidth. Unless you go for a system with multiple PCI buses (they are available, but I've not personally run Linux on one of these), you are limited to a maximum theoretical bandwidth of width*clock: 33MHz * 32-bit= ~132MB/s, 66MHz*64-bit= 528MB/s. B) Crash Dumps. If you hit an OS problem, who do you go to, and what do you give them? C) Memory bandwidth. RDRAM or at least DDR memory solutions should be used where possible. This is where the P4 is actually worth considering. Forget all the 'extensions' stuff, though - Oracle is pretty much a pure INTEGER compute load. The thing you get that's worth having with the P4 is 400MHz front side bus - Memory Bandwidth! I would recommend, in the complete absence of any real workload knowledge ( ;-) ) to go for a 2-way P4 system based upon the ServerWorks GC-HE chipset. Something like the Dell PowerEdge 4600. This will give you a) memory bandwidth more balanced against the CPU power, b) lots of PCI bandwidth. Hope that is of use. Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of Scaling Oracle8i - Building Highly Scalable OLTP System Architectures -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Buchan Sent: 04 March 2002 10:18 To: Multiple recipients of list ORACLE-L Subject: Linux for Big(ish) Databases We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Linux for Big(ish) Databases
We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? No reason why not. Might also want to consider linux on a Sparc or Alpha. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux for Big(ish) Databases
The problem with Linux on Sparc or Alpha is that Oracle doesn't have binaries for them. I've requested Alpha binaries, but haven't had any response, despite the 1-2 business days response. sigh GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 04, 2002 9:53 AM To: Multiple recipients of list ORACLE-L We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? No reason why not. Might also want to consider linux on a Sparc or Alpha. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux for Big(ish) Databases
May be they'll release the source code and distribute it under the GPL license? -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 12:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: Linux for Big(ish) Databases The problem with Linux on Sparc or Alpha is that Oracle doesn't have binaries for them. I've requested Alpha binaries, but haven't had any response, despite the 1-2 business days response. sigh GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 04, 2002 9:53 AM To: Multiple recipients of list ORACLE-L We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? No reason why not. Might also want to consider linux on a Sparc or Alpha. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux for Big(ish) Databases
-- Jesse, Rich [EMAIL PROTECTED] on 03/04/02 09:03:28 -0800 The problem with Linux on Sparc or Alpha is that Oracle doesn't have binaries for them. I've requested Alpha binaries, but haven't had any response, despite the 1-2 business days response. sigh Remember: They're Oracle, you're not. Be glad they take their precious time to not answer your questions! The main problem with Intel boxes is a narrow I/O bus and latency issues with the chipsets. The VIA set tends to be faster so far as I've seen. Combined with good SCSI boards and LVM striping you can get decent throughput, but it'll never match something like a V-box or 6500 for full-bore speed. The real alpha motherboards (not NT compatable toys) use wide I/O channels to keep the chip fed. If you're considering linux look carefully at clusters. They can be an immense help dealing with large databases. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).