Data migration method and device

A data and database technology, applied in the computer field, can solve the problems of clock synchronization and accuracy being difficult to ensure consistent and accurate, unable to meet the Internet business migration, high risk of data loss, etc., to control the migration progress, improve user experience, no data Lost and delayed effects

Inactive Publication Date: 2018-11-23
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF4 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the time precision (seconds or milliseconds) is different or the clocks of the two machines are not synchronized, it will cause data loss
In most cases, clock synchronization and accuracy are

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data migration method and device
  • Data migration method and device
  • Data migration method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments, but not as a limitation of the present invention.

[0035] figure 1 An exemplary system architecture 100 to which the data migration method or data migration device of the embodiment of the present invention can be applied is shown.

[0036] Such as figure 1 As shown, the system architecture 100 may include terminal devices 101 , 102 , 103 , a network 104 and a server 105 . The network 104 is used as a medium for providing communication links between the terminal devices 101 , 102 , 103 and the server 105 . Network 104 may include various connection types, such as wires, wireless communication links, or fiber optic cables, among others.

[0037] Users can use terminal devices 101 , 102 , 103 to interact with server 105 via network 104 to receive or send messages and the like. Various communication client applications can be installe...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to a data migration method and device. The method comprises a total synchronization process, and in addition, further can comprise an incremental synchronization process based ona binlog mechanism. Through the method, loss-free migration of database data can be realized, and the migration performance is improved. The method comprises the steps of synchronizing the total datain a source database to a new database; in the total synchronization process, monitoring the change condition of the data in the source database, and if the data in the source database is changed, updating the corresponding synchronized data in the new database; and calculating a migration rate according to user dimension, and when the data migration rate of a user reaches 100%, switching the database corresponding to the user from the source database to the new database.

Description

technical field [0001] The invention relates to the field of computers, in particular to a data migration method and device. Background technique [0002] With the continuous emergence of Internet-related businesses, some businesses have developed rapidly, and the original database storage and table structure design can no longer meet the needs of the business. In order to meet the normal development of business and the problems of data storage and table structure, it is necessary to establish a new database, which can accommodate massive data storage, and the table structure with design defects needs to be redesigned. Compared with the original database structure, the newly designed database table structure is called a heterogeneous structure. For this heterogeneous database, there needs to be a method to migrate user data from the original database to the new database. [0003] Existing data migration methods are based on polling synchronization, that is, polling synchro...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
Inventor 潘新宇
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products