title: Best way to Implement a MySQL Hash Table?
body: <p><strong>Background</strong></p>
  
  <p>I'm currently developing an online community and I want to store some temporary information in a hash table. Currently this information is being stored in memcached, however, should the memcached service need to be restarted or failed, I would like to resort back to the on disk hash/cache.</p>
  
  <p><strong>The Question</strong></p>
  
  <p>What is the most effective method of implementing an on disk Hash or Cache table in MySql? Are there any techniques that I can use to get out of a simple table which will have the following fields:</p>
  
  <ul>
  <li>Hash Value</li>
  <li>Stored Value</li>
  <li>Expiry Date</li>
  </ul>
  
  <p>Any help or insight would be much appreciated.</p>
  
  <p><strong>Clarity</strong></p>
  
  <ul>
  <li>I won't be storing any complex data objects, just simple text strings.</li>
  <li>My current plan is to implement an InnoDB table.</li>
  <li>Any links to articles on a similar topic would be a bonus.</li>
  </ul>