CN106445498A - One-click deployment method of Mysql - Google Patents
One-click deployment method of Mysql Download PDFInfo
- Publication number
- CN106445498A CN106445498A CN201610749568.2A CN201610749568A CN106445498A CN 106445498 A CN106445498 A CN 106445498A CN 201610749568 A CN201610749568 A CN 201610749568A CN 106445498 A CN106445498 A CN 106445498A
- Authority
- CN
- China
- Prior art keywords
- mysql
- operating system
- installation
- mono
- described step
- 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.)
- Pending
Links
Classifications
-
- 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
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/71—Version control; Configuration management
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Alarm Systems (AREA)
Abstract
The invention discloses a one-click deployment method of Mysql, and belongs to the field of the computer technology. The one-click deployment method comprises the following steps of: 1) applying for a Mysql virtual machine node and a preset remote installation server; 2) judging the operating system version of a virtual machine; 3) installing a cgroup container component; 4) according to the operating system version of the virtual machine, closing a corresponding firewall; 5) starting the container component, and adding the container component into an item which is automatically loaded when a system is started; 6) initializing a Mysql automatic installation script and a Mysql installation package; 7) connecting with the preset remote installation server, and downloading the Mysql installation package and a configuration file; 8) setting the data file storage path of the Mysql and the external access port of the Mysql; 9) according to user configuration, resetting the root password of the Mysql; and 10) verifying whether the port can be normally connected or not. By use of the one-click deployment method, the problem in the prior art the installation method of a Mysql database consumes overmuch vigor and time is solved.
Description
Technical field
The invention belongs to field of computer technology, particularly to a kind of Mysql mono- key dispositions method.
Background technology
With the change of information age, particularly " IOE (InternetofEverything, all things on earth interconnects) " motion is not
Disconnected deepening development, more and more wider to the application demand of associated data base management system Mysql database, as internet, communication, gold
The complicated operation system of industry such as melting needs to dispose substantial amounts of Mysql database, how installation Mysql data rapidly and efficiently
Storehouse just becomes a problem.
If installing by hand and configure by operation maintenance personnel, need to spend a lot of energy and times, and be easy to
Error, also higher to the technical requirements of operation maintenance personnel.
Content of the invention
It is an object of the invention to：For above-mentioned problem, the invention provides a kind of Mysql mono- key deployment side
Method, the present invention solves the problems, such as that the installation method of Mysql database expends excessive manpower, energy and time, realizes a key portion
Mysql database is installed by administration.
The technical scheme is that：
1st, a kind of Mysql mono- key dispositions method is it is characterised in that comprise the following steps：
1）, application Mysql virtual machine node and preset Remote Installation Server；
2）, judge VME operating system version；
3）, install cgroup container assemblies；
4）, according to VME operating system version, close corresponding fire wall；
5）, start container assemblies and by container assemblies add to system start when automatic loading project in；
6）, the initialization automatic installation script of Mysql and Mysql installation kit；
7）, connect preset Remote Installation Server, download Mysql installation kit and configuration file；
8）, the setting data file store path of Mysql and Mysql Outside Access port；
9）, according to user configuring, reset the root password of Mysql；
10）, checking port whether can normally connect.
Further：Described step 3）Judge VME operating system version, if then leading for operating system CentOS6
Device-mapper-libs assembly is installed, this assembly has to rely on assembly for container technique.
Further：Judge VME operating system version, close fire wall, if VME operating system is
CentOS6 then closes iptables fire wall, then closes firewalld fire wall if CentOS7.
Further：Described step 8）The data storage path of Mysql is /var/lib/mysql.
Further：Described step 8）The access port of middle Mysql is 3306.
Further：Described step 7）Remote Installation Server is connected by Ip address.
Further：Described step 7）Downloading Mysql installation kit is Mysql5.5, Mysql5.6 installation kit or Mysql5.7
The installation kit of version.
Beneficial effects of the present invention are：The installation method solving MySQL database in correlation technique expends excessive energy
With the problem of time, decrease the fussy degree installing MySQL and complexity, greatly shorten the set-up time, substantially reduce
The possibility of maloperation is it is ensured that the success rate installed and correctness.
Specific embodiment
The present invention will be further described to name specific example：
Embodiment 1
A kind of Mysql 15.5 1 key dispositions method, comprises the following steps：
1）, application Mysql virtual machine node and preset Remote Installation Server；
2）, judge VME operating system version；
3）, install cgroup container assemblies；
4）, according to VME operating system version, close corresponding fire wall；
5）, start container assemblies and by container assemblies add to system start when automatic loading project in；
6）, the initialization automatic installation script of Mysql and Mysql installation kit；
7）, connect preset Remote Installation Server, download Mysql installation kit and configuration file；
8）, the setting data file store path of Mysql and Mysql Outside Access port；
9）, according to user configuring, reset the root password of Mysql；
10）, checking port whether can normally connect.
Described step 3）VME operating system is operating system CentOS6, then install device-mapper- in advance
Libs assembly, this assembly has to rely on assembly for container technique.
Described VME operating system is operating system CentOS, and VME operating system is then closed for CentOS6
Iptables fire wall.
Described step 8）The data storage path of Mysql 15.5 is /var/lib/mysql.
Described step 8）The access port of middle Mysql is 3306.
Described step 7）Remote Installation Server is connected by Ip address.
Described step 7）Download Mysql installation kit is Mysql5.5.
Described step 9）The password of the root of Mysql 15.5 is：1234.
Checking port can be normally using connection, installation.
Embodiment 2
A kind of Mysql 15.6 1 key dispositions method, comprises the following steps：
1）, application Mysql virtual machine node and preset Remote Installation Server；
2）, judge VME operating system version；
3）, install cgroup container assemblies；
4）, according to VME operating system version, close corresponding fire wall；
5）, start container assemblies and by container assemblies add to system start when automatic loading project in；
6）, the initialization automatic installation script of Mysql and Mysql installation kit；
7）, connect preset Remote Installation Server, download Mysql installation kit and configuration file；
8）, the setting data file store path of Mysql and Mysql Outside Access port；
9）, according to user configuring, reset the root password of Mysql；
10）, checking port whether can normally connect.
Described VME operating system version, is that CentOS7 then closes firewalld fire wall.
Described VME operating system is CentOS7 for operating system, then close firewalld fire wall.
Described step 8）The data storage path of Mysql is /var/lib/mysql.
Described step 8）The access port of middle Mysql is 3306.
Described step 7）Remote Installation Server is connected by Ip address.
Described step 7）Download Mysql installation kit is Mysql5.6.
Described step 9）The password of the root of Mysql 15.6 is：1234.
Checking port can be normally using connection, installation.
Claims (7)
1. a kind of Mysql mono- key dispositions method is it is characterised in that comprise the following steps：
1）, application Mysql virtual machine node and preset Remote Installation Server；
2）, judge VME operating system version；
3）, install cgroup container assemblies；
4）, according to VME operating system version, close corresponding fire wall；
5）, start container assemblies and by container assemblies add to system start when automatic loading project in；
6）, the initialization automatic installation script of Mysql and Mysql installation kit；
7）, connect preset Remote Installation Server, download Mysql installation kit and configuration file；
8）, the setting data file store path of Mysql and Mysql Outside Access port；
9）, according to user configuring, reset the root password of Mysql；
10）, checking port whether can normally connect.
2. a kind of Mysql mono- key dispositions method according to claim 1 it is characterised in that：Described step 3）Judge virtual
Machine operating system version, if then installing device-mapper-libs assembly in advance for operating system CentOS6, this assembly is
Container technique have to rely on assembly.
3. a kind of Mysql mono- key dispositions method according to claim 1 it is characterised in that：Judge VME operating system
Version, closes fire wall, if VME operating system is CentOS6, closes iptables fire wall, if CentOS7
Then close firewalld fire wall.
4. a kind of Mysql mono- key dispositions method according to claim 1 it is characterised in that：Described step 8）Mysql's
Data storage path is /var/lib/mysql.
5. a kind of Mysql mono- key dispositions method according to claim 1 it is characterised in that：Described step 8）Middle Mysql
Access port be 3306.
6. a kind of Mysql mono- key dispositions method according to claim 1 it is characterised in that：Described step 7）By Ip ground
Location connects Remote Installation Server.
7. a kind of Mysql mono- key dispositions method according to claim 1 it is characterised in that：Described step 7）Download
Mysql installation kit is the installation kit of Mysql5.5, Mysql5.6 installation kit or Mysql5.7 version.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610749568.2A CN106445498A (en) | 2016-08-30 | 2016-08-30 | One-click deployment method of Mysql |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610749568.2A CN106445498A (en) | 2016-08-30 | 2016-08-30 | One-click deployment method of Mysql |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106445498A true CN106445498A (en) | 2017-02-22 |
Family
ID=58182080
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610749568.2A Pending CN106445498A (en) | 2016-08-30 | 2016-08-30 | One-click deployment method of Mysql |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106445498A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108632331A (en) * | 2017-08-28 | 2018-10-09 | 北京视联动力国际信息技术有限公司 | A kind of installation method and device regarding working application |
| CN109241035A (en) * | 2018-08-28 | 2019-01-18 | 福建南威软件有限公司 | A kind of custom script realizes the automatic deployment method of database |
| CN110806907A (en) * | 2019-10-31 | 2020-02-18 | 浪潮云信息技术有限公司 | Containerized configurable database execution script management system and method |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103608773A (en) * | 2011-04-12 | 2014-02-26 | 威睿公司 | Deployment system for multi-node applications |
| CN104663492A (en) * | 2013-11-26 | 2015-06-03 | 陕西龙海工程建设有限公司 | Embedded system based electronic pet collar |
-
2016
- 2016-08-30 CN CN201610749568.2A patent/CN106445498A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103608773A (en) * | 2011-04-12 | 2014-02-26 | 威睿公司 | Deployment system for multi-node applications |
| CN104663492A (en) * | 2013-11-26 | 2015-06-03 | 陕西龙海工程建设有限公司 | Embedded system based electronic pet collar |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108632331A (en) * | 2017-08-28 | 2018-10-09 | 北京视联动力国际信息技术有限公司 | A kind of installation method and device regarding working application |
| CN109241035A (en) * | 2018-08-28 | 2019-01-18 | 福建南威软件有限公司 | A kind of custom script realizes the automatic deployment method of database |
| CN110806907A (en) * | 2019-10-31 | 2020-02-18 | 浪潮云信息技术有限公司 | Containerized configurable database execution script management system and method |
| CN110806907B (en) * | 2019-10-31 | 2023-04-21 | 浪潮云信息技术股份公司 | Containerized configurable database script execution management system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9893887B2 (en) | Dynamic licensing for applications and plugin framework for virtual network systems | |
| US9116735B2 (en) | Offline provisioning of virtual machines | |
| CN106445498A (en) | One-click deployment method of Mysql | |
| CN109271170A (en) | A kind of distributed system dispositions method, system, electronic equipment and storage medium | |
| CN100372294C (en) | Appratus upgrading method | |
| CN101860853A (en) | Software upgrading method and device | |
| CN104516738A (en) | Integrated implementing method for development and release of APP | |
| US11646936B2 (en) | Adaptive virtual services | |
| CN110175042A (en) | A kind of firmware upgrade method, device and its relevant device | |
| CN108427570A (en) | Intelligent household appliance master control program upgrading system and upgrading method | |
| CN105071948B (en) | The automatic deployment method and device of a kind of access switch | |
| CN102104624B (en) | Software distribution and more new demand servicing are provided but regardless of the state or physical location of end point machine | |
| CN104283878A (en) | Security type mobile terminal based on cloud services and method of security type mobile terminal based on cloud services for having access to cloud server | |
| CN103327108B (en) | A kind of cross-platform software management platform based on cloud and construction method thereof | |
| CN105468395A (en) | Updating method, device and system | |
| CN104615455A (en) | Remote upgrading method and device for IPMC program of ATCA structure | |
| CN102663298A (en) | Safety online detecting system facing to terminal computers | |
| CN108536484A (en) | Parameter amending method, device, terminal device and storage medium | |
| CN106708573A (en) | System and method used for automatic installation of Hadoop cluster | |
| CN102622550A (en) | Safe online patch check system facing terminal computers | |
| CN113315681B (en) | Automatic testing method and system based on intelligent home gateway plug-in | |
| CN109246454B (en) | Set top box management method, device, terminal and storage medium based on cloud platform | |
| CN104967515B (en) | A kind of identity identifying method and server | |
| CN106130750A (en) | A kind of big data platform upgrade method based on privately owned Yum storehouse | |
| CN107741854A (en) | The installation method and device of the trawl performance of a kind of electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170222 |
|
| RJ01 | Rejection of invention patent application after publication |