I'm writing an analytics tool which will essentially log every time a page is hit. The problem I have is the amount of impressions could become very high and I will potentially need to handle millions a day or at least ~300 a second (I've head people say they can achieve 10k per second). My current setup is php logging each time a page is accessed as an insert directly into MySQL innodb table, this is becoming slow and the server appears to miss a hit occasionally which isn't too bad for analytics but not ideal. My idea is to put memcache in the front and log all impressions to that first and then run a scheduled batching process which takes the impressions from memcache and then puts them into the db at a quiet period e.g. 3am. So my question is I'm writing an analytics tool which will essent