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)
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