Configure server-level failover
- Last UpdatedOct 23, 2025
- 1 minute read
- PI System
- Adapter for RDBMS 1.1
- Adapters
To ensure that the database server data continues to flow in the event of a server disconnection or shutdown, you can configure server-level failover for the RDBMS adapter.
When enabled, the adapter is configured with two connection strings—one for the primary server and one for the backup. If the primary server becomes unavailable, the adapter automatically switches to the backup server and continues collecting and sending data without requiring manual intervention, helping to minimize downtime and prevent data loss.
To configure server-level failover:
-
Set the enableServerFailover parameter to true in the data source configuration.
-
Provide a secondaryConnectString that points to the backup server.
No changes are needed in the data selection or scheduling components. The adapter handles the failover internally, making it easy to implement high availability without a complex setup.
Note: If you have configured the database servers with high-availability, there is no need to configure for server side failover. Set the connection string to the high-availability node created.
For an example of data source configuration with server-side failover, see the Data source examples.