Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need to reduce the value of "write per second" and "read per second" on MySQL (this is for statistics: total views of post).

Can Memcached doing this job?

Thanks

share|improve this question

2 Answers 2

Memcache cannot control traffic. What you can do is MySQL cluster with load balancer.

Memcache is accelerator for MySQL with key-value store

share|improve this answer

Memcached doesn't have any such controls. You probably need some form of proxy server to sit in between your program calling MySQL and MySQL server itself. Check out MySQL Proxy:

http://forge.mysql.com/wiki/MySQL_Proxy

Lua is a pretty straight forward language and you can probably implement exactly what you're looking for.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.