Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for data migration in database cluster

A database and data technology, which is applied in the field of data migration in database clusters, can solve problems such as stopping database services, and achieve the effect of improving access efficiency and improving access experience

Active Publication Date: 2018-06-08
TENCENT TECH (SHENZHEN) CO LTD
View PDF7 Cites 37 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Based on this, an object of the present disclosure is to provide a method for data migration in a database cluster, which is used to solve the problem in the prior art that the database service needs to be stopped during the data migration process
[0006] In addition, another object of the present disclosure is to provide a device for data migration in a database cluster, which is used to solve the problem in the prior art that the database service needs to be stopped during the data migration process

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
  • Method and device for data migration in database cluster
  • Method and device for data migration in database cluster
  • Method and device for data migration in database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] Here, an exemplary embodiment will be described in detail, and examples thereof are shown in the accompanying drawings. When the following description refers to the accompanying drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The implementation manners described in the following exemplary embodiments do not represent all implementation manners consistent with the present disclosure. Rather, they are only examples of devices and methods consistent with some aspects of the present disclosure as detailed in the appended claims.

[0028] As mentioned earlier, with the gradual increase in user access, database clusters need to use data migration to relieve the storage pressure and load pressure of the original server.

[0029] At present, common databases include Key-Value databases, PostgreSQL-based databases, and so on.

[0030] For key-value databases, the multi-copy mechanism can realize functions such as da...

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 discloses a method and device for data migration in a database cluster. The method comprises the following steps of acquiring a snapshot of a source data node; recording incremental datain data fragments to be migrated according to stock data in the data fragments to be migrated backed up in the snapshot; migrating the backup stock data into a target data node; performing migrationon the recorded incremental data; in the migration process, when the incremental data which is not migrated meets the preset write lock conditions, notifying the source data node to execute write lockoperation on the data fragments to be migrated; migrating the incremental data which is not migrated to the target data node; after the migration of the incremental data is completed, notifying a coordination node to switch a route corresponding to the data fragments to be migrated from the source data node to the target data node. By using the method and device for data migration in the databasecluster provided by the invention, the database service interruption can be avoided in the data migration process.

Description

Technical field [0001] The present disclosure relates to the field of computer application technology, and in particular to a method and device for data migration in a database cluster. Background technique [0002] When a certain application has a large amount of user access, using only one server to provide database services to users will inevitably affect user experience. This requires multiple servers to provide database services to users, thus forming a so-called database cluster. [0003] With the gradual increase in user visits, the storage capacity and processing capacity of the database cluster will also reach the upper limit of the cluster capacity, which requires data migration to relieve the storage pressure and load pressure of the original server. [0004] However, the existing data migration process must stop the client's access to the data being migrated, that is, the database service must be stopped to ensure the consistency of the data migration, which will inevitab...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/214G06F2201/80G06F11/1451G06F2201/84
Inventor 许中清胡森李跃森刘煜宏
Owner TENCENT TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com