CN112035435A - MySQL master-slave cluster installation deployment method and cluster system - Google Patents
MySQL master-slave cluster installation deployment method and cluster system Download PDFInfo
- Publication number
- CN112035435A CN112035435A CN202010870488.9A CN202010870488A CN112035435A CN 112035435 A CN112035435 A CN 112035435A CN 202010870488 A CN202010870488 A CN 202010870488A CN 112035435 A CN112035435 A CN 112035435A
- Authority
- CN
- China
- Prior art keywords
- master
- mysql
- slave
- server
- cluster
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 32
- 238000009434 installation Methods 0.000 title claims abstract description 30
- 238000013515 script Methods 0.000 claims abstract description 23
- 230000010076 replication Effects 0.000 claims description 9
- 238000012544 monitoring process Methods 0.000 claims description 6
- 230000003252 repetitive effect Effects 0.000 claims description 3
- 238000000638 solvent extraction Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/61—Installation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/445—Program loading or initiating
- G06F9/44505—Configuring for program initiating, e.g. using registry, configuration files
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a MySQL master-slave cluster installation deployment method and a MySQL master-slave cluster installation system, belongs to the technical field of cluster deployment and installation, and aims to solve the technical problem of how to quickly and automatically install and deploy MySQL clusters. The method comprises the following steps: deploying a server for installing MySQL, and verifying the network connectivity of the server; preparing a data directory/var/lib/mysql for each server, and initializing the data directory/var/lib/mysql; initializing a user; initializing other running scripts for each server; setting a server MySQL configuration file; configuring a Slave node server, and automatically synchronizing data between the Slave node server and a Master Master node server; other running scripts for each server are started. The system comprises a plurality of servers, and the MySQL master-slave cluster is installed and deployed by the method.
Description
Technical Field
The invention relates to the technical field of cluster deployment and installation, in particular to a MySQL master-slave cluster installation deployment method and a cluster system.
Background
Under the background of cloud computing and big data, the application of the database in a public cloud environment is more and more extensive. The MySQL database is currently popular relational data, and in an actual production environment, the MySQL service of a single server cannot completely meet actual requirements in consideration of safety, high availability and other aspects. Therefore, data is generally synchronized by Master-Slave copy (Master-Slave), even if a Master node server fails to start, and the data is not cold or hot backed up, the data served by the Slave nodes of the Slave is particularly important for data recovery.
After the MySQL service is installed, the master-slave cluster deployment of MySQL also needs to perform related configuration on the master-slave node server, including data directory, user, master-slave plug-in, master-slave configuration, and the like, and is manually completed by professional technicians or operation and maintenance personnel.
Based on the analysis, how to rapidly and automatically install and deploy the MySQL cluster is a technical problem to be solved.
Disclosure of Invention
The technical task of the invention is to provide a MySQL master-slave cluster installation and deployment method and a MySQL cluster system aiming at the defects so as to solve the problem of how to quickly and automatically install and deploy the MySQL cluster.
In a first aspect, the invention provides a MySQL master-slave cluster installation and deployment method, which automatically installs and deploys MySQL master-slave clusters by executing an infrastructure script, and the method comprises the following steps:
deploying servers for installing MYSQL, and verifying the network connectivity of the servers to determine that an interrupt script execution program is communicated with the server network, wherein at least one server is used;
preparing a data directory/var/lib/mysql for each server, and initializing the data directory/var/lib/mysql;
initializing a user, wherein the user is used for master-slave synchronization of a MySQL cluster;
initializing other running scripts for each server, wherein the other running scripts comprise but are not limited to monitoring function scripts;
setting a MySQL configuration file of a server, and respectively modifying the configuration file for a Master Master node server and a Slave node server;
configuring a Slave node server, and automatically synchronizing data between the Slave node server and a Master Master node server;
other running scripts for each server are started.
Preferably, the server for installing the MySQL master-slave cluster satisfies the following conditions:
the virtual machine mirror image is provided with MySQL services of the same version;
servers of the same specification are created based on the same virtual machine image.
Preferably, a data directory/var/lib/mysql is prepared for each server, comprising:
mounting a new disk to a target server, and performing fdisk disk partitioning;
performing LVM logical volume management, wherein the logical volume mounts a data directory/var/lib/mysql directory for specially storing the data directory;
initializing the data directory/var/lib/mysql, which comprises the following steps: and initializing non-secure mode MySQL data for the newly mounted data directory for anonymous login of the database.
Preferably, the LOCAL SSD disk is mounted to the destination server.
Preferably, initializing the user includes:
initializing and creating a database user for master-SLAVE synchronization, and giving permission to REPLICATION SLAVE and REPLICATION CLIENT;
create database users for other functions including but not limited to monitoring database operating status, delete localhost and 127.0.0.1 local users with their own initialization data directories, and non-secure anonymous users.
Preferably, configuring the Slave node server includes:
setting a server MySQL configuration file;
accessing a Master Master node server at a Slave node server, acquiring MySQL information of the Master node server, and recording the IP of the Master node server and the current binlog file name and position of the MySQL service;
selectively stopping the Slave at the Slave node server to ensure that the Slave node server does not perform master-Slave synchronization;
taking a binlog file and position information of a Master Master node server corresponding to MySQL service, and configuring Slave Master-Slave synchronization;
and starting master-slave synchronization and executing a start slave command.
Preferably, the setting of the server MySQL configuration file comprises the following steps:
acquiring the specification of a server, and setting a parameter max _ connections and a parameter inbo _ buffer _ pool _ size according to the performance specification, wherein the parameter max _ connections represents the maximum number of connectable connections, and the parameter inbo _ buffer _ pool _ size represents the size of a data buffer pool;
setting server _ id of each server, wherein the server _ id of the servers are different;
starting the semi-synchronous setting of master-slave synchronization, including rpl _ semi _ sync _ master _ enabled, rpl _ semi _ sync _ slave _ enabled, and rpl _ semi _ sync _ master _ timeout;
setting a semi-synchronous plug-in configuration, i.e. plug-load
So, rpl _ semi _ sync _ master ═ semi sync _ master; so that the master and slave plug-ins can be automatically installed when the MySQL service is started, the semi-synchronous replication is continuously used after the service of the master and slave nodes is switched, and the semi-synchronous plug-ins are not required to be installed independently;
and restarting the MySQL service, and enabling the MySQL configuration to be effective.
Preferably, different server _ ids are set for each server based on the property that the unix timestamp string is not repeated.
In a second aspect, the present invention provides a cluster system, including a plurality of servers, where the cluster system installs and deploys a MySQL master-slave cluster by applying the MySQL master-slave cluster installation and deployment method according to any one of the first aspect.
The MySQL master-slave cluster installation deployment method and the cluster system have the following advantages:
1. the method has the advantages that the database cluster script is created through batch execution of the infrastructure script, server IPs of the master-slave cluster are deployed on the server IP, and compiled infrastructure commands are executed, so that the MySQL master-slave cluster building function can be realized by one key, the deployment can be completed quickly, the automation completion is performed to the maximum extent, the service response capability is improved, the cost is reduced, the installation and deployment efficiency of the MySQL master-slave cluster is improved, and the feasibility is high;
2. the method comprises the following steps that (1) automatic installation and deployment are carried out in batches by adopting Ansible, MySQL configuration files are synchronously set by different Master and Slave role servers of MySQL Master-Slave clusters, and Master-Slave MySQL data synchronization is set by Slave servers of different roles, so that the complexity of manual operation is reduced, and the deployment efficiency is improved;
3. the maximum connection number and the inbodb cache configuration of the MySQL are set according to different server specifications, the configuration of the server is utilized to the maximum extent, and the MySQL service performance is improved;
4. different server _ ids are set for each server by utilizing the non-repetitive characteristic of unix timestamp character strings, so that the configuration of the servers is different, and the master-slave synchronization problem of the master-slave servers caused by the same server _ id is solved;
5. and the configuration of the semi-synchronous plug-in is set, so that the master plug-in and the slave plug-in can be automatically installed when the MySQL service is started, and the semi-synchronous copy is continuously used after the master node service and the slave node service are switched.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed for the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on the drawings without creative efforts.
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a flow chart of a MySQL master-slave cluster installation deployment method in embodiment 1;
fig. 2 is a block diagram of a flow of setting a server MySQL configuration file in the MySQL master-slave cluster installation deployment method in embodiment 1;
fig. 3 is a block flow diagram of configuring a Slave node server in the MySQL master-Slave cluster installation and deployment method in embodiment 1.
Detailed Description
The present invention is further described in the following with reference to the drawings and the specific embodiments so that those skilled in the art can better understand the present invention and can implement the present invention, but the embodiments are not to be construed as limiting the present invention, and the embodiments and the technical features of the embodiments can be combined with each other without conflict.
It is to be understood that "a plurality" in the embodiments of the present invention means two or more.
The embodiment of the invention provides a MySQL master-slave cluster installation deployment method and a MySQL master-slave cluster installation deployment system, which are used for solving the technical problem of how to quickly and automatically install and deploy MySQL clusters.
Example (b):
the infrastructure is an automatic operation and maintenance tool, and can realize functions of batch system configuration, batch program deployment, batch operation commands and the like. The MySQL master-slave cluster is automatically installed and deployed by compiling the infrastructure script, one-key deployment is achieved, and the risk of manual misoperation of each server is reduced.
The MySQL master-slave cluster installation deployment method automatically installs and deploys MySQL master-slave clusters by executing an infrastructure script, and comprises the following steps:
s100, deploying servers for installing MySQL, and verifying the network connectivity of the servers to determine that an interrupt script execution program is communicated with the server network, wherein at least one server is provided;
s200, preparing a data directory/var/lib/mysql for each server, and initializing the data directory/var/lib/mysql;
s300, initializing a user, wherein the user is used for master-slave synchronization of the MySQL cluster;
s400, initializing other running scripts for each server, wherein the other running scripts comprise but are not limited to monitoring function scripts;
s500, setting a MySQL configuration file of a server, and modifying the configuration file for a Master Master node server and a Slave node server respectively;
s600, configuring a Slave node server, and automatically synchronizing data between the Slave node server and a Master Master node server;
and S700, starting other running scripts of each server.
The server for deploying and installing the MySQL master-slave cluster needs to meet the following advance conditions: the virtual machine mirror image is provided with MySQL services of the same version; servers of the same specification are created based on the same virtual machine image.
Preparing a data directory/var/lib/mysql for each server, comprising the steps of:
(1) mounting a new disk to a target server, and performing fdisk disk partitioning, wherein a LOCAL SSD disk is mounted to the target server in this embodiment;
(2) and performing LVM logical volume management, wherein the logical volume mounts a data directory/var/lib/mysql directory for specially storing the data directory.
Initializing the data directory/var/lib/mysql, which comprises the following steps: and initializing non-secure mode MySQL data for the newly mounted data directory for anonymous login of the database.
In step S300, each server starts up the MySQL database and initializes the user. Initializing the user includes the following operations: the method comprises the steps of initializing and creating database users for master-SLAVE synchronization, giving REPLICATION SLAVE and REPLICATION CLIENT rights, and creating database users for other functions, such as monitoring the running state of the database, deleting local users with localhost and 127.0.0.1 when initializing a data directory, and non-secure anonymous users.
In step S400, the method for setting the MySQL configuration file of the server includes the following steps:
s410, obtaining the specification of the server, and setting a parameter max _ connections and a parameter innodb _ buffer _ pool _ size according to the performance specification, wherein the parameter max _ connections represents the maximum number of connectable connections, and the parameter innodb _ buffer _ pool _ size represents the size of a data buffer pool;
s420, setting server _ ids of each server, wherein the server _ ids of the servers are different, and if the server _ ids of the Master server and the Slave server are consistent, synchronous copying fails, so that the server _ ids need to be set differently;
s430, starting semi-synchronous setting of master-slave synchronization, including rpl _ semi _ sync _ master _ enable-d, rpl _ semi _ sync _ slave _ enable, and rpl _ semi _ sync _ master _ timeout;
s440, setting a semi-synchronous plug-in configuration, namely plug-load
So, rpl _ semi _ sync _ master ═ semi sync _ master; so that the master and slave plug-ins can be automatically installed when the MySQL service is started, the semi-synchronous replication is continuously used after the service of the master and slave nodes is switched, and the semi-synchronous plug-ins are not required to be installed independently;
s450, restarting the MySQL service, wherein the MySQL configuration takes effect.
Configuring a Slave node server, comprising the following steps:
s510, setting a MySQL configuration file of the server according to the step S400;
s520, accessing a Master Master node server at the Slave node server, acquiring MySQL information of the Master node server, and recording the IP of the Master node server and the current binlog file name and position of the MySQL service;
s530, selectively stopping the Slave at the Slave node server to ensure that the Slave node server does not perform master-Slave synchronization;
s540, taking a binlog file and position information of a Master Master node server corresponding to MySQL service, and configuring Slave Master-Slave synchronization;
and S550, starting master-slave synchronization and executing a start slave command.
According to the MySQL Master-Slave cluster installation deployment method, the Ansible batch is adopted for automatic installation and deployment, different Master and Slave role servers of the MySQL Master-Slave cluster synchronously set MySQL configuration files, and Slave servers with different roles set Master-Slave MySQL data synchronization, so that the complexity of manual operation is reduced, and the deployment efficiency is improved; the maximum connection number and the inbodb cache configuration of the MySQL are set according to different server specifications, the configuration of the server is utilized to the maximum extent, and the MySQL service performance is improved; different server _ ids are set for each server by utilizing the non-repetitive characteristic of unix timestamp character strings, so that the configuration of the servers is different, and the master-slave synchronization problem of the master-slave servers caused by the same server _ id is solved; and the configuration of the semi-synchronous plug-in is set, so that the master plug-in and the slave plug-in can be automatically installed when the MySQL service is started, and the semi-synchronous copy is continuously used after the master node service and the slave node service are switched.
Example 2:
the cluster system of the invention comprises a plurality of servers, and the cluster system is provided with MySQL master-slave cluster by applying the MySQL master-slave cluster installation and deployment method disclosed in the embodiment 1.
While the invention has been shown and described in detail in the drawings and in the preferred embodiments, it is not intended to limit the invention to the embodiments disclosed, and it will be apparent to those skilled in the art that various combinations of the code auditing means in the various embodiments described above may be used to obtain further embodiments of the invention, which are also within the scope of the invention.
Claims (9)
- The MySQL master-slave cluster installation deployment method is characterized in that an optional script is executed to automatically install and deploy MySQL master-slave clusters, and the method comprises the following steps:deploying servers for installing MySQL, and verifying the network connectivity of the servers to determine that an interrupt script execution program is communicated with the server network, wherein at least one server is used;preparing a data directory/var/lib/mysql for each server, and initializing the data directory/var/lib/mysql;initializing a user, wherein the user is used for master-slave synchronization of a MySQL cluster;initializing other running scripts for each server, wherein the other running scripts comprise but are not limited to monitoring function scripts;setting a MySQL configuration file of a server, and respectively modifying the configuration file for a Master Master node server and a Slave node server;configuring a Slave node server, and automatically synchronizing data between the Slave node server and a Master Master node server;other running scripts for each server are started.
- 2. The MySQL master-slave cluster installation and deployment method according to claim 1, characterized in that the server for installing the MySQL master-slave cluster satisfies the following conditions:the virtual machine mirror image is provided with MySQL services of the same version;servers of the same specification are created based on the same virtual machine image.
- 3. The MySQL master-slave cluster deployment method of claim 1, wherein the step of preparing a data directory/var/lib/MySQL for each server comprises:mounting a new disk to a target server, and performing fdisk disk partitioning;performing LVM logical volume management, wherein the logical volume mounts a data directory/var/lib/mysql directory for specially storing the data directory;initializing the data directory/var/lib/mysql, which comprises the following steps: and initializing non-secure mode MySQL data for the newly mounted data directory for anonymous login of the database.
- 4. The MySQL master-slave cluster installation deployment method of claim 3, wherein a LOCAL SSD disk is mounted to the destination server.
- 5. The MySQL master-slave cluster installation and deployment method according to claim 1, wherein the initialization user comprises:initializing and creating a database user for master-SLAVE synchronization, and giving permission to REPLICATION SLAVE and REPLICATION CLIENT;create database users for other functions including but not limited to monitoring database operating status, delete localhost and 127.0.0.1 local users with their own initialization data directories, and non-secure anonymous users.
- 6. The MySQL master-Slave cluster installation deployment method according to claim 1, 2, 3, 4 or 5, wherein configuring the Slave node server comprises:setting a server MySQL configuration file;accessing a Master Master node server at a Slave node server, acquiring MySQL information of the Master node server, and recording the IP of the Master node server and the current binlog file name and position of the MySQL service;selectively stopping the Slave at the Slave node server to ensure that the Slave node server does not perform master-Slave synchronization;taking a binlog file and position information of a Master Master node server corresponding to MySQL service, and configuring Slave Master-Slave synchronization;and starting master-slave synchronization and executing a start slave command.
- 7. The MySQL master-slave cluster installation and deployment method of claim 6, wherein the server MySQL configuration file is set up, comprising the following steps:acquiring the specification of a server, and setting a parameter max _ connections and a parameter inbo _ buffer _ pool _ size according to the performance specification, wherein the parameter max _ connections represents the maximum number of connectable connections, and the parameter inbo _ buffer _ pool _ size represents the size of a data buffer pool;setting server _ id of each server, wherein the server _ id of the servers are different;starting the semi-synchronous setting of master-slave synchronization, including rpl _ semi _ sync _ master _ enabled, rpl _ semi _ sync _ slave _ enabled, and rpl _ semi _ sync _ master _ timeout;setting a semi-synchronous plug-in configuration, i.e. plug-loadSo, rpl _ semi _ sync _ master ═ semi sync _ master; so that the master and slave plug-ins can be automatically installed when the MySQL service is started, the semi-synchronous replication is continuously used after the service of the master and slave nodes is switched, and the semi-synchronous plug-ins are not required to be installed independently;and restarting the MySQL service, and enabling the MySQL configuration to be effective.
- 8. The MySQL master-slave cluster installation deployment method according to claim 7, wherein different server _ id is set for each server based on the non-repetitive property of unix timestamp strings.
- 9. A cluster system comprising a plurality of servers, wherein the cluster system is installed and deployed with a MySQL master-slave cluster by applying the MySQL master-slave cluster installation and deployment method according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010870488.9A CN112035435B (en) | 2020-08-26 | 2020-08-26 | MySQL master-slave cluster installation and deployment method and cluster system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010870488.9A CN112035435B (en) | 2020-08-26 | 2020-08-26 | MySQL master-slave cluster installation and deployment method and cluster system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112035435A true CN112035435A (en) | 2020-12-04 |
| CN112035435B CN112035435B (en) | 2024-04-30 |
Family
ID=73581532
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010870488.9A Active CN112035435B (en) | 2020-08-26 | 2020-08-26 | MySQL master-slave cluster installation and deployment method and cluster system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112035435B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112667440A (en) * | 2020-12-28 | 2021-04-16 | 紫光云技术有限公司 | Long-distance disaster recovery method for high-availability MySQL |
| CN113138882A (en) * | 2021-05-12 | 2021-07-20 | 平安国际智慧城市科技股份有限公司 | MySQL cluster-based automatic deployment method and device and related equipment |
| CN113347049A (en) * | 2021-08-04 | 2021-09-03 | 统信软件技术有限公司 | Server cluster deployment method and device, computing equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120166390A1 (en) * | 2010-12-23 | 2012-06-28 | Dwight Merriman | Method and apparatus for maintaining replica sets |
| WO2015188617A1 (en) * | 2014-06-11 | 2015-12-17 | 中兴通讯股份有限公司 | Method and device for installing mysql databases |
| CN105204897A (en) * | 2015-09-14 | 2015-12-30 | 上海新炬网络信息技术有限公司 | Batched MySQL installation and deployment method |
| CN107861838A (en) * | 2017-10-18 | 2018-03-30 | 福建中金在线信息科技有限公司 | Method and device of the automated back-up MySQL database from storehouse |
| CN109104318A (en) * | 2018-08-23 | 2018-12-28 | 广东轩辕网络科技股份有限公司 | The dispositions method and system of method for realizing cluster self-adaption deployment, the self-adaption deployment big data cluster based on cloud platform |
| WO2019101095A1 (en) * | 2017-11-21 | 2019-05-31 | 北京金山云网络技术有限公司 | Node down recovery method and apparatus, electronic device, and storage medium |
-
2020
- 2020-08-26 CN CN202010870488.9A patent/CN112035435B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120166390A1 (en) * | 2010-12-23 | 2012-06-28 | Dwight Merriman | Method and apparatus for maintaining replica sets |
| WO2015188617A1 (en) * | 2014-06-11 | 2015-12-17 | 中兴通讯股份有限公司 | Method and device for installing mysql databases |
| CN105204897A (en) * | 2015-09-14 | 2015-12-30 | 上海新炬网络信息技术有限公司 | Batched MySQL installation and deployment method |
| CN107861838A (en) * | 2017-10-18 | 2018-03-30 | 福建中金在线信息科技有限公司 | Method and device of the automated back-up MySQL database from storehouse |
| WO2019101095A1 (en) * | 2017-11-21 | 2019-05-31 | 北京金山云网络技术有限公司 | Node down recovery method and apparatus, electronic device, and storage medium |
| CN109104318A (en) * | 2018-08-23 | 2018-12-28 | 广东轩辕网络科技股份有限公司 | The dispositions method and system of method for realizing cluster self-adaption deployment, the self-adaption deployment big data cluster based on cloud platform |
Non-Patent Citations (2)
| Title |
|---|
| 彭剑;刘艳松;唐闻;: "MySQL主从服务器数据库同步的实现", 福建电脑, no. 07 * |
| 李海兵;: "基于MySQL的负载均衡的搭建与研究", 信息安全与技术, no. 05 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112667440A (en) * | 2020-12-28 | 2021-04-16 | 紫光云技术有限公司 | Long-distance disaster recovery method for high-availability MySQL |
| CN113138882A (en) * | 2021-05-12 | 2021-07-20 | 平安国际智慧城市科技股份有限公司 | MySQL cluster-based automatic deployment method and device and related equipment |
| CN113347049A (en) * | 2021-08-04 | 2021-09-03 | 统信软件技术有限公司 | Server cluster deployment method and device, computing equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112035435B (en) | 2024-04-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111522628B (en) | Kubernetes cluster building deployment method, framework and storage medium based on OpenStack | |
| CN112035435B (en) | MySQL master-slave cluster installation and deployment method and cluster system | |
| US20220116394A1 (en) | Automatically Deployed Information Technology (IT) System and Method | |
| US11321348B2 (en) | Provisioning and managing replicated data instances | |
| WO2017162173A1 (en) | Method and device for establishing connection of cloud server cluster | |
| US8943183B2 (en) | Decoupled installation of data management systems | |
| US20220174096A1 (en) | Automatically Deployed Information Technology (IT) System and Method with Enhanced Security | |
| WO2013184675A2 (en) | Automated disaster recovery and data migration system and method | |
| CN112311646B (en) | Hybrid cloud based on super-fusion system and deployment method | |
| CN102591679A (en) | Quick application software arrangement method for cluster system | |
| CN104394223A (en) | Automatic rapid deployment method for large-scale computer cluster system nodes | |
| CN104572269A (en) | Quick cluster deployment method based on Linux operation system | |
| CN111786810A (en) | Automatic deployment method and system for large-scale test bed nodes | |
| CN106209445A (en) | A kind of Visualized data centre by network design | |
| CN111240700A (en) | Cross-network-segment server OS deployment system and method | |
| CN110928624A (en) | Cloud desktop calling method and device for user terminal and terminal | |
| US20240223563A1 (en) | Automatically Deployed Information Technology (IT) System and Method | |
| CN114257512A (en) | Method and system for realizing high availability of ambari big data platform | |
| CN116545828A (en) | SaltStack distributed deployment-based method, host and system | |
| Dyke et al. | Adding and Deleting Nodes and Instances | |
| Dyke et al. | Installing and Configuring Oracle Software |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |