I'd like to get a new server set up for a LAMP application.
L=Linux, A=Apache, M=PostgreSQL (!), P=PHP
The database isn't ever going to exceed 1GB. It needs to be fast, but each transaction is valuable, so I'm thinking of using 2 hot-plug mirrored disks (RAID1) as well as the nightly backup to a remote server.
Here are my questions:
(1) Is the superior performance of a 15,000 RPM HDD likely to be noticeable over a 10,000 RPM HDD, bearing in mind my data set is not all that large?
(2) What is a sensible choice for a RAID controller for my configuration (64MB cache / 128 MB cache, why would I need an external channel?)
(3) What if... Catastrophe strikes and one of by HDD fails.
(a) Does business continue as usual with no intervention?
(b) How do I know one HDD has failed?
(c) What steps are required to replace the failed HDD?
Apologies for the multi-part question. I'm expecting to split points if experts only want to answer parts.