Thanks to everybody for the nice discussion.
Just to let you know about my (not necessary final) decisions:
We will upgrade our SCSI -II controller to an Ultra SCSI 160 controller
(always a good idea).
Next we are looking into buying a RAID-5 system from RAIDking.
While we do this we hope for
RE: SCSI needed for best performance -
While this is true in some cases, if you are using striping or any
RAID level (RAID 5 for example) that splits reads and writes across
drives, then there will be several IDE channels feeding data to the
RAID card at a time. Two ATA100 IDE channels
After testing a lot of different configurations (which was quite a
headache), I came up with the following. First of all, for both speed
and reliability, you will want SCSI. The list of reasons are quite long
for SCSI, and as you are doing research on the subject, it is an obvious
choice and I
What sort of throughput are you seeing in that setup?
God, I can't remember anymore. I can run a test again though. If you
have one you want me to run, just send it. We don't have other people's
money to spend, so all our disks are U160 18GB 15K IBM. They were less
than $100 each when we got
---Original Message-
--From: Adam Nelson [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, June 17, 2003 11:56 AM
--To: 'Bernd Jagla'; 'mysql'
--Subject: RE: RAID hardware suggestions/experience
--
--We recently bought a kick $%#%% machine for ~10k
--
--HP DL380
--2x2.8GHz Xeon
--1GB RAM
--5
'; 'mysql'
Subject: RE: RAID hardware suggestions/experience
---Original Message-
--From: Adam Nelson [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, June 17, 2003 11:56 AM
--To: 'Bernd Jagla'; 'mysql'
--Subject: RE: RAID hardware suggestions/experience
--
--We recently bought a kick
2 x 2.8 GHZ Xeon
4 GB of RAM
5 15K SCSI Drives
ICP SCSCI RAID control card with 1 Gb of ram on it.
I just bought 30 of these boxes to build out my mysql farm for close to
400-600 queries a second with 60 connections a second of mix read /
writes.
What kind of queries are you doing? Our
hardware suggestions/experience
--
--
--2 x 2.8 GHZ Xeon
--4 GB of RAM
--5 15K SCSI Drives
--ICP SCSCI RAID control card with 1 Gb of ram on it.
--I just bought 30 of these boxes to build out my mysql farm for close
to
--400-600 queries a second with 60 connections a second of mix read /
--writes
At 13:14 2003-06-17, Bernd Jagla wrote:
Sorry I forgot to mention:
We are using IRIS on an Origion2000, 7GB memory, 8 CPUs. I was thinking of
spending up to $10K.
I also wanted the redundant data for speeding up the seeks, I also need to
speed up the writes.
Bernd
I assume You mean IRIX on O2k.
A lot of table scans do to bitmasked column values.
Such that the above query will not utilize a key.
That statement gave me a cold shiver up my spine.
You could try an inverted index or match-cache technique, or
denormalization. These type of techniques are very app specific, but can
reduce
On Wed, Jun 18, 2003 at 03:20:17PM -0400, Adam Nelson wrote:
Where'd you get it. I've had bad experiences with generic machines but
I'll take a peak if you send the link?
There are a couple of things I didn't mention
2U Form Factor with tool-less rails
Redundant Power Supply
Redundant
I am using 4 120G IDE Drives with an Adaptec IDE RAID Controller on RedHat
Linux providing 240G of RAID 5 storage. While not quite as fast as SCSI, I
have found this to work very well. You should be able to pickup a nice
dual processor XENON 2.4Ghz system w/1G Ram and IDE RAID loaded with
Subject: Re: RAID hardware suggestions/experience
I am using 4 120G IDE Drives with an Adaptec IDE RAID Controller on RedHat
Linux providing 240G of RAID 5 storage. While not quite as fast as SCSI,
I
have found this to work very well. You should be able to pickup a nice
dual processor XENON
Tried a Promise FastTrak 100 TX2 in a Dell; RH 7.3. Miserable. Bailed on it
after one month.
Kerry
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 12:59 PM
To: [EMAIL PROTECTED]
Subject: Re: RAID hardware suggestions/experience
Anyone had
Im using a 3ware (which has great linux support) Escalade 7800 with 8
120GB/8MB cache ide drives in RAID 10 under Debian with 2.4.20 kernel.
I guess what we need to know is what platform and how much $$ you wanna
spend
-Original Message-
From: Bernd Jagla [mailto:[EMAIL PROTECTED]
Sent:
]
Subject: Re: RAID hardware suggestions/experience
Anyone had any experience with 3Ware 7500-4 IDE RAID or the Promise
SX-6000
IDE RAID cards? Specifically for Linux. Heard bad things about Promise,
good
about 3Ware.
David
- Original Message -
From: Patrick Shoaf [EMAIL PROTECTED
of Luck,
Grant Q
-Original Message-
From: Gabriel Guzman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 10:06 AM
To: Bernd Jagla
Cc: [EMAIL PROTECTED]; mysql
Subject: Re: RAID hardware suggestions/experience
Bernd,
here is a good resource on the different types
To: [EMAIL PROTECTED]
Subject: Re: RAID hardware suggestions/experience
Anyone had any experience with 3Ware 7500-4 IDE RAID or the Promise
SX-6000
IDE RAID cards? Specifically for Linux. Heard bad things about Promise,
good
about 3Ware.
David
- Original Message -
From: Patrick Shoaf
On Tue, 2003-06-17 at 09:58, David Griffiths wrote:
Anyone had any experience with 3Ware 7500-4 IDE RAID or the Promise SX-6000
IDE RAID cards? Specifically for Linux. Heard bad things about Promise, good
about 3Ware.
If I had to choose between the two, I would go with the 3wares. They
work
, 2003 10:41 AM
Subject: RE: RAID hardware suggestions/experience
Optimally, Yes, you should replace with exact same brand/model etc...
but you CAN replace with a different brand/ model drive of the same
amount of disk space or more. It isn't recomended (because of
different seek times, cache
away with it w/o any adverse effects.
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 12:33 PM
To: [EMAIL PROTECTED]
Subject: RE: RAID hardware suggestions/experience
I have heard good thing about 3Ware, but I would suggest looking
To me the question of reliability is that of the drive, not the
interface. I cannot see SATA itself being any more or less reliable than
ATA drives. I think certain controllers will accept a new drive that has
similar characteristics as long as the replacement drive is larger than
the lost drive.
We recently bought a kick $%#%% machine for ~10k
HP DL380
2x2.8GHz Xeon
1GB RAM
5 15k scsi drives (2 RAID 1 for OS and logs/3 RAID 5 for data)
RedHat Linux Enterprise Edition 2.1
This machine easily handles 200 queries/sec and never gets a load
average above 1.5. For your space requirements,
23 matches
Mail list logo