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
Wednesday, June 18, 2003, 2:38:53 PM, you wrote:
---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
'; '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
Hi there,
Our databank with all tables and idices is about 130GB big. The biggest
limitations we encounter are on the I/O side.
Therefore we are willing to update our data storage system to a RAID system
(RAID 0+1, RAID 5, or RAID 10).
Has anyone experience with such RAID systems?
What should we
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
: Tuesday, June 17, 2003 11:26 AM
To: [EMAIL PROTECTED]; mysql
Subject: RAID hardware suggestions/experience
Hi there,
Our databank with all tables and idices is about 130GB big. The biggest
limitations we encounter are on the I/O side.
Therefore we are willing to update our data storage system
]
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
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
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.
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 1:15 PM
To: mysql
Subject: RAID hardware suggestions/experience
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
26 matches
Mail list logo