Failover and Data Recovery in the Analytics Database

The Analytics database connection string, username, and password are stored in a table in the core application database in an encrypted format (not in an XML file). In the event of a failure, you want to be sure the web app nodes are calling the correct Analytics database server.

CAUTION:
You may choose to configure redundant databases and replicate data between them. Jive Software does not provide database replication configuration or support. Your data center and/or DBA team must provide database support for you and your configuration. Customers have successfully deployed Jive to Oracle RAC, SQL Server Clustering and other HA configurations.

Analytics Database Failover in a Single Data Center HA Configuration

In a single data center HA configuration, if Analytics database 1 fails over to Analytics database 2, this failure is transparent to the web application nodes due to the database driver layer controlling traffic between the web app nodes and the analytics database. So if the Analytics database 1 failed, community users would not notice the failure because the driver would automatically redirect web app node requests over to Analytics database 2.

Analytics Database Failover in a Multiple Data Center HA Configuration

The Analytics database server connection string, username, and password are stored in a table in the core application database in an encrypted format (not in an XML file). Because of this, how you set up the connection string affects how the web application nodes call and resolve the Analytics database server. In the event of a failure in a multiple data center HA configuration, you want to be sure the web app nodes are calling the correct Analytics database server. Therefore, be especially careful when setting up the Analytics database connection string.