Distributive relational database free expansion method

Abstract

The invention discloses a distributive relational database free expansion method, and belongs to the technical field of a database. The method belongs to the distributive relational database free expansion method capable of being used for freely expanding a database node and improving the data re-distribution efficiency. An application program, a database proxy node, a plurality of database nodes and a database proxy node are respectively deployed, and node information of the database proxy node and the node information of each database node are stored at the database proxy node; a value conversion function, a routing algorithm and a routing list are compiled, and data is distributed into the target database node according to routing information included by a new routing list; for the existing database nodes in the target database node, a bottom layer data file needs to be exchanged, then, the bottom layer data file in a source database node is deleted, and the operation is not needed for newly added database nodes in the target database node; in addition, a re-distributed list in the source database node is directly deleted.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for free expansion of a distributed relational database. Background technique [0002] The early database architecture existed in the form of a stand-alone database in the application system, see figure 1 As shown, the application directly accesses the database node. When the business system is not busy, the database generally does not become a bottleneck, but when the business system is busy or the value-added is rapid, once the database becomes a bottleneck, expansion will be troublesome, and usually only hardware can be upgraded. Hardware performance and price are often not directly proportional, and paying twice the price often does not get twice the performance improvement. [0003] Later, the database architecture appeared in the application system in the form of a read-write separation database, that is, a database architecture with read-write separation, see ...

AI Technical Summary

Problems solved by technology

[0005] The present invention aims to solve the problem of using GTM to manage global affairs in the existing distributed technology, which is not conducive to the application scenario of OLTP, resulting in low efficiency of OLTP, which cannot meet the actual production needs, and the need to transfer from the coordinator node when data redistribution leads to efficiency Insufficiency of being low provides a way for users to select data distribution algorithms, select distribution nodes, and freely expand database nodes according to actual conditions, so as to achieve the purpose of eliminating database bottlenecks in a cheap way, and can improve the performance of a single database node. OLTP efficiency, and a free expansion method for distributed relational databases that can improve data redistribution efficiency

Images