Build Sql2014-alwayson High Availability Group

Environment:

1. Three servers have Windows cluster set up

For a WIN cluster, refer to: http://pxizhi.blog.51cto.com/5283742/1598146

2. And three servers are fully installed in SQL 2014 Enterprise Edition

in the build A lways on High Availability Group before the Three server database instances need to Enable AlwaysOn availability groups feature

1. To start an AlwaysOn availability group:

Start with SQL Server configuration management, start SQL Server Properties , Select theAlwaysOn high Availability option,

Tick "Enable AlwaysOn availability groups (E)"

650) this.width=650; "title=" 1.png "style=" Float:none; "alt=" wkiol1suq7ry7lpiaahjyugmetg469.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/4f/wkiol1suq7ry7lpiaahjyugmetg469.jpg "/>

After determining and re-enabling the SQL instance

650) this.width=650; "title=" 2.png "style=" Float:none; "alt=" wkiom1suqvnxkcqfaaiuilq60jm199.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/53/wkiom1suqvnxkcqfaaiuilq60jm199.jpg "/>

Three SQL instances need to start enable AlwaysOn availability groups (E)and restart the instance.

2. Formation of Alwayson1 High Availability Groups

On the primary server, expandAlwaysOn High Availability, right-click the availability groups point,

Select the New Availability Group wizard from the menu

650) this.width=650; "title=" 3.png "style=" Float:none; "alt=" wkiom1surq2thkd3aahz-5c_xrg175.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/53/wkiom1surq2thkd3aahz-5c_xrg175.jpg "/>

Specify the availability group name:alwayson1, click Next to continue creating

650) this.width=650; "title=" 4.png "style=" Float:none; "alt=" wkiol1surc-hwikeaafh1mro0aq979.jpg "src=" http:/ S3.51cto.com/wyfs02/m00/58/4f/wkiol1surc-hwikeaafh1mro0aq979.jpg "/>

Select the database because the entire database has been backed up before, so you see 6 x the database state is meeting the prerequisites.

Here we choose reshent ,Ftdata, C Entercrm Database Build High Availability group

650) this.width=650; "title=" 5.png "style=" Float:none; "alt=" wkiom1surq7dbwhxaajyaqt6trm484.jpg "src=" http:/ S3.51cto.com/wyfs02/m00/58/53/wkiom1surq7dbwhxaajyaqt6trm484.jpg "/>

Click "Add Replica", "Connect to Server" dialog box, enter another two SQL instance name , click "Connect" and then connect to the worker role DB instance

650) this.width=650; "title=" 6.png "style=" Float:none; "alt=" wkiol1surdcxmggcaakevvazbni311.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/4f/wkiol1surdcxmggcaakevvazbni311.jpg "/>

Set the database automatic failover instance as needed, as well as synchronous commit, the secondary copy can read and so on

650) this.width=650; "title=" 7.png "style=" Float:none; "alt=" wkiol1surddiwjjhaakceeyyxo8440.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/4f/wkiol1surddiwjjhaakceeyyxo8440.jpg "/>

Specify a shared network location that all replicas can access , continue to create

650) this.width=650; "title=" 8.png "style=" Float:none; "alt=" wkiom1surq_hd40paakwl6buzxi603.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/53/wkiom1surq_hd40paakwl6buzxi603.jpg "/>

650) this.width=650; "title=" 9.png "style=" Float:none; "alt=" wkiol1surdgycqocaap0pavumim842.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/4f/wkiol1surdgycqocaap0pavumim842.jpg "/>

Because there are no listeners set up in the previous deployment, there is a warning message that will be configured later.

650) this.width=650; "title=" 10.png "style=" Float:none; "alt=" wkiom1surq-alurgaaoyhnbnhgi575.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/53/wkiom1surq-alurgaaoyhnbnhgi575.jpg "/>

Successfully build AlwaysOn High Availability groups,

Expand the availability group and see

650) this.width=650; "title=" 11.png "style=" Float:none; "alt=" wkiom1surq_j-uhvaahzoda1viu843.jpg "src=" http:/ S3.51cto.com/wyfs02/m02/58/53/wkiom1surq_j-uhvaahzoda1viu843.jpg "/>

3. Adding listeners in Alwayson1

Add a client access point, expand the available groups Alwayson1, Right-click on the Availability group listener, select Add Listener

650) this.width=650; "title=" 12.png "style=" Float:none; "alt=" wkiol1susu2j9c6zaaifed6k9ta337.jpg "src=" http:/ S3.51cto.com/wyfs02/m00/58/50/wkiol1susu2j9c6zaaifed6k9ta337.jpg "/>

On the interface of the new availability listener, you need to give the listener DNS name:sql2014a and IP address, OK to add

650) this.width=650; "title=" 13.png "style=" Float:none; "alt=" wkiom1susivqlkhoaagqozwgj10300.jpg "src=" http:/ S3.51cto.com/wyfs02/m00/58/53/wkiom1susivqlkhoaagqozwgj10300.jpg "/>

Successfully added listener

650) this.width=650; "title=" 14.png "style=" Float:none; "alt=" wkiol1susu3x4-ajaah3akpxz_u437.jpg "src=" http:/ S3.51cto.com/wyfs02/m01/58/50/wkiol1susu3x4-ajaah3akpxz_u437.jpg "/>

This article is from "What is our favorite" blog, please be sure to keep this source http://pxizhi.blog.51cto.com/5283742/1600779

Build Sql2014-alwayson High Availability Group