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

Method, system and device for controlling data migration of database

A control device and database technology, applied in the database field, can solve the problems of difficult and seamless migration of non-relational databases

Active Publication Date: 2013-04-10
上海盛霄云计算技术有限公司
View PDF3 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present application provides a method, system and device for controlling database data migration, so as to solve the problem that existing non-relational databases are difficult to perform seamless migration during capacity expansion

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, system and device for controlling data migration of database
  • Method, system and device for controlling data migration of database
  • Method, system and device for controlling data migration of database

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0062] see figure 1 , which is the flow chart of the first embodiment of the method for controlling database data migration in this application:

[0063] Step 101: Disconnect the connection between each slave node and the master node among the slave nodes in the data cluster.

[0064] Specifically, the pre-saved association between the network address of each master node and the network address of the slave node is searched, and the association between the network address of the slave node and the network address of the master node is deleted.

[0065] Step 102: Control each slave node to transmit data in at least one non-relational database running on the slave node to the expansion backup node configured for the slave node.

[0066] Step 103: Establish a connection between the expanded backup node and the master node.

[0067] Specifically, the network address of the deleted slave node is reconfigured to the expansion backup node of the slave node, and the expansion backup...

no. 1 example

[0105] see Figure 5 , which is a block diagram of the first embodiment of the device for controlling database data migration in this application:

[0106] The device includes: a disconnection unit 510 , a control unit 520 and an establishment unit 530 .

[0107] a disconnection unit 510, configured to disconnect each of the plurality of slave nodes from the master node;

[0108] A control unit 520, configured to control each slave node to transmit data in at least one non-relational database running on the slave node to the expansion backup node configured for the slave node;

[0109] The establishing unit 530 is configured to establish a connection between the expanded backup node and the primary node.

[0110] see Figure 6 , which is a block diagram of the second embodiment of the device for controlling database data migration in this application

[0111] The device includes: a disconnection unit 610 , a control unit 620 , an establishment unit 630 and a selection unit...

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 embodiment of the invention discloses a method, a system and a device for controlling the data migration of a database, wherein the system comprises a main node and a plurality of slave nodes; the main node is connected with the slaves nodes respectively; expansion backup nodes are allocated to the main node and the slave nodes respectively in advance; and the method comprises the steps of interrupting the connection between each of the slave nodes and the main node, controlling each slave node to transmit data which are located in at least one non-relational database and run on the slave nodes to the expansion backup nodes allocated to the slave nodes, and establishing the connection between each expansion backup node and the main node. With the adoption of the method, the system and the device for controlling the data migration of the database, when the data on the nodes in a data cluster are migrated, as the data on the slave nodes are transmitted to the expansion backup nodes one by one, the use of the data on each node in the data cluster is not affected during the data migration process; and therefore, the seamless migration of the data in the data cluster is realized.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a method, system and device for controlling database data migration. Background technique [0002] In existing Internet application systems, non-relational databases can be used to store data generated in the application systems. Non-relational databases are a type of database different from traditional relational databases. The data stored in this type of database has no fixed schema, but has strong scalability. In the application system, the data cluster using the non-relational database has automatic fault recovery function. The data cluster contains one active node and multiple backup nodes. Each node is equivalent to an independent server. Each node runs For multiple non-relational databases, when the active node fails, a backup node is selected to be promoted to the active node. With the increase of the number of users and visits of the application system, the...

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
Inventor 郭理靖段如冰姬毅辉
Owner 上海盛霄云计算技术有限公司
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