Failover Preconnect
- Last Updated: May 20, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Greenplum 8.0
- Documentation
Failover Preconnect
Attribute
FailoverPreconnect (FP)
Purpose
Specifies whether the driver tries to connect to the primary and an alternate server at the same time.
This attribute applies only when Failover Mode (FailoverMode) is set to
1 (Extended Connection) or 2 (Select) and at least one
alternate server is specified.
The Alternate Servers option specifies one or multiple alternate servers for failover and is required for all failover methods.
Valid Values
0 | 1
Behavior
If set to 0 (Disabled), the driver tries to connect to an
alternate server only when failover is caused by an unsuccessful connection attempt or a
lost connection. This value provides the best performance, but your application typically
experiences a short wait while the failover connection is attempted.
If set to 1 (Enabled), the driver tries to connect to the
primary and an alternate server at the same time. This can be useful if your application is
time-sensitive and cannot absorb the wait for the failover connection to succeed.
Default
0 (Disabled)