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

High availability data-base cluster based on message middleware

A message middleware, high-availability technology, applied to the redundancy in computing for data error detection, electrical digital data processing, special data processing applications, etc. Complex structure and other problems, to achieve the effect of ensuring service sustainability, improving concurrency, and simple system configuration

Inactive Publication Date: 2008-05-21
HUAZHONG UNIV OF SCI & TECH
View PDF0 Cites 128 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, most of these database clusters are based on database engines. For example, MySQLCluster can only use NDB (or NDB Cluster) storage engines, but cannot use storage engines such as MyISAM and InnoDB, let alone database servers such as SQL Server or DB2. Form a database cluster; secondly, the system structure is relatively complex, and the cost of system development and maintenance is high
[0005] At the same time, in terms of network (especially TCP connection level) fault tolerance, most database clusters currently perform poorly
Although Oracle RAC has TCP connection fault tolerance, its technology is proprietary

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
  • High availability data-base cluster based on message middleware
  • High availability data-base cluster based on message middleware
  • High availability data-base cluster based on message middleware

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The technical ideas adopted in the present invention are as follows:

[0026] a. Establish an application proxy, whose role is to redirect connections and act as a proxy for the client;

[0027] b. Establish database middleware and adopt the "read-write all available" technology to ensure data consistency among data nodes. At the same time, it meets the dynamic joining and leaving of data nodes, and maintains the normal operation of nodes.

[0028] c. Establish the database service layer, and use the MySQL server to build the database service layer.

[0029] Furthermore, transactions and SQL commands that are executed immediately after a single transmission are collectively referred to as tasks or requests. For a read-only request, the first node that receives it immediately executes and returns the result; for a write request task, it needs to be forwarded and executed to all other nodes. This is the "read-write-all" or "read-write-multiple" protocol. The present invention...

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 high-availability database cluster system based on message-oriented middleware, comprising a database service layer composed of a plurality of database servers and a middle layer arranged between an application layer and the database service layer; wherein, the middle layer comprises a plurality of application proxies, a plurality of database middleware and a message bus; the application proxy is used for connection redirection when fault occurs on service nodes so as to keep service uninterrupted and improve reliability; the database middleware is used for interception, analysis, processing and retransmission of the database request message; and the message bus runs through the database middleware and the database server, which is responsible for global sorting of reading and writing operation sent by the data middleware so as to ensure data consistency and sending of the sorting result to the database server. A feasible approach is provided for the invention in order to obtain a high-performance database with high availability. The invention has the advantages of high availability, good scalability and easy construction and management.

Description

Technical field [0001] The invention relates to the technical field of computer database cluster middleware, and more specifically, it uses message middleware technology to construct a high-availability database cluster. Background technique [0002] Some current hot applications such as e-commerce, train ticket ordering services, e-banking, etc., usually in a relatively short period of time, the number of users is extremely large, and the peak value of queries reaches more than 100,000 times per second. Whether a single server is from Neither the processing power of the CPU nor the physical bandwidth of the network can meet such high performance requirements. At the same time, for these applications, the failure of the server will bring huge losses to the service provider. In this context, the research and development of database cluster technology has become a matter of great concern to the academic and industrial circles. [0003] Currently, database cluster products are mainl...

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/30G06F11/14G06F9/46
Inventor 金海邵志远陈冠华蒋怀贞陆晓雯陈华才张德于集东
Owner HUAZHONG UNIV OF SCI & TECH
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