I have a TinyCore (3.6) Linux distribution on a device of mine, which uses disk-on-module or compact flash storage.
The filesystem is ext2.
I have a LAMP stack on this device and I'm playing with a MySQL database containing over 400 tables (myisam). Write operations occur systematically every 15 minutes.
These tables are generated by my web application, according to my setup needs.
Now, it happens that this device can be abruptly shut down, due to lack of power.
What happens is that, if MySQL is performing some write operation (i.e.
insert) some of the data as well as index files can be corrupted.
It's no big deal for sure, but performing a
repair table operation is not that bad; tables are repaired and applications can continue running, even if unfortunately some data is lost (which in my case could be acceptable).
The problem is that, often, when an abrupt shutdown occurs, several mysql table files (FRM or MYI or MYD) are in "Input/Output error" status and my MySQL front-end reports a "storage engine error 5" (I/O error) for those tables. Applications using the database are obviously unable to run correctly.
Rather than to prevent events like those ones (which I think are unavoidable at some extent) I would like to think about something to correctly and possibly automatically recover from file I/O error situations deriving from scenarios described above.
EDIT: Unfortunately I can't switch to ext3, I must stick with ext2, also due to the fact that ext3 would heavily affect solid state memory write cycles.