Mork0075 wrote:
Hello,
can someone please explain oder point me to some documentation or
papers, where i can read well proven facts, why scaling a relational db
is so hard and scaling a document oriented db isnt?
http://labs.google.com/papers/bigtable.html
relational dbs are great for having lots of structured data, where you
can run SELECT operations, do O/R mapping to make them look like
objects, etc. Its one thing to back up, and you get transactions.
They're bad places to store binary data, or, say, billions and billions
of rows of web server log data
by relaxing some of the expectations of a relational db, things like
bigtable, hbase and others can scale well, but as they have relaxed the
rules, may not do everything you want.
So perhaps if i got lots of requests to my relational db, i would
duplicate it to several servers and partition the requests. So why this
doenst scale and why HBase for instance could manage this?
That's called sharding/horizontal partitioning.
It works well if you can partition all your data so that different users
can go on different places. though once you've done that. you cant think
about JOIN-ing stuff from multiple machines.
The alternative option (which is apparently common in places like
myspace and imdb) is to or have one r/w master and a number of read only
slaves. All changes go into the master, the slaves pick the changes later
I'am really new to this topic and would like to dive in deeper.
check out the articles in http://highscalability.com/
-steve