SQL Server 2012 High Availability Solution
SQL Server 20one2 provides multiple solutions for high availability, such as:one. By using alwayson, virtual IP addresses (VIPs) can be provided to achieve failover and read scalability
SQL Server 20one2 provides multiple solutions for high availability, such as:
one. By using alwayson, virtual IP addresses (VIPs) can be provided to achieve failover and read scalability.
2. Mirroring. It can synchronize databases between two instances and maintain availability. One instance becomes the primary instance, the other is a mirror instance, and data is written to both instances simultaneously.
3. Database replication. In this case, an instance becomes the publisher responsible for publishing data changes to subscribers. Changes are executed at the Subscriber without affecting the Publisher or other Subscribers.
4. The so-called&quo; Alwayson replication” The technology can only be used in SQL Server 20one6 and later versions.
5. Clustering. Although it is not a feature of SQL Server itself, it is still a method that can be used to achieve high availability. A cluster includes two or more servers, running SQL server instances with the same configuration items within the cluster, and ensuring that when one server fails, the other node takes over.
The methods listed above are not absolutely good or bad, only based on one's existing environment and selecting solutions that are suitable for one's business according to their needs.
This tutorial follows the steps of sqlserver20one2 as follows:
one. Environmental configuration
2. Domain environment construction
3. Configure Failover
4. Build database alwayon
Environment configuration:
one. Prepare three servers
| Serial number | Intranet IP | system | Account password | describe |
|---|---|---|---|---|
| one | one72.one9.200.oneone0 | Windowsserver2008r2 | Administrator (consistent) | Domain control, DNS, arbitration server |
| one | one72.one9.87.one47 | Windowsserver2008r2 | Administrator (consistent) | one |
| one | one72.one9.87.one46 | Windowsserver2008r2 | Administrator (consistent) | Cluster Node 2 |
2. Three servers on Alibaba Cloud under the same security group (internal network interoperability)
3. Install. NETFramWork3.5 and failover cluster roles on three servers respectively
4. External network bandwidth issue of domain control server (solution: add a dedicated security group to the domain control server, and prohibit external and internal network access)
5. SQLAlwaysOn sets automatic failover (listener), and Alibaba Cloud High Availability Virtual IP (Havip) must be enabled. Otherwise, only the primary replica can be accessed, and other nodes in the domain cannot access it.
5. The servers hosted by SQLAlwaysOn locks must be in the same Alibaba Cloud availability zone
6. SQLAlwaysOn: If accessed through a listener IP address, the node server can be in the same area, and the same availability zone is not required
7. The link read-only routing connection string is [connectionString=&quo; DataSource=listener name; InitialCatalog=data name; Integrated]
Security=SSPI; ApplicationIntent=ReadOnly; MultiSubnetFailover=True;& rdquo;
sql server 20one2,sql server 20one2
Tag: SQL Server 2012 High Availability Solution
Disclaimer: The content of this article is sourced from the internet. The copyright of the text, images, and other materials belongs to the original author. The platform reprints the materials for the purpose of conveying more information. The content of the article is for reference and learning only, and should not be used for commercial purposes. If it infringes on your legitimate rights and interests, please contact us promptly and we will handle it as soon as possible! We respect copyright and are committed to protecting it. Thank you for sharing.
