MYSQL 集群 (NDB) 与 MongoDB

发布于 2024-12-07 14:56:22 字数 148 浏览 0 评论 0 原文

MYSQL Cluster (NDB) 与 MongoDB 相比如何?看起来,虽然 NDB 和 Mongo 都支持在商用机器节点上横向扩展,但 NDB 还提供所有关系功能,例如 JOIN、事务等......

因此,在什么情况下人们会选择 Mongo 而不是 NDB?

How does MYSQL Cluster (NDB) compare against MongoDB? It seems that while both NDB and Mongo supports scale out over commodity machine nodes, NDB also provides all the relational capabilities such as JOINs, transactions, etc...

Therefore, under what situations would one choose Mongo over NDB?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

著墨染雨君画夕 2024-12-14 14:56:22

尽管 MYSQL Cluster NDB 是一种无共享方法,可以跨商用机器扩展关系数据库,但仍然存在限制和对性能的影响。您可以在下面的链接中阅读完整的详细信息,但是 NDB 不支持一些更重要的功能,例如外键,这可能会让您质疑如果您必须给出,为什么要首先对 RDBMS 进行集群增加一些您希望利用的功能。

18.1.5.1 NDB 和 NDB 之间的差异InnoDB 存储引擎

href="https://stackoverflow.com/questions/1980484/what-are-limitations-of-implementing-mysql-ndb-cluster">实施 MySQL NDB Cluster有 关系型背景,像 MongoDB 这样的东西最初并没有让我感兴趣,但经过几周的修修补补,我惊讶地发现,在不受传统模式准则和关系数据库带来的事务开销约束的情况下,它的可能性有多大。如果您确实想要真正的水平可扩展性,并且愿意放弃联接和外键的奢侈,那么您应该认真考虑使用 Mongo 或属于 NoSQL 类别的类似内容。

Even though MYSQL Cluster NDB is a shared-nothing approach that scales a relational database across commodity machines, there are limitations and impacts to performance. You can read the full details at the link below, but some of the more important features are just not supported in NDB, such a foreign keys, which may make you question why you would cluster a RDBMS in the first place if you have to give up some of the features you're expecting to leverage.

18.1.5.1 Differences Between the NDB and InnoDB Storage Engines

What are the limitations of implementing MySQL NDB Cluster?

I come from a relational background, and things like MongoDB did not initially click with me, but after tinkering with it for a few weeks, I was surprised at how much is possible while not being subject to traditional schema guidelines and transactional overhead that comes with relational databases. If you really want true, horizontal scalability and are willing 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.

稀香 2024-12-14 14:56:22

如果您想保留 sql/关系数据库结构,请使用 NDB。
如果您想构建结构上更具层次结构的数据,您应该使用 mongodb。

If you want to keep your sql/ relational database structure then go with NDB.
If you want to build data that is a little more heirarchial in structure you should go with mongodb.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文