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