在同一个项目中运行多个数据库是否是好事？ [英] Is it good to have multiple database running in a same project?

问题描述

我已经读过许多数据库设计书籍，但所有人都只使用一个数据库来处理项目。
但是我想知道有一个好主意，让多个数据库处理同一个项目？

I had read many database design books, but all of them use only one database to deal with a project. But I was wondering that is that a good idea to have multiple database dealing with the same project?

推荐答案

不是真的。

在某些情况下，它是必需的或甚至是理想的，但这些是针对特定用例的。

There are certainly circumstances where it's required or even desirable, but those are for specific use cases.

一般你不想结合关系完整性（难以跨数据库强制执行）和事务完整性。必须有一个真正令人信服的理由来拆分数据集，以增加单独的数据库实例的复杂性和维护。

In general you don't want to for a combination of relational integrity (difficult to enforce across databases) and transactional integrity. There would have to be a really compelling reason to split the datasets to incur the added complexity and maintenance of a separate database instance.

这篇关于在同一个项目中运行多个数据库是否是好事？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！