I'm running a pretty big (or maybe I should call it
SELECT & INSERT-intensive) database.
Now I've heard here and there that a
MEMORY-based table is better for my situation (since I now run on a
RAID1 HDD array consisting of 2 HDDs and can't afford SSDs). But I know that using the
MEMORY engine is not good in case of a power outage (as the data on there will be lost). And since I'm running the server in my own house without UPS... well... you see where this is going.
So, how can I have 2 tables, 1 on the disk (InnoDB for example) and 1 in the memory, then have the memory table sync with the on-disk table once every 5 minutes so the data won't get lost completely in case of a power outage? (I realise that the data since the last sync will be gone.)
At the moment, I can use about 2GB of RAM for the database (which should not be a big deal because at the moment the table is about 300MB big with InnoDB).