Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Separate use of AlwaysOn Service IP and High availability IP (4)

2025-04-07 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

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

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:

Disable Ethernet 1 on the basis of scenario 1, binding 173,174 to Ethernet 0.

The DNS reverse parsing area also has 173and174parsing.

Kerberos authentication can be used for remote access via Windows authentication.

Test:

1. Remove the standby node from AG and switch between 10.198.197.173 and 10.198.197.174.

First, change the IP of 173to 171.Then restart the network card with the following command line, then restart the network card with the following command line, restart the network card with the following command line, and then restart the network card with the following command line, and then restart the network card with the following command line, so that the IP of 173and 174will be switched safely:

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.

During the process of restarting the network card, all WSFC cluster communication links that can reach the host are interrupted, and a re-election occurs, which lasts for a few minutes, and then the WSFC resumes and can be connected.

Delete the resolution corresponding to 173,174 in the reverse resolution area of DNS, and add a new corresponding resolution relationship.

Kerberos authentication can be used for remote access via Windows authentication.

two。 After the business switch to standby database testing, switch 173 and 174 back.

Can access the database service remotely.

The WSFC status is as follows:

Summary:

The third 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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report