Configuring system database failover
- Last Updated: April 7, 2022
- 1 minute read
- Hybrid Data Pipeline
- Version 5.0
- Documentation
Hybrid Data Pipeline requires a system database (sometimes referred to as an account database) for storing user and configuration information. To promote the continuous availability of the service, Oracle, SQL Server, and PostgreSQL system databases can be configured to fail over to alternate servers.
Failover configuration of a system database must take place during installation or upgrade of the service. The database initially specified as the system database during installation of the Hybrid Data Pipeline server functions as the primary server. In turn, alternate servers can be specified in a connection string as Advanced Options during the initial installation, or subsequent upgrade, of the service. To ensure the continuous operation of the service, all alternate servers should be regularly synced with the primary database server.