H2 database does not provide failover capability for a TIBCO Spotfire Statistics Services Cluster.
Article ID: KB0082076
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.
Issue/Introduction
This article describes preferred databases to be used when installing a TIBCO Spotfire Statistics Services cluster.
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:
If you are installing a TSSS cluster then ensure you are configuring one of the following database as the jobs database for your cluster:
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).
Additional Information
Feedback
Yes
No
Powered by
