SQL Server AlwaysOn

Tags: SQL server/mssql server/Database/dba/High Performance solution

Overview

Environment:

Domain server: Windows Server R2 sp1,192.168.2.10

dns:192.168.2.10

CLU11, Windows Server R2 SP1, 192.168.2.11,sql server Enterprise (64-bit)

CLU12, Windows Server R2 SP1, 192.168.2.12,sql server Enterprise (64-bit)

CLU13, Windows Server R2 SP1, 192.168.2.13,sql server Enterprise (64-bit)

The failover cluster has been built

If you are building and joining a domain reference:http://www.cnblogs.com/chenmh/p/4444168.html

If you are building a failover cluster reference: http://www.cnblogs.com/chenmh/p/4479304.html

Directory

• Overview
• Installing Failover Services
• Create a cluster
• Summary

start AlwaysOn High Availability

1. Add Cmh\administrator to the login name of three servers, select sysadmin for server role

2. Open SQL Server Configuration Manager, configure the domain user to start the server account

3. Enable AlwaysOn availability Groups

Configure AlwaysOn High Availability

1. Open AlwaysOn Availability Groups-New Availability Group wizard

2. Next step

3. Enter the name of the availability group

4. Select the database for the availability group, the database must be the full recovery model and a full backup first

5. Add a copy

6. Since Port No. 5022 is already in use, configure Port No. 5023 here

7. Select default configuration-preferred secondary replica

8. Configure the listener, and temporarily do not configure the last configuration.

9. Configure the backup share path, create a new AlwaysOn on the CLU12 Server local folder, and share the folder with permissions configured to read and write.

In order to ensure shared storage, you should configure reliability shared storage because of a single node failure.

10. Verifying the configuration results

11. Complete

12. Close

13. Add a copy

14. The readable copy is selected "Yes" while the endpoint is configured with 5023 and the default is 5022

15. Configure Shared storage paths

16.

17.

18. Adding listeners

19. Port Select 1433, network mode select static IP, enter listening IP address

20. Viewing computers in a domain controller

21. View DNS in a domain controller

22. View the configured AlwaysOn

23. View the cluster

24. View the monitor display panel

Summary

In the firewall, you need to add an exception to the 1433,5023 port. Here, because it is a test to place the backup share path on the CLU12 local disk, in a production environment, AlwaysOn failover cluster instances require the use of symmetric shared disk storage, such as a storage Area network (SAN) or SMB file share. the shared disk storage volume must be available for all possible failover nodes in the WSFC cluster.

if the article is helpful to everyone, I hope you can give a recommendation, thank you!!!

Note: pursuer.chen Blog:http://www.cnblogs.com/chenmh This site all the essays are original, welcome to reprint, but reprint must indicate the source of the article, and at the beginning of the article clearly to the link, otherwise reserves the right to hold responsibility. Welcome to the exchange of discussions

SQL Server AlwaysOn