知识卡片

普通读书笔记卡 · 3430

迁移后同时核对结构数据与行为

理解等级:高级

新库就绪不能只看仪表板绿灯;须检查表、列、索引、配置、行数及代表性记录校验和,再核对成功率、错误和延迟。大规模数据抽样只能提供证据,不能替代必要的全量对账。

这张卡片看不懂?

已有反馈 · 0 / 10 条

    还没有人提交反馈。

    原书出处

    参考来源

    - 位置:《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.