In-memory dB on Embedded system.

[Sandhya Srinivas]

Hi,

I am a newbie in database. Please excuse me If my query sounds elementary.

I have an Embedded Debian linux 2.6.35.9, mysql 5.1.

My objective is to run the db in-memory, as in the long run it would damage the flash drive with too many read/write operations.

Hence I want to run the db in-memory and to have data consistency, I want to write back the data to
1. flash drive say every 2hrs(or may be less).
2. Also during every system restart/shutdown, copy the data to/from memory from/to flash drive.

Please help me with some pointers. I believe there exists some solution, as I have time constraints, I could not do exhaustive research. Hence any help is much appreciated.


Thanks
Sandhya