89268

Adapting Database Best Practices to memcached Applications

The most direct way to cache MySQL data is to use a 2-column table, where the first column is a

primary key. Because of the uniqueness requirements for memcached keys, make surę your database

schema makes appropriate use of primary keys and unique constraints.

If you combine multiple column values into a single memcached item value, choose data types to

make it easy to parse the value back into its components, for example by using a separator character between numeric values.

The queries that map most easily to memcached lookups are those with a single WHERE clause, using

an = or IN operator. For complicated WHERE clauses, or those using operators such as <, >, BETWEEN,

or LIKE, memcached does not provide a simple or efficient way to scan through or filter the keys

or associated values, so typically you perform those operations as SQL queries on

the underlying

database.