CN107391640B - Method for realizing automatic deployment of SQL Server database mirror mode - Google Patents
Method for realizing automatic deployment of SQL Server database mirror mode Download PDFInfo
- Publication number
- CN107391640B CN107391640B CN201710561588.1A CN201710561588A CN107391640B CN 107391640 B CN107391640 B CN 107391640B CN 201710561588 A CN201710561588 A CN 201710561588A CN 107391640 B CN107391640 B CN 107391640B
- Authority
- CN
- China
- Prior art keywords
- deployment
- node
- nodes
- mirror
- sql server
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 37
- 238000004891 communication Methods 0.000 abstract description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 239000003550 marker Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 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
- G06F16/211—Schema design and management
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method for realizing the automatic deployment of an SQL Server database mirror mode, which utilizes the file sharing function of Windows to exchange data among nodes and realizes the one-key automatic deployment of the SQL Server database mirror mode. The method solves the problem of complex data communication among a plurality of nodes, reduces deployment time, improves deployment efficiency, and improves service quality and customer experience.
Description
Technical Field
The invention relates to the technical field of cloud computing, in particular to a method for realizing automatic deployment of a mirror image mode of an SQL Server database.
Background
In the cloud computing era, the service cloud gradually becomes a trend, namely, various services are provided by a cloud computing platform, and a user can obtain the services provided by the cloud platform for use only by lightly clicking an application button without concerning the construction of the services and the configuration of the operating environment.
As a widely used relational database, the SQL Server has a strong demand that a user can provide a one-key deployment SQL Server service for a cloud platform. Particularly, with the improvement of the client on the data security requirement, higher requirements are also provided for the deployment of the SQL Server mirror image mode, and at present, in the SQL Server mirror image mode, data exchange among a plurality of nodes is tedious, long in time consumption and low in efficiency, so that the service quality and the client experience are greatly reduced.
Disclosure of Invention
In order to solve the problems, the method for realizing the automatic deployment of the SQL Server database mirror image mode is provided, the problem that data exchange among a plurality of nodes is complicated is solved, the deployment time is shortened, the deployment efficiency is improved, and the service quality and the customer experience are improved.
One specific embodiment of the invention adopts the following technical scheme:
a method for realizing the automatic deployment of the mirror image mode of the SQL Server database utilizes the file sharing function of Windows to exchange data among all nodes, and realizes the one-key automatic deployment of the mirror image mode of the SQL Server database.
Further, the method comprises the following steps:
s1: creating a host and copying an automatic deployment program inwards;
s2: the control end sends a starting command to the host;
s3: a mirror mode main node creates a shared folder, and a mirror node is connected to the shared folder;
s4: and the mirror mode master node and the mirror mode node deploy own SQL Server service.
Further, in step S3, the mirror mode master node and the mirror node both have read-write permission of the shared folder.
Further, the specific implementation process of step S4 is as follows:
s41: the node divides the self deployment into a plurality of deployment phases;
s42: and the nodes sequentially select the started deployment stage until all the nodes finish the deployment process.
Further, the specific implementation process of step S4 is as follows:
s41: the node divides the self deployment into a plurality of deployment phases;
s42: a node selects a deployment stage of starting;
s43: the node detects whether the deployment requirement is met, if yes, the S43 is entered, and if not, the S42 is returned;
s44: the node generates a mark file of the deployment stage;
s45: steps S41-S44 are repeated until all nodes complete the deployment process.
Further, if in step S43, the node detects that the deployment requirement is not satisfied more than the set number of times, the deployment is considered to be failed, and the deployment process is interrupted.
Further, in step S4, if a node itself generates data required by other nodes, the data needs to be put into a shared folder for other nodes to use.
The beneficial effects of one embodiment of the invention are as follows:
1. by utilizing the shared folder, the problem of complex data communication among a plurality of nodes is solved, the deployment time is reduced, the deployment efficiency is improved, and the service quality and the customer experience are improved.
2. By setting the read-write permission of the shared folder, the requirements of all nodes can be met only by establishing one shared folder to store all data, so that the operation process is simplified, and the efficiency is improved.
3. Each node is used as a data source, and all data are stored in a shared folder, so that the integrity of the data can be ensured, and the whole deployment process can be carried out smoothly.
4. By generating the mark file as a mark for recording the completion of a certain deployment stage of a certain node, the time sequence problem among different deployment stages can be solved, whether the deployment requirement is met or not is judged at the first time, the deployment logicality is greatly improved, and the deployment efficiency is improved.
5. The deployment time limit is set, when a certain node does not meet the deployment requirement for many times, the deployment process can be interrupted in time, the occupation of resources is avoided, technicians can be reminded to find problems, and the whole deployment process can be fed back in time.
Drawings
FIG. 1 is a flow diagram of a method of one embodiment of the invention;
fig. 2 is a flow chart of a method of another embodiment of the present invention.
Detailed Description
The present invention will be described in detail below with reference to specific examples in order to enable those skilled in the art to better understand and practice the present invention.
Example 1
As shown in fig. 1, a specific embodiment provides a method for implementing an automatic deployment of an SQL Server database mirror mode, which includes the following steps:
s1: a host is created and the auto-deploy program is copied in. In actual operation, for the case of large-batch operation, a plurality of tools such as a cloud platform can be used to realize batch creation of host operation.
S2: the control end sends a starting command to the host. At this time, if the tool creating the host in S1 is the control end in S2, for example, the tool creating the host in S1 is the cloud platform, then the control end in S2 is the cloud platform.
S3: and the mirror mode master node creates a shared folder, the mirror node is connected to the shared folder, and both the mirror mode master node and the mirror node have the read-write permission of the shared folder.
S4: the mirror mode master node and the mirror node deploy the SQL Server service of the mirror mode master node and the mirror node, and the specific implementation process is as follows:
s41: the node divides the self deployment into a plurality of deployment phases.
S42: and the nodes sequentially select the started deployment stage until all the nodes finish the deployment process.
It should be noted that, in the whole deployment process of step S4, if a node itself generates data required by other nodes, such as certificates, database files, etc., the data needs to be put into a shared folder for other nodes to use.
Example 2
As shown in fig. 1, a specific embodiment provides a method for implementing an automatic deployment of an SQL Server database mirror mode, which includes the following steps:
s1: a host is created and the auto-deploy program is copied in. In actual operation, for the case of large-batch operation, a plurality of tools such as a cloud platform can be used to realize batch creation of host operation.
S2: the control end sends a starting command to the host. At this time, if the tool creating the host in S1 is the control end in S2, for example, the tool creating the host in S1 is the cloud platform, then the control end in S2 is the cloud platform.
S3: and the mirror mode master node creates a shared folder, the mirror node is connected to the shared folder, and both the mirror mode master node and the mirror node have the read-write permission of the shared folder.
S4: the mirror mode master node and the mirror node deploy the SQL Server service of the mirror mode master node and the mirror node, and the specific implementation process is as follows:
s41: the node divides the self deployment into a plurality of deployment phases.
S42: the node selects the deployment phase of the startup.
S43: and (4) detecting whether the deployment requirement is met by the node, if so, entering S43, and if not, returning to S42. And if the node detects that the deployment requirement is not met for more than the set number of times, such as 5 times, the deployment is considered to be failed, and the deployment process is directly interrupted.
S44: the node generates a marker file for the deployment phase.
S45: steps S41-S44 are repeated until all nodes complete the deployment process.
It should be noted that, in the whole deployment process of step S4, if a node itself generates data required by other nodes, such as certificates, database files, etc., the data needs to be put into a shared folder for other nodes to use.
For the implementation of step S43, the following example is provided:
if a certain deployment phase of a certain node (referred to as "node A" herein) needs to wait for a certain phase (referred to as "phase B" herein) of other nodes to be completed before starting, whether a flag file (referred to as "flag B" herein) which is created after the other folders finish executing the "phase B" exists is detected in the shared folder, and if so, the "node A" continues to execute the deployment process downwards; if not, waiting for a period of time, and detecting again; if the detection times exceed a certain number, the 'mark B' still cannot be found, the deployment is considered to be failed, and the deployment is interrupted.
While the invention has been described in detail in the specification and drawings and with reference to specific embodiments thereof, it will be understood by those skilled in the art that various changes may be made and equivalents may be substituted; all technical solutions and modifications thereof which do not depart from the spirit and scope of the present invention are intended to be covered by the scope of the present invention.
Claims (1)
1. A method for realizing the mirror image mode automatic deployment of SQL Server database is characterized in that the method uses the file sharing function of Windows to exchange data among nodes, and realizes the one-key automatic deployment of the SQL Server database mirror image mode;
the method comprises the following steps:
s1: creating a host and copying an automatic deployment program inwards;
s2: the control end sends a starting command to the host;
s3: a mirror mode main node creates a shared folder, and a mirror node is connected to the shared folder;
in step S3, the mirror mode master node and the mirror node both have read-write permissions of the shared folder;
s4: the mirror mode main node and the mirror node deploy the SQL Server service of the mirror mode main node and the mirror node;
the specific implementation process of step S4 is as follows:
s41: the node divides the self deployment into a plurality of deployment phases;
s42: the nodes sequentially select the started deployment stages until all the nodes finish the deployment process;
in step S4, if a node itself generates data needed by other nodes, the data needs to be put into a shared folder for other nodes to access; or
The specific implementation process of the S4 is as follows:
s41: the node divides the self deployment into a plurality of deployment phases;
s42: a node selects a deployment stage of starting;
s43: the node detects whether the deployment requirement is met, if yes, the S43 is entered, and if not, the S42 is returned;
s44: the node generates a mark file of the deployment stage;
s45: repeating the steps S41-S44 until all nodes complete the deployment process;
if the node detects that the deployment requirement is not met and the set times are exceeded in the step S43, the node considers that the deployment is failed and interrupts the deployment process;
if a node itself generates data needed by other nodes, the data needs to be put into a shared folder for other nodes to take.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710561588.1A CN107391640B (en) | 2017-07-11 | 2017-07-11 | Method for realizing automatic deployment of SQL Server database mirror mode |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710561588.1A CN107391640B (en) | 2017-07-11 | 2017-07-11 | Method for realizing automatic deployment of SQL Server database mirror mode |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107391640A CN107391640A (en) | 2017-11-24 |
| CN107391640B true CN107391640B (en) | 2020-12-08 |
Family
ID=60339045
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710561588.1A Active CN107391640B (en) | 2017-07-11 | 2017-07-11 | Method for realizing automatic deployment of SQL Server database mirror mode |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107391640B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1848787A (en) * | 2006-04-30 | 2006-10-18 | 西安交通大学 | Automatic fast dispositioning method for aggregated server system node |
| CN101727496A (en) * | 2010-01-15 | 2010-06-09 | 山东高效能服务器和存储研究院 | Method for realizing load balancing cluster of MICROSOFT SQL SERVER database |
| CN101788917A (en) * | 2010-02-26 | 2010-07-28 | 浪潮(北京)电子信息产业有限公司 | Deployment method of utility software and the system thereof |
| CN102339283A (en) * | 2010-07-20 | 2012-02-01 | 中兴通讯股份有限公司 | Access control method for cluster file system and cluster node |
| CN103475716A (en) * | 2013-09-11 | 2013-12-25 | 北京京东尚科信息技术有限公司 | Method and system for achieving data sharing through shared storage |
| CN105183520A (en) * | 2015-09-21 | 2015-12-23 | 赵伟 | Automatic remote installing and debugging method and system for computer software |
| CN106339468A (en) * | 2016-08-30 | 2017-01-18 | 广西电网有限责任公司 | Oracle RAC (Real Application Cluster) one-key automatic deployment method |
| CN106603725A (en) * | 2017-02-03 | 2017-04-26 | 济南浪潮高新科技投资发展有限公司 | Implementation method for enterprise cloud service virtual mirror image management service |
| CN106649430A (en) * | 2016-08-30 | 2017-05-10 | 广西电网有限责任公司 | Automatic one-click deploying method for SQL Server |
| CN106708727A (en) * | 2016-08-03 | 2017-05-24 | 腾讯科技（深圳）有限公司 | Verification method and system for distributed virus characteristic sample |
| CN106789198A (en) * | 2016-12-07 | 2017-05-31 | 高新兴科技集团股份有限公司 | A kind of calculate node management method and system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10560457B2 (en) * | 2015-12-14 | 2020-02-11 | American Express Travel Related Services Company, Inc. | Systems and methods for privileged access management |
-
2017
- 2017-07-11 CN CN201710561588.1A patent/CN107391640B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1848787A (en) * | 2006-04-30 | 2006-10-18 | 西安交通大学 | Automatic fast dispositioning method for aggregated server system node |
| CN101727496A (en) * | 2010-01-15 | 2010-06-09 | 山东高效能服务器和存储研究院 | Method for realizing load balancing cluster of MICROSOFT SQL SERVER database |
| CN101788917A (en) * | 2010-02-26 | 2010-07-28 | 浪潮(北京)电子信息产业有限公司 | Deployment method of utility software and the system thereof |
| CN102339283A (en) * | 2010-07-20 | 2012-02-01 | 中兴通讯股份有限公司 | Access control method for cluster file system and cluster node |
| CN103475716A (en) * | 2013-09-11 | 2013-12-25 | 北京京东尚科信息技术有限公司 | Method and system for achieving data sharing through shared storage |
| CN105183520A (en) * | 2015-09-21 | 2015-12-23 | 赵伟 | Automatic remote installing and debugging method and system for computer software |
| CN106708727A (en) * | 2016-08-03 | 2017-05-24 | 腾讯科技（深圳）有限公司 | Verification method and system for distributed virus characteristic sample |
| CN106339468A (en) * | 2016-08-30 | 2017-01-18 | 广西电网有限责任公司 | Oracle RAC (Real Application Cluster) one-key automatic deployment method |
| CN106649430A (en) * | 2016-08-30 | 2017-05-10 | 广西电网有限责任公司 | Automatic one-click deploying method for SQL Server |
| CN106789198A (en) * | 2016-12-07 | 2017-05-31 | 高新兴科技集团股份有限公司 | A kind of calculate node management method and system |
| CN106603725A (en) * | 2017-02-03 | 2017-04-26 | 济南浪潮高新科技投资发展有限公司 | Implementation method for enterprise cloud service virtual mirror image management service |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107391640A (en) | 2017-11-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20140310047A1 (en) | Simplifying scheduling of dependent tasks in a collaborative project management environment | |
| CN107992537B (en) | Service attribute transmission method, device, computer equipment and storage medium | |
| CN102932415A (en) | Method and device for storing mirror image document | |
| CN109344006A (en) | A kind of mirror image management method and mirror image management module | |
| CN110764788B (en) | Cloud storage deployment method and device, computer equipment and readable storage medium | |
| CN114281253B (en) | Storage volume management method | |
| CN110597590A (en) | Method and device for replacing vehicle-mounted system icon, computer equipment and storage medium | |
| CN112463290A (en) | Method, system, apparatus and storage medium for dynamically adjusting the number of computing containers | |
| CN108108119B (en) | Configuration method and device for extensible storage cluster things | |
| US20200089688A1 (en) | Pseudo-synchronous processing by an analytic query and build cluster | |
| CN111294377B (en) | Dependency network request sending method, terminal device and storage medium | |
| CN107391640B (en) | Method for realizing automatic deployment of SQL Server database mirror mode | |
| WO2016078326A1 (en) | Method, apparatus and system for displaying names of virtual machine | |
| CN108536541B (en) | Process engine object processing method and device | |
| CN108805527A (en) | A kind of project management method and device | |
| JP2021101319A (en) | Information processing device and information processing program | |
| WO2022267878A1 (en) | Method for interfacing with third-party system, and apparatus, electronic device, and readable medium | |
| CN106250068A (en) | Image processing system and the delet method of application | |
| CN112685613B (en) | Resource package query method and device and information processing system | |
| CN114265584A (en) | Page component generation method, device, equipment and storage medium | |
| CN114020368A (en) | Information processing method and device based on state machine and storage medium | |
| CN103268333A (en) | Storage method and storage device | |
| US20080282262A1 (en) | Automatic and configurable loading of loosely coupled service oriented software components | |
| CN113064598A (en) | Container cluster management system deployment method and deployment system | |
| CN111797070A (en) | Ticket data processing method and device |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200522 Address after: 250101 floor 27, S01, Inspur Science Park, No. 1036, Inspur Road, Jinan City, Shandong Province Applicant after: Tidal Cloud Information Technology Co.,Ltd. Address before: 450018 Henan province Zheng Dong New District of Zhengzhou City Xinyi Road No. 278 16 floor room 1601 Applicant before: ZHENGZHOU YUNHAI INFORMATION TECHNOLOGY Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 27th floor, S01 building, Inspur Science Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province Applicant after: Inspur cloud Information Technology Co., Ltd Address before: 250101 floor 27, S01, Inspur Science Park, No. 1036, Inspur Road, Jinan City, Shandong Province Applicant before: Tidal Cloud Information Technology Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |