nosql 与 rdbms 硬件规格
一般认为,RDBMS 的垂直扩展能力更好,而 nosql 是专门为水平扩展而设计的。
什么样的数据库更适合这种硬件 http://www.dell.com/us /enterprise/p/dell-compellent-storage-center/pd.aspx
可扩展到数百 TB。
由于 nosql 数据库通常设计为在商品服务器上运行,那么考虑到数据库的负载非常高,该商品服务器的规格应该是什么。
RDBMS 硬件节点的限制是什么……考虑到有足够的 RAM 可以始终在内存中保存索引(而不是数据集)。
而NOSQL对RAM中的索引没有硬性要求(但当然是推荐的)。
了解什么最适合 SAN 设备也很有趣? 就像 http://www-03.ibm.com/systems/ storage/disk/ds3500/index.html 可以在同一位置容纳数百 TB。
Generally its believed that RDBMS scales better vertically while nosql are designed specifically to scale horizontally.
What kind of databases would be better fit for this kind of hardware
http://www.dell.com/us/enterprise/p/dell-compellent-storage-center/pd.aspx
which can scale up to many hundred TBs.
As nosql databases are typically designed to be run on commodity servers then what should be the specs of that commodity server considering a very high load on database.
And what would be limit of RDBMS hardware node.. considering that enough RAM is available to have indexes (not dataset) in memory all the time.
While NOSQL has not hard requirement of indexes in RAM (but of course its recommended).
It would be also very interesting to know what are best fit for SAN devices?
like http://www-03.ibm.com/systems/storage/disk/ds3500/index.html which can hold many hundred TBs at same place.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
是使用 NoSQL 数据库还是使用关系数据库的决定应该来自您的用例/应用程序,而不是您的硬件。分析您的用例,确定是使用 RDBMS 还是 NoSQL 数据库(如果是 NoSQL,那么使用哪个 NoSQL 数据库是另一个关键问题,其答案将再次取决于您的用例)。然后购买运行您所决定的功能所需的硬件。
您链接到的机器可以运行 RDBMS 和 NoSQL,具体取决于您需要如何处理数据。对于 MongoDB 和 HBase,商用服务器通常意味着具有 16-24GB RAM 的 4 核机器。仅当集群上至少有 6-7 台机器后,HBase 才会开始显示良好的结果。对于其他 NoSQL 数据库,情况可能有所不同。
The decision whether to use NoSQL databases or to use Relational databases should come from your use case/application rather than your hardware. Analyze your use case, determine whether to use RDBMS or NoSQL Database (If NoSQL, then which NoSQL database to use is another crucial question, the answer to which will again depend on your use case). Then buy hardware which would be needed to run what you have decided.
The machine you link to can run RDBMS and NoSQL both, depepnding on what you need to do with your data. In case of MongoDB and HBase, commodity servers generally means 4-core machines with 16-24GB RAM. HBase starts showing good results only after you have at least 6-7 machines on your cluster. In case of other NoSQL DBs it might be different.