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]