In-memory dB on Embedded system

[Sandhya Srinivas]

Hi All,

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



Edited 1 time(s). Last edit at 04/24/2013 04:00AM by Sandhya Srinivas.