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

System and method for realizing distributed database

A technology for implementing systems and databases, applied in transmission systems, electrical components, etc., can solve problems such as inability to operate data, cannot guarantee high availability of data, and achieve the effect of ensuring reliability

Inactive Publication Date: 2011-08-17
TELEFON AB LM ERICSSON (PUBL)
View PDF3 Cites 91 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this solution cannot guarantee the high availability of data, because once a server node in the cluster fails, it will cause the problem that the data on the server cannot be operated

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
  • System and method for realizing distributed database
  • System and method for realizing distributed database
  • System and method for realizing distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] In order to enable those skilled in the art to better understand the solutions of the embodiments of the present invention, the embodiments of the present invention will be further described in detail below in conjunction with the drawings and implementations.

[0049] The system and method for implementing a distributed database in the embodiment of the present invention uses a database cluster to disperse the data in the local server to multiple servers, and sets a primary database and a standby database on each node forming the database cluster, and each node The standby database on the node backs up the data stored in the primary database on another node sequentially according to the preset corresponding relationship in order to ensure the reliability of the data. In this system, the user's read operation request is processed through the proxy server, and after receiving the user's read operation request, the read operation node is selected from the plurality of node...

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 relates to the technical field of databases and discloses a system and method for realizing a distributed database. The system comprises a plurality of nodes forming a database cluster and an agent server, wherein each node forming the database cluster comprises two database instances, namely a master database and a backup database; the backup database on each node backs up data stored in the master database on another node in a non-repeated mode in accordance with a preset correspondence; the agent server comprises an operating processing unit which is used for receiving a read operating request from a user; a read operating node is selected from the plurality of nodes in accordance with the read operating request; and data requested by the user are read in the backup database of the read operating node, and the data are sent to the user. By using the system and method, the reliability of the data can be ensured at the same time of meeting the requirement of storing the mass data.

Description

technical field [0001] The present invention relates to the field of database technology, and more specifically, to a distributed database implementation system and method. Background technique [0002] The database has basically become the basis of application development. With the emergence of Web2.0, the storage capacity of a single database has encountered a bottleneck, because if all applications are placed on one database, there will be no good scalability. As the load increases, sooner or later you will hit a performance bottleneck. The traditional solution is to buy more and more powerful servers to replace the old ones, which is often called "vertical expansion" or "upward expansion". [0003] In order to make the database better adapt to data growth and meet more query requirements, an ideal scalability solution is to use clusters to seamlessly replace local servers, that is, to distribute data to multiple servers through clusters, and Use these servers to comple...

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): H04L29/08
Inventor 喻先兵温文全
Owner TELEFON AB LM ERICSSON (PUBL)
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