Node identification method and device for MySQL group replication

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

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 the new connection is established. Therefore, this method will seriously affect the external service availability and transaction processing performance of the application system during the switchover period (connection reconstruction) ;

[0013] 2. Most of the existing database middleware that supports MySQL group replication are deployed independently, which increases resource investment and increases the complexity of the network link from the application system to the database

Images