Fault processing method and device of database cluster, and terminal

A fault handling method and database technology, which is applied in the fault handling, device and terminal fields of database clusters, can solve the problems of uncertain fault repair time, manpower and material resources for fault repair, etc., and achieve the effect of saving manpower and physical costs and improving user experience

Inactive Publication Date: 2018-09-28
WUHAN DOUYU NETWORK TECH CO LTD
View PDF4 Cites 37 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a database cluster fault handling method, device, and terminal to solve the technical problems of the existing database cluster fault repair that consumes manpower and material resources and the fault repair time is uncertain, and realizes automatic and rapid processing of the database cluster connection layer failure

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
  • Fault processing method and device of database cluster, and terminal
  • Fault processing method and device of database cluster, and terminal
  • Fault processing method and device of database cluster, and terminal

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] figure 1 It is a flow chart of a database cluster fault handling method provided by Embodiment 1 of the present invention. This embodiment is applicable to situations requiring efficient fault recovery, and the method can be executed by a fault processing device of a database cluster. The device It can be realized by means of hardware and / or software, and can generally be configured in a server to realize the method of this embodiment.

[0027] Such as figure 1 As shown, the fault handling method of the database cluster in this embodiment specifically includes:

[0028] S110. Check the connection status of the current master node in the MGR cluster based on the health check function.

[0029] In actual database applications, the system backend can configure one or more clusters according to actual needs, and the MGR cluster usually includes at least three instances or at least three nodes. Each cluster provides two domain name system (Domain Name System, DNS) service...

Embodiment 2

[0052] figure 2 It is a schematic flowchart of a preferred example of a database cluster fault handling method provided by Embodiment 2 of the present invention. see figure 2 , the main program is developed using Python. Connect to the database by means of a domain name. Then the program initiates the real-time status check of the cluster and the judgment of the read-write node through the heartbeat setting, and automatically switches the domain name from the faulty node to the new read-write node as soon as a problem occurs, which is transparent to the user Unaware, and the whole process does not require any manual intervention, second-level fault recovery.

[0053] Specifically, the DNS can be configured through the DNS configuration function, and the clusters defined in the backend database table can be maintained. The backend can be configured with one or more clusters, each cluster can contain at least 3 instances, and each cluster provides 2 DNS services: read-writ...

Embodiment 3

[0062] image 3 Shown is a schematic structural diagram of a database cluster fault handling device provided by Embodiment 3 of the present invention. The device can be implemented by means of hardware and / or software, and can generally be configured in a server to implement the method of this embodiment. Such as image 3 As shown, the database cluster fault handling apparatus of this embodiment includes: a check module 310 , a target master node acquisition module 320 and a corresponding relationship establishment module 330 .

[0063] Wherein, the check module 310 is configured to check the connection status of the current master node in the MGR cluster based on the health check function, wherein the master node is set corresponding to the domain name system, and provides read and write domain name system services for the domain name system; The target master node acquisition module 320 is used to obtain the target master node corresponding to the current master node when i...

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 embodiment of the invention discloses a fault processing method and a fault processing device of a database cluster, and a terminal. The fault processing method of the database cluster comprises the steps of checking the connection state of a current main node in an MGR cluster based on a health examination function, wherein the main node and a domain name system are correspondingly arranged,and the main node provides a domain name system service for the domain name system; when checking that a fault occurs in the connection between the current domain name system and the current main node, acquiring a target main node corresponding to the current main node; and switching the current main node into the target main node based on a domain name switching function, and building a corresponding relation between the current domain name system and the target main node. According to the technical scheme provided by the embodiment of the invention, the technical problems that the existing database cluster consumes many manpower and material resources for repairing the fault and the fault repairing time is uncertain can be solved, and the connection layer fault of the database cluster can be quickly processed.

Description

technical field [0001] The embodiments of the present invention relate to the technical field, and in particular, relate to a database cluster fault handling method, device, and terminal. Background technique [0002] MySQL Group Replication (MGR for short) is a new high-availability and high-expansion MySQL cluster service launched by MySQL. The group replication technology based on native replication and paxos protocol has greatly improved the strong consistency and performance of data. However, this high-availability cluster is only a kind of high availability for the back-end database, and it cannot really achieve high availability for the connection layer. [0003] When the current master node of MGR fails, one solution is that the system will notify the database administrator (Database Administrator, DBA) through monitoring means, and the DBA will inform the development of the IP address of the new master node through manual inspection. Or operation and maintenance to...

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
Patent Type & Authority Applications(China)
IPC IPC(8): H04L12/24H04L29/12G06F17/30G06F11/14
CPCH04L41/0668G06F11/1464H04L61/4511
Inventor 陈阳陈少杰张文明
Owner WUHAN DOUYU NETWORK TECH CO 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