Node identification method and device for MySQL group replication

An identification method and node technology, applied in the direction of database distribution/replication, generation of response errors, error detection of data due to redundancy in operations, etc. , increase the complexity of network links, etc., to achieve the effect of improving service availability, reducing configuration complexity, and avoiding connection re-establishment actions

Pending Publication Date: 2021-12-31
辽宁振兴银行股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0012] 1. The existing technology is based on the automatic switching of MySQL group replication found by the monitoring program, and then triggers the mapping adjustment of DNS. From the perspective of the application system, it is necessary to release the connection (to the old master node) that has been established before the switching, and establish ( For a new connection with the new master node, the application system can only provide services to the outside world after t

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
  • Node identification method and device for MySQL group replication
  • Node identification method and device for MySQL group replication
  • Node identification method and device for MySQL group replication

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] see Figure 1~3 , in an embodiment of the present invention, a node identification device for MySQL group replication, including:

[0053] Node connection management module: used to connect all nodes;

[0054] Node status register: used to store all node status data;

[0055] Node status identification module: used to identify the node status, judge the abnormality of the master node and automatically replace the new master node.

[0056] Further, a node identification method for MySQL group replication, comprising the following steps:

[0057] S1: Relevant logic processing in the initialization phase of service startup;

[0058] S2: Interaction and collaboration between the node connection management module and the transaction processing process;

[0059] S3: When the MySQL group replication node fails abnormally, the node connection management module interacts with the transaction processing process.

[0060] Further, S1 includes the following sub-steps:

[0061...

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 the technical field of MySQL group replication node identification, in particular to a node identification method and device for MySQL group replication, and the method comprises the steps: S1, the related logic processing of a service starting initialization stage is performed; s2, the node connection management module interactively cooperates with the transaction processing flow; and S3, when the MySQL group replication node has an abnormal fault, the node is connected with the interaction cooperation of the management module and the transaction processing flow. Through the node connection management module, the node data register and the node state identification module, on the basis that a network link between an application system and data is not changed, automatic master-slave switching of quasi-real-time detection, discovery and adaptation MGR nodes is met, the connection reestablishment action is avoided, the configuration complexity of the application system is reduced, and the service availability of the application system is improved.

Description

technical field [0001] The invention relates to the technical field of MySQL group replication node identification, in particular to a node identification method and device for MySQL group replication. Background technique [0002] MySQL: a database software for the purpose of storing business data, and providing read and write services for application systems, with transactional characteristics; [0003] MySQL group replication: It is a data synchronization mechanism of MySQL database and a deployment method of MySQL database. In terms of data, MySQL group replication has high security, high consistency, and high fault tolerance. In terms of service, MySQL group replication High scalability and high flexibility; [0004] MySQL group replication node: the instance that constitutes MySQL group replication. A MySQL group replication cluster consists of at least two instances and can support multiple instances; [0005] According to the type of service provided externally, My...

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): G06F11/14G06F16/27
CPCG06F11/142G06F16/27
Inventor 陈典银张德权
Owner 辽宁振兴银行股份有限公司
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