Geek Answers Handbook

Horizontal scaling in traditional DBMS

I just came across NoSQL systems with all of their divine benefits. One of them, apparently, is an easy horizontal scaling. My question is: why not a classic DBMS like MySQL or SQL Server capable of horizontal scaling? Or unable to do this to the same extent as NoSQL systems?

+4
source share
3 answers

There are many reasons. Here is one of them:

Horizontal scaling is usually achieved by shards - this object is stored on one host in a cluster defined by some function of this object. Shard compounds are extremely ineffective, if possible at all. A traditional DBMS relies on data that can be combined when combined, which often prevents efficient scalding.

0
source

I take another stub from @joews on it.

. . NoSQL, Lucene, , ( ). .

, Facebook, MySQL . , , , , MySQL / . , ?

, , , Dremel, Apache Drill Presto.

, NoSQL , CAP. : ( ), ( , ..). NoSQL : http://www.youtube.com/watch?v=qI_g07C_Q5I

, , .. , . /, ! , NoSQL, .

0

:

1) , RDBMS node = >

2) = >

1) , JOIN

2) , "" Java, JTA, article JEPLayer, ORM

Of course, your problem may be the sum of 1) and 2)

0
source

More articles:


All Articles