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