Failover and data recovery in Analytics database

The Analytics database connection string, user name, and password are stored in a table in the Core Application database in an encrypted format. In the event of a failure, you want to be sure the web app nodes are calling the correct Analytics database server.

Note: You may choose to configure redundant databases and replicate data between them. Jive does not provide database replication configuration or support. Your data center or DBA team, or both, must provide database support for you and your configuration. We have seen customers successfully deploy Oracle RAC and SQL server HA configurations with Jive.

Analytics database failover in 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.

For more information, see Designing single data center HA configuration.

Analytics database failover in multiple data center HA configuration

The Analytics database server connection string, user name, 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.

For more information, see Designing multiple data center HA configuration and Configuring Analytics database for high-availability.