How to store count of number of requests on a server in a day?
<p>I have a condition where I need to count the number of requests coming on my HTTP server, aggregated by hour and request type.
For example - 
This is the kind of output data that I want to obtain if I have 3 unique resource requests</p>

<pre><code>Resource /a - 10 req between 10pm - 11pm, 13 req between 11pm - 12am
Resource /b - 14 req between 10pm - 11pm, 17 req between 11pm - 12am
Resource /c - 12 req between 10pm - 110m, 16 req between 11pm - 12am
</code></pre>

<p>There is no requirement for real time reporting. It can stand a delay of a couple of hours. I know I can achieve this by log parsing. But just wanted to know if there is a better way to store this kind of data. Lets say a real-time counter in Redis where the key is made using <code>url + hour</code> and dump it periodically lets say every 2 hours to some other DB. </p>