Purpose

Determines whether the driver attempts parallel connections to the failover IP addresses of an Availability Group during initial connection or a multi-subnet failover. When MultiSubnetFailover is enabled, the driver simultaneously attempts to connect to all IP addresses associated with the Availability Group listener when establishing an initial connection or reconnecting after a connection is broken or the listener IP address becomes unavailable. The first IP address to successfully respond to the request is used for the connection. Using parallel-connection attempts offers improved response time over traditional failover, which attempts to connect to alternate servers one at a time.

Valid values

true | false

Behavior

If set to true, the driver attempts parallel connections to all failover IP addresses in an Availability Group when establishing an initial connection or reconnecting after a connection is broken or the listener IP address becomes unavailable. The first IP address to successfully respond to the request is used for the connection. This setting is only supported when your environment is configured for Always On Availability Groups.

If set to false, the driver connects to an alternate server or servers as specified by the AlternateServer property when the primary server is unavailable. Use this setting if your environment is not configured for Always On Availability Groups.

Notes

  • When MultiSubnetFalover is enabled, the virtual network name (VNN) of the availability group listener must be specified with the ServerName connection property.
  • When MultiSubnetFailover is enabled, the driver does not support FailoverMode=select. If MultiSubnetFailover=true and FailoverMode=select, the driver downgrades the FailoverMode to extended and provides the following warning.
    failoverMode=select is not supported for AlwaysOn Availability Group,
downgraded to failoverMode=extended
  • When MultiSubnetFailover is enabled, the ConnectionRetryDelay connection property is ignored.
  • If MultiSubnetFailover is enabled and the connection attempt fails, the driver will attempt to connect two more times, regardless of the ConnectionRetryCount setting.
  • When MultiSubnetFailover is enabled, the value of the LoginTimeout property is 15 seconds by default. When LoginTimeout is set to 0 (zero), the driver will still timeout requests after 15 seconds. However, when the value of LoginTimeout is an integer greater than 0 (zero), the driver will timeout requests for the specified duration.

Data source method

public Boolean getMultiSubnetFailover()

public void setMultiSubnetFailover(Boolean)

Default

false

Data type

Boolean

See also

  • Always On Availability Groups
  • Note: For more information on connection failover and different levels of failover protection provided by the driver, refer to Failover in the Progress DataDirect for JDBC Drivers Reference.