A method for automatic deployment of SQL Server database mirroring mode

A technology of automatic deployment and database, applied in the field of cloud computing, can solve the problems of cumbersome data exchange and so on

Active Publication Date: 2020-12-08
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF12 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In order to solve the above problems, a method for automatic deployment of SQL Server database mirroring mode is provided, which solves the problem of cumbersome data exchange between multiple nodes, reduces deployment time, improves deployment efficiency, and improves service quality and customer experience

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
  • A method for automatic deployment of SQL Server database mirroring mode
  • A method for automatic deployment of SQL Server database mirroring mode

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0034] Such as figure 1 Shown is a kind of specific embodiment, provides a kind of method that realizes the automatic deployment of SQL Server database mirror pattern, and this method comprises the following steps:

[0035] S1: Create a host and copy the automatic deployment program inside. In actual operation, in the case of large-scale operations, various tools such as cloud platforms can be used to realize batch creation of host operations.

[0036] S2: The control end sends a start command to the host. At this time, if the tool for creating hosts in S1 is the control terminal in S2, for example, the tool for creating hosts in S1 is a cloud platform, then the control terminal in S2 is the cloud platform.

[0037] S3: The master node in mirror mode creates a shared folder, and the mirror node connects to the shared folder. Both the master node and the mirror node in mirror mode have read and write permissions for the shared folder.

[0038] S4: Mirror mode master node and...

Embodiment 2

[0043] Such as figure 1 Shown is a kind of specific embodiment, provides a kind of method that realizes the automatic deployment of SQL Server database mirror pattern, and this method comprises the following steps:

[0044] S1: Create a host and copy the automatic deployment program inside. In actual operation, in the case of large-scale operations, various tools such as cloud platforms can be used to realize batch creation of host operations.

[0045] S2: The control end sends a start command to the host. At this time, if the tool for creating hosts in S1 is the control terminal in S2, for example, the tool for creating hosts in S1 is a cloud platform, then the control terminal in S2 is the cloud platform.

[0046] S3: The master node in mirror mode creates a shared folder, and the mirror node connects to the shared folder. Both the master node and the mirror node in mirror mode have read and write permissions for the shared folder.

[0047] S4: Mirror mode master node and...

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 provides a method for achieving automatic deployment of a mirror mode of the SQL server database. According to the method, the file sharing function of Windows is used to communicate data among each node, so that automatic deployment of the mirror mode of the SQL server database is achieved. By means of the method, the problem that data communication among each node is tedious is solved, deployment time is reduced, the deployment efficiency is improved, and the service quality and user experience are promoted.

Description

technical field [0001] The invention relates to the technical field of cloud computing, in particular to a method for realizing the automatic deployment of SQL Server database mirroring mode. Background technique [0002] In the era of cloud computing, "services on the cloud" has gradually become a trend, that is, various services are provided by the cloud computing platform, and users do not need to care about service construction and operating environment configuration, just click the "Apply" button lightly, The services provided by the cloud platform can be obtained and used. [0003] SQL Server is a widely used relational database, and users have a strong demand for the cloud platform to provide one-click deployment of SQL Server services. Especially with the improvement of customers' requirements for data security, higher requirements are put forward for the deployment of SQL Server mirroring mode. The time is long and the efficiency is low, which greatly reduces the ...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/25G06F16/21G06F8/60
CPCG06F8/60G06F16/211G06F16/25
Inventor 李少青
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap