Just noticed that you said partitions. I am assuming that you meat multiple drives in a raid array.
Bill David Lazo said: > Thanx again. > > For the time being, we will keep 4 drives with Dan's suggestion. OS and > MySQL running from there. > > > > On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PROTECTED]> wrote: > >> James, with just 4 drives, you can set up one big RAID 10 disk >> (usually called a "logical disk", with Dell PERCs I think it's a >> "container"), and then partition it for your different needs. >> >> If you have 4 73 GB disks, you probably have around 135 GB formatted >> capacity with RAID 10; I'd do something like this for my own MySQL >> server in that situation: >> >> 20 GB C partition for OS and software binaries >> 10 GB D partition for MySQL temp space >> 20-40 GB E partition for MySQL binary logs (if you're using them) >> remainder F partiition for MySQL data directory >> >> Your needs will vary depending on whether this server does only MySQL >> or other serving as well, how big your databases are, whether you want >> to keep binary logs for some period of time, and how large those >> binary logs are. >> >> I agree with David's response that you want redundancy for the OS as >> well. Drives fail, plain and simple. The single best thing you can >> do with servers is plan for hardware failure. Having your data on >> redundant disks is great, but if your OS is on a single drive, when >> (not if, when) that one fails, your data is redundant but still >> unavailable. >> >> You may pay a small performance penalty having the OS on the same >> physical drives with your MySQL, but I'd make that sacrifice for the >> redundancy, no question. On the other hand if you want to add a >> couple of drives and make a separate RAID 1 pair for the OS, go for >> it. >> >> Best, >> Dan >> >> On 8/25/06, JamesDR <[EMAIL PROTECTED]> wrote: > > > > -- > 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]
