One of SQL Server 2014 high availability: Always on

For an overview of always on, here's not much to say, you need to see Microsoft's official website: https://technet.microsoft.com/zh-cn/library/ff877884 (v=sql.110). aspx

Let's start by introducing the machines used in your environment.

Computer name	IP Address	Note
Contoso-sql-a01	172.168.1.43	Always on Node 1
Contoso-sql-a02	172.168.1.44	Always on Node 2
Sqlalwayson	172.168.1.45	Cluster address
Ag_listener_aon	172.168.1.46	Listen
Contoso-storage	172.168.1.46	Provides storage

———————————————— This is a gorgeous split line ——————————————

First, the computer to the computer name plus domain, modify the firewall rules, installation of SQL Server 2014 and so on is not described here. Or I can make up a blog!

During the installation process, I modified the collation SQL_Latin1_General_CP1_CI_AS required by System Center in advance, at the collation point, because the late server was available to System Center for use.

After the lengthy SQL installation is complete, you are ready to start the always on configuration.

First, use Contoso-storage to create a quorum disk for the two nodes

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/85/a5/wkiol1eq6svwpi51aafbwtdvmnk391.png "width=" 523 "height=" "/>"

Then, the two AlwaysOn nodes connect to this disk and assign the drive letter Q

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/85/A5/wKioL1eq6SyQAzP8AAA7XrDt6Ls986.png "width=" 335 "height="/>

Finally, install the Failover Cluster service on two AlwaysOn nodes, respectively

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/85/A5/wKioL1eq6S2DbeblAAGQdYg6wwo472.png "width=" 564 "height=" 402 "/>

When the installation is complete, start creating the cluster

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/85/A5/wKiom1eq6S7B4DxAAAC7rIvpwds742.png "width=" 554 "height=" 344 "/>

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/85/a5/wkiol1eq6s-dakjwaadkfgotib8289.png "width=" 475 "height=" 327 "/>

The cluster name Sqlalwayson and the cluster IP address are written here

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/85/A5/wKioL1eq6TDxQMNyAADaU1FiJek329.png "width=" 529 "height=" 369 "/>

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/85/A5/wKioL1eq6THCUkknAADo3P5B9vI130.png "width=" 561 "height=" 392 "/>

Create complete

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/85/a5/wkiol1eq6tlzqoo8aadxlukdpx8863.png "width=" 522 "height=" 365 "/>

Once created, go to two nodes in SQL Server Configuration Manager, enable AlwaysOn availability groups individually, enable and then restart the service

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/85/A5/wKioL1eq6TPhpuKeAAEnmUdrbiM183.png "width=" 470 "height=" 335 "/>

Because of the test environment, a new database is created on the node, and when the new one is completed, the recovery model of the set database is complete and a full backup is made.

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/85/A6/wKiom1eq6TTAqlxhAAEi4OuLxFc140.png "width=" 533 "height=" 364 "/>

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/85/A6/wKiom1eq6TXBC-FmAAComn9Xpq8100.png "width=" 582 "height=" 357 "/>

When you are finished, start the New Availability Group wizard

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/85/A5/wKioL1eq6TbSj3UMAADEJ7Ino60214.png "width=" 441 "height=" 257 "/>

Write name Next

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/85/A6/wKiom1eq6TfR-sixAABvYPNkv4Y273.png "width=" 466 "height=" 294 "/>

Then, because the full recovery model was previously set up and a full backup was made, the prerequisites were met, or 2 status hints for the default database appear

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/85/A6/wKiom1eq6TiQw-R4AADiQacWBjU187.png "width=" 561 "height=" 288 "/>

Sets a replica that the listener can create later.

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/85/A6/wKiom1eq6TnjSjkYAAGE5QuXivs555.png "width=" 546 "height=" 389 "/>

Select the path of the previous backup

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/85/A6/wKiom1eq6TqTFSu-AAFjt5kXw64238.png "Width=" 510 "height=" 319 "/>

Passed because the listener did not create a warning

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/85/A6/wKiom1eq6TuiwfkWAAFVTf8soWs736.png "width=" 519 "height=" 337 "/>

Finish creating

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/85/A5/wKioL1eq6TySf6FbAAFzLjuwPqc022.png "width=" 530 "height=" 489 "/>

and start adding listeners

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/85/a5/wkiol1eq6t7wezwbaad_jlenm0w974.png "width=" 406 "height=" 314 "/>

Add a static IP address by filling in the NDS name and port

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M00/85/A5/wKioL1eq6T_T27lVAACEt_-V7V4656.png "width=" 597 "height=" 349 "/>

Finally, try to connect the listener

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/85/A5/wKioL1eq6T_xKwJsAACMAtUwpfo211.png "width=" 370 "height="/>

650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M02/85/A6/wKiom1eq6UCBhbeSAAFxT03UYaw123.png "width=" 423 "height=" 441 "/>

At this point, AlwaysOn configuration is complete, as for the failover you can test

PS: Because this alwayson has done once before I overturned the environment, this new environment has been done again, so the computer name is a little bit different. Next blog will be mentioned in cluster mode to deploy SQL Server, today is the first ...

This article is from the "Li Fei _ignore" blog, be sure to keep this source http://ignore.blog.51cto.com/2247529/1836554

One of SQL Server 2014 high availability: Always on