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]
