[erlang-questions] Postgresql vs Mnesia vs Couchdb

[G.S.]

Hello everyone,

Anyone ever ran a benchmark against these 3 dbs to see which ones scale
better to terabyte scale? Also, are there any well known projects in Erlang
that are similar to Dynamo?
Also, what does everyone suggest one uses for a db if one knows that that db
might grow to be huge, I've heard that mnesia does not scale that well.

Thanks,
-Gene

[Sean Cribbs]

Dynomite is a Dynamo clone written mostly in Erlang:
http://github.com/cliffmoon/dynomite

Your question about benchmarks and scalability is rather vague. Are you
looking for throughput, availability, reliability, or some other
factor? Also, you cite three very different databases, that have
different purposes. I think a better question would be "which one is
appropriate for the application I'm building?"

Cheers,

Sean

________________________________________________________________
erlang-questions mailing list. See http://www.erlang.org/faq.html
erlang-questions (at) erlang.org

[G.S.]

I'm interested in throughput and reliability.

[G.S.]

Thanks for the link, that will work.

On Sun, Jun 21, 2009 at 11:30 PM, Chris Anderson <jch...@apache.org> wrote:

> On Sat, Jun 20, 2009 at 6:28 PM, G.S.<cortical...@gmail.com> wrote:
> > I'm interested in throughput and reliability.
> >
>

> Even knowing that suggests that you need to look closely at your
> application needs. All three of the databases have throughput and
> reliability, depending on the use. Are you planning to write to
> multiple masters? Do you need offline replication? What sort of
> queries do you need to run?
>
> This page might be a helpful resource:
> http://blog.oskarsson.nu/2009/06/nosql-debrief.html

> --
> Chris Anderson
> http://jchrisa.net
> http://couch.io
>

[Rapsey]

You may want to take a look at mongodb:
http://www.mongodb.org/display/DOCS/Home

It has pretty good documentation, is fast as hell and also has an erlang
driver.

Sergej

[Sergey Samokhin]

Hi!

Take a look at this article written by Richard Jones:

http://www.metabrew.com/article/anti-rdbms-a-list-of-distributed-key-value-stores/

Hope it will help you to decide which DB you need.

--
Sergey Samokhin

[Wojciech Kaczmarek]

On Sat, Jun 20, 2009 at 23:03, G.S. <cortical...@gmail.com> wrote:

> Hello everyone,

Hi,

One of the basic questions is what fits your architecture more: the
distributed commit or the different approach: replicating data between the
nodes which are possibly offline. If the latter it's how CouchDB naturally
works. If the former, you have it for free in Mnesia (but retrieving data
from offline nodes is a nightmare).

I guess answering this question is much more important than benchmarks
(which usually are not relevant to *your* problem domain anyway) as it
determines how your infrastructure will be built and maintained.

cheers