I'd go with raid 1+0 ... Be a shame to have that much cpu power and become I/O bound.. This way you've got 4 disks feeding the cpu's instead of 2.. Better performance than raid 5, and only 2 more disks than your current config.
On Tue, 2 Mar 2004 [EMAIL PROTECTED] wrote: > > > > > I have a requirement for a system that is of the order of 8-10 times the > size of my current system. Unfortunately (a) I don't know how many times > larger it actually is, and (b) my current system, while very happy, even > relaxed, on its current hardware, has not yet been subjected to the full > rigour of the target number of users. So it is very difficult to estimate > what hardware I need to specify for the new system. > > Fortunately, the budget is fairly generous. Obviously, we don't want to > gold-plate the system - but if a bit of overspend gives > faster-than-specified performance, that will be a gain rather than wasted > money. So I can get a lot of hardware - if I can confidently state that it > will improve MySQL performance. So what should I be planning to use? > > The database is quite small - 2-4 Gb, but high churn: maybe 25% of it > replaced every day. Reads dominate writes, but not overwhelmingly: at a > guess, 10:1. The current hardware is dual Xeon 2.0, 2Gb, single Scsi disk. > The one fixed factor is that the OS is Windows 2000 (I know the arguments > for Linux/BSD, but that is not feasible). > > Scanning a PC manufacturer's website, it seems easy to get 4x2.5GHz Xeon, > 1Mb L3, 8Gb ram, dual 15000 rpm Scsi with Raid 1 (for performance as well > as reliability). > > Does this sound balanced for a MySQL engine? Or what would other people > advise? > > Thanks for any advice, > > Alec > > > -- > 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]