> -----Original Message----- > From: Chris White [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 12, 2006 5:15 PM > To: mysql@lists.mysql.com > Subject: Re: I don't understand why SCSI is preferred. > > On Wednesday 12 July 2006 01:13 pm, Tim Lucia wrote: > > I've seen whitepapers from MySQL's web site, co-authored with Dell, that > > recommend the hardware optimization be: > > > > 1. More Memory > > That's a definite > > > 2. Faster Drives (15K RPM is better the 10K) > > Well, I guess for any server really, the faster the disk writes (Though > let's > be honest, the faster the disk writes AND the better integrity disk). > Generally this is, in my opinion more suitable for things like logging, or > the times MySQL actually decides to write to the disk (here's where a > MySQL > person steps in and states when that is ;) ). > > > 3. Faster CPU. > > As with most things these days. Better CPU means less worry about "Oh, I > wonder if I can do this" and increases the time period between now and > when > you need to scale. > > > Based on this, we're spec'ing 2950s with 16Gb, dual 2.8 dual-core Xeons, > > and 146Gb 15K (times 6) drives. > > Sounds about right. If you're on a linux system I also recommend that you > turn on NPTL (Native Posix Threading Library), which is done through glibc > (or by grabbing an rpm/deb/whatever with said support). As always, don't > forget the SMP support in the kernel to benifit from the Dual-Core (I'm > guessing you probably know this, but hey.. never hurts). > > > The plan is to RAID then 2 x RAID1 for the o/s (/boot, /, > > sounds good > > > /var, and some > > It's actually best to shove this on a separate disk. As the name > implies, /var is for variable data. That said, you'll be chucking > everything > and the kitchen sink at it. Logs, spools, etc. These suckers are > constantly > being written to, and let's forgot the fact that some people attack > servers > by shoving data at it, which goes to logs.. which take up space.. you get > the > idea.
/var would be on a separate partition, on the same physical RAID set -- sorry that was obvious to *me* but I didn't say that. > > > working space for dumps and restores), and 4 x RAID10 for /data. Anyone > > have any feedback on this? > > Some people use replication servers for backups, others use the same > drive. I > like the idea of a separate backup replication server as if the main one > goes > down, I've got a real physically separated backup to work with. In the > end > that's what matters. The plan is to backup the slave. I just want to reserve some space if I need to have a local dump file or something. > > -- > Chris White > PHP Programmer/DBloomingOnions > Interfuel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
