MySQL Forums
Forum List  »  Router & Proxy

Does MySQL-Proxy support caching
Posted by: Alex Todorov
Date: October 03, 2013 02:24PM

Hi guys,
I just discovered MySQL-Proxy and it looks like what I need. What I need is to:

* When a client makes a select query (application is redirecting writes to a master server) data will be read from the master and also kept locally at the proxy

* When a second request for the same data comes then data is served from the local copy.

* If there is another select which partially matches the same data only the bits missing will be read from the master.


Essentially to cache queries (read ones) and serve them from memory instead of connecting again to the master DB server. Is this supported?

I'm asking because I didn't see any caching options in the docs and because I also found this project https://github.com/clofresh/mysql-proxy-cache.

Options: ReplyQuote


Subject
Views
Written By
Posted
Does MySQL-Proxy support caching
5470
October 03, 2013 02:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.