5 ms·
This is a really fascinating presentation, and an easy read. The major conclusion is to think really carefully about abandoning a SQL database for noSQL. A litt
by geophile 15y ago
This is a really fascinating presentation, and an easy read. The major conclusion is to think really carefully about abandoning a SQL database for noSQL. A little more info on the postgres solution and their experience with replication would have been good.
- trustfundbaby 15y agoexactly ... I was hoping to hear how they finally made it work on Postgres, since they initially migrated from postgres to mongo
- schmichael 15y agoHorizontal scaling is key. If we had more faith in auto-sharding in MongoDB 1.6, that may have worked (however horizontal scaling wasn't our only issue with MongoDB). With PostgreSQL we manually partition the data (luckily we have a really nice key to partition on). PostgreSQL 9's streaming replication has been adequate so far. We've only been using it in production for a few months and recently moved off of AWS* which drastically reduced our error rates overall. * http://urbanairship.com/blog/2011/06/01/hybrid-cloud-were-up/ http://urbanairship.com/blog/2011/06/01/hybrid-cloud-were-up...
- jacquesgt 15y agoTotally off-topic here, but have you noticed that the body text size of your company's blog stays really small even when trying to zoom in? I've tried zooming in using Safari and Chrome, and with both of them the text stays so small that it's difficult to read.