Automatic deployment method and device based on MySQL cluster and related equipment

Abstract

The invention relates to a data processing technology, and provides an automatic deployment method and device based on a MySQL cluster, computer equipment and a storage medium. The method comprises the steps of determining a master server, and obtaining a target slave server set located in the same MySQL cluster as the master server; establishing heartbeat connection between the master server and each target slave server in the target slave server set; receiving and analyzing a first heartbeat packet sent by the target slave server to the master server, obtaining an installation data directory corresponding to the target slave server, and the installation data directory being used for deploying a preset file; sending a second heartbeat packet to the target slave server, the second heartbeat packet carrying the preset file, and deploying the preset file to the installation data directory; when it is monitored that deployment of the preset file is completed, obtaining target state information of the main server; and automatically synchronizing the state information in the target slave server according to the target state information. The deployment efficiency can be improved, and rapid development of a smart city is promoted.

Description

technical field [0001] The present application relates to the technical field of data processing, and in particular to a MySQL cluster-based automatic deployment method, device, computer equipment, and computer-readable storage medium. Background technique [0002] The MySQL master-slave replication function is the basis for building large-scale and high-performance applications. It distributes MySQL data to multiple servers. The mechanism is to copy the data of a MySQL host to other hosts. To ensure data security, when the master database server is abnormal, it can switch to the slave database to continue working to avoid data loss, and can also separate reads and writes to improve the efficiency of the database. [0003] In the process of realizing the present invention, the inventor found that the prior art has at least the following technical problems: Since the master and slave of the database service are distributed on multiple different servers, it is necessary for th...

AI Technical Summary

Problems solved by technology

[0003] In the process of realizing the present invention, the inventor found that the prior art has at least the following technical problems: since the master and slave of the database service are distributed on multiple different servers, it is necessary to run The maintenance personnel log in to each server one after another, and install and deploy services on each server separately. The deployment work requires the operation and maintenance personnel to have high professional skills, and the process is cumbersome and error-prone, and the deployment efficiency is low.

Images