This repository has been archived by the owner. It is now read-only.
A protocol-level caching layer for mysql
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
LICENSE
README
mysql-proxy-cache.lua

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