Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Building Analytics at 500px

medium.com

Post reply on HN
Print view View original

11–17 of 17 posts

Re: Building Analytics at 500px

#11

Post by Wagthesam »

potatosareok wrote: post #9
Wagthesam wrote: post #7

Earlier quoted context omitted.

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?

That is all there is. s3, one amazon instance for luigi which holds the mysql read replica, and amazon redshfit. There wasn't any heavy ETL in Luigi. Luigi mostly just extracted/dumped data. All the heavy lifting was in EMR

Re: Building Analytics at 500px

#14

Post by Wagthesam »

potatosareok wrote: post #9
Wagthesam wrote: post #7

Earlier quoted context omitted.

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?

Also to add. Logging too much should not be a problem if you are using it. Wish's hadoop log store is over 40tb compressed right now. And its worth every penny.

Re: Building Analytics at 500px

#15

Post by warbon123 »

It is quite interesting post. I have been working in a scenario where the company is moving out of traditional Oracle based BI stack and this post just highlights how opex for BI can be reduced drastically.

Re: Building Analytics at 500px

#16

Post by Jgrubb »

Wagthesam wrote: post #8

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.

Just wanted to say thanks for this writeup. I read it the last time on here and it was definitely inspirational.

Re: Building Analytics at 500px

#17

Post by samuell »

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…

Luigi creator Erik Bernhardsson has posted some notes on Luigi vs Airflow & more:

http://erikbern.com/2015/07/02/more-luigi-alternatives/

... and Pinball:

http://erikbern.com/2015/03/14/pinterest-open-sources-pinbal...

Post reply on HN