On Tue, 12 Aug 2003 23:08:15 +0200, Thomas Corell corell@corell.dyndns.org gave utterance to the following:
Jimmy Wales wrote:
How much priority should I give to RAID versus RAM for the db server, if there's a tradeoff? Does anyone really know the answer to that?
All what I heard of mysql it likes to use RAM. So, primary target is RAM and secondary is RAID ( => 3 disks: 1 for root, logs etc. and 2 striping disks for DB-Data). Thats the information some guys given, after some discussion in a forum of a great german computer magazin (c't / heise).
So, if possible, the new to buy machine if it will be the new DB-Server, it should have at least 3 HD slots.
One question to throw into the mix - If we cache static pages for anonymous (no skin preference)users (updating them when edited) rather than pulling them afresh from the database, on which mahine should the static pages reside - the web server, the db box or a dedicated box?