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 the
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
> Redu
> 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
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".
#x27;Mysql'
-->Subject: RE: RAID 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
-->40
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 s
June 18, 2003 2:39 PM
> To: 'Adam Nelson'; 'mysql'
> Subject: RE: RAID hardware suggestions/experience
>
>
>
>
> -->-Original Message-
> -->From: Adam Nelson [mailto:[EMAIL PROTECTED]
> -->Sent: Tuesday, June 17, 2003 11:56 AM
> -->
-->-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 ~10
> 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 the
On Wed, Jun 18, 2003 at 09:37:24AM -0700, Steven Roussey wrote:
>
> Don't stripe too many. More sets to stripe increase performance, but
> syncing the rotations of many drives degrades performance. So there
> are diminishing returns. For our calculations, 3-4 mirrors were
> sufficient. Most of our
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 don'
> 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 channel
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, yo
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.
n get 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 lo
t;
Sent: Tuesday, June 17, 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 recomende
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
wor
o:[EMAIL PROTECTED]
> Sent: Tuesday, June 17, 2003 10:59 AM
> 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 thin
d what to do.
Best 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 t
ECTED]
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" <[EM
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: T
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
esday, June 17, 2003 9:40 AM
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
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 RedH
24 matches
Mail list logo
