Data Migration Method and Device

A data and database technology, applied in the database field, can solve problems such as database downtime, and achieve the effect of reducing the probability of downtime

Active Publication Date: 2019-10-08
ALIBABA GRP HLDG LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when there are many concurrent accesses to the database, it is easy to cause database downtime

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 approach

[0047] For another example, in combination with the above scheme of grouping the databases to be migrated, an implementation manner in which the migration thread performs data migration on the databases to be migrated includes:

[0048] The migration thread corresponding to each group can determine the target data in the database to be migrated in each group, and the target data refers to the data required to carry out the target business;

[0049] The migration thread corresponding to each group migrates the target data from the database to be migrated in each group to the new database;

[0050] The migration thread corresponding to each group migrates other data in the database to be migrated in each group except the target data to the new database.

[0051] In this embodiment, the migration thread does not directly migrate all the data to be migrated, but first determines the target business and the target data required to carry out the target business, so as to facilitate ...

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 application provides a data migration method and device. The method comprises following steps: determining at least one database to be migrated; determining a migration thread count for starting the at least one database to be migrated; and starting at least one migration thread count for the at least one database to be migrated based on the migration thread count such that data migration is conducted by the at least one migration thread count for the at least one database to be migrated. The application can achieve data migration while decreasing downtime possibility of databases.

Description

【Technical field】 [0001] The present application relates to the technical field of databases, in particular to a data migration method and device. 【Background technique】 [0002] A database is a collection of data that is stored together in a certain way, can be shared by multiple users, has as little redundancy as possible, and is independent of the application. During the use of the database, when the storage structure of the database cannot meet the business needs, the data in the database needs to be migrated to a new database that can meet the business needs, which involves the problem of migrating a large amount of data. [0003] Traditional data migration is generally offline, but in order not to affect business use, online data migration technology has emerged, that is, during the data migration process, business threads are still allowed to access the database to carry out business. However, when there are many concurrent accesses to the database, it is easy to cau...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21
Inventor 杨晓芬江建明
Owner ALIBABA GRP HLDG 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