Data Storage at foursquare
- June 22, 2011 · 6:30 PM
Following up on our outstanding discussion last month about the comparision between MySQL and PostgreSQL, we have a great discussion by Jon Hoffman about "Data Storage at foursquare." Foursquare is a location-based mobile platform that makes cities easier to use and more interesting to explore by "checking in."
foursquare by the numbers (last updated April, 2011)
- Users: Over 8 million worldwide, adding around 35,000 new users each day
- Check-ins per day: Over 2.5 million, with over half a billion check-ins in the last year
- Businesses: Over 250,000 using the Merchant Platform (more information at foursquare.com/business)
foursquare started off on MySQL, switched to PostgreSQL, and is now split between PostgreSQL and MongoDB with the majority of the data in MongoDB.
This talk will include:
- Reasons for the move
- Trade-offs made
- Logistics of performing the migration
- MongoDB and PostgreSQL war stories
-
-
-
Harry T
Foursquare shared their downfalls and their reasons for using mongoDB. A very informative session.
June 23, 2011
-
Anil
Thanks to the organizers (Mason, Jim and Jon) for facilitating such interesting events.
June 23, 2011
-
A former member
It was good, nice to see the different ways people use the bigdata stack, It was an excellent usecase. Nice presentation...
June 23, 2011
-
A former member
Great talk, fun to attend. Fun crowd.
June 23, 2011
-
-
-
-
People in this
Meetup are also in:
-
-
NYC Amazon Web Services User Group & Forums
1,110 People interested in Cloudins
-
-
-
Algorithms and Data Structures
1,547 Developers
-
nodejs
1,456 Noders
Join or login to comment.