{"id":741,"date":"2009-11-09T20:33:32","date_gmt":"2009-11-10T03:33:32","guid":{"rendered":"http:\/\/xiehang.com\/blog\/?p=741"},"modified":"2009-11-09T20:33:32","modified_gmt":"2009-11-10T03:33:32","slug":"question-from-a-friend","status":"publish","type":"post","link":"https:\/\/xiehang.com\/blog\/2009\/11\/09\/question-from-a-friend\/","title":{"rendered":"Question from a friend"},"content":{"rendered":"<p>One of my friends asked me if this service is doable:<\/p>\n<ul>\n<li>Every hour multiple machines (clients) will send ~1M actions records to the service<\/li>\n<li>Each action contains: user id, action, action result, start time, end time, and couple of user profile keys<\/li>\n<li>The service should be able to deliver reports for any given time frame (minutes), within 15 min after the period finishes. For example, report for 3pm~3:30pm should be available by 3:45pm<\/li>\n<li>Reports include: how many users did a specific action with specific result (during that time frame), how many actions does a specific user did, and top number of actions taken by others users who did the same action as the user (hard to understand, but think about Amazon, &#8220;Customers bought this item also bought&#8230;)<\/li>\n<li>Most important thing is: all these requirements should be done on no more than 4 machines, include redundancy, which means should be done on 2 or 3 machines<\/li>\n<\/ul>\n<p>I have to say, this is a pretty common requirements for online services (shopping, search, gaming,&#8230; could be anything), and if I can make it and make the solution linear, then it will be pretty much interesting (let&#8217;s say, 40 machines supporting 10M actions per hour, a lot already).<\/p>\n<p>I will do some research (the nosql stuffs could well fit into this one), and post thinking\/design here.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of my friends asked me if this service is doable: Every hour multiple machines (clients) will send ~1M actions records to the service Each action contains: user id, action, action result, start time, end time, and couple of user profile keys The service should be able to deliver reports for any given time frame <a href='https:\/\/xiehang.com\/blog\/2009\/11\/09\/question-from-a-friend\/' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[47,73,34,133],"_links":{"self":[{"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/posts\/741"}],"collection":[{"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/comments?post=741"}],"version-history":[{"count":1,"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/posts\/741\/revisions"}],"predecessor-version":[{"id":742,"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/posts\/741\/revisions\/742"}],"wp:attachment":[{"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/media?parent=741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/categories?post=741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xiehang.com\/blog\/wp-json\/wp\/v2\/tags?post=741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}