H2 database does not provide failover capability for a TIBCO Spotfire Statistics Services Cluster.

H2 database does not provide failover capability for a TIBCO Spotfire Statistics Services Cluster.

book

Article ID: KB0082076

calendar_today

Updated On:

Products Versions
Spotfire Statistics Services 7.5 and higher

Description

When a TIBCO Spotfire Statistics Services (TSSS) cluster is configured to use the default H2 database, there will not be a proper distribution of requests to all Manager nodes. If a Load Balancer is in front of the TSSS cluster, then we may see all requests being routed to a single Manager node. If that primary Manager node goes offline, then the TSSS cluster will not be operational. If a secondary Manager node goes offline, the TSSS cluster will remain operational as the requests will still be routed to that primary Manager node.

Resolution

This is expected behavior using H2 database as it does not provide failover capability when used in Cluster deployment.

From the TIBCO Spotfire Statistics Services Installation and Administration: 
Note: H2 provides no failover capability for a  Spotfire Spotfire Statistics Services cluster.

If you are installing a TSSS cluster then ensure you are configuring one of the following database as the jobs database for your cluster: 
Oracle (10g or later).
Microsoft SQL Server (2005 or later).
MySQL (5.0.89 or later).

Issue/Introduction

This article describes preferred databases to be used when installing a TIBCO Spotfire Statistics Services cluster.

Additional Information

Doc: Job database requirements
Powered by Wolken Software