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

Method and device for building MySQL high-availability group

A cluster and node technology, applied in special data processing applications, structured data retrieval, database design/maintenance, etc., can solve problems such as overloading of working nodes, computing of working nodes, waste of storage resources, failure to guarantee clusters and working nodes, etc. , to achieve the effect of reducing operation and maintenance pressure, rapid deployment, and rapid delivery

Pending Publication Date: 2021-02-23
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

like figure 2 As shown, it is inaccurate to select a suitable cluster in the existing production cluster to deploy multiple nodes of the MySQL high-availability group, and it is not accurate to rely only on manual judgment
Especially for a large-scale application, when hundreds of MySQL high-availability groups need to be built, it puts a lot of pressure on operation and maintenance
At the same time, there is no guarantee that the selected cluster and working nodes are optimal. The result is that some working nodes have waste of computing and storage resources, and some working nodes are overloaded.
The existing technology lacks a reasonable MySQL high-availability group automatic construction scheme

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
  • Method and device for building MySQL high-availability group
  • Method and device for building MySQL high-availability group
  • Method and device for building MySQL high-availability group

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is an embodiment of a part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0034] Those skilled in the art should understand that the embodiments of the present invention may be provided as methods, systems, or computer program products. Accordingly, the present invention can take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects...

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 discloses a method and a device for building a MySQL high-availability group, which can be used in the financial field or other fields, the method comprises the following steps: receiving a building request for the MySQL high-availability group, the MySQL high-availability group comprises a plurality of nodes, and the nodes comprise a master node and a slave node; for each node of the MySQL high-availability group, screening out all candidate scheduling clusters corresponding to the node from all current MySQL clusters according to a preset cluster screening rule, determining a to-be-scheduled cluster corresponding to the node according to the master-slave balance score of each candidate scheduling cluster, and establishing the MySQL high-availability group according to the to-be-scheduled cluster corresponding to each node. According to the invention, rapid deployment of the MySQL high-availability group is realized.

Description

technical field [0001] The invention relates to the field of cloud computing service scheduling, in particular to a method and device for building a MySQL high-availability group. Background technique [0002] With the continuous popularization of open source technology and the rapid development of cloud computing, the MySQL database container has landed in major companies and enterprises and has become the first choice for relational databases. As a product of the cloud computing era, the MySQL container has powerful functions such as rapid creation and expansion, convenient management, safety and reliability, etc., enabling customers to have a stable and reliable MySQL high-availability service group in a short period of time. [0003] MySQL generally provides external services in a high-availability cluster mode with one master and multiple slaves, such as figure 2 As shown, the master-slave replication function provided by the MySQL database itself can easily realize mu...

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): G06F16/21
CPCG06F16/211Y02D10/00
Inventor 蔡中原孙政清李凤超白佳乐
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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