I am looking for a database that is -
- Relational (Not NoSQL).
- Has an in-memory store.
- Has disk-based backing storage.
I want to set up a system where entire contents of the disk are replicated in memory. So writes are made to both the in-memory store and disk, but reads are done only against memory.
Most of the databases I have seen such as H2 or HSQLDB offer in memory grid or disk based tables. I am looking for an in-memory grid WITH disk based backing storage.
Is there such a database system available or is it possible to configure MySQL (or some other) database to work in such a manner?