A Free Expansion Method of Distributed Relational Database

An expansion method and database technology, applied in the field of free expansion of distributed relational databases, can solve the problems of low OLTP efficiency, low efficiency, and unfavorable OLTP application scenarios, and achieve the effect of eliminating database bottlenecks, improving efficiency, and improving effects.

CN104572809BActive Publication Date: 2017-11-07南京鸿舟科技有限公司
3 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Publication Date
2017-11-07

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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 ...

Examples

Embodiment

[0036] Embodiment: a kind of free expansion method of distributed relational database, see Figure 5 As shown, the steps include:

[0037] (1-1) Deploy the application program, and the client is arranged on the application program;

[0038] (1-2) Deploy the database agent node;

[0039] (1-3) Deploy several database nodes and allow each database node to access each other, denying applications to directly access database nodes;

[0040] (1-4) Deploy database proxy nodes, and allow database proxy nodes to access all database nodes, and allow applications to access database proxy nodes;

[0041] (1-5) storing the node information of the database proxy node and the node information of each database node at the database proxy node, the node information including the node number and connection parameters;

[0042](1-6) Write a value conversion function that is convenient for routing. The value conversion function can convert any value into a unique number;

[0043] (1-7) write r...