Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database high availability method, device, system and storage medium

A high-availability, storage medium technology, applied in the field of database management, can solve the problems of switching failure, unable to find the host, etc., to achieve the effect of fast reliability, automatic master-slave switching, and failure recovery capability

Active Publication Date: 2020-08-25
SHANGHAI ZHONGTONGJI NETWORK TECH CO LTD
View PDF3 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In order to solve the problem that the remote computer room switching in the existing technology of remote disaster recovery is prone to fail due to the failure of the host, the present invention provides a high-availability method, device, system and storage medium for the database, which has the characteristics of reliable and fast automatic switching.

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 high availability method, device, system and storage medium
  • Database high availability method, device, system and storage medium
  • Database high availability method, device, system and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be described in detail below. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other implementations obtained by persons of ordinary skill in the art without making creative efforts fall within the protection scope of the present invention.

[0031] refer to Figure 1 to Figure 4 As shown, the embodiment of the present invention provides a database high availability method, comprising the following steps:

[0032] 101. Determine the master node and slave node of each data center database;

[0033] 102. Build an MGR cluster based on master nodes and slave nodes;

[0034] 103. Build consul based on the MGR cluster, and register the master node and the slave node to the service discovery of consul to...

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 relates to a database high availability method, a device, a system and a storage medium. Master nodes and slave nodes in a data center database form an MGR cluster, MySQL can automatically discover a master library crash in an MGR mode, a new master node is generated through a master selection mechanism to provide read-write service for the outside, and automatic master-slave switching and fault recovery capacity are achieved; and the relationship between the nodes is maintained in combination with the consul in the micro-service framework to realize the synchronization and strong consistency of the data between the nodes, and the domain name of the switched main node is analyzed in combination with the dynamic domain name server to obtain the corresponding IP address, so that the reliability and rapidness of automatic switching are ensured.

Description

technical field [0001] The invention belongs to the technical field of database management, and in particular relates to a database high-availability method, device, system and storage medium. Background technique [0002] The MYSQL database is currently the largest relational database for open source applications, and there are a large number of applications that store data in the MYSQL database. The security and reliability of stored data is the focus of production databases. At present, most of the MYSQL databases solve single point failures, using traditional MHA, PXC and other solutions, while the existing MHA (MHA is developed by Japan's DeNA company, is An excellent high-availability software for failover and master-slave promotion in a MySQL high-availability environment) can only be deployed on the same network segment in the same computer room. For database machines in different network segments or in the same network segment in different computer rooms, when the ...

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): G06F16/27G06F16/28H04L29/12
CPCG06F16/27G06F16/284H04L61/10H04L61/4511
Inventor 朱晶熙柯伟峰
Owner SHANGHAI ZHONGTONGJI NETWORK TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com