Database fault automatic detection and transfer method

A technology of automatic detection and transfer method, which is applied in the direction of redundant data error detection, electrical digital data processing, special data processing application, etc. in the calculation, and can solve the problem of database server outage, service interruption, weak HA link design, etc. problems, to achieve the effect of ensuring continuity and improving reliability

Active Publication Date: 2010-11-03
上海黑桃互动网络科技股份有限公司
View PDF4 Cites 85 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] However, in the small database management system provided by MySQL, the design of the HA link is relatively wea

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
  • Database fault automatic detection and transfer method
  • Database fault automatic detection and transfer method
  • Database fault automatic detection and transfer method

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0040] Such as figure 1 Shown is a schematic diagram of each component module of the database fault automatic detection and transfer system of the present invention, which includes a user terminal 100, a cache (Cache) server 200, a database master (Master) server 300, and a database slave (Slave) server 400 , And the management end 500. The database server of the present invention adopts the dual redundancy structure of Master / Slave, and at the same time, multiple slave servers can be configured, and the data between the databases is strictly synchronized to ensure that the data of the Master server and the slave server are consistent. In addition, the cache server 200 of the present invention is directly connected to a plurality of independent client terminals 100 through the Internet, and performs data transmission; then, the related data of the client terminal passes through the cache server 200, and performs data transfer with the database server (300, 400). Synchronization...

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 database fault automatic detection and transfer method which is configured with a client (100), a cache memorizer (200), an MDHA module (210), a management terminal (500) and a plurality of database server groups (300 and 400), and comprises the main steps that each database server group is divided into a master server (300) and a slave server (400); the MDHA module (210) is arranged between the client (100) and a database and is used for detecting the database; when the client connection is started, a detection thread is set up; when in running, the client (100) can be used for detecting the master server (300) through the MDHA module (210); when the master server (300) is detected to be abnormal, the MDHA module (210) leads the access of the client to be automatically switched into the slave server; and when the master server is recovered, intermediate leads the access of the client to be switched into the master server. The method can be applied into a small and medium size data base management systems adopting a My SQL system, can guarantee the continuity of the service operation of a network server, and improves the reliability.

Description

technical field [0001] The invention relates to a database access technology, in particular to a database fault automatic detection and transfer method, which can be applied to the operation method of a system with high availability requirements for database services. Background technique [0002] MySQL is a small relational database management system developed by MySQL AB of Sweden. Acquired by Sun on January 16, 2008. At present, MySQL is widely used in small and medium-sized websites on the Internet. Due to its small size, fast speed, low total cost of ownership, especially the open source feature, many small and medium-sized websites choose MySQL as the website database in order to reduce the total cost of ownership of the website. [0003] MySQL, the most widely used free database open source software in the Internet industry, provides a small relational database management system. At present, MySQL is widely used in small and medium-sized websites on the Internet. ...

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): G06F11/14G06F17/30
Inventor 余伟徐景春李杰
Owner 上海黑桃互动网络科技股份有限公司
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