Most reliable filesystem for embedded purposes
I'm constructing small server for special monitoring purposes (HPAC monitoring and GSM notifications).
There is intel Atom motherboard inside 1U 19" case with Transcend SSD driver and GSM-modem in a package.
Software solution include Debian Linux, nagios and smstools.
It would be unattended system, often powered off without shutdown .
The root filesystem is in read-only mode, but there is a need for RW-filesystem (/var) for nagios data, logs, etc.
Which filesystem is most suitable to be keeped of system hangs on boot due to dirty (/var) filesystem after powering of without shutdown ?
And another one question. Is it possible to use mysql bases confidently in same condition (for ndoutils), or DBMS should be avoided also ?