Automatic MySQL cluster deployment system and method

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

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 cluster, the number of database cluster nodes increases or decreases extremely. flexible

In order to solve the problem of inflexible horizontal expansion of traditional master-slave database clusters and how to allow database clusters to communicate safely under the Kubernetes system, the present invention proposes a MySQL cluster automatic deployment system and method

Images