返回主题:数据集成与分拆:一份真源与多份衍生

知识卡片

普通读书笔记卡 · 3359

数据库隔离包含资源层

理解等级:高级

同一数据库服务器上的独立 schema 可以隔开表与数据,但 CPU、容量和故障域仍共享;报表查询占满资源时,关键交易服务也会受影响。评估数据库隔离需同时检查数据边界和基础设施边界。

这张卡片看不懂?

已有反馈 · 0 条

    还没有人提交反馈。

    原书出处

    参考来源

    - 位置:《Principles of Software Architecture Modernization》第2章《Anti-Patterns: Lack of Isolation》(源文件:`_epub-src/OPS/ch02.xhtml`,归一化正文 [33636:37799)) - 结论依据:原文承认共享服务器可用 schema 隔开数据,同时以报表查询耗尽 CPU 为例说明基础设施层仍会相互影响。 - 原始内容:It is even possible to share the same database server and still have isolation via schemas in production; however, we would not advise using this in production because of availability and resiliency reasons. You reduce isolation by increasing the blast radius of a database failure. Figure 2.12: Shared database server - Isolated schemas/data In our example, the payments service is a critical service; if the payments service is down, the company cannot collect money and experiences a big business disruption.