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

A single-point failure and monitoring system technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as poor system stability, poor data security, and low efficiency, and achieve effective and reliable monitoring results and easy operation Effect

Active Publication Date: 2013-12-04
ALIBABA GRP HLDG LTD
View PDF3 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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
  • Monitoring system and monitoring method for single point of failure of database cluster
  • Monitoring system and monitoring method for single point of failure of database cluster
  • Monitoring system and monitoring method for single point of failure of database cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] Embodiments of the present application will be described below in conjunction with the accompanying drawings. It should be understood that the embodiments described here are only used to illustrate and explain the present application, and are not intended to limit the present application.

[0022] Aiming at the problems of low efficiency, poor data security, and poor system stability existing in solutions for single point failures of MySQL data cluster databases in the prior art, the embodiment of the present application provides a method for monitoring single point failures in database clusters solutions to address at least one of the above problems.

[0023] In the solution provided by the embodiment of this application, a database proxy corresponding to the database in the database cluster is set, the correspondingly set database and the database proxy are located on the same server, and at least three coordination terminals based on a distributed coordination mechani...

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 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...

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/30
Inventor 朱金清
Owner ALIBABA GRP HLDG LTD
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap