All geek questions in one place

MYSQL Cluster (NDB) vs MongoDB

How does the MYSQL (NDB) cluster compare with MongoDB? It appears that while NDB and Mongo support scaling over nodes of commodity machines, NDB also provides all relational capabilities such as JOINs, transactions, etc.

Therefore, in what situations could Mongo be chosen over NDB?

+6
source share
2 answers

Although MYSQL Cluster NDB is a general approach that scales the relational database on commodity machines, there are limitations and performance implications. You can read the full information at the link below, but some of the most important functions are simply not supported in NDB, such foreign keys, which may provoke why you should group RDBMS in the first place, if you need to give some of the functions that you expect use.

18.1.5.1 Differences between NDB and InnoDB Storage Systems

What are the limitations of implementing an NDB MySQL cluster?

I come from a relational background, and things like MongoDB did not initially click on me, but after months of working with it, I was surprised as much as possible if you are not subject to the traditional scheme rules and the transaction overhead that comes with relational databases data. If you really need true horizontal scalability and are ready to give up the luxury of joins and foreign keys, you should seriously consider using Mongo or something similar that falls under the NoSQL category.

+6
source

If you want to keep the sql / relational database structure, go to NDB. If you want to build data that is slightly more hierarchical in structure, you should go with mongodb.

+2
source

Source: https://habr.com/ru/post/898505/

More articles:


All Articles