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

问题描述

根据我的理解，目前有很多关于 NoSQL 的讨论，Mongodb 就是其中之一，在我看来，NoSQL 似乎是 SQL，只是与我们了解 mySQL 的意义不同.

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 数据库更快，否则它会慢得多(即使这样你也不会遇到什么问题).对于大多数 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屋！