知识卡片
数据库隔离包含资源层
同一数据库服务器上的独立 schema 可以隔开表与数据,但 CPU、容量和故障域仍共享;报表查询占满资源时,关键交易服务也会受影响。评估数据库隔离需同时检查数据边界和基础设施边界。
这张卡片看不懂?
这张卡片的反馈已满 10 条,暂时无法继续提交。
已有反馈 · 0 / 10 条
还没有人提交反馈。
原书出处
参考来源
- 位置:《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.