CN113138882B - MySQL cluster-based automatic deployment method and device and related equipment - Google Patents

MySQL cluster-based automatic deployment method and device and related equipment Download PDF

Info

Publication number
CN113138882B
CN113138882B CN202110519134.4A CN202110519134A CN113138882B CN 113138882 B CN113138882 B CN 113138882B CN 202110519134 A CN202110519134 A CN 202110519134A CN 113138882 B CN113138882 B CN 113138882B
Authority
CN
China
Prior art keywords
target
server
slave server
target slave
heartbeat packet
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202110519134.4A
Other languages
Chinese (zh)
Other versions
CN113138882A (en
Inventor
胡维其
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Saiante Technology Service Co Ltd
Original Assignee
Shenzhen Saiante Technology Service Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shenzhen Saiante Technology Service Co Ltd filed Critical Shenzhen Saiante Technology Service Co Ltd
Priority to CN202110519134.4A priority Critical patent/CN113138882B/en
Publication of CN113138882A publication Critical patent/CN113138882A/en
Application granted granted Critical
Publication of CN113138882B publication Critical patent/CN113138882B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • G06F11/1461Backup scheduling policy
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • G06F11/1464Management of the backup or restore process for networked environments
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/3003Monitoring arrangements specially adapted to the computing system or computing system component being monitored
    • G06F11/3006Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system is distributed, e.g. networked systems, clusters, multiprocessor systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/3055Monitoring arrangements for monitoring the status of the computing system or of the computing system component, e.g. monitoring if the computing system is on, off, available, not available
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80Database-specific techniques

Abstract

The application relates to a data processing technology, and provides an automatic deployment method, an automatic deployment device, computer equipment and a storage medium based on a MySQL cluster, which comprise the following steps: determining a master server, and acquiring a target slave server set which is in the same MySQL cluster with 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 from a target slave server to a master server to obtain an installation data directory corresponding to the target slave server, wherein the installation data directory is used for deploying a preset file; sending a second heartbeat packet to the target slave server, wherein the second heartbeat packet carries a preset file and the preset file is deployed to a mounting data directory; when the preset file deployment is monitored to be completed, acquiring target state information of a main server; and automatically synchronizing the state information in the target slave server according to the target state information. The efficiency of deployment can be improved to this application, promotes the rapid development in wisdom city.

Description

MySQL cluster-based automatic deployment method and device and related equipment
Technical Field
The present application relates to the field of data processing technologies, and in particular, to an automated deployment method and apparatus based on a MySQL cluster, a computer device, and a computer-readable storage medium.
Background
The MySQL master-slave copy function is used for constructing a basis of large-scale and high-performance application, data of MySQL is distributed to a plurality of servers, the mechanism is that data of one host of MySQL is copied to other hosts, the MySQL master-slave copy function is used for performing hot standby to ensure data safety, and after a master database server is abnormal, the MySQL master-slave copy function can be switched to a slave database to continue working, so that data loss is avoided, and read-write separation can be performed to improve the efficiency of the database.
In the process of implementing the invention, the inventor finds that the prior art has at least the following technical problems: because the database services are distributed on a plurality of different servers in a master-slave mode, operation and maintenance personnel are required to log in each server in sequence and install and deploy services on each server respectively, the deployment work requires the operation and maintenance personnel to have higher professional skills, the procedures are complicated, mistakes are easy to make, and the deployment efficiency is low.
Therefore, it is necessary to provide an automatic deployment method based on the MySQL cluster, which can improve the efficiency of deployment.
Disclosure of Invention
In view of the foregoing, it is necessary to provide an automatic deployment method based on MySQL cluster, an automatic deployment apparatus based on MySQL cluster, a computer device, and a computer-readable storage medium, which can improve deployment efficiency.
A first aspect of an embodiment of the present application provides an automated deployment method based on a MySQL cluster, where the method includes:
determining a master server, and acquiring a target slave server set which is in the same MySQL cluster with the master server;
establishing heartbeat connection between the main server and each target slave server in the target slave server set;
receiving and analyzing a first heartbeat packet sent to the main server by the target slave server to obtain an installation data directory corresponding to the target slave server, wherein the installation data directory is used for deploying a preset file;
sending a second heartbeat packet to the target slave server, wherein the second heartbeat packet carries the preset file and the preset file is deployed to the installation data directory;
when the preset file deployment is monitored to be completed, acquiring target state information of the main server;
and automatically synchronizing the state information in the target slave server according to the target state information.
Further, in the foregoing automatic deployment method based on MySQL cluster provided in this embodiment of the present application, the establishing a heartbeat connection between the master server and each target slave server in the target slave server set includes:
acquiring operation parameters of the target slave server which establishes long connection with the master server;
calculating the operation load state of the slave server according to the operation parameters;
determining a heartbeat packet sending strategy corresponding to the running load state, wherein the heartbeat packet sending strategy comprises the sending frequency of heartbeat packets and the number of files carried by each heartbeat packet;
and establishing the heartbeat connection between the main server and the target slave server according to the heartbeat packet sending strategy.
Further, in the foregoing automatic deployment method based on MySQL cluster provided in this embodiment of the present application, the receiving and analyzing the first heartbeat packet sent from the target slave server to the master server to obtain the installation data directory corresponding to the target slave server includes:
detecting whether the first heartbeat packet carries a preset mark or not;
when the detection result is that the first heartbeat packet carries the preset mark, determining a target position of the preset mark, and acquiring configuration information at the target position;
and extracting target format data in the configuration information as an installation data directory corresponding to the slave server.
Further, in the foregoing automatic deployment method based on MySQL cluster provided in this embodiment of the present application, the sending a second heartbeat packet to the target slave server includes:
acquiring the file size of the preset file;
detecting whether the file size exceeds a preset file size threshold value;
when the detection result shows that the size of the file amount exceeds the preset file amount threshold value, splitting the preset file to obtain a target sub-file set;
and storing each target subfile in the target subfile set into the second heartbeat packet, and sending the second heartbeat packet to the target server according to the heartbeat packet sending strategy.
Further, in the foregoing automatic deployment method based on MySQL cluster provided in this embodiment of the application, before the deploying the preset file to the installation data directory, the method further includes:
when the file volume of the preset file exceeds the preset file volume threshold, acquiring a second heartbeat packet to obtain a second heartbeat packet set;
acquiring a target subfile carried by each second heartbeat packet in the second heartbeat packet set to obtain a target subfile set;
and determining the arrangement sequence of each target subfile in the target subfile set, and merging the target subfiles according to the arrangement sequence to obtain a preset file.
Further, in the foregoing automatic deployment method based on MySQL cluster provided in this embodiment of the present application, after the target subfiles are merged according to the arrangement order to obtain a preset file, the method further includes:
acquiring the performance specification of the target slave server;
obtaining a target performance parameter corresponding to the performance specification according to a preset mapping relation between the performance specification and the performance parameter;
determining an initial performance parameter corresponding to the target performance parameter in the preset file;
and replacing the initial performance parameters as the target performance parameters to obtain a target preset file.
Further, in the foregoing automatic deployment method based on MySQL cluster provided in the embodiment of the present application, the automatically synchronizing the state information in the target slave server according to the target state information includes:
acquiring a key field corresponding to the target state information;
determining initial state information corresponding to the key fields in the target slave server;
and replacing the initial state information into the target state information so that the state information in the target slave server is synchronous with the state information in the master server.
A second aspect of the embodiments of the present application further provides an automatic deployment apparatus based on a MySQL cluster, where the automatic deployment apparatus based on a MySQL cluster includes:
the server determining module is used for determining a master server and acquiring a target slave server set which is in the same MySQL cluster with the master server;
the heartbeat establishing module is used for establishing heartbeat connection between the main server and each target slave server in the target slave server set;
the directory sending module is used for receiving and analyzing a first heartbeat packet sent to the main server by the target slave server to obtain an installation data directory corresponding to the target slave server, and the installation data directory is used for deploying a preset file;
the file sending module is used for sending a second heartbeat package to the target slave server, wherein the second heartbeat package carries the preset file, and the preset file is deployed to the installation data directory;
the information acquisition module is used for acquiring target state information of the main server after monitoring that the preset file deployment is finished;
and the state synchronization module is used for automatically synchronizing the state information in the target slave server according to the target state information.
A third aspect of the embodiments of the present application further provides a computer device, where the computer device includes a processor, and the processor is configured to implement the MySQL cluster-based automated deployment method according to any one of the above items when executing a computer program stored in a memory.
A fourth aspect of the embodiments of the present application further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the MySQL cluster-based automated deployment method is implemented as any one of the above methods.
According to the automatic deployment method based on the MySQL cluster, the automatic deployment device based on the MySQL cluster, the computer equipment and the computer readable storage medium, a heartbeat connection is established between the main server and the target slave server, the installation data directory of the preset file of the target slave server is obtained through a first heartbeat package sent to the main server by the target slave server, then a second heartbeat package sent to the target slave server by the main server is received, the preset file is obtained, the preset file is deployed to the installation data directory, mySQL deployment is completed, automatic deployment is achieved, complexity of manual operation can be reduced, and deployment efficiency is improved. The method and the system can be applied to various functional modules of smart cities such as smart government affairs and smart traffic, for example, the MySQL cluster-based automatic deployment module of the smart government affairs can promote the rapid development of the smart cities.
Drawings
Fig. 1 is a flowchart of an automated deployment method based on MySQL cluster according to an embodiment of the present application.
Fig. 2 is a structural diagram of an automatic deployment apparatus based on MySQL cluster according to the second embodiment of the present application.
Fig. 3 is a schematic structural diagram of a computer device provided in the third embodiment of the present application.
The following detailed description will further illustrate the present application in conjunction with the above-described figures.
Detailed Description
In order that the above objects, features and advantages of the present application can be more clearly understood, a detailed description of the present application will be given below with reference to the accompanying drawings and specific embodiments. It should be noted that the embodiments and features of the embodiments of the present application may be combined with each other without conflict.
In the following description, numerous specific details are set forth to provide a thorough understanding of the present application, and the described embodiments are a part, but not all, of the present application. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments in the present application without making any creative effort belong to the protection scope of the present application.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs. The terminology used herein in the description of the present application is for the purpose of describing particular embodiments only and is not intended to be limiting of the application.
The MySQL cluster-based automatic deployment method provided by the embodiment of the invention is executed by computer equipment, and correspondingly, the MySQL cluster-based automatic deployment device runs in the computer equipment.
Fig. 1 is a flowchart of an automated deployment method based on MySQL cluster according to a first embodiment of the present application. As shown in fig. 1, the automatic deployment method based on MySQL cluster may include the following steps, and according to different requirements, the order of the steps in the flowchart may be changed, and some may be omitted:
s11, determining a master server, and acquiring a target slave server set which is in the same MySQL cluster with the master server.
In at least one embodiment of the present application, the number of the master servers may be 1, the number of the target slave servers may be multiple, multiple target slave servers form a target slave server set, and the master server and the target slave server set corresponding to the master server belong to the same MySQL cluster. The master server is a control server including slave server cluster management, configuration management, file management and task management, and the target slave server is a server for storing backup data. The slave server cluster management comprises adding, modifying and deleting slave server information; the configuration management comprises parameterized variables and assignments in each task; the file management comprises file management of a Mysql installation package, a script file and a configuration file; the task management comprises a main task and a plurality of subtasks, wherein the main task comprises subtasks, and each subtask specifically comprises executed operations, such as: the method comprises the following steps of cluster server initialization task, mysql deployment task, master-slave synchronization deployment task and master-slave verification task.
And S12, establishing heartbeat connection between the main server and each target slave server in the target slave server set.
In at least one embodiment of the present application, a heartbeat connection between the master server and each of the target slave servers is established to ensure network connectivity between the master server and the target slave servers.
Optionally, the establishing a heartbeat connection between the master server and each target slave server in the target slave server set includes:
acquiring operation parameters of the target slave server establishing long connection with the master server;
calculating the operation load state of the target slave server according to the operation parameters;
determining a heartbeat packet sending strategy corresponding to the running load state, wherein the heartbeat packet sending strategy comprises the sending frequency of heartbeat packets and the number of files carried by each heartbeat packet;
and establishing the heartbeat connection between the main server and the target slave server according to the heartbeat packet sending strategy.
The operation parameters may include information such as an operation state of the target slave server, a system time, a network signal, and the like. The operation load state refers to the load quantity currently borne by the target slave server, and the operation load state comprises a primary level, a middle level and a high level. When the running load state is primary, the target slave server bears less load currently; when the operation load state is a medium level, the load quantity borne by the target slave server is moderate; and when the running load state is high, the current load carried by the target slave server is larger.
In an embodiment, an operation load state calculation model may be established in advance, and the operation load state calculation model may enable the operation load state of the target slave server to be determined according to the operation parameters of the target server. The operation load state calculation model can be obtained through big data training, and the training process is the prior art and is not described herein again. The heartbeat packet sending strategy comprises the sending frequency of the heartbeat packets and the number of files carried by each heartbeat packet. The heartbeat packet sending strategy can be stored in a preset database, and the preset database can be a target node in a block chain in consideration of privacy and confidentiality of data. It can be understood that, when the operating load state is primary, the sending frequency of the heartbeat packets and the number of files carried by each heartbeat packet may be increased appropriately, and at this time, the target slave server can receive a larger number of files; when the operation load state is high, the sending frequency of the heartbeat packets and the number of files carried by each heartbeat packet can be reduced appropriately, and at this time, the target slave server can receive a smaller number of files.
In an embodiment, a first mapping relation and a second mapping relation between the running load state and the sending frequency of the heartbeat packets and the number of files carried by each heartbeat packet are established in advance, and the target sending frequency of the heartbeat packets in the running load state can be obtained by inquiring the first mapping relation; and acquiring the number of target files carried by the heartbeat packet under the operating load state by inquiring the second mapping relation.
This application is through right the running load state of server is followed to the target is confirmed to establish corresponding heartbeat package and send the strategy, can be based on running load state developments set up the sending frequency of heartbeat package and the file quantity that every heartbeat package carried, make heartbeat package sending strategy satisfy the running load state, avoid under the great condition of running load state, the problem of the too much target follow server overload operation that leads to of the sending frequency of heartbeat package too big and the file quantity that every heartbeat package carried can improve the target from the operating efficiency of server, and then improve the efficiency of cluster deployment.
S13, receiving and analyzing a first heartbeat packet sent from the target slave server to the master server to obtain an installation data directory corresponding to the target slave server, wherein the installation data directory is used for deploying preset files.
In at least one embodiment of the present application, the target slave server sends a first heartbeat package to the master server according to the heartbeat package sending policy, where the first heartbeat package carries an installation data directory in which the target slave server correspondingly installs the preset file, and the preset file may include files such as a MySQL installation package, a script file, and a configuration file. The installation data directory refers to a directory for installing the files. It can be understood that, for different target slave servers, the installation data directories corresponding to the preset files may be the same or different. The encoding of the target slave server may be carried in the first heartbeat packet to determine information of the target slave server.
Optionally, the receiving and analyzing the first heartbeat packet sent by the target slave server to the master server to obtain the installation data directory corresponding to the target slave server includes:
detecting whether the first heartbeat packet carries a preset mark or not;
when the detection result is that the first heartbeat packet carries the preset mark, determining the position of the preset mark, and acquiring configuration information at the position;
and extracting target format data in the configuration information as a preset file installation data directory corresponding to the slave server.
In order to ensure the transmission rate of the first heartbeat packet, the first heartbeat packet does not need to carry information such as an installation data directory and the like every time the first heartbeat packet is transmitted. In an embodiment, it may be determined that the first heartbeat packet carries the installation data directory by adding a preset flag. And the position of the preset mark is the position of the installation data directory. The configuration information at the position comprises a preset file installation data directory of the slave server, the installation data directory is written according to a target format, and the installation data directory of the preset file can be obtained by extracting target format data in the configuration information. The preset marks may be numerical marks, letter marks and color marks, and are not limited herein. The target format is a preset format.
And S14, sending a second heartbeat packet to the target slave server, wherein the second heartbeat packet carries the preset file, and the preset file is deployed to the installation data directory.
In at least one embodiment of the present application, when the master server receives a first heartbeat packet sent by the target slave server according to the heartbeat packet sending policy, where the first heartbeat packet carries an installation data directory in which the target slave server correspondingly installs the preset file, the master server returns a second heartbeat packet carrying the preset file to the target slave server, and the preset file may be a MySQL installation packet, a script file, a configuration file, or other files. And deploying the preset file to the installation data directory to finish the initial deployment of the MySQL cluster.
In an embodiment, it may be determined that the second heartbeat packet carries a preset file by adding a preset tag. And the position of the preset label is the position of the preset file. The preset labels may be numerical marks, letter marks and color marks, which are not limited herein. The steps of receiving and parsing the heartbeat packet are described above and will not be described herein.
Optionally, the sending a second heartbeat packet to the target slave server, where the second heartbeat packet carrying the preset file includes:
acquiring the file size of the preset file;
detecting whether the file size exceeds a preset file size threshold value;
when the detection result shows that the size of the file amount exceeds the preset file amount threshold value, splitting the preset file to obtain a target sub-file set;
and storing each target subfile in the target subfile set into the second heartbeat packet, and sending the second heartbeat packet to the target server according to the heartbeat packet sending strategy.
The preset file volume threshold value is the preset maximum file volume which can be borne by the heartbeat package, whether the file volume exceeds the preset file volume threshold value or not is detected, and when the detection result shows that the file volume exceeds the preset file volume threshold value, the preset file is split, so that the heartbeat package can be normally transmitted. In an embodiment, when the preset file is split to obtain the target subfile set, the preset file may be split in an average manner to obtain target subfiles with the same or similar file size. In other embodiments, the file size of each split target subfile may also be determined according to the running load status of the target slave server. It is understood that, when the detection result is that the size of the file amount does not exceed the preset file amount threshold, the transmission of the preset file may be completed by one heartbeat packet.
In an embodiment, before the deploying the preset file to the installation data directory, the method further includes:
when the file volume of the preset file exceeds the preset file volume threshold, acquiring a second heartbeat packet to obtain a second heartbeat packet set;
acquiring a target subfile carried by each second heartbeat packet in the second heartbeat packet set;
and determining the arrangement sequence of each target subfile, and integrating the target subfiles according to the arrangement sequence to obtain a preset file.
Each second heartbeat packet carries a mark marking the arrangement sequence of the target subfiles, and a complete preset file can be obtained by determining the arrangement sequence among the target subfiles, so that the problems of target subfile loss or target subfile transmission sequence error and the like caused by the current network problem are avoided, and the accuracy of the preset file can be ensured.
In one embodiment, the performance specifications of the target slave servers may or may not be the same. And for the slave servers with different performance specifications, assignment and replacement are carried out on related parameters in the preset file so as to adapt to the corresponding slave servers. Optionally, after the integrating the target subfiles according to the arrangement order to obtain a preset file, the method further includes:
acquiring the performance specification of the target slave server;
obtaining a target performance parameter corresponding to the performance specification according to a preset mapping relation between the performance specification and the performance parameter;
determining an initial performance parameter corresponding to the target performance parameter in the preset file;
and replacing the initial performance parameters as the target performance parameters to obtain a target preset file.
Wherein the performance parameters include, but are not limited to, a parameter max _ connections representing the maximum number of connectable connections and a parameter inbb _ buffer _ pool _ size representing the size of a data buffer pool.
S15, when the preset file deployment is monitored to be completed, acquiring target state information of the main server.
In at least one embodiment of the present application, after the preset file is deployed to the installation data directory, the target slave server may send a heartbeat packet to the master server, where the heartbeat packet carries information of successful deployment to prompt the master server to: the current target is successfully deployed from the server MySQL. And acquiring target state information of the main server, wherein the target state information can comprise state information corresponding to key fields such as master _ host, master _ user, master _ password, master _ log _ file, master _ log _ pos and the like.
And S16, automatically synchronizing the state information in the target slave server according to the target state information.
In at least one embodiment of the present application, the target state information is stored in a third heartbeat packet sent from the master server to the target slave server, the target slave server parses the third heartbeat packet to obtain the target state information of the master server, and the state in the target slave server is automatically synchronized according to the target state information, so as to complete the state synchronization between the master server and the target slave server. And the target slave server analyzes the third heartbeat packet to obtain target state information of the master server, and automatically synchronizes the state in the target slave server according to the target state information so as to complete state synchronization between the master server and the target slave server.
Optionally, the automatically synchronizing the state information in the target slave server according to the target state information includes:
acquiring a key field corresponding to the target state information;
determining initial state information corresponding to the key field in the target slave server;
and replacing the initial state information into the target state information so that the state information in the target slave server is synchronous with the state information in the master server.
The key field is a preset field for performing master-slave synchronization, for example, the key field may be a master _ host, a master _ user, a master _ password, a master _ log _ file, or a master _ log _ pos field. The initial state information refers to current state information corresponding to the key field in the target slave server. By replacing the initial state information with the target state information, the state information in the target slave server can be synchronized with the state information in the master server.
In an embodiment, after automatically synchronizing the state in the slave server according to the target state information, the method further comprises: and executing the verification synchronization task. Illustratively, the login target acquires the Slave _ status from the server, prints out the values of Slave _ IO _ Running and Slave _ SQL _ Running, and if the value is "Yes", the verification is passed.
According to the automatic deployment method based on the MySQL cluster, the heartbeat connection is established between the main server and the target slave server, the installation data directory of the preset file of the target slave server is obtained through the first heartbeat package sent by the target slave server to the main server, then the second heartbeat package sent by the main server to the target slave server is received, the preset file is obtained, the preset file is deployed to the installation data directory, mySQL deployment is completed, automatic deployment is achieved, complexity of manual operation can be reduced, and deployment efficiency is improved. The method and the system can be applied to various functional modules of smart cities such as smart government affairs and smart traffic, for example, the MySQL cluster-based automatic deployment module of the smart government affairs can promote the rapid development of the smart cities.
Fig. 2 is a structural diagram of an automatic deployment apparatus based on MySQL cluster according to the second embodiment of the present application.
In some embodiments, the MySQL cluster-based automated deployment apparatus 20 may comprise a plurality of functional modules composed of computer program segments. The computer programs of the respective program segments in the MySQL cluster-based automated deployment apparatus 20 may be stored in a memory of a computer device and executed by at least one processor to perform (see detailed description of fig. 1) the functions of MySQL cluster-based automated deployment.
In this embodiment, the MySQL cluster-based automation deployment device 20 may be divided into a plurality of functional modules according to the functions executed by the device. The functional module may include: the server comprises a server determination module 201, a heartbeat establishing module 202, a directory sending module 203, a file sending module 204, an information obtaining module 205 and a state synchronization module 206. A module as referred to herein is a series of computer program segments capable of being executed by at least one processor and capable of performing a fixed function and is stored in a memory. In the present embodiment, the functions of the modules will be described in detail in the following embodiments.
The server determining module 201 is configured to determine a master server, and acquire a target slave server set in the same MySQL cluster as the master server.
In at least one embodiment of the present application, the number of the master servers may be 1, the number of the target slave servers may be multiple, multiple target slave servers may form a target slave server set, and the master server and the target slave server set corresponding to the master server belong to the same MySQL cluster. The master server is a control server including slave server cluster management, configuration management, file management and task management, and the target slave server is a server for storing backup data. The slave server cluster management comprises adding, modifying and deleting cluster server information; the configuration management comprises parameterized variables and assignments in each task; the file management comprises file management of a Mysql installation package, a script file and a configuration file; the task management comprises a main task and a plurality of subtasks, wherein the main task comprises subtasks, and each subtask specifically comprises executed operations, such as: the method comprises the steps of cluster server initialization task, mysql deployment task, master-slave synchronous deployment task and master-slave verification task.
A heartbeat establishing module 202, configured to establish a heartbeat connection between the master server and each target slave server in the target slave server set.
And establishing heartbeat connection between the master server and each target slave server so as to ensure the network connectivity between the master server and the target slave servers. Optionally, the establishing a heartbeat connection between the master server and each target slave server in the target slave server set includes:
acquiring operation parameters of the target slave server which establishes long connection with the master server;
calculating the operation load state of the target slave server according to the operation parameters;
determining a heartbeat packet sending strategy corresponding to the running load state, wherein the heartbeat packet sending strategy comprises the sending frequency of heartbeat packets and the number of files carried by each heartbeat packet;
and establishing heartbeat connection between the main server and the target slave server according to the heartbeat packet sending strategy.
The operation parameters may include information such as an operation state of the target slave server, a system time, a network signal, and the like. The operation load state refers to the load quantity currently borne by the target slave server, and the operation load state comprises a primary level, a middle level and a high level. When the running load state is primary, the target slave server bears less load currently; when the operation load state is a medium level, the load quantity borne by the target slave server is moderate; and when the running load state is high, the current load carried by the target slave server is larger.
In an embodiment, an operation load state calculation model may be established in advance, and the operation load state calculation model may enable the operation load state of the target slave server to be determined according to the operation parameters of the target server. The operation load state calculation model can be obtained through big data training, and the training process is the prior art and is not described herein again. The heartbeat packet sending strategy comprises the sending frequency of the heartbeat packets and the number of files carried by each heartbeat packet. The heartbeat packet sending strategy can be stored in a preset database, and the preset database can be a target node in a block chain in consideration of privacy and confidentiality of data. It can be understood that, when the operating load state is primary, the sending frequency of the heartbeat packets and the number of files carried by each heartbeat packet may be increased appropriately, and at this time, the target slave server can receive a larger number of files; when the operation load state is high, the sending frequency of the heartbeat packets and the number of files carried by each heartbeat packet can be reduced appropriately, and at this time, the target slave server can receive a smaller number of files.
In an embodiment, a first mapping relation and a second mapping relation between the running load state and the sending frequency of the heartbeat packets and the number of files carried by each heartbeat packet are established in advance, and the target sending frequency of the heartbeat packets in the running load state can be obtained by inquiring the first mapping relation; and acquiring the number of target files carried by the heartbeat packet under the operating load state by inquiring the second mapping relation.
This application is through right the running load state of target from the server is confirmed to establish corresponding heartbeat package and send the strategy, can be based on running load state developments set up the sending frequency of heartbeat package and the file quantity that every heartbeat package carried, make heartbeat package sending strategy satisfy the running load state, avoid under the great condition of running load state, the problem of the too big target from server overload operation that leads to of the sending frequency of heartbeat package and the file quantity that every heartbeat package carried excessively, can improve the target from the operating efficiency of server, and then improve the efficiency of cluster deployment.
The directory sending module 203 is configured to receive and analyze the first heartbeat packet sent by the target slave server to the master server, so as to obtain an installation data directory corresponding to the target slave server, where the installation data directory is used to deploy a preset file.
In at least one embodiment of the present application, the target slave server sends a first heartbeat package to the master server according to the heartbeat package sending policy, where the first heartbeat package carries an installation data directory in which the target slave server correspondingly installs the preset file, and the preset file may include files such as a MySQL installation package, a script file, and a configuration file. The installation data directory refers to a directory for installing the files. It can be understood that, for different target slave servers, the installation data directories corresponding to the preset files may be the same or different. The encoding of the target slave server may be carried in the first heartbeat packet to determine information of the target slave server.
Optionally, the receiving and analyzing the first heartbeat packet sent from the target slave server to the master server to obtain the installation data directory corresponding to the target slave server includes:
detecting whether the first heartbeat packet carries a preset mark or not;
when the detection result is that the first heartbeat packet carries the preset mark, determining the position of the preset mark, and acquiring configuration information at the position;
and extracting target format data in the configuration information as a preset file installation data directory corresponding to the slave server.
In order to ensure the transmission rate of the first heartbeat packet, the first heartbeat packet does not need to carry information such as an installation data directory and the like every time the first heartbeat packet is transmitted. In an embodiment, it may be determined that the first heartbeat packet carries the installation data directory by adding a preset flag. And the position of the preset mark is the position of the installation data directory. The configuration information at the position comprises a preset file installation data directory of the slave server, the installation data directory is written according to a target format, and the installation data directory of the preset file can be obtained by extracting target format data in the configuration information. The preset marks may be numeric marks, alphabetic marks, and color marks, which are not limited herein. The target format is a preset format.
The file sending module 204 is configured to send a second heartbeat package to the target slave server, where the second heartbeat package carries the preset file, and the preset file is deployed to the installation data directory.
In at least one embodiment of the present application, when the master server receives a first heartbeat packet sent by the slave server according to the heartbeat packet sending policy, where the first heartbeat packet carries an installation data directory in which the preset file is correspondingly installed by the slave server, the master server returns a second heartbeat packet carrying the preset file to the slave server, and the preset file may be a file such as a MySQL installation packet, a script file, a configuration file, and the like. And deploying the preset file to the installation data directory to finish the initial deployment of the MySQL cluster.
In an embodiment, it may be determined that the second heartbeat packet carries a preset file by adding a preset tag. And the position of the preset label is the position of the preset file. The preset label may be a number mark, a letter mark, and a color mark, which is not limited herein. The steps of receiving and parsing the heartbeat packet are described above and will not be described herein.
Optionally, the sending a second heartbeat packet to the target slave server, where the second heartbeat packet carrying the preset file includes:
acquiring the file size of the preset file;
detecting whether the file size exceeds a preset file size threshold value;
when the detection result shows that the size of the file amount exceeds the preset file amount threshold value, splitting the preset file to obtain a target sub-file set;
and storing each target subfile in the target subfile set into the second heartbeat packet, and sending the second heartbeat packet to the target server according to the heartbeat packet sending strategy.
The preset file volume threshold value is the preset maximum file volume which can be borne by the heartbeat package, whether the file volume exceeds the preset file volume threshold value or not is detected, and when the detection result shows that the file volume exceeds the preset file volume threshold value, the preset file is split, so that the heartbeat package can be normally transmitted. In an embodiment, when the preset file is split to obtain the target subfile set, the preset file may be split in an average manner to obtain target subfiles with the same or similar file size. In other embodiments, the file size of each split target subfile may also be determined according to the running load status of the target slave server. It can be understood that, when the detection result is that the size of the file amount does not exceed the preset file amount threshold, the transmission of the preset file may be completed by one heartbeat packet.
In an embodiment, before the deploying the preset file to the installation data directory, the file sending module 204 is further configured to:
when the file volume of the preset file exceeds the preset file volume threshold, acquiring a second heartbeat packet to obtain a second heartbeat packet set;
acquiring a target subfile carried by each second heartbeat packet in the second heartbeat packet set;
and determining the arrangement sequence of each target subfile, and integrating the target subfiles according to the arrangement sequence to obtain a preset file.
Each second heartbeat packet carries a mark marking the arrangement sequence of the target subfiles, and a complete preset file can be obtained by determining the arrangement sequence among the target subfiles, so that the problems of target subfile loss or target subfile transmission sequence error and the like caused by the current network problem are avoided, and the accuracy of the preset file can be ensured.
In one embodiment, the performance specifications of the target slave servers may or may not be the same. And for the slave servers with different performance specifications, assignment and replacement are carried out on related parameters in the preset file so as to adapt to the corresponding slave servers. Optionally, after the target subfiles are integrated according to the arrangement order to obtain a preset file, the file sending module 204 is further configured to:
acquiring the performance specification of the target slave server;
obtaining a target performance parameter corresponding to the performance specification according to a preset mapping relation between the performance specification and the performance parameter;
determining an initial performance parameter corresponding to the target performance parameter in the preset file;
and replacing the initial performance parameters as the target performance parameters to obtain a target preset file.
Wherein the performance parameters include, but are not limited to, a parameter max _ connections representing the maximum number of connectable connections and a parameter inbb _ buffer _ pool _ size representing the size of a data buffer pool.
An information obtaining module 205, configured to obtain target state information of the main server after it is monitored that the preset file deployment is completed.
In at least one embodiment of the present application, after the preset file is deployed to the installation data directory, the slave server may send a heartbeat packet to the master server, and the heartbeat packet carries information of successful deployment, so as to prompt the master server to: currently, mySQL deployment from a server is successful. And acquiring target state information of the main server, wherein the target state information can comprise state information corresponding to key fields such as master _ host, master _ user, master _ password, master _ log _ file, master _ log _ pos and the like.
And a state synchronization module 206, configured to automatically synchronize the state information in the target slave server according to the target state information.
In at least one embodiment of the present application, the destination state information is stored in a third heartbeat packet sent from the master server to the slave server, the slave server analyzes the third heartbeat packet to obtain the destination state information of the master server, and the state in the slave server is automatically synchronized according to the destination state information, so as to complete the state synchronization between the master server and the slave server. And the slave server analyzes the third heartbeat packet to obtain the target state information of the master server, and automatically synchronizes the state in the slave server according to the target state information so as to complete the state synchronization between the master server and the slave server.
Optionally, the automatically synchronizing the state information in the target slave server according to the target state information includes:
acquiring a key field corresponding to the target state information;
determining initial state information corresponding to the key field in the target slave server;
and replacing the initial state information into the target state information so that the state information in the target slave server is synchronous with the state information in the master server.
The key field is a preset field for performing master-slave synchronization, for example, the key field may be a master _ host, a master _ user, a master _ password, a master _ log _ file, a master _ log _ pos, or other fields. The initial state information refers to current state information corresponding to the key field in the target slave server. By replacing the initial state information with the target state information, the state information in the target slave server can be synchronized with the state information in the master server.
In an embodiment, after automatically synchronizing the state information in the target slave server according to the target state information, the state synchronization module 206 is further configured to: and executing the verification synchronization task. Illustratively, the login target acquires the Slave _ status from the server, prints out the values of Slave _ IO _ Running and Slave _ SQL _ Running, and if the value is "Yes", the verification is passed.
Fig. 3 is a schematic structural diagram of a computer device according to a third embodiment of the present application. In the preferred embodiment of the present application, the computer device 3 includes a memory 31, at least one processor 32, at least one communication bus 33, and a transceiver 34.
It will be appreciated by those skilled in the art that the configuration of the computer device shown in fig. 3 is not a limitation of the embodiments of the present application, and may be a bus-type configuration or a star-type configuration, and that the computer device 3 may include more or less hardware or software than those shown, or a different arrangement of components.
In some embodiments, the computer device 3 is a device capable of automatically performing numerical calculation and/or information processing according to instructions set or stored in advance, and the hardware includes but is not limited to a microprocessor, an application specific integrated circuit, a programmable gate array, a digital processor, an embedded device, and the like. The computer device 3 may also include a client device, which includes, but is not limited to, any electronic product capable of interacting with a client through a keyboard, a mouse, a remote controller, a touch pad, or a voice control device, for example, a personal computer, a tablet computer, a smart phone, a digital camera, etc.
It should be noted that the computer device 3 is only an example, and other existing or future electronic products, such as those that may be adapted to the present application, are also included in the scope of the present application and are incorporated herein by reference.
In some embodiments, the memory 31 has stored therein a computer program which, when executed by the at least one processor 32, implements all or part of the steps of the MySQL cluster-based automated deployment method described above. The Memory 31 includes a Read-Only Memory (ROM), a Programmable Read-Only Memory (PROM), an Erasable Programmable Read-Only Memory (EPROM), a One-time Programmable Read-Only Memory (OTPROM), an electronically Erasable Programmable Read-Only Memory (Electrically-Erasable Programmable Read-Only Memory (EEPROM)), an optical Read-Only disk (CD-ROM) or other optical disk Memory, a magnetic disk Memory, a tape Memory, or any other medium capable of being Read by a computer for carrying or storing data.
Further, the computer-readable storage medium may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function, and the like; the storage data area may store data created according to the use of the blockchain node, and the like.
The block chain referred by the application is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
In some embodiments, the at least one processor 32 is a Control Unit (Control Unit) of the computer device 3, connects various components of the entire computer device 3 by using various interfaces and lines, and executes various functions and processes data of the computer device 3 by running or executing programs or modules stored in the memory 31 and calling data stored in the memory 31. For example, the at least one processor 32, when executing the computer program stored in the memory, implements all or part of the steps of the MySQL cluster-based automated deployment method described in the embodiments of the present application; or all or part of functions of the automatic deployment device based on the MySQL cluster are realized. The at least one processor 32 may be composed of an integrated circuit, for example, a single packaged integrated circuit, or may be composed of a plurality of integrated circuits packaged with the same or different functions, including one or more Central Processing Units (CPUs), microprocessors, digital Processing chips, graphics processors, and combinations of various control chips.
In some embodiments, the at least one communication bus 33 is arranged to enable connection communication between the memory 31 and the at least one processor 32 or the like.
Although not shown, the computer device 3 may further include a power supply (such as a battery) for supplying power to each component, and preferably, the power supply may be logically connected to the at least one processor 32 through a power management device, so as to implement functions of managing charging, discharging, and power consumption through the power management device. The power supply may also include any component of one or more dc or ac power sources, recharging devices, power failure detection circuitry, power converters or inverters, power status indicators, and the like. The computer device 3 may further include various sensors, a bluetooth module, a Wi-Fi module, and the like, which are not described herein again.
The integrated unit implemented in the form of a software functional module may be stored in a computer-readable storage medium. The software functional module is stored in a storage medium and includes several instructions to enable a computer device (which may be a personal computer, a computer device, or a network device) or a processor (processor) to execute parts of the methods according to the embodiments of the present application.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
It will be evident to those skilled in the art that the present application is not limited to the details of the foregoing illustrative embodiments, and that the present application may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the application being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned. Furthermore, it is obvious that the word "comprising" does not exclude other elements or that the singular does not exclude the plural. A plurality of units or means recited in the specification may also be implemented by one unit or means through software or hardware. The terms first, second, etc. are used to denote names, but not any particular order.
Finally, it should be noted that the above embodiments are only used for illustrating the technical solutions of the present application and not for limiting, and although the present application is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions can be made to the technical solutions of the present application without departing from the spirit and scope of the technical solutions of the present application.

Claims (9)

1. An automatic deployment method based on MySQL cluster is characterized by comprising the following steps:
determining a master server, and acquiring a target slave server set which is in the same MySQL cluster with the master server;
acquiring operation parameters of the target slave server establishing long connection with the master server;
calculating the operation load state of the target slave server according to the operation parameters;
determining a heartbeat packet sending strategy corresponding to the running load state, wherein the heartbeat packet sending strategy comprises the sending frequency of heartbeat packets and the number of files carried by each heartbeat packet; establishing heartbeat connection between the main server and each target slave server in the target slave server set according to the heartbeat packet sending strategy;
receiving and analyzing a first heartbeat packet sent to the main server by the target slave server to obtain an installation data directory corresponding to the target slave server, wherein the installation data directory is used for deploying a preset file;
sending a second heartbeat package to the target slave server, wherein the second heartbeat package carries the preset file and deploys the preset file to the installation data directory;
when the preset file deployment is monitored to be completed, acquiring target state information of the main server;
and automatically synchronizing the state information in the target slave server according to the target state information.
2. The MySQL cluster-based automated deployment method of claim 1, wherein the receiving and analyzing a first heartbeat packet sent by the target slave server to the master server to obtain an installation data directory corresponding to the target slave server comprises:
detecting whether the first heartbeat packet carries a preset mark or not;
when the detection result is that the first heartbeat packet carries the preset mark, determining a target position of the preset mark, and acquiring configuration information at the target position;
and extracting target format data in the configuration information as an installation data directory corresponding to the slave server.
3. The MySQL cluster-based automated deployment method of claim 1, wherein the sending a second heartbeat package to the target slave server comprises:
acquiring the file size of the preset file;
detecting whether the file size exceeds a preset file size threshold value;
when the detection result shows that the size of the file amount exceeds the preset file amount threshold value, splitting the preset file to obtain a target sub-file set;
and storing each target subfile in the target subfile set into the second heartbeat packet, and sending the second heartbeat packet to the target slave server according to the heartbeat packet sending strategy.
4. The MySQL cluster-based automated deployment method according to claim 3, wherein before the deploying the preset file to the installation data directory, the method further comprises:
when the file volume of the preset file exceeds the preset file volume threshold, acquiring a second heartbeat packet to obtain a second heartbeat packet set;
acquiring a target subfile carried by each second heartbeat packet in the second heartbeat packet set to obtain a target subfile set;
and determining the arrangement sequence of each target subfile in the target subfile set, and combining the target subfiles according to the arrangement sequence to obtain a preset file.
5. The MySQL cluster-based automated deployment method according to claim 4, wherein after the merging the target subfiles according to the arrangement order to obtain a preset file, the method further comprises:
acquiring the performance specification of the target slave server;
obtaining a target performance parameter corresponding to the performance specification according to a preset mapping relation between the performance specification and the performance parameter;
determining an initial performance parameter corresponding to the target performance parameter in the preset file;
and replacing the initial performance parameters as the target performance parameters to obtain a target preset file.
6. The MySQL cluster-based automated deployment method of claim 1, wherein the automatically synchronizing the state information in the target slave server according to the target state information comprises:
acquiring a key field corresponding to the target state information;
determining initial state information corresponding to the key field in the target slave server;
and replacing the initial state information into the target state information so that the state information in the target slave server is synchronous with the state information in the master server.
7. An automatic deployment device based on MySQL cluster is characterized in that the automatic deployment device based on MySQL cluster comprises:
the server determining module is used for determining a master server and acquiring a target slave server set which is in the same MySQL cluster with the master server;
the heartbeat establishing module is used for acquiring the operating parameters of a target slave server which establishes long connection with the master server; calculating the operation load state of the target slave server according to the operation parameters; determining a heartbeat packet sending strategy corresponding to the running load state, wherein the heartbeat packet sending strategy comprises the sending frequency of heartbeat packets and the number of files carried by each heartbeat packet; establishing heartbeat connection between the main server and each target slave server in the target slave server set according to the heartbeat packet sending strategy;
the directory sending module is used for receiving and analyzing a first heartbeat packet sent to the main server by the target slave server to obtain an installation data directory corresponding to the target slave server, and the installation data directory is used for deploying a preset file;
the file sending module is used for sending a second heartbeat package to the target slave server, wherein the second heartbeat package carries the preset file, and the preset file is deployed to the installation data directory;
the information acquisition module is used for acquiring target state information of the main server after monitoring that the preset file deployment is finished;
and the state synchronization module is used for automatically synchronizing the state information in the target slave server according to the target state information.
8. A computer device comprising a processor for implementing the MySQL cluster-based automated deployment method when executing a computer program stored in a memory according to any one of claims 1 to 6.
9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the MySQL cluster-based automated deployment method according to any one of claims 1 to 6.
CN202110519134.4A 2021-05-12 2021-05-12 MySQL cluster-based automatic deployment method and device and related equipment Active CN113138882B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110519134.4A CN113138882B (en) 2021-05-12 2021-05-12 MySQL cluster-based automatic deployment method and device and related equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110519134.4A CN113138882B (en) 2021-05-12 2021-05-12 MySQL cluster-based automatic deployment method and device and related equipment

Publications (2)

Publication Number Publication Date
CN113138882A CN113138882A (en) 2021-07-20
CN113138882B true CN113138882B (en) 2023-02-07

Family

ID=76817864

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110519134.4A Active CN113138882B (en) 2021-05-12 2021-05-12 MySQL cluster-based automatic deployment method and device and related equipment

Country Status (1)

Country Link
CN (1) CN113138882B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113949704B (en) * 2021-10-15 2024-03-08 北京奇艺世纪科技有限公司 User information processing method and server cluster
CN114124459B (en) * 2021-10-25 2024-04-09 杭州安恒信息技术股份有限公司 Cluster server security protection method, device, equipment and storage medium
CN114860349B (en) * 2022-07-06 2022-11-08 深圳华锐分布式技术股份有限公司 Data loading method, device, equipment and medium

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103532784A (en) * 2013-10-17 2014-01-22 中国联合网络通信集团有限公司 Method and system for transmitting heartbeat messages, terminal and network equipment

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030126247A1 (en) * 2002-01-02 2003-07-03 Exanet Ltd. Apparatus and method for file backup using multiple backup devices
CN104679907A (en) * 2015-03-24 2015-06-03 新余兴邦信息产业有限公司 Realization method and system for high-availability and high-performance database cluster
CN109165022A (en) * 2018-07-18 2019-01-08 山东中创软件商用中间件股份有限公司 A kind of big data cluster dispositions method, system, medium and equipment
CN112035435A (en) * 2020-08-26 2020-12-04 浪潮云信息技术股份公司 MySQL master-slave cluster installation deployment method and cluster system

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103532784A (en) * 2013-10-17 2014-01-22 中国联合网络通信集团有限公司 Method and system for transmitting heartbeat messages, terminal and network equipment

Also Published As

Publication number Publication date
CN113138882A (en) 2021-07-20

Similar Documents

Publication Publication Date Title
CN113138882B (en) MySQL cluster-based automatic deployment method and device and related equipment
CN107566165B (en) Method and system for discovering and deploying available resources of power cloud data center
CN106850260A (en) A kind of dispositions method and device of virtual resources management platform
CN110719209B (en) Cluster network configuration method, system, equipment and readable storage medium
CN112698971A (en) Rule engine based parameter conversion method, device, equipment and medium
CN102708027B (en) A kind of method and system avoiding outage of communication device
CN103064757A (en) Method and system for backing up data
CN112948063A (en) Cloud platform creation method and device, cloud platform and cloud platform implementation system
CN112948723A (en) Interface calling method and device and related equipment
CN114385759A (en) Configuration file synchronization method and device, computer equipment and storage medium
CN112199157A (en) Cloud environment management method
CN109474467A (en) Network automatically management method, device, storage medium and electronic equipment
CN114281788A (en) BMC firmware data extraction method, device, terminal and storage medium
CN114650223A (en) Network configuration method and device of Kubernetes cluster and electronic equipment
CN112367186B (en) Fault protection method and device based on 0penStack bare computer
CN111459510A (en) Cross-network operating system installation method and device, electronic equipment and medium
CN112598135A (en) Model training processing method and device, computer equipment and medium
CN102413154B (en) Method of data information synchronization between systems and apparatus thereof
CN107707398B (en) Method and device for managing physical host in cloud computing system
CN110795118A (en) Cloud platform upgrading tool and upgrading method
CN113746676B (en) Network card management method, device, equipment, medium and product based on container cluster
CN112804202B (en) Multi-internetwork data security interaction method and device, server and storage medium
CN106557386A (en) Method, the apparatus and system of standby virtual network interface card virtual machine are disposed based on KVM
CN109032765A (en) A kind of virtual machine two-node cluster hot backup dispositions method, device and equipment
CN113286014A (en) Dynamic configuration method and device of basic domain name and related equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
TA01 Transfer of patent application right

Effective date of registration: 20211015

Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.)

Applicant after: Shenzhen saiante Technology Service Co.,Ltd.

Address before: 1-34 / F, Qianhai free trade building, 3048 Xinghai Avenue, Mawan, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong 518000

Applicant before: Ping An International Smart City Technology Co.,Ltd.

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant