知识卡片

普通读书笔记卡 · 3423

导出导入需处理停机与增量追平

理解等级:中级

导出导入适合做初始全量搬迁,但导入期间源库仍变化时会出现差异。需要明确停机窗口,或结合 CDC、双写、表差异等方式追平增量后再切换。

这张卡片看不懂?

已有反馈 · 0 / 10 条

    还没有人提交反馈。

    原书出处

    参考来源

    - 位置:《Principles of Software Architecture Modernization》第10章《Data Migrations》(源文件:`_epub-src/OPS/ch10.xhtml`,归一化正文 [16900:21101)) - 结论依据:原文指出导入可能锁表和需要停写,并建议与其他增量同步方式组合。 - 原始内容:Exporting and importing has a few obvious drawbacks: Offline: Typically, the generated statements are destructive; they lock tables, and can take a lot of physical resources to execute. Plus, you do not want new records being added or changed while you are importing. For maximum safety, you need to take both databases offline. Locked data persistence technology: SQL is universal, but not all databases work the same way.