Configuring the Activity Engine Database for High-Availability

The Activity Engine database supports several types of databases. For the database connection string, you must use a dynamic link, which can be either an IP address or a domain name.

Note: All of the database information here assumes that you have successfully deployed your database system of choice in an HA configuration, ensuring that the database server itself is not a single point of failure.
The Activity Engine service supports the following database types:

Location of the Activity Engines' Database Configuration Information

The Activity Engine nodes maintain their database configuration information in the core application database. The database connection string can either be an IP address or a domain name, but should be dynamic in case of a failure at the database layer.

Setting Up the Connection String

The application requires you to add a DNS name or IP address for the Activity Engine database server deployed with the application. You set this connection string via the Admin Console: System > Settings > Activity Engine. This string is then stored in the core application databases. For more on what must be persisted in the core application database during a disaster recovery, see Restoring the Database With Persistent Properties.

In the event of a failover, there are specific ways that the application uses the connection string to determine which Activity Engine database server to failover to. Therefore, be especially careful when setting up the connection string as follows: