SQL Server, AlwaysON

Build high availability for SQL Server 2012 AlwaysON based on a previously established 3-node failover cluster

Get ready:

1.3 node servers are installed complete SQL Server Enterprise (AlwaysOn features only Enterprise only)

Version of MS Feature Description: http://www.microsoft.com/zh-cn/server-cloud/products/sql-server-editions/

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/EA/wKiom1QD-iXQDc1cAAXKDeG4ZnU815.jpg "title=" 2.jpg " alt= "Wkiom1qd-ixqdc1caaxkdeg4znu815.jpg"/>

After the 2.SQL Server 2012 installation is complete, confirm that the TCP/IP protocol is enabled, using 1433 ports.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/47/EA/wKiom1QD-tvgC--QAALgWMHSzWQ390.jpg "title=" 1.jpg " alt= "Wkiom1qd-tvgc--qaalgwmhszwq390.jpg"/>

3. Enable AlwaysOn functionality in the service (AlwaysOn functionality must be enabled after the failover cluster is completed), the SQL service is modified to use the domain account as the logon identity, and the SQL service is restarted. 650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/47/EA/wKiom1QD-7Cz-zgpAAH7LxPbkTg158.jpg "title=" 3.jpg " alt= "Wkiom1qd-7cz-zgpaah7lxpbktg158.jpg"/>

4. Create a new database on Node 1 and make a full backup of the database.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/EC/wKioL1QD_aXBXprlAALhwCfhsH0973.jpg "title=" 4.jpg " alt= "Wkiol1qd_axbxprlaalhwcfhsh0973.jpg"/>

5. When AlwaysOn is established, other nodes participating in AlwaysOn need to use the backup file and the shared directory for database synchronization, so you need to establish a shared directory on Node 1 and put the previous database full backup file in the shared directory. It is recommended that the domain account used by the startup account configured for the SQL service be read-write permission.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/EA/wKiom1QD_dvi173kAAJMNMU0G9I103.jpg "title=" 5.jpg " alt= "Wkiom1qd_dvi173kaajmnmu0g9i103.jpg"/>

6. Create AlwaysOn

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/47/EC/wKioL1QEAJXwYE3lAAH3epKUBEM614.jpg "title=" 6.jpg " alt= "wkiol1qeajxwye3laah3epkubem614.jpg"/> After selecting the database to configure AlwaysOn functionality, specify all node servers and configure the capabilities of each node

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/47/EC/wKioL1QEAT6BVbLbAAK55UVzX9M383.jpg "title=" 7.jpg " alt= "Wkiol1qeat6bvblbaak55uvzx9m383.jpg"/>

In the backup preferences, you can specify a copy of the participating backup tasks, and the priority between them, for example, we can configure that the current cluster master does not participate in the backup task.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/47/EC/wKioL1QEAcrTlvXrAAK8tTgjxKE999.jpg "title=" 8.jpg " alt= "Wkiol1qeacrtlvxraak8ttgjxke999.jpg"/>

Establish a listener, which is the name used by the application client or server connection database, the IP address is the network segment where the public network card is located, and of course the listener can be established afterwards.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/47/EC/wKioL1QEAo-yzcvUAAKMg59aq9k460.jpg "title=" 9.jpg " alt= "Wkiol1qeao-yzcvuaakmg59aq9k460.jpg"/>

Finally, the data synchronization between the nodes is completed, specifying the shared directory required for the initial synchronization, and a full backup of the database configured for AlwaysOn functionality must be in the shared directory.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/ED/wKioL1QEDFehA-MsAAJhZTKSLXU229.jpg "title=" 10.jpg "alt=" Wkiol1qedfeha-msaajhztkslxu229.jpg "/>

Complete all validations

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/47/EB/wKiom1QEC7vzA1YJAAOCe299-1A240.jpg "title=" 11.jpg "alt=" Wkiom1qec7vza1yjaaoce299-1a240.jpg "/>

AlwaysOn Setup Complete

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/47/ED/wKioL1QEDS3DKY8oAAOom39LoGU412.jpg "title=" 12.jpg "alt=" Wkiol1qeds3dky8oaaoom39logu412.jpg "/>

SQL Server, AlwaysON