Method and system for implementing database clustering function

An implementation method and database technology, which are applied in the field of database cluster function implementation methods and systems, can solve problems such as single database performance bottlenecks, and achieve the effect of realizing database expansion and solving performance bottlenecks

Active Publication Date: 2016-06-01
AGRICULTURAL BANK OF CHINA +1
View PDF5 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the object of the present invention is to provide a method and system for implementing a database cluster function, aiming to ef

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 system for implementing database clustering function
  • Method and system for implementing database clustering function
  • Method and system for implementing database clustering function

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0059] Example one

[0060] The first embodiment of the present invention discloses a method for implementing a database cluster function, wherein the database cluster includes a plurality of database nodes, and the plurality of database nodes respectively store first type data that are different from each other. Refer to figure 1 , The method may include the following steps:

[0061] S101: Receive a first type data service request from a sender, where the first type data service request includes a first service element and a first type data operation task.

[0062] The present application solves the performance bottleneck problem caused by a single database node by expanding a database system including only a single database node in the prior art to a database cluster including multiple database nodes, and realizing an effective database cluster function.

[0063] Wherein, the sender may be an ordinary user, or may be a corresponding application system.

[0064] This embodiment uses a ...

Example Embodiment

[0079] Example two

[0080] In the second embodiment, reference image 3 , The implementation method of the database cluster function may further include the following steps:

[0081] S104: Feed back the return result data generated by the target database node to the sender.

[0082] This embodiment specifically supplements the solution of Embodiment 1. If the target database node generates corresponding result data that needs to be returned to the front-end application system after executing the SQL statement (such as query) submitted by the SQL mapper, it can pass In the data connection established in the first embodiment, the returned data is fed back to the front-end application system via the SQL mapper and interceptor.

[0083] Among them, if the number of target database nodes is more than one, when the SQL mapper receives multiple copies of the result data returned by each target database node, it will integrate the data returned by each target database node into a result set ...

Example Embodiment

[0084] Example three

[0085] In the third embodiment, reference Figure 4 , The implementation method of the database cluster function may further include the following steps:

[0086] S105: When the target database node fails, allocate the first type of data service request to the target backup database node corresponding to the target database node, and the target backup database node is used to perform data processing on the target database node. The first type of data is backed up.

[0087] Since each database node in the database cluster stores different first-type data, such as transactional data, etc., based on this, this embodiment preliminarily backs up the first-type data of each database node in the database cluster, and By adding the relevant backup information of the database cluster in the configuration corpus of the interceptor and SQL mapper in advance, when the target database node fails, the intercepted first-type data service request is routed to the correspondin...

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 system for implementing a database clustering function. According to the method and system, an existing database system only comprising a single database node is expanded into a database cluster comprising multiple database nodes, different kinds of first-type data are stored in the nodes of the database cluster respectively, on this basis, when a first-type data service request of a sender is received, a matched target database node is assigned for the request based on service elements included in the request, and then the request is distributed to the assigned target database node to be processed. Thus, different kinds of data are stored in different nodes of the database cluster, the database clustering function is achieved through effective service routing, database expansion can be effectively achieved based on the function, and therefore the problem of performance bottleneck brought by a single database is solved.

Description

technical field [0001] The invention belongs to the technical field of database management and application, and in particular relates to a method and system for realizing a database cluster function. Background technique [0002] Today's era is an era of information, and people's life, work and study are inseparable from information systems. The processing and storage of data by information systems need to be supported by database systems. Based on this, database systems have become particularly important in today's information age. [0003] Most of the current database systems are single database systems that only use a single database node. With the rapid growth of data volume in various industries, the database system is also facing performance bottlenecks caused by a single database while correctly recording data results. Take the banking system as an example. A large number of customers go to the banking system to handle various businesses every day. The peak number of...

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
IPC IPC(8): G06F17/30
CPCG06F16/27
Inventor 马川郑德健张吉吴旭春朱寅生谢之波
Owner AGRICULTURAL BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap