Database migration method, apparatus, device, medium, and program product

By obtaining the high and low water level information of the source database, the scope of the migration transaction can be accurately determined, which solves the problem of low database migration efficiency in the existing technology and realizes a high-efficiency and low-resource-consumption database migration process.

CN122111979APending Publication Date: 2026-05-29CETC JINCANG (BEIJING) TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
CETC JINCANG (BEIJING) TECH CO LTD
Filing Date
2026-01-23
Publication Date
2026-05-29

AI Technical Summary

Technical Problem

Existing database migration solutions are inefficient during seamless migration, especially in large-scale database migrations, where they suffer from high resource consumption, long migration times, and complex conflict handling.

Method used

By obtaining the high-water mark and low-water mark information of the source database, the start and end positions of the migration transaction are accurately determined. Only data changes within the high-water mark and low-water mark intervals are processed, avoiding full log scanning, reducing resource consumption and computational overhead. The process involves direct synchronization after the high-water mark and ignoring operations before the low-water mark, while handling conflicts between the high-water mark and low-water mark.

Benefits of technology

It improved the efficiency of database migration, reduced the frequency of conflicts, reduced resource consumption and computing overhead, and ensured data consistency and business continuity.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN122111979A_ABST
    Figure CN122111979A_ABST
Patent Text Reader

Abstract

Embodiments of the present application provide a database migration method, device, equipment, medium and program product. The method comprises: in the process of migrating inventory data of a source database to a target database, obtaining high-water mark information and low-water mark information of to-be-migrated data in the source database; the source database is a MySQL database; the low-water mark information is used to represent a starting position of a migration transaction; the high-water mark information is used to represent an ending position of the migration transaction; and based on the high-water mark information and the low-water mark information, incremental data of the source database is synchronized to the target database. The method is used to improve the efficiency of database migration.
Need to check novelty before this filing date? Find Prior Art