DIY NAS + database: boot off USB and spin down hdd?
I am about to build a little NAS, not really for streaming media but for sharing files, recieving backups and running a couple of database engines (Postgre and eventually MySql).
It will be very common that the NAS spends 2 or 3 days without being accessed so I was wondering if I could do someting to avoid having the hdd spinning at all time.
First I thought about system hibernation but I guess it can be troublesome having the DB engines there, so I am thinking about booting the OS off a USB pendrive (*) and storing my user data and DBs in a separate hard drive.
Then I remebered that in the past I had tried to make my hard drive spind down when idle and the OS just kept spining it on, eventually after some googling it was apparent that spining down the root fs was not possible or at least not realistic.
Has anyone tried and succeded at such configuration? (USB, Databases, spindown)
anyone has some insights to share?
(*) As I am not in the USA reasonable CF cards are rather expensive for the space they provide and SSD are almost prohibitively expensive, so a decent USB pendrive would be a better option.
Thanks in advance!