Database fault automatic detection and transfer method

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

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

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

Images