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

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

An operation and maintenance system and automatic technology, applied in the field of ProxySQL automatic operation and maintenance system, can solve the problems of cumbersome operation, prone to misoperation, inability to rewrite, etc., to reduce risks and avoid damage.

Active Publication Date: 2021-05-04
望海康信(北京)科技股份公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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.

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
  • Proxysql automatic operation and maintenance system, method, corresponding equipment and storage medium
  • Proxysql automatic operation and maintenance system, method, corresponding equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] Embodiments and examples of the present invention will be described in detail below with reference to the drawings.

[0025] The scope of applicability of the present invention will become apparent from the detailed description given below. It should be understood, however, that the detailed description and specific examples, while indicating the preferred embodiment of the invention, are given for purposes of illustration only.

[0026] figure 1 A block diagram of a preferred embodiment of the ProxySQL automatic operation and maintenance system according to the present invention is shown. The ProxySQL automatic operation and maintenance system is used for the operation and maintenance of the ProxySQL cluster. The ProxySQL cluster includes multiple sets of ProxySQL agents and communicates with the MySQL (database) cluster, and specifies a virtual IP (VIP) for the ProxySQL cluster. The node where the VIP is located is the master node. The system includes:

[0027] The...

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

This application discloses a ProxySQL automatic operation and maintenance system, method, corresponding equipment, and storage medium for the operation and maintenance of a ProxySQL cluster, wherein the ProxySQL cluster includes multiple sets of ProxySQL and communicates with the MySQL cluster, wherein the system includes: deployed on each ProxySQL The monitoring service module in is used to determine the health status of the ProxySQL node and the health status of the MySQL cluster; the health service module is used to determine whether the ProxySQL master node is available according to the health status of ProxySQL and the health status of the MySQL cluster; The node migration module is used to recommend a new master node in response to the unavailability of the ProxySQL master node, and switch the virtual IP of the ProxySQL cluster to the recommended master node. The present invention enables automatic configuration, operation and maintenance of ProxySQL, and reduces risks caused by misoperation.

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

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 Patents(China)
IPC IPC(8): G06F16/21G06F16/242G06F16/25G06F16/27
CPCG06F16/21G06F16/2433G06F16/252G06F16/27
Inventor 段雅亭许明娄景军张富卿孟庆安
Owner 望海康信(北京)科技股份公司
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