Automatic MySQL cluster deployment system and method

A deployment system and automation technology, applied in the field of cloud computing, can solve the problems of inflexibility, low security, high error rate, etc. when the number of database cluster nodes increases or decreases, and achieves the effect of dynamically adjusting the cluster size and ensuring security

Pending Publication Date: 2020-09-11
山东汇贸电子口岸有限公司
View PDF5 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This is inefficient, more error prone, and less secure
[0005] Traditional database clusters generally consist of multiple virtual machines or physical machines, and are manually built by operation and maintenance personnel. Not only is the building process time-consuming and laborious, but when business diversification requires horizontal expansion of the database...

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
  • Automatic MySQL cluster deployment system and method
  • Automatic MySQL cluster deployment system and method
  • Automatic MySQL cluster deployment system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] In order to enable those skilled in the art to better understand the technical solutions in the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the embodiments of the present invention. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0035] Combined with Kubernetes technology, in the scenario of high concurrency and large database reading business, the pressure on the master-slave database cluster increases. How to safely expand the cluster service capability without interrupting the service and improve the high availability of the database, based on the Kubernetes system The dyna...

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 particularly relates to an automatic MySQL cluster deployment system and method. According to the MySQL cluster automatic deployment system and method, a database cluster adopts a one-master multi-slave architecture, and all internal connections adopt an SSL encryption mode; a service provided by a Kubernetes system is adopted to provide load balancing, and the size of a cluster is dynamically adjusted according to the number of copies based on a container service provided by the Kubernetes system. According to the MySQL cluster automatic deployment system and the method, the number of cluster nodes can be dynamically adjusted according to the service volume and the service peak value, the service stability is guaranteed in the service peak period, resources are released in the service low peak period, the availability of a database system is improved, and the resource utilization rate is increased; and meanwhile, the node communication encryption mode in the cluster ensures the security of data and the system. Therefore, the problems of database connection security and dynamic cluster size adjustment are solved.

Description

technical field [0001] The invention relates to the technical field of cloud computing, in particular to a MySQL cluster automatic deployment system and method. Background technique [0002] With the wide application and rapid development of information technology, cloud computing, as an emerging computing model, has attracted more and more attention from people, and many fields such as scientific research, production, business, and government work functions have begun to use cloud computing technology more and more. , cloud computing technology is becoming more and more mature and constantly improving, whether it is the service components of the cloud platform itself that support the operation of the platform or the number of service components deployed to users on the cloud computing platform is increasing day by day. [0003] Kubernetes is a container cluster management system. It is a new technology and product in the cloud computing era. It can realize automatic deploym...

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): G06F9/50G06F11/14G06F16/27G06F16/28H04L12/24H04L29/06H04L29/08
CPCG06F9/5083G06F9/5072G06F11/1464G06F16/27G06F16/284H04L41/0893H04L63/0428H04L63/166H04L67/10G06F2209/508G06F2201/80
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