我应该使用mySQL还是MongoDB [英] Should I be using mySQL or MongoDB

问题描述

根据我的理解，目前有很多关于NoSQL的讨论，Mongodb是其中之一，对我而言，NoSQL似乎与我们对mySQL的理解不同，这就是SQL.

There is alot of talk at the moment about NoSQL from my understanding Mongodb is one of them, to me the NoSQL seems that it is SQL just not in the same sense that we know mySQL.

这样想，他们俩都存储数据，一个是通过一个具有所谓限制的固定数据库来完成的，而另一个则认为是存储数据的最佳时间而可存储的数据却没有限制或很少的时候就存储了数据.

Think of it this way, they both store data, one does it by a fixed database with so called limits while another stores data when it thinks it the best time to store data and supposable has not limits or very few.

但是，这会使正在进行切换或正在考虑进行切换的Web开发人员感到困惑.以我为例，我在一家大型电信公司工作，需要像这样进行切换，这是需要真正考虑的事情，而我们不能依靠没有实质意义的话来传达信息.

However this is confusing to web developers who are making the switch or thinking about making the switch. In my case I work for a big teleco company and making a switch like this is something that needs to be really looked at, and we cant relay on something that has no physical being so to say.

也许我不了解NoSQL的含义，也许我的意思正确.

Maybe I am not understanding the meaning of NoSQL, maybe I have the meaning correct.

目前我正在重写我们使用的整个CMS，很高兴知道我是否应该花时间看一下noSQL或保留MySQL(这似乎没有任何问题，时刻)

I am in the process at the moment re-writing the whole CMS that we use, and would kinda be nice to know should I spend the time looking at noSQL or keep MySQL (which does not seem to have any issues that the moment)

我们在客户详细信息中只有5000行，而在备份中有14000行，它被备份，以防万一主表决定搞砸.

We only have 5000 rows in the customer details and in the backup with have 14000, it gets backed up just incase the master table decides to screw up.

推荐答案

有了这样的数据，MySQL不会成为问题. NoSQL db是为大型数据集而设计的，并且设计的完全不同(在NoSQL中可以做的所有事情，在sql db中也可以做的一切).

With such data, MySQL wouldn't be a problem. NoSQL db are designed for large data sets, and are quite different designed(everything you can do in NoSQL you can also do in sql db).

此外，NoSQL的管理难度要大得多. Cassandra需要正确的配置，以使其比普通的MySQL db更快，否则，它的运行速度会慢得多(即使那样，您也可能遇到一些问题).对于大多数NoSQL，您需要VPS/专用人质.

Besides, NoSQL are far more harder to administrate. Cassandra needs right config to be faster than normal MySQL db, if not it is much slower(and even then you can have few problems with it). And for most NoSQL you need VPS/dedicated hostage.

这篇关于我应该使用mySQL还是MongoDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！