Redigera

Dela via

Configure multiple-subnet Always On availability groups and failover cluster instances

  • Artikel

Applies to: SQL Server - Linux

When an Always On availability group (AG) or failover cluster instance (FCI) spans more than one site, each site usually has its own networking, which often means that each site has its own IP addressing.

For example, the Site A addresses start with 192.168.1.<x>, and the Site B addresses start with 192.168.2.<x>, where <x> is the part of the IP address that is unique to the server. Without some sort of routing in place at the networking layer, these servers aren't able to communicate with each other.

There are two ways to handle this scenario:

  • set up a network that bridges the two different subnets (known as a VLAN)
  • configure routing between the subnets

VLAN-based solution

Prerequisite: For a VLAN-based solution, each server participating in an AG or FCI needs two network cards (NICs) for proper availability (a dual port NIC would be a single point of failure on a physical server), so that it can be assigned IP addresses on its native subnet as well as one on the VLAN. This requirement is in addition to any other network needs, such as iSCSI, which also needs its own network.

The IP address creation for the AG or FCI is done on the VLAN. In the following example, the VLAN has a subnet of 192.168.3.<x>, so the IP address created for the AG or FCI is 192.168.3.104. Nothing additional needs to be configured, since there's a single IP address assigned to the AG or FCI.

Diagram showing how to configure multiple subnets with VLAN.

Configuration with Pacemaker

On Windows, a Windows Server Failover Cluster (WSFC) natively supports multiple subnets and handles multiple IP addresses via an OR dependency on the IP address. On Linux, there's no OR dependency, but there's a way to achieve a proper multi-subnet natively with Pacemaker, though you can't use the normal Pacemaker command line. Instead, you need to modify the cluster information base (CIB). The CIB is an XML file with the Pacemaker configuration.

Diagram showing how to configure multiple subnets with Pacemaker.

Update the CIB

  1. Export the CIB.

    sudo pcs cluster cib <filename>

    Where <filename> is the name you want to call the CIB.

  2. Edit the file that was generated. Look for the <resources> section. You see the various resources that were created for the AG or FCI. Find the one associated with the IP address. Add a <instance_attributes> section with the information for the second IP address either before or after the existing one, but before <operations>. It's similar to the following syntax:

    <instance_attributes id="<NameForAttribute>">
    <nvpair id="<NameForIP>" name="ip" value="<IPAddress>"/>
</instance_attributes>

    where <NameForAttribute> is the unique name for this attribute, <NameForIP> is the name associated with the IP address, <IPAddress> is the IP address for the second subnet.

    The following shows an example.

    <instance_attributes id="virtualip-instance_attributes">
    <nvpair id="virtualip-instance_attributes-ip" name="ip" value="192.168.1.102"/>
</instance_attributes>

    By default, there's only one <instance_attributes /> in the CIB XML file exported. If there are two subnets, you need two <instance_attributes /> entries.

    Here's an example of entries for two subnets:

    <instance_attributes id="virtualip-instance_attributes1">
    <rule id="Subnet1-IP" score="INFINITY" boolean-op="or">
        <expression id="Subnet1-Node1" attribute="#uname" operation="eq" value="Node1" />
        <expression id="Subnet1-Node2" attribute="#uname" operation="eq" value="Node2" />
    </rule>
    <nvpair id="IP-In-Subnet1" name="ip" value="192.168.1.102"/>
</instance_attributes>
<instance_attributes id="virtualip-instance_attributes2">
    <rule id="Subnet2-IP" score="INFINITY">
        <expression id="Subnet2-Node1" attribute="#uname" operation="eq" value="Node3" />
    </rule>
    <nvpair id="IP-In-Subnet2" name="ip" value="192.168.2.102"/>
</instance_attributes>

    You would use boolean-op="or" when the subnet has more than one server.

  3. Import the modified CIB and reconfigure Pacemaker.

    sudo pcs cluster cib-push <filename>

    Where <filename> is the name of the CIB file with the modified IP address information.

Check and verify failover

  1. After the CIB is successfully applied with the updated configuration, ping the DNS name associated with the IP address resource in Pacemaker. It should reflect the IP address associated with the subnet currently hosting the AG or FCI.

  2. Fail the AG or FCI to the other subnet.

  3. After the AG or FCI is fully online, ping the DNS name associated with the IP address. It should reflect the IP address in the second subnet.

  4. If desired, fail the AG or FCI back to the original subnet.

Related content