Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

MySQL master-slave cluster installation and deployment method and cluster system

A master-slave and cluster technology, applied in the direction of software deployment, program control device, program control design, etc., can solve the problems of installing and deploying MySQL clusters, and achieve the effects of improving installation and deployment efficiency, reducing costs, and high feasibility

Pending Publication Date: 2020-12-04
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical task of the present invention is to provide MySQL master-slave cluster installation and deployment method and cluster system for the above deficiencies, to solve the problem of how to quickly and automatically install and deploy MySQL clusters

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • MySQL master-slave cluster installation and deployment method and cluster system
  • MySQL master-slave cluster installation and deployment method and cluster system
  • MySQL master-slave cluster installation and deployment method and cluster system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0055] Ansible is an automated operation and maintenance tool that can implement functions such as batch system configuration, batch program deployment, and batch running commands. Automatically install and deploy MySQL master-slave clusters by writing Ansible scripts to achieve one-click deployment and reduce the risk of manual misoperations on each server.

[0056] The MySQL master-slave cluster installation and deployment method of the present invention automatically installs and deploys the MySQL master-slave cluster by executing the Ansible script, and the method includes the following steps:

[0057] S100, deploying a server for installing MySQL, and verifying the network connectivity of the above-mentioned server, to determine that the Ansible script execution program is connected to the above-mentioned server network, at least one of the above-mentioned servers;

[0058] S200. Prepare the data directory / var / lib / mysql for each server, and initialize the above data dire...

Embodiment 2

[0085] The cluster system of the present invention includes multiple servers, and the cluster system uses the MySQL master-slave cluster installation and deployment method disclosed in Embodiment 1 to install and deploy the MySQL master-slave cluster.

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a MySQL master-slave cluster installation and deployment method and a cluster 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 of: deploying servers for installing MySQL, and verifying the network connectivity of the servers; 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 foreach server; setting a MySQL configuration file of the servers; configuring a Slave slave node server, enabling the data between the Slave slave node server and a Master master node server to be automatically synchronized; and starting other running scripts of each server. The system comprises a plurality of servers; and the MySQL master-slave cluster is installed and deployed through the method.

Description

technical field [0001] The invention relates to the technical field of cluster deployment and installation, in particular to a MySQL master-slave cluster installation and deployment method and a cluster system. Background technique [0002] In the context of cloud computing and big data, database applications in public cloud environments are becoming more and more widespread. The MySQL database is currently a popular relational data. In the actual production environment, considering security, high availability and other aspects, the MySQL service provided by a single server cannot fully meet the actual needs. Therefore, generally speaking, data is synchronized through master-slave replication (Master-Slave). The data served by Slave from the node is especially important for data recovery. [0003] After the MySQL service is installed, the master-slave cluster deployment of MySQL also needs to configure the master-slave node servers, including data directories, users, maste...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/21G06F16/27G06F8/61G06F9/445
CPCG06F16/21G06F16/27G06F8/61G06F9/44505
Inventor 厉颖赵山王阳高传集
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com