Monitoring system and monitoring method for single point of failure of database cluster

Abstract

The invention discloses a monitoring system and a monitoring method for a single point of failure of a database cluster. The monitoring system and the monitoring method are applied to the database cluster of a plurality of databases. The databases include primary databases or secondary databases. The monitoring system comprises a plurality of database agents and at least three mutually-communicated coordinating terminals on the basis of a distributed coordination function. The coordinating terminals include a lead coordinating terminal. A database agent and a database in the database cluster are arranged on a server correspondingly, and addresses of the coordinating terminals are stored in each database agent. The database agents detect read-write states of corresponding databases regularly, and the lead coordinating terminal recognizes the single point of failure in the database cluster according to database write-read state information from the databases agents, so that the single point of failure in the database cluster can be recognized efficiently and reliably, and the problem of low efficiency of a solution to a distributed MySQL (my structured query language) database single point of failure in the prior art can be solved.

Description

technical field [0001] The present application relates to a network communication system, and in particular, to a monitoring system and method for a single point failure of a database cluster. Background technique [0002] Currently, Internet companies usually use database clusters to store massive amounts of data on websites. The structure of the database cluster is as follows figure 1 As shown, the master library (Master) 1 provides external read and write services, and several slave libraries (Slave) 2 only provide external read services. Taking MySQL database as an example, both master library 1 and slave library 2 are MySQL instances, so figure 1 The database cluster shown constitutes a MySQL cluster, and each MySQL database (including the master database and the slave database) is a single point. The relationship between each MySQL database includes: through the replication mechanism, the slave library 2 continuously reads updated data from the master library 1 accor...

AI Technical Summary

Problems solved by technology

[0009] Aiming at the problems of low efficiency, poor data security, and poor system stability existing in the solution of distributed MySQL database single point of failure in the prior art, the embodiment of this application provides a monitoring system for database cluster single point of failure, which is used to Solve at least one of the above problems

Images