ProxySQL automatic operation and maintenance system and method, corresponding equipment and storage medium

Abstract

The application discloses a ProxySQL automatic operation and maintenance system and method, corresponding equipment and a storage medium. The ProxySQL automatic operation and maintenance system and method are used for operation and maintenance of a ProxySQL cluster; the ProxySQL cluster comprises multiple sets of ProxySQL and communicates with a MySQL cluster; and the system comprises a monitoringservice module deployed in each ProxySQL and used for determining the health condition of a ProxySQL node and determining the health condition of the MySQL cluster, a health service module used for determining whether the ProxySQL main node is available or not according to the health condition of the ProxySQL and the health condition of the MySQL cluster, and a node migration module used for responding to the situation that the ProxySQL main node is not available, pushing a new main node, and switching the virtual IP of the ProxySQL cluster to the pushed main node. According to the invention,automatic configuration, operation and maintenance of ProxySQL can be realized, and risks caused by misoperation are reduced.

Description

technical field [0001] This application relates to the field of electrical digital data processing, and in particular to a ProxySQL automatic operation and maintenance system, method, corresponding equipment and storage medium. Background technique [0002] As a MySQL-based open source middleware that undertakes front-end business requests and back-end databases, ProxySQL is a flexible MySQL proxy layer and the key to ensuring system stability. The current ProxySQL operation and maintenance solution requires operation and maintenance personnel to log in to the online server and manually modify the internal configuration of ProxySQL, which is a cumbersome process. When there are more cluster services online, misoperations are more likely to occur. The main disadvantages of the current operation and maintenance solution are: 1) single point of failure, the ProxySQL middleware cluster cannot be automatically switched; 2) read-write separation cannot be modified in real time, a...

AI Technical Summary

Problems solved by technology

The current ProxySQL operation and maintenance solution is that the operation and maintenance personnel log in to the online server and manually modify the internal configuration of ProxySQL. The process is cumbersome

When there are more cluster services online, misoperations are more likely to occur

The main disadvantages of the current operation and maintenance solution are: 1) single point of failure, the ProxySQL middleware cluster cannot be automatically switched; 2) read-write separation cannot be modified in real time, and the operation is cumbersome; It needs to be analyzed by operation and maintenance personnel, and then go online for heavy operations; 4) All operations are directly applied to the database, and the risk of misoperation is high; 5) After the backend is offline due to delay, it cannot join the service queue.

Images