database - 意见 : Reason to use NoSQL

Question

我从 friend 那里得到了关于 NoSQL 的两个意见。

第一:使用 NoSQL 来提高性能并保存偶尔更新的数据。仍然使用sql保存所有重要的dan交易数据。

第二:如果您真的不需要，请不要使用 NoSQL。如果你真的保存大数据，就用它。

我使用过 NoSQL，它在选择数据时速度非常快。

我想知道，第一意见是否足以实现 NoSQL？大家对这些怎么看？

注意:在我的例子中，它仍然可以很好地运行 SQL。我想添加 NoSQL 以提高数据读取速度。所以它会一起工作。

这么早使用 NoSQL 值得吗？

提前致谢

Answer 1

这取决于您的设计。

根据我扩展数据收集的经验，我发现传统的关系存储是一个瓶颈，因为当数据库变得非常大时，它无法在多个节点上扩展。当然它会扩大规模，但在某些时候这会变得成本过高。因此，在这种情况下，它将取决于您的中长期数据存储预测。因此，对我来说，解决方案是将关系存储用于可能经常更新的数据，并结合使用 noSQL(文档存储)用于数据的快速增长，通常不会在写入后更新。

注意事项:

查询

SQL relational storage supports a growing subset languages for queries, as well as a wide range of filters, sorting options, and projections and index queries. NoSQL does all this as well, but SQL can often go beyond it, allowing powerful aggregations of your data as well, beyond what NoSQL can do.

交易

Transactions are important because they ensure that you have atomically made changes to your database. Many NoSQL platforms don’t support transactions, so be aware of this feature when you’re figuring out which to use, and what your own needs are.

一致性

MySQL platforms often use a single master to guarantee strong consistency in your database. These use synchronous replication to ensure you don’t lose important changes queued up to the master. NoSQL, by contrast, does replication of entity groups without a master, so that data is strong within an entity group, and is eventually updated across all groups. The better option depends on the constraints and needs of your database.

可扩展性

For years, database administrators relied on scaling up, buying bigger servers as database load increased. However, as transaction rates and demands on the databases continue to expand immensely, emphasis is on scaling out instead. Scaling out is distributing databases across multiple hosts, and that’s something NoSQL does better than standard SQL. They’re designed for optimal use on scaled out databases.

管理

NoSQL databases are generally designed to require less management overall. Repairs are often automatic, and data distribution and simpler data models contribute to less administration required overall. However, you’ve also got less support when there’s a problem. SQL platforms often have vendors waiting to supply support to enterprises.

架构

Regular SQL platforms often have strictly enforced rules for a schema change, to stave off user-created typos that can put faults in your query. NoSQL platforms will have their own mechanisms for combating this.

希望对您有所帮助。