public
Description: A protocol-level caching layer for mysql
Homepage:
Clone URL: git://github.com/clofresh/mysql-proxy-cache.git
Daniel Lockard (author)
Wed Jul 08 14:08:09 -0700 2009
commit  b897c81a2e39231ad7f06d03019ec068a1fc24cf
tree    124cbc93967e93d420f17a11aa9cb05807d3d084
parent  6f21baa7557665cfa22c1e072ac383268e9dd260
name age message
file README Wed Jul 08 14:00:37 -0700 2009 Modified mysql-proxy-cache.lua so that it works... [Daniel Lockard]
file mysql-proxy-cache.lua Wed Jul 08 14:08:09 -0700 2009 uncommented print messages [Daniel Lockard]
README
Dependencies:
* MySQL Proxy (http://dev.mysql.com/downloads/mysql-proxy/index.html)
* memcached (http://www.danga.com/memcached/)
* LuaRocks (http://www.luarocks.org/) - to install the md5 and luasocket libraries
* md5.lua (http://www.keplerproject.org/md5/)
* Memcached.lua (http://luamemcached.luaforge.net/)
* LuaSocket (http://www.tecgraf.puc-rio.br/~diego/professional/luasocket/)

Usage:

Assuming you have mysql and memcache instances running locally listening at their respective default ports, you can just 
run the following commands:

mysql-proxy --proxy-lua-script=mysql-proxy-cache.lua

Then, point your application to mysql proxy on port 4040 instead of 3306. Make sure you specify 127.0.0.1 as the host 
instead of localhost, otherwise you won't connect to mysql proxy.

Default Timeout for data is 30 seconds. To change this, as it is rather low, and set this way for testing, edit the 
variable cache_timeout it mysql-proxy-cache.lua