On Mon, Sep 1, 2008 at 2:32 PM, Thomas Finneid <tfinneid@xxxxxxxxxxxxxxxxxxxxx> wrote: > > Scott Carey wrote: >> >> For a development box, just enable write-back caching regardless of the >> battery back up situation. As long as its not your only copy of > > Will have a look at it, the data is not important and can be reproduced any > time on any machine. The controller I have is a Areca ARC-1220 Serial ATA 8 > port RAID Controller - PCI-E, SATA II, so I dont know exactly what it > supports of caching. It's a pretty good card. It should support 1G of cache at least, and definitely supports battery backup. Have had a pair of 1680 Arecas in production for a month now and so far I'm very happy with the reliability and performance. The other Scott is technically right about the lack of need for battery back on a dev machine as long as you go in and change the chaching to write back, and I'm sure the card will give you a red dialog box saying this is a bad idea. Now, if it would take you a day of downtime to get a dev database back in place and running after a power loss, then the bbu may be worth the $200 or so. While I like to have a machine kitted out just like prod for testing, for development I do tend to prefer slower machines, so that developers might notice if they've just laid a big fat bloaty code egg that's slower than it should be. Try to optimize for acceptable performance on such server and you're far more likely to get good performance behaviour in production.
