Sqlserver2012 alwayson部署攻略
一、环境。 1、服务器：准备 4 台虚拟机。 2、操作系统： windows2008R2SP2 或者以上版本。 3、数据库： Sqlserver2012 。 二、操作系统安装及设置。 4 、在 4 台虚拟机上均装上操作系统 windows2008R2, 并分别设置计算机名为 :DomainServer 、 DB1 、 DB2
一、环境。
1、服务器：准备4台虚拟机。
2、操作系统：windows2008 R2 SP2或者以上版本。
3、数据库：Sqlserver 2012。
二、操作系统安装及设置。
4、在4台虚拟机上均装上操作系统windows 2008 R2,并分别设置计算机名为:DomainServer、DB1、DB2、DB3，分别设置IP为192.168.100.20、192.168.100.21、192.168.100.22、192.168.100.23。
5、在DB1、DB2、DB3上开启功能.NET3.5 SP1。
6、在DB1、DB2、DB3上安装Sqlserver2012。
7、在DomainServer服务器上建立域服务alwayson.com、并将DB1、DB2、DB3的DNS设置为192.168.100.20，然后加如域alwayson.com。
三、windows2008故障转移群集部署。
8、以alwayson.com\administrator域帐户登录DB1、DB2、DB3，并添加故障转移集群功能。
9、在DB1、DB2、DB3中任一台机上创建群集，并将DB1、DB2、DB3台服务器添加进去、群集名称为alwaysoncluster,群集IP为192.168.100.25,仲裁配置为“多数节点”。
四、alwayson部署。
10、关闭DB1、DB2、DB3的防火墙或者在防火墙规则中添加例外端口1433、5022。
11、分别打开DB1、DB2、DB3的“SQL Server 配置管理器”，在左侧的“SQL Server 服务”列表中找到默认的实例,并开启alwayson功能。
12、将Sqlserver服务的登录帐户更改为域帐户alwayson.com\administrator，并重启sqlserver服务。
13、分别使用数据库管理工具连接DB1、DB2、DB3的数据库，并创建sqlserver的域登录帐户alwayson.com\administrator，并赋予sysadmin角色。
14、在DB1、DB2、DB3的分别建立目录D:\SQLDATA用于存放sql数据库文件，在局域网内建立一个可读写共享目录，该共享目录用于存放快照文件。要消除单点故障，可考虑将该共享存放在DFS共享上。
15、在DB1上新建数据库，数据文件存放在上面的新建文件夹D:\sqldata下，并做一次完整备份，要使用alwayson的数据库必须先完备一次。
16、以域管理员帐户登录DB1、打开“Sql Server Management Studio”，展开“alwayson高可用性”，并新建alwayson可用性组，命名为alwayson。
17、选择刚刚完备过的数据库。
18、在指定副本中添加DB1、DB2和DB3，其中DB1为主，DB2和DB3为辅；DB1和DB2为自动故障转移，同步提交，DB3不是自动故障转移且为异步提交，DB1和DB2、DB3均为可读辅助副本。
19、选择数据同步中选择完整，并填入用于存放快照的共享文件夹位置，然后直接下一步直至alwayson部署完成。
20、添加侦听器，在添加可用性组的地方选择添加侦听器，名称为alwaysonconn,IP为192.168.100.25，端口为1433，此连接用于程序连接，此伪IP信息始终在主数据库服务器上，若使用集群伪IP192.168.100.24会出现该IP不在主数据库服务器上的错误。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1387
52
Collapse Star Dome Railway Underworld Relic Set Matching Guide
Mar 27, 2024 pm 04:10 PM
How to choose the underworld relics of the Collapsed Star Dome Railway? The new five-star character Huang Quan has officially debuted, and many players have already drawn her. This character is positioned as the main C output. Below, the editor brings the Huang Quan relic set and entry recommendations, hoping to be helpful to all of you. 1. For the suit, it is recommended to choose the four-piece set [Pioneer of Backwater Diving], and for the plane jewelry, it is recommended to choose [Izumo Xianshi and Gaotian Divine Kingdom] or [Stalled Sarsotu]. 2. The main entries are selected as follows: torso critical hit rate/critical hit damage, foot attack/speed, plane ball lightning damage/attack, and link rope attack power. The selection of adverbs is: give priority to double violence, just meet the threshold or be as high as possible, and then stack speed and attack power. 3. Note: ① A four-piece outer ring set is the best for stagnant water. The thunder set is suitable for stagnant water when wearing a thunder ball and speed shoes.
Achievement Guide for Collapse Star Dome Railway Tianzhan Muzan
Mar 28, 2024 am 08:26 AM
The Collapse Star Dome Railway Tian Zhan Wu Zhan is an exclusive achievement for Huang Quan. Many players don’t know how to obtain the Tian Zhan Wu Zhan achievement. It is actually very simple. First, use Fu Xuan to attract the monsters on both sides together, and then teleport back to the previous teleport. Click and then use Huangquan to fight. Let’s take a look at this guide to obtain the Honkai Star Dome Railway Tianzhan Muzan achievement for details. Honkai Star Dome Railway Guide Complete Guide to Honkai Star Dome Railway Tianzhan Muzan Achievement Guide 1. Teleport to the location in the picture below. 2. First use Fu Xuan to attract the monsters on both sides together. 3. Then teleport back to the teleport point just now. If you have no achievement points, you can make up for them. 4. After that, you can get the achievement by using Huang Quan to cut five times in a row.
Yolov10: Detailed explanation, deployment and application all in one place!
Jun 07, 2024 pm 12:05 PM
1. Introduction Over the past few years, YOLOs have become the dominant paradigm in the field of real-time object detection due to its effective balance between computational cost and detection performance. Researchers have explored YOLO's architectural design, optimization goals, data expansion strategies, etc., and have made significant progress. At the same time, relying on non-maximum suppression (NMS) for post-processing hinders end-to-end deployment of YOLO and adversely affects inference latency. In YOLOs, the design of various components lacks comprehensive and thorough inspection, resulting in significant computational redundancy and limiting the capabilities of the model. It offers suboptimal efficiency, and relatively large potential for performance improvement. In this work, the goal is to further improve the performance efficiency boundary of YOLO from both post-processing and model architecture. to this end
Collapse Star Dome Railway Double Indemnity Mission Guide Process
Mar 28, 2024 pm 02:20 PM
How to do double compensation on the Honkai Star Dome Railway? Double compensation is part of the main mission [Cat among Pigeons]. In this mission, you can obtain the hidden achievement of "Stealing the Blind Bet". Below, the editor will provide a detailed explanation of the double compensation mission of the Collapsed Star Dome Railway, hoping it will be helpful to the players. help. 1. Come to the new map [Chaolu Mansion] and go in through the front door. 2. After entering through the door in the picture above, rotate the four statues in the picture below correctly and the correct hidden door will appear. Then continue the task and follow the tracking task first. Go to the 1st and 2nd mission points to talk, and then switch to the 3rd position, you can consume consumables first to fill up Sand Gold's finishing move with energy before entering the battle. After entering the battle, just release Sand Gold's finishing move first. If you can get 7 [Blind Bet] points at one time, you can get the hidden achievement "Stealing the Blind Bet"; note
One Piece Hotline Horror Story Cemetery Horror Mission Guide
Mar 26, 2024 pm 08:20 PM
In the latest One Piece Hot-blooded Route mission, there is an exploration mission of Horror and Strange Graveyard Horror in One Piece. How to do Horror and Strange Graveyard Horror in One Piece and Hot-blooded Route? Many players don’t know how to play. Let’s introduce it below. Let’s take a look! One Piece: The Horror of One Piece: How to do the Cemetery Horror 1. Find the supernatural news reporters outside the ship of terror, and they guide us into the cemetery. 2. When you come to the cemetery, the plot will be triggered, and then the battle will begin. 3. After winning the battle, talk to the reporter to complete the mission.
How to deploy and maintain a website using PHP
May 03, 2024 am 08:54 AM
To successfully deploy and maintain a PHP website, you need to perform the following steps: Select a web server (such as Apache or Nginx) Install PHP Create a database and connect PHP Upload code to the server Set up domain name and DNS Monitoring website maintenance steps include updating PHP and web servers, and backing up the website , monitor error logs and update content.
Guide to the Devil in Velvet on the Collapsed Star Dome Railway
Mar 28, 2024 am 11:26 AM
The Devil in Velvet is a brand new mission launched in this version. Many players are very curious about how to complete this mission. Today, the editor has brought you a picture and text mission guide for this mission. Players can pass This guide is used to solve the puzzles in the mission and complete the mission faster. The detailed content can be found in this graphic mission guide of The Devil in Velvet. Let’s take a look together. Guide to the Demon in the Velvet of the Collapsed Star Dome Railway 1. First, the player needs to reach level 34 and complete the prerequisite task [Who killed...], then you can automatically accept this task. 2. Go to Pinoconi’s Platinum Suite and talk to Sand Gold and Black Swan. 3. Then follow the movement of the black swan and go to the golden moment in the dream. 4. Come to the clock
Do Laravel and CodeIgniter support cloud platform deployment?
Jun 05, 2024 pm 01:51 PM
Both Laravel and CodeIgniter support cloud platform deployment. Laravel provides native support out of the box, simplifying the deployment process. CodeIgniter requires additional configuration and modifications to run in a cloud environment.
