Background
I am currently developing an online community and I want to store some temporary information in a hash table. This information is currently stored in memcached, however, if you need to restart or disable the memcached service, I would like to return to the hash cache on disk.
Question
What is the most efficient method to implement Hash or Cache tables on disk in MySql? Are there any methods that I can use to exit a simple table that will have the following fields:
- Hash value
- Stored value
- expiry date
Any help or understanding would be greatly appreciated.
Clarity
- I will not store complex data objects, just plain text strings.
- My current plan is to implement the InnoDB table.
- .