Shulou(Shulou.com)06/01 Report--

Scheme 4: the active and standby source IP is used for business access, and the new IP is bound to the source network card for AG communication.

Test environment description:

AG role

Hostnam

Network adapter

IP address 1

IP address 2

Main library

TEST-GS-ZHXT1

Ethernet0

10.198.197.167

10.198.197.173

Prepare the library

TEST-GS-ZHXT2

Ethernet0

10.198.197.168

10.198.197.174

Disaster preparedness

TEST-GS-ZHXT3

Ethernet0

10.198.194.183

Test environment deployment:

On the basis of scheme 3, AG is limited to communicate through 173,174.

Test:

1. Local and remote access to 167 and 168 database services

Try to access through SSMS:

Can be accessed normally.

two。 Primary node downtime switch to standby node

When Node 1 goes down, WSFC is normal and AG fails:

Perform an AG failover manually, and then attempt to access the new primary node source IP database service locally and remotely:

Can be accessed normally.

3. Restore Node 1 is the primary node, remove the standby node from AG, and swap 10.198.197.167 with 10.198.197.168.

Because there is only one network card, in the process of IP exchange, careless operation can easily lead to the remote RDP unable to connect.

First, change the IP of 167to 171. then restart the network card with the following command line, then change the IP of 168to 167. also restart the network card with the following command line, then change the IP of 171to 168. then restart the network card with the following command line, so that the IP of 167and 168will be safely switched over:

Because it is bound to a network card, when it is manually disabled, the server cannot be connected after it is disabled. You can only restart the Nic through the command line to allow the IP switch to take effect.

Make sure that both forward and reverse parsing are correct.

Check the status of WSFC:

WSFC network connections depend on 167s and 168s, and they are switched accordingly.

With Windows authentication, remote access 167,168 can use Kerberos authentication.

Summary:

The fourth scheme can meet the needs of separate use of business IP and high-availability IP. Since there is only one network card, high availability and business communicate from here, increasing the risk of failure.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.