News for hackers. Stuff that matters.
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by Nitramp on Saturday September 27, 2014 @08:09AM (#8376788)
Is MongoDB's distribution and scaling story really nicer? A cluster story that's easy to set up but then doesn't actually work (loses data, fails in potentially catastrophic ways) sounds not all that useful.

http://aphyr.com/posts/284-call-me-maybe-mongodb

Re:PostgreSQL Outperforms MongoDB in New Round of Tests by jpgvm on Saturday September 27, 2014 @08:53AM (#8376888)
MongoDB clustering is nothing short of disastrous.

If anything I hope databases like RethinkDB and even multi-master PostgreSQL if we ever see it learn from the most crucial mistake here - rolling your own consensus. (This goes for databases other than MongoDB, I don't meant to single it out here)

Stick to proven algoritms, ZAB, Paxos, Raft.

Re:PostgreSQL Outperforms MongoDB in New Round of Tests by chaostheory on Saturday September 27, 2014 @11:34PM (#8378845)
Mongodb is easy to setup as a single instance, but it is definitely no easier to setup for horizontal scaling compared to alternatives. I'm still not aware of anything that's both simple to setup and maintain for horizontal scaling in practice (not theory).
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by pas on Sunday September 28, 2014 @03:36PM (#8380695)
Cassandra is, but you're forced into a very simplistic data (sharding) model. (And probably Riak is too, but haven't used it.)
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by chaostheory on Monday September 29, 2014 @12:46AM (#8381727)
Cassandra is easier to scale than mongo, and yeah Riak is even easier, but they're still not easy unless you don't care as much about consistency and you can wait, and if your app is more about writes than reads.
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by craigching on Saturday September 27, 2014 @08:56AM (#8376894)
It depends on your workload, but MongoDB has worked extremely well for us, we've never lost data. I love aphyr's posts on databases, but you can't use them as a blanket for everything.
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by nemothekid on Saturday September 27, 2014 @01:49PM (#8377668)
Just because you haven't had a failure yet, it doesn't make the test any less true.
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by craigching on Saturday September 27, 2014 @02:32PM (#8377778)
Three years? Numerous customers? That's good enough for me so far.
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by nemothekid on Saturday September 27, 2014 @05:43PM (#8378301)
C'mon you know that isn't fair reasoning, you could say the same about running backups. Just because someone hasn't seen the need for backups for three years after numerous customers doesn't mean thats a good enough reason to not keep backups.

I'm not saying you shouldn't use Mongo, but to say Aphyr's assessment of database shouldn't be considered in all deployments isn't wise.

Re:PostgreSQL Outperforms MongoDB in New Round of Tests by craigching on Saturday September 27, 2014 @11:37PM (#8378850)
I'm not saying Aphyr's work isn't useful, it's the right tool for the job. For our needs and uses, it's been spectacular. I want to use Postgres, but it's HA isn't something I'm willing to expose to my customers. So I'm actually using MongoDB in anger ... and it's doing spectacular.

So let me leave off with our use case. We have few writes, little need for sharding (our largest customers run on a single node and keep the hot data in memory), we use acknowledged writes (MongoDB can be journaled you know), and our customers are willing to have three + nodes in an HA scenario. The HA is simple to configure. So far in three years we have no data loss.

What more information can I provide to make up for the downvotes?

As an aside, downvotes to me should be used for those that contribute nothing to a conversation. If you disagree with what someone says, state your disagreement so that we all, including me, can benefit from your better experience.

Re:PostgreSQL Outperforms MongoDB in New Round of Tests by Nitramp on Saturday September 27, 2014 @03:44PM (#8377976)
Have you actually tested a net split situation, or a crash, or what it'd take to recover?
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by craigching on Saturday September 27, 2014 @05:33PM (#8378277)
Yep, sure have. And you still need backups of your data, that's just good sense.
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by craigching on Saturday September 27, 2014 @11:31PM (#8378842)
Nitramp, I'm sorry you disagree with my experience. But instead of downvoting, why don't you contribute to the conversation with your own experience? At least my experience is taken from the real world and not from something I read on the internet.
Re:PostgreSQL Outperforms MongoDB in New Round of Tests by craigching on Saturday September 27, 2014 @11:29PM (#8378839)
Ok, granted, my experience is an anecdote, but downvoting me without disputing what I'm saying? Pure cowardice. At least counter with your own anecdote, don't downvote. Or let me know why I'm being downvoted, simply disagreeing shouldn't result in a downvote, that just kills the conversation.