Building Analytics at 500px

#1

Post by titanas » Wed, Sep 30, 2015, 9:52 PM UTC

Re: Building Analytics at 500px

#2

Post by lexicography » Thu, Oct 01, 2015, 2:48 AM UTC

This is such an awesome post. Samson shared the details of his data engineering work at 500px and Wish during a Keen IO event last night. His slides are here -> https://keen.io/blog/130230045601/analytics-startups-and-lau...

Re: Building Analytics at 500px

#3

Post by hanklazard » Thu, Oct 01, 2015, 3:14 AM UTC

Wow, this post is incredible--I can't thank the author enough for writing it! It's so thorough and has so many pieces of wisdom to offer in building a complete analytics solution from top to bottom. I'll be returning to this often.

Re: Building Analytics at 500px

#4

Post by potatosareok » Thu, Oct 01, 2015, 3:43 AM UTC

Thanks a lot for a detailed post. 20gb of log to not seem like much though? Not really sure of 500px scale. Fully conceding that at my company probably are logging too much, I'm wondering what takes ETL pipeline 4hr to run over that. Is just no need to optimize it since there's no benefit to have these metrics real time? Or am I missing some really data heavy part. Again not trying to be negative just wondering.

Luigi seems cool, can anyone comment on it compared Airflow or Spring XD, or is are those just different products.

Periscope looks like Kibana for relational stores, also cool to see.

Thanks again for great post!

Re: Building Analytics at 500px

#5

Post by pboutros » Thu, Oct 01, 2015, 3:52 AM UTC

I really appreciate the amount of time - and honesty - that went into this post. The author really sounds like they have their head firmly on their shoulders. Thanks, Samson!

Re: Building Analytics at 500px

#6

Post by jasoon » Thu, Oct 01, 2015, 4:26 AM UTC

Great post, and a nicely detailed read. This also came up on HN a few months ago (https://news.ycombinator.com/item?id=9760606), with some interesting alternatives to some of the presented tech in the comments.

Re: Building Analytics at 500px

#7

Post by Wagthesam » Thu, Oct 01, 2015, 5:18 AM UTC

potatosareok wrote: post #4

Thanks a lot for a detailed post. 20gb of log to not seem like much though? Not really sure of 500px scale. Fully conceding that at my company probably are logging too much, I'm wondering what takes ETL pipeline 4hr to run over that. Is just no need to optimize it since there's no benefit to have these metrics real time? Or am I missing some really data heavy part. Again not trying to be negative just wondering. Luig…

Its not a lot of data, but the biggest constraints to me were cost time to implementation. You could actually get an amazon memory intensive server and do it all in memory, but I didn't have those resources. ETL + a Redshift server in the end cost me around $5000 a year, which is TINY compared to the value we got out of it and the cost that most companies pay.

Re: Building Analytics at 500px

#8

Post by Wagthesam » Thu, Oct 01, 2015, 5:23 AM UTC

Author here

I'll follow up and say that my first three months in SF/Bay area have been amazing. This is truly the capital of technology here. The level of talent and the one-ness of the community goes beyond anything that exists in Canada. I'm excited to take what I lear back one day.

Send me questions via email shanzhen.hu at gmail.com if you have any questions about the process. I'm happy to help.

Re: Building Analytics at 500px

#9

Post by potatosareok » Thu, Oct 01, 2015, 5:48 AM UTC

Wagthesam wrote: post #7

potatosareok wrote: post #4

Thanks a lot for a detailed post. 20gb of log to not seem like much though? Not really sure of 500px scale. Fully conceding that at my company probably are logging too much, I'm wondering what takes ETL pipeline 4hr to run over that. Is just no need to optimize it since there's no benefit to have these metrics real time? Or am I missing some really data heavy part. Again not trying to be negative just wondering. Luig…

Its not a lot of data, but the biggest constraints to me were cost time to implementation. You could actually get an amazon memory intensive server and do it all in memory, but I didn't have those resources. ETL + a Redshift server in the end cost me around $5000 a year, which is TINY compared to the value we got out of it and the cost that most companies pay.

Makes sense I'm used to physical servers with tons of ram at work. If you don't mind, and I assume you're on Amazon entirely then, what size instances/how many are you using for the ETL(luigi) nodes? And do is there any infrastructure besides s3 (mysql dump, logs) => amazon instances (luigi) => redshift being involved?

Re: Building Analytics at 500px

#10

Post by gricardo99 » Thu, Oct 01, 2015, 6:08 AM UTC

Very good post. So great to get this kind of detailed insights into the whole process: requirements, trade offs, architecture and implementation decisions, impact across the whole business and the end result and added value.