Building Analytics at 500px

Re:Building Analytics at 500px by Wagthesam on Thursday October 01, 2015 @01:18AM (#10309369)

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.

[ Parent | on HN ]

Re:Building Analytics at 500px by potatosareok on Thursday October 01, 2015 @01:48AM (#10309456)

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?

[ Parent | on HN ]

Re:Building Analytics at 500px by Wagthesam on Thursday October 01, 2015 @02:11AM (#10309511)

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

[ Parent | on HN ]

Re:Building Analytics at 500px by Wagthesam on Thursday October 01, 2015 @03:39AM (#10309767)

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.

[ Parent | on HN ]