Method, system and device for controlling data migration of database
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
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
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
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
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to view more 
Login to view more