知识卡片
迁移后同时核对结构数据与行为
新库就绪不能只看仪表板绿灯;须检查表、列、索引、配置、行数及代表性记录校验和,再核对成功率、错误和延迟。大规模数据抽样只能提供证据,不能替代必要的全量对账。
这张卡片看不懂?
这张卡片已通过人工审查,不再接受失败反馈。
已有反馈 · 0 条
还没有人提交反馈。
原书出处
参考来源
- 位置:《Principles of Software Architecture Modernization》第10章《Data Migrations》(源文件:`_epub-src/OPS/ch10.xhtml`,归一化正文 [46385:50610))
- 结论依据:原文列出迁移后结构与数据检查,建议用计数和哈希抽查。
- 原始内容:Now you need to verify the sanity and consistency of your new database structure and data. Let us say you are migrating a relational database like a self-hosted Postgres cluster to RDS Postgres. You will want to check: Tables sanity: All tables were migrated: 100 tables in Postgres == 100 tables in RDS Postgres. All columns, rows, indexes, and configurations are present as expected.